ABOUT THIS COURSE

In this Microsoft Excel Pivot Tables and Advanced Filtering training course, delegates will learn how to quickly explore and analyse raw data using Excel. After completing this course delegates will be able to: 

  • Apply multiple and custom filters to data 
  • Enable filtering by colour 
  • Design and create pivot tables 
  • Apply pivot table calculations and report pages 
  • Filter pivot tables

COURSE CURRICULUM

  • 3

    Pivot Tables

    • Calculated Fields

    • Totals Analysis

    • Slicers and Timelines

    • Report Pages

    • Multiple Pivot Tables

    • Modifying Pivot Tables

    • Linked Calculations

    • Grouping Data

    • Filtering and Sorting

    • External Data

    • Data Consolidation

    • Dashboard Creation

    • Creating and Formatting Pivot Tables

    • Conditional Formatting

    • Charts and Chart Design

    • Calculated Items

    • Calculated Fields

MEET YOUR INSTRUCTOR

Senior Instructor

Richard Walters

Richard Walters is one of NILC's Senior Level Trainer's with more than a decade of experience in IT and Business Skills training. Richard has a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project.

FREQUENTLY ASKED QUESTIONS

When does the course start and finish?

The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.


How long do I have access to the course?

How does 1 years access sound? After enrolling, you have unlimited access to this course for 365 days - across any and all devices you own.


What if I am unhappy with the course?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.

GET STARTED NOW

  • £99.99

    365 days access to Microsoft Excel Pivot Tables and Advanced Filtering

    Get started now

RECOMMENDED FOR YOU