Excel Pivot Tables: Get a Handle on your Data

Excel’s Pivot Tables enable you to quickly create concise reports from large data sets, spot trends by consolidating information and display results for multiple variable questions ‐ plus you can easily create Pivot Charts to visually represent your data. Stop writing complicated formulas, creating multiple worksheets, and using Sort and Filter commands ‐ and make Pivot Tables do the work for you!

Course Topics

•  analysing data using pivot tables
•  creating pivot tables from worksheet data
•  recommended pivot tables
•  using the pivot table wizard
•  using the pivot table toolbar
•  managing pivot tables
•  modifying a pivot table
•  filtering & sorting pivot table
•  using slicers to filter pivot table data
•  adding sparklines to a pivot table
•  adding calculated fields to a pivot table
•  creating a chart from a pivot table
•  showing/hiding pivot table data

Follow on Courses

• Data Analysis with PivotTables and PowerPivot
• Power BI