0
| Author : | David Ringstrom, CPA |
| Course Length : | Pages: 3 ||| Review Questions: 6 ||| Final Exam Questions: 10 |
| CPE Credits : | 2.0 |
| IRS Credits : | 0 |
| Price : | $29.95 |
| Passing Score : | 70% |
| Course Type: | Video - NASBA QAS - NASBA Registry |
| Primary Subject-Field Of Study: | Computer Software & Applications - Computer Software & Applications for Course Id 1392 |
| Description : |
Excel expert David Ringstrom, CPA, explains helpful ways you build upon your existing VLOOKUP skills in this online excel course for CPAs. The presentation begins with a brief introduction of VLOOKUP, and contrasts the HLOOKUP and LOOKUP functions. You’ll see a how to troubleshoot common look-up formula frustrations, such as #N/A and #REF! errors. You'll also learn how to how to future-proof VLOOKUP with Data Validation and the Table feature. The presentation wraps up by explaining alternatives that include MATCH/INDEX, SUMIF, and SUMIFS. |
| Usage Rank : | 0 |
| Release : | 2018 |
| Version : | 1.0 |
| Prerequisites : | Experience with Lookup Formulas Recommended. |
| Experience Level : | Overview |
| Additional Contents : | Complete, no additional material needed. |
| Additional Links : |
NDEX MATCH: THE BETTER ALTERNATIVE TO VLOOKUP
|
| Advance Preparation : | None. |
| Delivery Method : | QAS Self Study |
| Intended Participants : | Anyone needing Continuing Professional Education (CPE). |
| Revision Date : | 30-May-2021 |
| NASBA Course Declaration : | Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam. |
| Approved Audience : | Video - NASBA QAS - NASBA Registry - 1392 |
| Keywords : | Computer Software & Applications, Agile, Excel, VLOOKUP, Alternatives, Video, cpe, cpa, online course |
| Learning Objectives : |
Course Learning Objectives |
| Course Contents : | Chapter 1 - Agile Excel: VLOOKUP and Alternatives Chapter 1 Review Questions Glossary - Key Terms |
Login/Register