Excel 4 Accounting & Bookkeeping – Master Lookup Functions

Lookup to the right, Lookup to the left, Index, Match and Choose - Master Lookups Now

Created by: Paula Guilfoyle CPA
CPA Accountant, & Life Long Learner

What Will I Learn?

• Carry out Basic V-lookups and H-lookups in Excel
• Use the Index and Match functions in isolation and combined
• Combine V-lookup with Match for a more dynamic formula
• Carry out a lookup to the left
• Use the V-lookup function with Text
• Use the Choose function to lookup values
• Workbooks to download
• Activities to complete

Requirements

• You should have Excel knowledge similar to that offered in the free Udemy Course - Basic Excel for Basic Bookkeeping

Target audience

• These functions work in all versions of Excel
• You should take this course if you are interested in becoming more efficient in your daily Excel and Spreadsheets tasks.
• This course is for you if you wish to improve your Excel skills and Master Lookup functions