Excel 2013-2016 Advanced PivotTables

 Price: $25 incl GST

Duration: 1 hour

This updated session assumes you are already using pivottables. Topics covered include

  • Calculated Fields – what they are and how and why to use them
  • Calculated Items – what they are and how and why to use them
  • Advanced filtering
  • Useful Report Layouts
  • Conditional Formatting
  • Adding relationships so you can report on two tables as once
  • Data normalisation and variance analysis example using Power Query
  • Two handy macros that can speed up pivot table creation

 

As always, I will share a few general tips along the way.

Date: October 24, 2018
Time: 1:00 PM AEDST
Event: Webinar - Excel 2013-2016 Advanced PivotTables
Topic: Excel 2013-2016 Advanced PivotTables
Public: Public
Registration: Click here to register.