Excel Pivot Table Slicers

For Beginners, Intermediate & Advanced Excel Users
Course Created by MyExcelOnline | John Michaloudis
I am the founder of MyExcelOnline and long time lover of Excel.

I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish.

My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilised but powerful tool. Now its my turn to teach the rest of the world!

I am currently living in the North of Spain and I´m married and have one cheeky boy.
You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

Pivot Table Slicers are NEW in Microsoft Excel 2010.

Slicers are easy-to-use filtering components that contain a set of interactive buttons that enable you to quickly filter the data in a PivotTable report, without the need to open drop-down lists to find the items that you want to filter.

Pre Excel 2010 when you had to filter on multiple items, the filter indicated only that multiple items are filtered, and you had to open a drop-down list to find the filtering details. Not very useful.

However, a Slicer clearly labels the filter that is applied and provides details so that you can easily understand the data that is displayed in the filtered PivotTable report.
  In addition to quick filtering, you can also style the Slicers to the colors and design that you want!

In this course you will learn all the different Slicer tools and tricks to make you a better analyst, create awesome looking Reports and Dashboard and Stand Out From the Crowd!

Course Objectives

  • Insert & Style a Slicer
  • Analyze and drill down on specific financial information
  • Become an expert in Slicers
  • Create awesome looking Dashboard for management

Who Is This For?

  • New users, beginners, intermediates and advanced Excel users
  • Financial Analysts, Business Controllers, Accountants, Auditors, Sales Managers, Administrative Assistants

Course Outline

Chapter 1: INTRODUCTION TO SLICERS

  • Lesson 1
    Insert a Slicer
    04:02
  • Lesson 2
    Slicer Styles
    02:27
  • Lesson 3
    Creating a custom style
    05:39
  • Lesson 4
    Copy a custom style into a …
    01:41
  • Lesson 5
    Slicer Settings
    04:51
  • Lesson 6
    Slicer Size & Properties
    03:04
  • Lesson 7
    Slicer Connections for mult…
    03:25

Chapter 2: SLICER TIPS

  • Lesson 8
    Different ways to filter a …
    01:23
  • Lesson 9
    Use one slicer for two pivo…
    01:27
  • Lesson 10
    Lock the workbook but not t…
    01:34
  • Lesson 11
    Interactive employee photos…
    09:29

Chapter 3: BUSINESS CASE STUDIES

  • Lesson 12
    ACCOUNTING: Select a Monthl…
    04:21
  • Lesson 13
    FINANCIAL: Base, Best & Wor…
    05:11

Chapter 4: BONUS MATERIAL

  • Lesson 14
    Insert a Slicer with a Pivo…
    02:01
  • Lesson 15
    Change Chart Type with Slic…
    08:09
  • Lesson 16
    Pivot Table Slicer & Chart …
    15:56
  • Lesson 17
    Control Conditional Formatt…
    02:55
  • Lesson 18
    Several Slicer Custom Style…
    02:04
  • Lesson 19
    Interactive Balance Sheet P…
    12:22
  • Lesson 20
    Monthly Sales Manager Perfo…
    04:36

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)