Microsoft® Excel 2007, Level 3: Data Analysis, Pivot Tables and Macros

In this advanced Excel class, you will work with pivot tables and pivot charts, create macros to automate routine tasks, use the PMT and FV functions, goal seek, solver, the analysis toolpak, and the scenario manager. You will use 3-D cell references, HLOOKUP, VLOOKUP, and IF functions. Learn to create data tables and trend lines, consolidate data, use data validation, and conditional formatting.