Using Slicers in Excel
Visual filters for tables, pivot tables, and charts in Excel
About This Course
Course Information
This course introduces the use of slicers and takes you through the basic concepts and techniques. It is divided into two sections. The first section shows the application of slicers to tabular data, whereas the second section demonstrates the use of slicers on graphs and charts.
Certificate on Completion
This course is made up of videos, questions and additional reading materials and accounts for 2 units of CPD. One unit is the equivalent of one hour of learning. A certificate will be issued once you have completed all 2 units.
Course Sections
This Course is made up of the following sections:
- Using Slicers in Excel – Part 1(Video and Quiz)
- Using Slicers in Excel – Part 2 (Video and Quiz)
- Additional Reading Materials
What You Will Learn
- Describe what slicers are and how they differ from standard Excel filters
- Apply slicers to tabular data to filter records by clicking visual buttons
- Apply slicers to charts and graphs using pivot tables and Report Connections
- Explain how to format slicer layout, colours, and column count for dashboard use
- Identify which Excel versions support slicers for tables versus pivot tables only
Who This Course Is For
- Excel users who build reports or dashboards and want interactive filtering
- Accountants who present data to managers and non-technical colleagues using visual tools
- Finance professionals who already use pivot tables and want to add slicer-based navigation
Prerequisites
- Working knowledge of Excel tables and basic pivot table creation
- Familiarity with formatting data as a table using Ctrl+T
Frequently Asked Questions
Course Details
Pricing
Invest in your professional development with flexible payment options.
Everything included in your subscription:
Ready to Start Learning?
Join thousands of finance professionals who have advanced their careers with Learnsignal CPD courses.
Enrol Now