Master the ways of presenting your data effectively by using PivotTables etc.
Microsoft Office Excel 2010 is the latest version of Microsoft’s spreadsheet program. Excel is a popular tool for creating spreadsheets, analyzing data, and charting information. This new version of Excel incorporates robust error checking, numerous file validation/verification tools, image editing, and Sparklines (charts within individual cells). 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.