Pivot Tables

• Preparing Your Data Ready for Pivot Tables

  • Best Practise
  • Data Range Vs Table

  Creating Pivot Tables

  • Pivot Table 1 – Standard Pivot
  • Pivot Table 2 – Formatting a Pivot Table
  • Pivot Table 3 – Summary Pivot
  • Pivot Table 4 – Show Values As

  Grouping Excel Pivot Table Data

  • Pivot Table 5 – Group by Numbers
  • Pivot Table 6 – Group by Dates
  • Pivot Table 7 – Group by Text

  Slicers

  • How to add slicer for Pivot tables in Excel
  • Changing the appearance of the slicer
  • Adding a timeline slicer (Excel 2013 Onwards)

  Pivot Charts

  • What is a Pivot Chart
  • Create a Pivot Chart
  • Using Slicers with Charts
  • How to drill down into your data via a Pivot Chart (Excel 2016 only)

  Dashboard

  • Creating a simply non VBA dashboard
  • Adding slicers and charts
  • Linking slicers to multiple charts

  Tips and Tricks to Improve the Appearance of your Pivot Table

  • Handling how empty cells are displayed
  • Stop Auto-Width of columns when you refresh the data
  • How to auto refresh your Pivot Table
  • Create a Pipeline Pivot Table
  • How to Handle error messages in your Pivot Table

  Top 10

  • Using Pivot Table Top 10 Filters

  Report Filter to Worksheets

  • Create Multiple Pivot Table Reports with Show Report Filter Pages

  GetPivotData Function

  • Use the Excel GETPIVOTDATA function to query a pivot table. Retrieve data from a pivot table in a formula.

  Calculated Fields

  • Create calculated fields, using formulas that work with the sum of other pivot fields.

  Calculated Items

  • Learn the difference between Excel pivot table calculated fields and calculated items. When and how to use them, examples and warnings.

In-house Course Fee

*All prices are excluded from VAT.

For any in-house enquiries, please contact us on 020 7183 8357.

More than one school can gather to request an in-house training. Maximum number of delegates is 12 for a quality training session. We can organise sessions in the morning and afternoon if your request more than 12 delegates to attend.

Alternatively, contact us by telephone/email to speak to one of our consultants to discuss your school’s needs, options and request a Personalised Training package.

Since 2006, we have specialised in ASP (formerly RAISEonline Training) for all schools and local authorities to analyse your school’s performance and progress data with your colleagues.

Our mission is to provide quality and multifaceted consultancy in education and training in Early Years settings, Primary Schools, Secondary Schools, Special Schools, Church Schools and Independent Schools.

ASP training and consultancy sessions can be personalised to support the professional development needs of your school team and offer consultancy support to Head Teachers, Deputy Head Teachers, Senior Management Teams, Subject Leaders, SENCO’s, Gifted and Talented Leaders, Class teachers, Newly Qualified Teachers, Learning Support Assistants and Governors.

We are here to support you with using tools such as ASP, Ofsted IDSR’s, Excel, FFT and MIS Systems as well as provide guidance for Governing Bodies, creating your school’s data story, EYFS, SEN, Gifted and Talented, Leadership and Management, School Improvement and Ofsted Preparation.

You can select your audience – Training can be 1:1 for Headteachers and Deputies, for particular focus groups or whole staff teams.

ASP & IDSR Primary
ASP & IDSR Secondary
ASP & IDSR Post 16

Microsoft Excel
Introduction
Intermediate
Advanced
Expert
Pivot Tables
Dashboards
Excel Charts
Excel VBA Introduction

Power BI
Introduction 1 Day
Introduction 2 Days
Intermediate 2 Days
Advanced 2 Days

Microsoft Word
Introduction
Intermediate
Advanced

Microsoft PowerPoint
Microsoft Teams
Microsoft Sharepoint – End User

Data Story Course
Fischer Family Trust

If you would like to book a course or find out more about our bespoke training, please fill the contact form below and we will get back to you as soon as possible. Please contact us on 0207 183 8357, option 5.

Please note, the below booking form will not be available until you accept the use of cookies and refresh