Time: 9am - 4pm
Duration: 1 day
Compatible with 2013
This Advanced level is intended to help everyday users of Excel present their data in more effective ways using PivotTables and PivotCharts. Users will also learn about advanced analysis tools like the Scenario Manager, goal seek, Solver, PowerPivot, advanced functions, macros, and Visual Basic. Highlights of the course include a solid introduction to creating PivotTables with PowerPivot, coverage of advanced financial functions, hands-on practice with VLOOKUP, extensive coverage of PivotTables and PivotCharts, and an introduction to macros and Visual Basic.
MO13EX201—Microsoft Excel 2013 Advanced Essentials or equivalent is mandatory.