Master Excel Course Landing

Unlock the power of Excel with this beginner-to-intermediate class, designed to teach you over 80 essential skills through hands-on learning with an event budget planner. This course will give you the foundational knowledge needed to efficiently manage data, analyze trends, and create professional reports. You'll master the Excel tools that streamline workflows and help you make smarter, data-driven decisions. What makes this course different is you're learning from an executive who has gone from analyst to Microsoft MVP to executive and I show you exactly what you need to be successful at work. You can complete this course before lunch and know everything needed to save time, summarize data, and effectively use Excel. We start with creating an event planner and then, you take all of those skills and apply them to the most common work scenarios while I walk you through it. In the end you have an event planner, budget, order and project tracker. Start mastering Excel today and elevate your productivity! Ready to boost your career? Enroll now and take the first step toward becoming an Excel super user.

Course Curriculum

6 Chapters · 148 Lessons

1
Learn Excel Foundations Creating an Event Planner
1. (Included in full purchase)
  Get Started
2. (Included in full purchase)
  Download this workbook for the course
3. (Included in full purchase)
  1. Ribbon Basics
4. (Included in full purchase)
  Lesson 1 Supplemental Reading
5. (Included in full purchase)
  Lesson 1 Quiz
6. (Included in full purchase)
  2. Cell Address and Cell Reference Type
7. (Included in full purchase)
  Lesson 2 Supplemental Reading
8. (Included in full purchase)
  Lesson 2 Quiz
9. (Included in full purchase)
  3. Freeze Panes
10. (Included in full purchase)
  Lesson 3 Supplemental Reading
11. (Included in full purchase)
  Lesson 3 Quiz
12. (Included in full purchase)
  4. Row and Column Features
13. (Included in full purchase)
  Lesson 4 Supplemental Reading
14. (Included in full purchase)
  Lesson 4 Quiz
15. (Included in full purchase)
  5. Wrap Text and Adding a Line
16. (Included in full purchase)
  Lesson 5 Supplemental Reading
17. (Included in full purchase)
  Lesson 5 Quiz
18. (Included in full purchase)
  6. Proper
19. (Included in full purchase)
  Lesson 6 Supplemental Reading
20. (Included in full purchase)
  Lesson 6 Quiz
21. (Included in full purchase)
  7. Formatting & Alignment
22. (Included in full purchase)
  Lesson 7 Supplemental Reading
23. (Included in full purchase)
  Lesson 7 Quiz
24. (Included in full purchase)
  8. Merge & Center
25. (Included in full purchase)
  Lesson 8 Supplemental Reading
26. (Included in full purchase)
  Lesson 8 Quiz
27. (Included in full purchase)
  9. Icons & Shapes
28. (Included in full purchase)
  Lesson 9 Supplemental Reading
29. (Included in full purchase)
  Lesson 9 Quiz
30. (Included in full purchase)
  10. Tables
31. (Included in full purchase)
  Lesson 10 Supplemental Reading
32. (Included in full purchase)
  Lesson 10 Quiz
33. (Included in full purchase)
  11. Rounding and Decimals
34. (Included in full purchase)
  Lesson 11 Supplemental Reading
35. (Included in full purchase)
  Lesson 11 Quiz
36. (Included in full purchase)
  12. Join Cells
37. (Included in full purchase)
  Lesson 12 Supplemental Reading
38. (Included in full purchase)
  Lesson 12 Quiz
39. (Included in full purchase)
  13. Flash Fill
40. (Included in full purchase)
  Lesson 13 Supplemental Reading
41. (Included in full purchase)
  Lesson 13 Quiz
42. 14. Check Boxes, IF, Count Free preview
43. (Included in full purchase)
  Lesson 14 Supplemental Reading
44. (Included in full purchase)
  Lesson 14 Quiz
45. (Included in full purchase)
  15. Nested IF, OR, AND Statements
46. (Included in full purchase)
  Lesson 15 Supplemental Reading
47. (Included in full purchase)
  Lesson 15 Quiz
48. (Included in full purchase)
  16. Macros
49. (Included in full purchase)
  Lesson 16 Supplemental Reading
50. (Included in full purchase)
  Lesson 16 Quiz
51. (Included in full purchase)
  17. Average, Max, Min
52. (Included in full purchase)
  Lesson 17 Supplemental Reading
53. (Included in full purchase)
  Lesson 17 Quiz
54. (Included in full purchase)
  18. XLOOKUP and VLOOKUP
55. (Included in full purchase)
  Lesson 18 Supplemental Reading
56. (Included in full purchase)
  Lesson 18 Quiz
57. (Included in full purchase)
  19. Math, Autosum, IFERROR
58. (Included in full purchase)
  Lesson 19 Supplemental Reading
59. (Included in full purchase)
  Lesson 19 Quiz
60. (Included in full purchase)
  20. Find and Replace
61. (Included in full purchase)
  Lesson 20 Supplemental Reading
62. (Included in full purchase)
  Lesson 20 Quiz
63. (Included in full purchase)
  21. Duplicates and Unique
64. (Included in full purchase)
  Lesson 21 Supplemental Reading
65. (Included in full purchase)
  Lesson 21 Quiz
66. (Included in full purchase)
  22. Sort and Custom Sort
67. (Included in full purchase)
  Lesson 22 Supplemental Reading
68. (Included in full purchase)
  Lesson 22 Quiz
69. (Included in full purchase)
  23. Filter
70. (Included in full purchase)
  Lesson 23 Supplemental Reading
71. (Included in full purchase)
  Lesson 23 Quiz
72. (Included in full purchase)
  24. Special Values
73. (Included in full purchase)
  Lesson 24 Supplemental Reading
74. (Included in full purchase)
  Lesson 24 Quiz
75. (Included in full purchase)
  25. Data Validation
76. (Included in full purchase)
  Lesson 25 Supplemental Reading
77. (Included in full purchase)
  Lesson 25 Quiz
78. (Included in full purchase)
  26. Protect
79. (Included in full purchase)
  Lesson 26 Supplemental Reading
80. (Included in full purchase)
  Lesson 26 Quiz
81. (Included in full purchase)
  27. Multiple Tabs
82. (Included in full purchase)
  Lesson 27 Supplemental Reading
83. (Included in full purchase)
  Lesson 27 Quiz
84. (Included in full purchase)
  28. Indicators
85. (Included in full purchase)
  Lesson 28 Supplemental Reading
86. (Included in full purchase)
  Lesson 28 Quiz
87. (Included in full purchase)
  29. AVERAGEIF, SUMIF, COUNTIF
88. (Included in full purchase)
  Lesson 29 Supplemental Reading
89. (Included in full purchase)
  Lesson 29 Quiz
90. (Included in full purchase)
  30. Conditional Formatting
91. (Included in full purchase)
  Lesson 30 Supplemental Reading
92. (Included in full purchase)
  Lesson 30 Quiz
93. (Included in full purchase)
  31. Text to Columns
94. (Included in full purchase)
  Lesson 31 Supplemental Reading
95. (Included in full purchase)
  Lesson 31 Quiz
96. (Included in full purchase)
  32. PivotTables and PivotCharts
97. (Included in full purchase)
  Lesson 32 Supplemental Reading
98. (Included in full purchase)
  Lesson 32 Quiz
99. (Included in full purchase)
  33. Theme Colors
100. (Included in full purchase)
  Lesson 33 Supplemental Reading
2
Apply Excel Foundations at Work Creating a Budget, Project Tracker and Order Sheet
1. (Included in full purchase)
  Budget, Project Tracker and Order Manager Workbook
2. (Included in full purchase)
  Making it look pretty with formatting
3
Order Manager
1. (Included in full purchase)
  1. Custom number format
2. (Included in full purchase)
  2. Math functions
3. 3. Data validation drop downs and list Free preview
4. (Included in full purchase)
  4. Conditional formatting
5. (Included in full purchase)
  5. Sort and custom sort
6. (Included in full purchase)
  6. Filter
7. (Included in full purchase)
  7. Moving columns and other options
8. (Included in full purchase)
  8. PivotTables
9. (Included in full purchase)
  9. VLOOKUP and XLOOKUP
10. (Included in full purchase)
  10. Tables
11. (Included in full purchase)
  11. Sumif
12. (Included in full purchase)
  12. Join cells
13. (Included in full purchase)
  13. IF, OR, AND statements
14. (Included in full purchase)
  14. Freeze panes
15. (Included in full purchase)
  15. Slicers
16. (Included in full purchase)
  Order Manager Supplemental Reading
4
Basic Budget
1. (Included in full purchase)
  1. Fill right and down
2. (Included in full purchase)
  2. Alignment
3. (Included in full purchase)
  3. Date and number formatting
4. (Included in full purchase)
  4. More math functions
5. (Included in full purchase)
  5. Sparklines
6. (Included in full purchase)
  6. Rounding and decimals
7. (Included in full purchase)
  7. Duplicates
8. (Included in full purchase)
  8. IFERROR
9. (Included in full purchase)
  9. Macros
10. (Included in full purchase)
  Basic Budget Supplemental Reading
5
Project Tracker
1. (Included in full purchase)
  1. Checkboxes and countif
2. (Included in full purchase)
  2. Progress bar and COUNTA
3. (Included in full purchase)
  3. Conditional formatting continued
4. (Included in full purchase)
  4. Pie Chart
5. (Included in full purchase)
  5. Charts
6. (Included in full purchase)
  6. Merge and center vs. center across selection
7. (Included in full purchase)
  7. Protect
8. (Included in full purchase)
  8. Removing blank rows
9. (Included in full purchase)
  Project Tracker Supplemental Reading
10. (Included in full purchase)
  Final Quiz
6
Fun Extra Skills
1. (Included in full purchase)
  Work day calendar list
2. (Included in full purchase)
  Excel form
3. (Included in full purchase)
  Chart types

Practical, career-focused Excel Foundations Course

Course Curriculum

Learn Excel Foundations Creating an Event Planner

Apply Excel Foundations at Work Creating a Budget, Project Tracker and Order Sheet

Order Manager

Basic Budget

Project Tracker

Fun Extra Skills