ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
EXCEL FOR CONSULTANTS
3
Beginner to Advanced — Learn. Practice. Apply.
4
5
6
7
Created by Mitali Mittal | PMP | Ex-KPMG | @tech_mitali_mittal
8
9
HOW TO USE THIS WORKBOOK
10
📗 Formulas ReferenceComplete formula library — beginner to advanced with syntax and real examples
11
12
📊 Practice DataA realistic dataset to practice every formula on — a real consulting project scenario
13
14
🎯 Case Study 1Vendor Evaluation — score and rank vendors using Excel formulas
15
16
🎯 Case Study 2Sales Performance Analysis — analyse a team's quarterly performance
17
18
🎯 Case Study 3IT Budget Tracker — track, categorise and analyse IT spend
19
20
🃏 FlashcardsPrint-and-cut formula flashcards — formula on front, explanation on back
21
22
🏆 QuizTest yourself — 20 questions across all levels
23
24
25
26
⚠️ Views expressed are my own. For educational purposes only. © Mitali Mittal. All rights reserved.
27
28
29
30
31
32
33
34
35
36
37
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