This training program is designed to teach the toolsets that transform an Excel beginner to a high-productivity user, including LOOKUP functionality, IF functions, and how to work with large data ranges effectively.
Understanding how and why we need to “lock” cells is a must before moving on to intermediate Excel use.
When using IF and LOOKUP functions, we’ll need to know how to handle large rages of data. Named ranges accomplish this.
IF functions are a cornerstone of decision-making formulas in Excel. We’ll write these formulas, then combine them into larger formula structures.
LOOKUP Functions such as VLOOKUP, XLOOKUP, INDEX/MATCH and CHOOSE are powerful tools that allow us to look up and retrieve data from tables or sheets.
We can turn data ranges into tables, which enables powerful database and list calculation tools to increase functionality.
We cover 2 related areas – how to group (or combine) data columns for ease of use, and use Excel’s subtotal tools to calculate database totals.
Only Advanced Filters have the ability to extract data using OR relationships, and the time-saving advantages can be immense.
This powerful visual tool allows you to group, filter, sort and calculate database information with ease. We look at the basics through to advanced tools
We can create our own drop-down boxes to help users enter data correctly by choosing from available options and preventing them from entering incorrect data.
If a phone number in a cell appears as 355551111, we can use Custom Formatting to change its appearance to (03) 5555 1111. And it does much more.
The bulleted items listed above comprise a condensed overview of course topics.Download full course outline (PDF)
This course is designed for Microsoft Excel users who can build basic workbooks. It is assumed that the user will know how to create basic formulas using SUM and AVERAGE, and who are able to perform basic sorting and filtering of lists.