One of the most powerful tools that Excel 2013 provides is the collection of PivotTables, PivotCharts, and PowerPivot. These tools allow you to dynamically reorganise and display your data. They can summarise huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganising your spreadsheet. You can choose and change what you want to summarize. In addition to these benefits, PowerPivot has the ability to handle huge amounts of data, quickly and easily. The course also shows how to create advanced chart elements, such as trend lines and dual axis.
This online course forms part of the SkillsNet short course suite.
Professionals seeking to improve competency in Excel.