Excel Expert Dashboards Course

Business efficiency and success start with the ability to measure, analyze, and report results effectively. My Excel classes are designed to take you beyond the basics—teaching you how to harness the power of spreadsheets to streamline workflows, make data-driven decisions, and drive measurable results. Whether you're looking to create dynamic dashboards, automate repetitive tasks, or gain insights from complex data, this self-paced video class will equip you with the skills you need to excel at work and achieve your goals. Transform the way you manage and present information—improve your productivity and impact today! Ready to level up? Enroll now and become the Excel expert your team needs.

Course Curriculum

14 Chapters · 229 Lessons

1
Chapter 1 The Excel Basics
1. (Included in full purchase)
  Get started here
2. (Included in full purchase)
  Get the workbook here
3. (Included in full purchase)
  Excel eBook
4. (Included in full purchase)
  Shortcut PDF
5. (Included in full purchase)
  Excel dictionary of errors and how to fix
6. (Included in full purchase)
  1. 4 things not to do
7. (Included in full purchase)
  2. Mistakes
8. (Included in full purchase)
  3. Beginner math
9. (Included in full purchase)
  3a. Cell reference
10. (Included in full purchase)
  4. Cell reference types
11. (Included in full purchase)
  5. Find active cell
12. (Included in full purchase)
  6. Fill blanks
13. (Included in full purchase)
  7. Formatting an invoice
14. (Included in full purchase)
  7b. Auto format
15. (Included in full purchase)
  8. HOI HOA
16. (Included in full purchase)
  9. Switch
17. (Included in full purchase)
  10. Freeze row and column
18. (Included in full purchase)
  11. Table
19. (Included in full purchase)
  12. Untable
20. (Included in full purchase)
  13. Paste special values
21. (Included in full purchase)
  14. Flash
22. (Included in full purchase)
  15. Rounding
23. (Included in full purchase)
  16. Protect
24. (Included in full purchase)
  17. Tenure or age
25. (Included in full purchase)
  18. Flash fill
26. (Included in full purchase)
  19. Hide digits
27. (Included in full purchase)
  20. Join with &
28. (Included in full purchase)
  21. Fill Right
29. (Included in full purchase)
  22. Separate names
30. (Included in full purchase)
  23. Replace
31. (Included in full purchase)
  24. Alt ;
32. (Included in full purchase)
  25. IFERROR
33. (Included in full purchase)
  26. Data validation drop down
34. (Included in full purchase)
  27. Folders
35. (Included in full purchase)
  Chapter 1 Supplemental Reading
2
Chapter 2 Sorting and Filtering
1. (Included in full purchase)
  28. Auto sort
2. (Included in full purchase)
  29. Custom sort
3. (Included in full purchase)
  30. Filter images
4. (Included in full purchase)
  31. Sort top 3
5. (Included in full purchase)
  32. Project timeline
6. (Included in full purchase)
  33. Text string filter
7. (Included in full purchase)
  Chapter 2 Supplemental Reading
3
Chapter 3 Math and Advanced Functions
1. (Included in full purchase)
  34. Min max
2. (Included in full purchase)
  35. Budget
3. (Included in full purchase)
  36. AVERAGEIF
4. (Included in full purchase)
  37. SUMIF
5. (Included in full purchase)
  38. AutoSum
6. (Included in full purchase)
  39. Sum with criteria
7. (Included in full purchase)
  39b. Sum with criteria checkbox
8. (Included in full purchase)
  40. Slicers
9. (Included in full purchase)
  41. SUMIFS
10. (Included in full purchase)
  42. Running Total
11. (Included in full purchase)
  43. COUNTIF wildcard
12. (Included in full purchase)
  43b. COUNTIF colors
13. (Included in full purchase)
  44. Payment
14. (Included in full purchase)
  45. Payment house
15. (Included in full purchase)
  46. Goal seek
16. (Included in full purchase)
  47. Weighted average
17. (Included in full purchase)
  48. Time
18. (Included in full purchase)
  Chapter 3 Supplemental Reading
4
Chapter 4 Format and clean up
1. (Included in full purchase)
  49. Formatting
2. (Included in full purchase)
  50. Correcting CAPS
3. (Included in full purchase)
  51. Trim spaces
4. (Included in full purchase)
  51b. Find and replace
5. (Included in full purchase)
  51c. Text to columns
6. (Included in full purchase)
  52. Alignment icons
7. (Included in full purchase)
  53. Rotate headers
8. (Included in full purchase)
  54. Merge and center
9. (Included in full purchase)
  55. Remove blanks
10. (Included in full purchase)
  56. Rename headings
11. (Included in full purchase)
  57. Number format
12. (Included in full purchase)
  58. Wraprows
13. (Included in full purchase)
  58b. Row break out
14. (Included in full purchase)
  Chapter 4 Supplemental Reading
5
Chapter 5 Lookup and Search
1. (Included in full purchase)
  59. XLOOKUP
2. (Included in full purchase)
  60. VLOOKUP
3. (Included in full purchase)
  60b. Advanced VLOOKUP
4. (Included in full purchase)
  60c. PDF
5. (Included in full purchase)
  61. VLOOKUP vs. XLOOKUP
6. (Included in full purchase)
  62. XLOOKUP more
7. (Included in full purchase)
  63. HLOOKUP
8. (Included in full purchase)
  64. LOOKUP
9. (Included in full purchase)
  65. LOOKUP more
10. (Included in full purchase)
  66. VLOOKUP and Match
11. (Included in full purchase)
  67. Filter List
12. (Included in full purchase)
  68. Search
13. (Included in full purchase)
  69. Search bar
14. (Included in full purchase)
  70. Get from database
15. (Included in full purchase)
  Chapter 5 Supplemental Reading
6
Chaper 6 Lists
1. (Included in full purchase)
  71. Assign teams
2. (Included in full purchase)
  72. Duplicates with conditional formatting
3. (Included in full purchase)
  72b. Compare duplicate and unique
4. (Included in full purchase)
  73. Unique and vstack
5. (Included in full purchase)
  74. Form
6. (Included in full purchase)
  74b. Printable form
7. (Included in full purchase)
  75. Split out column
8. (Included in full purchase)
  76. List comparison
9. (Included in full purchase)
  Chapter 6 Supplemental Reading
7
Chapter 7 PivotTables
1. (Included in full purchase)
  77. PivotTables
2. (Included in full purchase)
  78. Another PivotTable
3. (Included in full purchase)
  79. PivotTable calculated fields
4. (Included in full purchase)
  Chapter 7 Supplemental Reading
8
Chapter 8 Indicators
1. (Included in full purchase)
  80. Grades
2. (Included in full purchase)
  80b. Green red
3. (Included in full purchase)
  81. Up down indicators
4. (Included in full purchase)
  82. Over under goal
5. (Included in full purchase)
  83. Color-coded approvals
6. (Included in full purchase)
  83b. Color-coded status
7. (Included in full purchase)
  83c. Checkbox timestamps
8. (Included in full purchase)
  84. Checkmark
9. (Included in full purchase)
  85. Nested IF, AND, OR statements
10. (Included in full purchase)
  Chapter 8 Supplemental Reading
9
Chapter 9 Charts
1. (Included in full purchase)
  86. Dashboard shapes
2. (Included in full purchase)
  86b. Data labels
3. (Included in full purchase)
  87. Shapes
4. (Included in full purchase)
  88. Chart template
5. (Included in full purchase)
  88b. Radial bar chart
6. (Included in full purchase)
  89. Color scales
7. (Included in full purchase)
  90. Dynamic progress bars
8. (Included in full purchase)
  90b. Multi stage progress bar
9. (Included in full purchase)
  90c. Progress bar dashboard
10. (Included in full purchase)
  90d. Box plot
11. (Included in full purchase)
  91. Scatterplot
12. (Included in full purchase)
  91b. Bubble dashboard
13. (Included in full purchase)
  92. Data bars
14. (Included in full purchase)
  92b. Advanced Bar Chart
15. (Included in full purchase)
  92c. Conditional format color scale
16. (Included in full purchase)
  93. Bullet chart
17. (Included in full purchase)
  93b. Circular bullet chart
18. (Included in full purchase)
  94. Speedometer
19. (Included in full purchase)
  94b. Speedometer dashboard
20. (Included in full purchase)
  95. Donut chart
21. (Included in full purchase)
  95b. Progree donut charts
22. (Included in full purchase)
  95c. Weekly 1:1 progress
23. (Included in full purchase)
  96. Checkbox chart
24. (Included in full purchase)
  97. Dashboard
25. (Included in full purchase)
  97b. Dashboard line and bar
26. 98. Full Dashboard pie and progress bars Free preview
27. (Included in full purchase)
  98b. Dashboard part 1
28. (Included in full purchase)
  98b. Dashboard part 2
29. (Included in full purchase)
  98c. Slicer dashboard
30. (Included in full purchase)
  98d. Project progress
31. (Included in full purchase)
  98e. Job tracker
32. (Included in full purchase)
  98f. Employee dashboard
33. (Included in full purchase)
  98f. Renaming pivots
34. (Included in full purchase)
  98g. Dashboard with tree chart
35. (Included in full purchase)
  98h. Dashboard with tabs
36. (Included in full purchase)
  98i. Project dashboard
37. (Included in full purchase)
  98j. Dashboard
38. (Included in full purchase)
  98k. Blue icon dashboard
39. (Included in full purchase)
  98l. Dashboard with shapes/3D
40. (Included in full purchase)
  98m. Expense dashboard
41. (Included in full purchase)
  98n. Customer dashboard
42. (Included in full purchase)
  98o. Sales dashboard
43. (Included in full purchase)
  98p. Sales report dashboard
44. (Included in full purchase)
  98q. Dashboard
45. (Included in full purchase)
  98r. Project Tracker
46. (Included in full purchase)
  98s. Sales Report
47. (Included in full purchase)
  99. Sparkline
48. (Included in full purchase)
  100. Actual variance chart
49. (Included in full purchase)
  100b. Actual to goal chart
50. (Included in full purchase)
  100c. Custom image chart
51. (Included in full purchase)
  100d. Variance chart
52. (Included in full purchase)
  100e. Quarter to total chart
53. (Included in full purchase)
  101. Project timeline chart
54. (Included in full purchase)
  102. Gantt 1
55. (Included in full purchase)
  102b. Gantt example 2
56. (Included in full purchase)
  102c. Advanced Gantt
57. (Included in full purchase)
  103. Waffle charts
58. (Included in full purchase)
  104. Waffle chart
59. (Included in full purchase)
  104b. Attendance waffle
60. (Included in full purchase)
  104c. Attendance tracker
61. (Included in full purchase)
  105. Busy time chart
62. (Included in full purchase)
  105b. Likert scale
63. (Included in full purchase)
  106. Milestone chart
64. (Included in full purchase)
  107. Budget to actual
65. (Included in full purchase)
  108. New sparklines
66. (Included in full purchase)
  108b. Sparklines column
67. (Included in full purchase)
  109. Progress completion bar
68. (Included in full purchase)
  110. Full budget
69. (Included in full purchase)
  110b. McKinsey chart
70. (Included in full purchase)
  110c. Butterfly chart
71. (Included in full purchase)
  110d. Pie chart vs. tree map
72. (Included in full purchase)
  110e. KPI scorecard
73. (Included in full purchase)
  110f. Step chart checkbox
74. (Included in full purchase)
  110g. Scatter line chart
75. (Included in full purchase)
  110h. All the chart basics
76. (Included in full purchase)
  Chapter 9 Supplemental Reading
10
Chapter 10 Random fun things
1. (Included in full purchase)
  111. QR codes
2. (Included in full purchase)
  112. Bingo
3. (Included in full purchase)
  113. Org chart
4. (Included in full purchase)
  114. Photo org chart
5. (Included in full purchase)
  114b. Photo in cell
6. (Included in full purchase)
  115. Side perspective image
7. (Included in full purchase)
  116. Image graph
8. (Included in full purchase)
  116b. Country map
9. (Included in full purchase)
  117. Insert your own signature
10. (Included in full purchase)
  118. Let's use the camera to snapshot dynamic data
11. (Included in full purchase)
  119. Dynamic calendar
12. (Included in full purchase)
  120. Calendar days
13. (Included in full purchase)
  120b. Work day calendar
14. (Included in full purchase)
  121. Annual calendar
15. (Included in full purchase)
  121b. Fishbone
16. (Included in full purchase)
  121c. RACI matrix
17. (Included in full purchase)
  121d. Closet inventory dashboard
18. (Included in full purchase)
  Chapter 10 Supplemental Reading
11
Chapter 11 VBA fun
1. (Included in full purchase)
  122. Make your own custom function
2. (Included in full purchase)
  123. Change notice
3. (Included in full purchase)
  123b. Notes within formulas
4. (Included in full purchase)
  124. Highlight the active cell
5. (Included in full purchase)
  125. Autofit rows and columns
6. (Included in full purchase)
  Chapter 11 Supplemental Reading
12
Chapter 12 Developer tab fun
1. (Included in full purchase)
  126. Button counter
2. (Included in full purchase)
  126. Button counter and speedometer dashboard
3. (Included in full purchase)
  126c. Cross it off
4. (Included in full purchase)
  126d. New checkboxes
5. (Included in full purchase)
  127. Radio buttons
6. (Included in full purchase)
  128. Macros
7. (Included in full purchase)
  Chapter 12 Supplemental Reading
13
Chapter 13 Pro tips
1. (Included in full purchase)
  Merge and center issues
2. (Included in full purchase)
  Align your charts
3. (Included in full purchase)
  How to split your screen
4. (Included in full purchase)
  Import data from your phone
5. (Included in full purchase)
  Errors and how to correct them
6. (Included in full purchase)
  Finding your tab trick
7. (Included in full purchase)
  Combining files tip
8. (Included in full purchase)
  How to get the developer tab
9. (Included in full purchase)
  Table of contents on Get Started tab
14
Chapter 14 Wrap up
1. (Included in full purchase)
  General knowledge Excel quiz

BECOME AN EXCEL EXPERT IN 200+ SKILLS

Course Curriculum

Chapter 1 The Excel Basics

Chapter 2 Sorting and Filtering

Chapter 3 Math and Advanced Functions

Chapter 4 Format and clean up

Chapter 5 Lookup and Search

Chaper 6 Lists

Chapter 7 PivotTables

Chapter 8 Indicators

Chapter 9 Charts

Chapter 10 Random fun things

Chapter 11 VBA fun

Chapter 12 Developer tab fun

Chapter 13 Pro tips

Chapter 14 Wrap up