Master advanced Excel lookup functions including Index, Match, and Vlookup. Perfect for accounting and bookkeeping professionals seeking to enhance their spreadsheet skills.
This course is all about nailing those Excel lookup functions you’ve heard about. You’ll start with the basics and effortlessly dive into advanced stuff. By the end, you’ll be a lookup wizard, ready to tackle any Excel challenge that comes your way!
Lookup to the right, Lookup to the left, Index, Match and Choose - Master Lookups Now
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.
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
With over 25 years of expertise in Accountancy, Business Management, and Operations, I, Paula, am a seasoned CPA (Certified Public Accountant) dedicated to empowering learners with practical skills and knowledge. As a former Microsoft MVP (Most Valuable Professional) in Excel for two consecutive years (2020 & 2021), I've been recognized for my commitment to excellence in spreadsheet solutions and financial...
It is a good match.
I needed to understand better the Vlookup function
Yes
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
Thank! Everything was well explained, I am happy I took this course!
definitely, i was looking for specific content
overall good, compared with other courses that I have taken, would be better if filled with more cases.
Great explanation of how to make dynamic formulas.
Your email address will not be published. Required fields are marked *
Ana C.
Yes, it is a good match. Very easy to understand.