This course is designed to introduce higher-level Excel tool-set functionality and take intermediate-level users to the power-user level. Not only does the course introduce a host of new Excel tools and functions, but it also expands on the functionality of intermediate-level tools, adding powerful complimentary functions that make Excel jump.
This toolset will add power to your existing lookup functions, and reduce the time it’ll take to scale up their use.
Manipulating and separating strings of text will cut down the time you'll need to spend performing large-scale data handling.
Bringing data into your Excel file is simple, but ensuring you have the tools to “clean” the data while doing so will save work and time.
These functions allow you to use formulas to combine, sort and filter data scattered throughout different non-connecting ranges.
Automating your spreadsheet with recorded macros is just the start. We look at VBA code and creating event-driven procedures.
This category of functions allows you to perform AND/OR calculations on large databases at lightning speed, with zero errors.
The bulleted items listed above comprise a condensed overview of course topics.Download full course outline (PDF)
This course is designed for confident Microsoft Excel users who are comfortable with creating formulas above the level of SUM, AVERAGE, MAX, MIN and COUNT. Participants will also be experienced with database sorting and filtering techniques.