Master Lookup Functions in Excel

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

Master Lookup Functions in Excel. 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 (Vlookup) but quickly moves into more complex examples, providing solutions to common lookup problems such as looking up to the left.

You will learn how to use:

• Vlookup

• Index and Match

• How to look up to the left

•Dynamic Lookups by combining Vlookup with Match

• Lookups within Text

• Choose

• HLookup

Who Should Attend?

This course is suited to those with an interest in Excel and Reporting. This course is well suited for Accountants, Auditors, Internal Auditors, Business Analysts, Finance staff, Banking staff, Management and those involved with Compliance and Risk assessment and BI.

• This course is meant for those involved in the Analysis of Data, Finance & Accounting and Reporting roles.
• This course is for you if you are looking to improve your Excel skills and increase efficiency
• This course is not for you if you don’t have a basic working knowledge of Excel

What’s included?

  • Instruction by an expert
  • 12 months access 24/7
  • Certificate of completion

How long will it take?

Completion Time 2 Hours


********************************************************************************************
REGISTER NOW and get started with  - Master Lookup Functions
*******************************************************************************************


Intended Audience: Bookkeepers

Course Workbook
Vlookup
Index and Match
Combining VLookup with Match
How to do a Lookup to the left
How to do a Lookup within Text
Choose function
Hlookup
Conclusion

Look-up Functions

Marie Fluskey , 4 months ago

Extremely helpful and easy to follow.

Lookup

James Bolton , 7 months ago

Very informative and practical

What's included

  • 8 Video Lessons
  • 1 Text Lesson

  • Works on all devices
  • Certificate of completion

Paula Guilfoyle

Instructor

My Name is Paula, and I am a qualified CPA with over 15 years’ experience in Accounting and Business. I have worked across a broad range of industries and levels of seniority. During this time I used Excel as my spreadsheet tool of choice, attending many courses and regularly updating my skills. It was my love for Excel that started my journey as an e-learning educator. As a manager and an Accountant, I noticed a skills gap amount Accountants and finance staff in Excel. In 2010 I launched www.theexcelclub.com with 1 course aimed at this market. I am now author and presenter of many online courses and can boast that I have thought over 10,000 students!

In addition to being an Accountant and an Online Educators I am also a wife and a mother of two, my youngest is 2 and eldest is 7. I currently work as an Accountant for a global company, which makes family life very very busy. I am always stuck for time, and finding a balance is very difficult. I’m sure all working parents understand the pressures involved.