Microsoft Excel 2 Hour Pivots & Graphs Bitesize Module

Learn the power of pivots and graphs to help you analyse data in a clear, meaningful way, saving you hours in manual sorting and segmenting. Produce graphical representations of your findings to aid slicker reports for your colleagues and clients.

Format: 2 Hour Virtual Session: Max Capacity 4

Wireless Computer Accessories
microsoft-excel-seeklogo.com.png

Session Topics

 

  • Use Power Query results as data sources

  • Pivot table Settings

  • Using multiple filter fields

  • GetPivotData Function

  • Fields, Items and Sets

  • Custom Grouping

  • Slicers and Timelines

  • Unlinking Pivot Tables and Pivot Charts