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
Instructor
David H. Ringstrom
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches over 200 webinars each year. His Excel courses are based on over 30 years of consulting and teaching experience. David’s catchphrase is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. He's currently writing a book titled "Exploring Excel's Hidden Treasures". To learn more about David, you can view his
LinkedIn profile and follow him on
Facebook or
Twitter (@excelwriter).