Unlock the full potential of Microsoft Excel in this comprehensive course designed to take you from beginner to advanced—plus expert-level tools like Macros and VBA. Perfect for any version from Microsoft Excel 2007 to 2025, this course bundles four intensive classes into one powerful package.
What You’ll Learn
Whether you’re just starting or looking to automate your workflow, we’ve got you covered:
Building organized and effective spreadsheets
Managing and analyzing large data sets with ease
Mastering essential Excel functions like SUM, VLOOKUP, IF, and INDEX/MATCH
Including new Microsoft 365 Functions like XLOOKUP, SWITCH, TEXTSPLIT & More
Creating dynamic reports with PivotTables
Harnessing PowerPivot for more advanced data modeling
Cleaning and auditing formulas to ensure accuracy
Automating tasks with Macros and VBA
What’s Included?
22+ hours of in-depth video instruction led by a Microsoft Certified Trainer
Downloadable exercise files to follow along and practice
Section quizzes to reinforce learning
An interactive Q&A board for questions and support
Course Features
- Lectures 77
- Quiz 0
- Duration 1 week
- Skill level All levels
- Language English
- Students 6283
- Certificate No
- Assessments Yes
- 14 Sections
- 77 Lessons
- 1 Week
- Unit -16
- Unit -211
- 2.1Main workbook download
- 2.2The three different types of references. Part 18 Minutes
- 2.3The three different types of references. Part 24 Minutes
- 2.4References exercise5 Minutes
- 2.5Formulas and functions. What’s the difference?3 Minutes
- 2.6How to write formulas10 Minutes
- 2.7Basic function variations you must know11 Minutes
- 2.8Basic function variations you must know. SumIF and AverageIF10 Minutes
- 2.9Functions exercise instructions2 Minutes
- 2.10Concatenate function4 Minutes
- 2.11The IF Function13 Minutes
- Unit -38
- 3.1Introduction to charts2 Minutes
- 3.2Inserting a chart7 Minutes
- 3.3Chart exercise instructions2 Minutes
- 3.4Charts solution video and more!6 Minutes
- 3.5Formatting data into a table8 Minutes
- 3.6Formatting data into a table. Part 26 Minutes
- 3.7The If/And/Or functions. Part 19 Minutes
- 3.8The If/And/Or functions. Part 25 Minutes
- Unit -411
- 4.1Introduction to printing2 Minutes
- 4.2Printing your first spreadsheet11 Minutes
- 4.3Printer settings2 Minutes
- 4.4Printing the second spreadsheet. Solution/exercise5 Minutes
- 4.5Building a Navigation paneI9 Minutes
- 4.6Vlookup10 Minutes
- 4.7Conditional formatting5 Minutes
- 4.8Subtotaling data. Part 110 Minutes
- 4.9Subtotaling data. Part 28 Minutes
- 4.10“Goals” Exercise instructions4 Minutes
- 4.11Goals solution video!12 Minutes
- Unit -54
- Unit -65
- Unit -72
- Unit -83
- Unit -93
- Unit -107
- 10.1Must know functions. Part 19 Minutes
- 10.2Must know functions. Part 29 Minutes
- 10.3Must know functions. Part 36 Minutes
- 10.4Splitting names with the ‘Find’, ‘Left’, ‘Right’ and ‘Len’ Function. Part 18 Minutes
- 10.5Splitting names with the ‘Find’, ‘Left’, ‘Right’ and ‘Len’ Function. Part 27 Minutes
- 10.6Missing Draw tab1 Minute
- 10.7Excels drawing tools and more6 Minutes
- Unit -115
- Unit -125
- Unit -133
- Unit -144
