Intermediate Excel starts with a quick review of some of the essential tools such as freezing panes, flash and auto fill and custom sorting. A general review of grouping, subtotaling, conditional formatting is next, followed by a look at basic functions and formulas.

A majority of the course focuses on the use of Pivot Tables and working with formulas and multiple data sets in Pivot Tables and using advanced functions such as VLOOKUP and SUMIF & SUMIFS.

Advanced Excel starts with a quick review of some of the essential tools such as tables and advanced filtering and sorting A general review of pivot tables and VLOOkUP formulas follows.

A majority of the course focuses on the

1. Named ranges, 3-D cell reference

2. Sumif, Sumifs

3. Hiding columns, worksheets, workbooks

4. Locking cells and ranges, protecting worksheets, and workbooks

5. Advanced Filter

6. Formula Auditing and Handling Formula Errors

7. Array Formulas

8. Creating table relationships

9. Get and Transform and Power Pivot in Excel

10. Creating Data Models (i.e. using Excel like a relational database)

11. Turn on the Developer Tab

12. Macros