Microsoft Excel Dashboard report with Pivot charts & Slicers

Microsoft Excel Dashboard report with Pivot charts & Slicers

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 0h 22m | 130 MB

This class consist of interactive dashboard report to evaluate performance against set KPIs (in this case to improve sales) with pivot charts & Slicers. In this class you will learn to

  • Create interactive dashboards with Pivot Tables and Pivot Charts
  • Learn best practices for dashboard development
  • Create a Sales Dashboard
  • Learn best practices for Pivot Chart development
  • Improve your effectiveness to develop management reports and gain new insight and intelligence from your data
  • Filter your data effectively with Report Filters and Slicers
Table of Contents

1 Introduction – Microsoft Excel Dashboard report with Pivot charts & Slicers
2 Formating – Microsoft Excel Dashboard report with Pivot charts & Slicers
3 Number of sales per group – Microsoft Excel Dashboard report with Pivot charts & Slicers
4 Product wise sales – Microsoft Excel Dashboard report with Pivot charts & Slicers
5 Sales vs cost – Microsoft Excel Dashboard report with Pivot charts & Slicers
6 Top 5 customers – Microsoft Excel Dashboard report with Pivot charts & Slicers