Advanced Pivot Tables in Excel

Advanced Pivot Tables in Excel
  • Tests
  • Anytime Learning
  • Certificates
  • CPD Accredited Training
  • Video Tutorials
  • 30-Day Refund Guarantee

In this Advanced Pivot Tables in Excel course, we teach you how to make the most of the powerful PivotTable function in Excel.


In this course you will learn:

  • How to do a basic Pivot Table (a quick refresher)
  • How to combine data from multiple worksheets for a Pivot Table
  • Grouping, ungrouping and dealing with errors in a Pivot Table
  • How to format a Pivot Table, including adjusting styles
  • How to use Value Field Settings in a Pivot Table
  • How to use Slicers, Timelines on multiple tables
  • How to create and use a Calculated Field in a Pivot Table
  • The GETPIVOTDATA function
  • How to create a Pivot Chart and add sparklines and slicers
  • How to create 3D Maps from a PivotTable
  • How to update your data in a Pivot Table and Pivot Chart
  • How to use Conditional Formatting in a PivotTable
  • How to create a basic macro to refresh Pivot Table data

+ Syllabus


About the author

Simon Sez IT

For this course, we’ve partnered with training experts SimonSezIT, who help learners win when it comes to computer and software technology. Just like EWB, the SimonSezIT team are passionate about Microsoft applications and computer programs, knowing what makes excellent training work. Their content is inventive and compelling, and we’re sure you’ll love it.


If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.

Sale price
£49.00
Regular price
Sale price
£49.00
Regular price
Sold out
Unit price
per 
Tax included.

In this Advanced Pivot Tables in Excel course, we teach you how to make the most of the powerful PivotTable function in Excel.


In this course you will learn:

  • How to do a basic Pivot Table (a quick refresher)
  • How to combine data from multiple worksheets for a Pivot Table
  • Grouping, ungrouping and dealing with errors in a Pivot Table
  • How to format a Pivot Table, including adjusting styles
  • How to use Value Field Settings in a Pivot Table
  • How to use Slicers, Timelines on multiple tables
  • How to create and use a Calculated Field in a Pivot Table
  • The GETPIVOTDATA function
  • How to create a Pivot Chart and add sparklines and slicers
  • How to create 3D Maps from a PivotTable
  • How to update your data in a Pivot Table and Pivot Chart
  • How to use Conditional Formatting in a PivotTable
  • How to create a basic macro to refresh Pivot Table data

+ Syllabus


About the author

Simon Sez IT

For this course, we’ve partnered with training experts SimonSezIT, who help learners win when it comes to computer and software technology. Just like EWB, the SimonSezIT team are passionate about Microsoft applications and computer programs, knowing what makes excellent training work. Their content is inventive and compelling, and we’re sure you’ll love it.


If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.