Excel Pivot Tables, Pivot Charts & Slicers for Analysing and Presenting Data

In our day to day work environment we tend to use Excel’s great features of calculation, sorting and storing information to create efficient, functional spreadsheets. However, there are other elements within Excel that can transform spreadsheets into powerful and efficient business tools. The PivotTable is probably Excel's most powerful feature set. A PivotTable is a powerful tool to calculate, summarise, and analyse data that lets you see comparisons, patterns, and trends in your data.  On completion of this half-day workshop, delegates will be familiar with using PivotTables, PivotCharts and Slicers to calculate, analyse and summarise data.

 

Course Content

  • Create a PivotTable from a List or Table
  • PivotTable Layout
  • Format the PivotTable
  • Update and Refresh the PivotTable
  • Customise the PivotTable Report Layout
  • Explore Field Options – "summarise values as", "show values as"
  • Use Calculated Fields
  • PivotTable Options
  • Filter the PivotTable Data
  • Group the Data
  • Create a PivotChart
  • Filter Data with Slicers and Timeline

 

Target Trainee Profile

 

Those who are familiar with the basics of Excel but who wish to learn more about the capabilities of PivotTables.  Anyone who needs to extract information from large data sets.  Delegates should already be using Excel on a regular basis.  They should also be familiar with creating and editing spreadsheets and with the basics of calculation and formatting.