Course Images

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course

By One Education

5.0(1)

Booking options

£12

Buy Contact Us

30 Day Money Back Guarantee
Completion Certificate
24/7 Technical Support

Highlights

On-Demand course
2 hours
All levels

Description

The Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course focuses on turning large datasets into clear, meaningful summaries using Microsoft Excel’s most powerful analysis features. The course explains how Pivot Tables organise data quickly, how Pivot Charts present insights visually, and how Slicers and Timelines add simple, interactive filtering for better reporting. Clear explanations guide learners through data grouping, sorting, calculated fields, and layout choices, helping information appear structured and easy to interpret.

This course is designed for online learning and suits anyone who works with spreadsheets and needs faster, smarter reporting. Content highlights efficient data exploration, cleaner dashboards, and consistent results for business, finance, administration, and management tasks. By understanding how these Excel tools work together, learners can improve accuracy, save time, and communicate findings with confidence. The course remains focused, engaging, and commercially relevant, making it a strong choice for personal development and professional growth using Excel’s analytical features.

Learning Outcomes:

Understand how to create and manage Pivot Tables in Excel

Analyse data using Pivot Charts and Slicers

Learn how to customise the Pivot Table fields and calculations

Create reports by day, month, quarter, or year using Pivot Tables

Understand how to use PowerQuery and PowerPivot to enhance your analysis

Learn how to refresh Pivot Table data with new data sets

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines

Getting started with your Pivot Table

Drill Down

Managing the Field List

Changing the Calculation type with Value Field Settings

Growing your Pivot Table with Multiple Fields

Formatting the Pivot Table

Sorting and Filtering the Pivot Table

Creating a Dashboard with Slicers, Timelines and Pivot Charts

Reporting by day, month, qtr, or year within the Pivot Table

Refreshing the Pivot Data with new data

Adding your own calculations into the Pivot Table

The power of the Filter Section in the Pivot Table

PowerQuery

PowerPivot

How is the course assessed?

Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%.

Exam & Retakes:
It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.

Certification
Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).