View Cart

Lookups & database functions

Summary

This intermediate course will teach you how to use the powerful lookups and database functions when performing analysis in Microsoft Excel. This set of Excel functions enables you to search datasets to find specific values, all within your Excel formulas. The course will also teach you how to use named ranges, cell validation and index/match functions to maximise the usefulness of lookups and database functions. Created & customized for Chartered Accountants Ireland by kubicle.com

Description

Product type:

CPD online course

Category:

Kubicle, Technology and data

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.