Microsoft Excel - Excel with Excel Pivot Tables in 1 Hour!

John Michaloudis MyExcelOnline.com, Stand Out From The Crowd

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Lessons (1h)
    • 1. Welcome Introduction

      1:25
    • 2. Why Pivot Tables?

      6:20
    • 3. Excel Tables & Tabular Format

      5:57
    • 4. Creating your first Pivot Table

      6:03
    • 5. Formatting a Pivot Table

      3:57
    • 6. Summarize Values By: Sum, Average, Count

      2:32
    • 7. Show Values As: Year to Date & Variance

      7:16
    • 8. Grouping Your Data

      7:02
    • 9. Inserting Slicers

      3:57
    • 10. Inserting Pivot Charts

      2:19
    • 11. Creating a Dashboard with Slicers & Pivot Charts

      4:12
    • 12. BONUS: Pivot Table Tips!

      9:40
12 students are watching this class

Project Description

Slicer & Pivot Chart Dashboard

3ce6c55c

ASSIGNMENT:

After going through all of the tutorials, I would like you to view tutorial number 11:

11. Creating a Dashboard with Slicers & Pivot Charts

In this tutorial I design an Excel Dashboard using Slicers and Pivot Charts.  It combines several Pivot Table features and the end result is an informative Dashboard that can be used by management for key business insights.

YOUR GOAL:

I want you to create your own Excel Dahboard using Slicers and Pivot Charts! You can get as creative as you want and there are no wrong answer here. I want you to follow these guidelines though:

Include at least 2 Slicers (Slicers are new in Excel 2010 so if you are using Excel 2007 then you can use the Pivot Table Report filter);
Inlcude at least 2 Pivot Charts;
Create at least 2 separate Pivot Tables.


DELIVERABLE:

Upload your final Dashboard to the Project Gallery and I will be on hand to give you valuable feedback.

WORKBOOK:

Please download the attached workbook below which has the data that you will have to work with. You can add extra Columns if you like and make changes to the data as you see fit.

Best of luck :)

John Michaloudis

Chief Inspirational Officer

www.myexcelonline.com

www.myexcelonline.com/blog - Sign Up to receive free weekly Excel lessons

www.myexcelonline.com/podcast - Get the Excel insights from the Excel experts

Student Projects