Excel Sample Dashboard

Upgrade your skills using Pivot

Language: English

Instructors: Mahendra Rana

₹1500

Why this course?

Description

An Eye catching view of sales in single spread sheet that summarizes overall sales and provides flexibility to select multiple criteria. The graphs are dynamic and responds to different criterias

Course Curriculum


	What will you learn
		Introduction
		Sales Raw Data
		Dashboard File for Reference
	Make a Blue Print
		Create Sales Trend Pivot Chart
		Creating States and Category Pivot Chart
		Creating Pie Pivot Chart
		Creating Top 10 Chart
		Creating Raw Data for Sparkline
	Creating Dashboard
		Creating Sparkline Report
		Assemble all Charts and Arrange
		Adding Dynamic Text to Pie
		Add Slicer and Build Connection with Multiple Pivot
		Solving REF error and Zero Value
	Bonus Chapter
		Freezing Unhide Option
	Demo Pivot Graph

How to Use

After successful purchase, this item would be added to your courses.You can access your courses in the following ways :

From the computer, you can access your courses after successful login
For other devices, you can access your library using this web app through browser of your device.

Reviews

Load More Reviews