Booking Information
Once you have booked your course, you will receive a confirmation email containing an access link and passcode. Use these to set up your account on the Chartered Accountants Ireland Portal within the Kubicle site.
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.
LOADING...