Booking Information
Once you have booked your course, the link to the recording will be available
in your "My Account" area.
Please be aware that you will have access to this course for 180 days from
the date of purchase
Online courses cannot be booked on behalf of someone else. Access will only
be granted to the person completing the online order.
Who Should Attend?
This course is suitable for beginner learners who are already familiar with Excel but not proficient analyzing these 3 different types of data. It is best suited to accountants, management consultants, analysts and other business professionals.
Course Overview
This Kubicle course contains 11 lessons, 3 exercises and 1 Exam. It covers the following topics:
- Finding records with VLOOKUP
- Naming arrays
- Better lookups with INDEX/MATCH
- Tiered pricing with nested IF
- Create dropdown list for search
- Ranking data records
- Lookup multiple criteria
- Calculating monthly totals
- Database functions
- Updating formulas with new data
Key Outcomes
Once you have completed this course you will know how to use all of Excel’s lookups and database functions (e.g. VLOOKUP, HLOOKUP, DSUM, DAVERAGE) and be able to deploy these functions in formulas that perform calculations on various datasets. You will also know how combine these functions with other Excel features to create Top 5 lists, drop down menus and much more.