Free Online Training: PivotTables and Advanced Charts in Excel 2016


If you've never used PivotTables and PivotCharts in Excel then these are excellent tools to help summarise and show key data in new ways. We have a free online training course called PivotTables and Advanced Charts in Excel 2016 available for Business Achievers members.

Join our Business Achievers community and get access to downloads to help your business, free online training courses and network with members to help grow your business. 

About the Training Course

In Microsoft Excel 2016, PivotTables and PivotCharts let you dynamically reorganize and display your data. They can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. You can choose and change what you want to summarize. In this course, you will also learn how to use advanced chart features like trendlines and dual axis charts.

Who the Course is For

End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

What the Course Covers

It takes just under an hour to go through and the course covers:

- creating a PivotTable in Microsoft Excel 2016 
- modifying the data in a PivotTable
- filtering PivotTable data with slicers 
- using recommended charts to create a PivotChart 
- adding trendlines to a chart
- creating a dual axis chart 
- presenting data in PivotTables and PivotCharts

To access this free online training course click here

Related Posts



No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Monday, 23 September 2019
If you'd like to register, please fill in the username, password and name fields.

Member Login

Business Insights & Tips


Jill Holtz
2109 Points
Tena Glaser
1394 Points
Michael Lane
802 Points
Ron Immink
732 Points
Fionan Murray
721 Points
View Leaderboard