- Introduction
- Course Material
- Basic V-lookups in Excel
- Index and Match in Excel
- More Dynamic V-lookup
- Lookups to the Left
- The Choose function
- Lookups with Text
- HLookup
- Conclusion
- Course Activities
- Bonus
What you'll 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
Description
Excel for Accounting and Bookkeeping - Master Lookup Functions. A comprehensive course for those that wish to up skill in Excel and Learn advanced lookup formula.
In This Course You Will Learn How Lookup To The Right and the Left, Use Index and Match, Use Combinations of Index, Match and Vlookup, Carry out Lookups with Text And Use The Choose Function.
Do you need to understand and carry out basic or complex lookups in Excel? Then this course is for you!
Course Overview
This course begins with some basic lookup formula but quickly moves into more complex examples, providing solutions to common lookup problems.
This course contains:
Activities are used through out this course and the answer from one activity leads into a later activity.
Workbook to download
Certificate of Completion
******BONUS****** FREE Join a community of other learners where you can interact with each other and with the instructor.
********************************************************************************************
REGISTER NOW and get started with Excel for Accounting and Bookkeeping - Master Lookup Functions
*******************************************************************************************
Your purchase is 100% RISK FREE with a 30 day money-back guarantee. If you don't learn anything new from this course, simply request a refund within your 30 day period for your money back, no questions asked.
Students also bought
Información sobre el Instructor

- 4.33 Calificación
- 106465 Estudiantes
- 26 Cursos
Paula Guilfoyle CPA & MVP
Microsoft MVP, CPA Accountant, & Life Long Learner
Paula is a qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management, Process improvement, Internal Audit, Group accountant, Operations Management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to upskill, especially in the area of Spreadsheets, Bookkeeping and Accounting.
In 2020 Paula was awarded with a Microsoft MVP award for her dedication to Excel and the Excel community.
Student feedback
Course Rating
Reviews
It went a little bit quickly and I thought there was going to be a excel file for the H lookup function but I made my own and it was really helpful that I did because I was able to grasp it. Very great job overall I will be buying more excel courses no doubt
The course was a good match for me but I feel some parts the lecturer hurried through them, especially the choose function.
not sure yet