Excel Level 3 – Formulas & Functions
Class Outline — 4 hours
This four-hour, instructor-led course will teach you advanced formulas and functions to perform more complex calculations in Microsoft Excel. By the end of this course, you will be able to use logical and lookup functions; date/time and text functions; reference functions; and statistical functions. You will learn about auditing and error-handling both of which are tools to help you prevent formula and function errors and, how to summarize data by using the subtotals feature. If your job requires you to work with Excel on a regular basis, mastering this level is vital to your success.