Pivot Table is an excellent data analysis and reporting tool in Microsoft Excel 2016/2019/365 Users that enable you to create summary of large data in a few clicks. You can use Pivot Table to sort, count, total or give the average of the data stored in a table, display the results in a second table and show the summarized data automatically. The new chart types and improvements added to Microsoft Excel 2016/2019/365 Users makes PivotTables easier to work with a large amount of data rapidly and give it even more meaning!
This 2-days course will teach the participants useful skills such as prepare the source data for PivotTable, convert source data to table, change the PivotTable report layouts, apply PivotTable styles, sort, filter and group PivotTable data, create PivotChart, apply conditional formats, perform calculations, import external data sources, create table relationships, create slicer and timeline to filter data, as well as build dynamic reports to facilitate data analysis.
If you want to replace manual tracking of data with interactive data analysis and dynamic reports, this is the perfect course for you. This course covers PivotTable related contents from beginner level to advanced level.
