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.
About this Course
It can be frustrating to know you have a wealth of information stored in your spreadsheet but not know how to access it. Excel helps with functions to speed up your search.
Throughout this course, you’ll learn how to find unique records, split data into different tiers, and create go-to functions for ease of access.
After completing the 12 lessons, you’ll be comfortable updating your search panel formulas to automatically include any new records added to your dataset.
Who Should Attend?
This course is suitable for beginner learners who are already familiar with Excel but not proficient at 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
- Using XLOOKUP
- Tiered Pricing with Nested IF
- Create a Dropdown List for a Search Panel
- Ranking Data Records
- Lookup Multiple Criteria
- Calculating Monthly Totals
- Database Functions
- Updating Formulas with New Data
- Updating Formulas with New Data Part 2
Key Outcomes
- Find specific values using VLOOKUP, INDEX, and MATCH
- Create names for arrays of data
- Create nested IF functions
- Build a search panel using lookup functions
- Use Excel’s database functions
- Update your formulas automatically when new data is added
Contact Us
If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at (+353) 01 523 3930.