Advanced PivotTables in Excel: Master the Pivot Table!

Take your data analysis skills to new heights with this Advanced course on Pivot Tables in Excel

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I Learn?

• How to create amazing looking dashboards using Pivot Tables
• Advanced data analysis techniques
• How to do a PivotTable (a quick refresher)
• How to format a PivotTable, including adjusting styles
• Advanced Sorting and Filtering in PivotTables
• How to use 3D Maps from a PivotTable
• How to update your data in a PivotTable and Pivot Chart
• Advanced Sorting and Filtering in PivotTables

Requirements

• Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.
• Intermediate knowledge of Microsoft Excel.

Target audience

• Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
• Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.
• People looking to perform Data Analysis using Excel