Pivot Table for Dashboards

	A	B	C	D
1	Google Sheet's Pivot Table - for Dashboards (A-Z)
2
3	SN	Topic	Status	Series
4

5	1	Pre-requisite - Flat File data (1 line = 1 tranx.), Column Headings		001
6	2	Create a Pivot Table from Data tab		001
7	3	Understanding the 4 Layouts - Row, Col, Values, Filter		001
8	4	Sort		002
9	5	Values = Mathematical Calculations (Aggregate - SUM)		002
10	6	Values = Mathematical Calculations (% of)		002
11	7	Rename Headings		003
12	8	Drill-Down (~double click)		003
13	9	Filter		003
14
15	10	Expand & Collapse (+/- buttons)		004
16	11	Change the sequence of Field items		004
17	12	Repeat Row Labels (~Fill Blanks)		004
18	13	Show Totals (~Subtotals)		004
19
20	14	Create Pivot- Date Group - for Dates (with Years and Months trick)		005
21	15	Create Pivot- Group Rule - for Numbers		006
22	16	Create Pivot- Group - for Text		007
23	17	Slicers		008
24	18	Design & Formatting - using Theme		009
25	19	Applying Basic Conditional Formatting - Color Scale for Heatmap		009
26	20	SPARKLINE() trick - for Dynamic Data Bars		009
27
28	21	Basics of Calculated Field e.g. 'Gross Sales Amt' * 2		010
29	22	Calculated Field - They fail at the granular level		010
30	23	Convert CrossTab to Flat data (Unpivot)		011
31
32
33		About the Course Instructor:
34
35		Rishabh Pugalia, Chartered Accountant
36		Previously worked with J.P. Morgan, KPMG, & G.H. Financials
37		Trained at 150+ companies including EY, PwC, Flipkart (Walmart), PepsiCo etc.
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100