Master Lookup Functions in Excel

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 and how much does it cost?

Completion Time 2 Hours

€56

*please note that you cannot use your €50 CPD voucher for the Excel Club online courses