About the course

  • Pre-requisites

    You'll need Excel 2010, 2013 or 2016 installed. Ideally you should be familiar with working with big sets of data. An understanding of using Filtering an Charts would also be advantageous.

  • Who will benefit?

    Managers, Data Analysts, Accountants and anyone else who needs to analyse and create reports from large data sets.

  • Course Outcomes

    You'll be able to understand how to create Pivot Table reports and best practices to get the results you need.

  • Course Duration

    The course will take approximately 1 hour to complete.

Course curriculum

  • 1
    Welcome to the course!
    • Here's what you'll be learning...
    • Exercise Files
  • 2
    Module 1 - Introduction to Pivot Tables
    • Introduction to Pivot Tables
  • 3
    Module 2 - Analyse and Group data
    • Analysing Data
    • Grouping Data
  • 4
    Module 3 - Filtering Data using Slicers
    • Slicers
  • 5
    Module 4 - Illustrate data with Pivot Charts
    • Pivot Charts
  • 6
    Course Survey
    • Before you go, we'd love to hear your feedback on the course please...

Course Instructor

  • Simon Lambourne-Wills

    Microsoft Office and Office365 Trainer

    Simon Lambourne-Wills

    I’ve been an IT trainer for over 10 years and have acquired many skills in teaching different software packages to students of all abilities. I aim to build confidence in all attendees of the courses that I teach, for both large and small groups. Through my professional conduct and enthusiasm when working with learners of mixed levels, I am able to create good rapport with students, which forms a high-quality learning environment. I believe it’s important to enjoy attending training courses. Therefore, engaging and interacting with students on their own experiences of using the software, enables them to feel more involved in the course.

Other Bitesize Courses