Excel Lookup Functions: Function Wizard (Nano Course)
Author: David H. Ringstrom
| CPE Credit: |
0.2 hour for CPAs |
In this nano course, Excel expert David Ringstrom, CPA, introduces you to the concept of lookup functions in Excel. David extensively covers VLOOKUP, which is often the first lookup function that Excel users learn. David explains the context of when to use lookup functions, demonstrates troubleshooting techniques, and prepares you to deal with subtle issues that can prevent them from working properly.
Please check your State Board of Accountancy to confirm if Nano courses are accepted for CPE credit.
Publication Date: January 2019
Designed For
Practitioners who would like to work more efficiently in Excel by using lookup functions, such as VLOOKUP.
Topics Covered
- Function Wizard command in Excel
Learning Objectives
- Define the purpose of Excel's Function Wizard
Level
Basic
Instructional Method
Nano Learning
NASBA Field of Study
Computer Software & Applications (0.2 hour)
Program Prerequisites
None
Advance Preparation
None
