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.
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.
Manipulating and separating strings of text will cut down the time you’ll need to spend performing large-scale data handling.
This toolset will add power to your existing lookup functions, and reduce the time it’ll take to scale up their use.
Adding this group of tools to your Excel spreadsheets can eliminate lengthy workarounds, and help guarantee decimal accuracy.
Conditional formatting is a powerful tool, and we add weight to the basics by focusing on formula-driven formatting techniques.
We take date calculations past the basics, including how to factor in non-working days, holidays and breaking down time components.
Controls help automate spreadsheets and are great for end-users. We’ll learn to set them up and create solutions that users will value.
We look at the role of these condition testers as both stand-alone tools and as used within IF functions.
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.
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.