Microsoft Excel - Excel from Beginner to Advanced
Course Description
Master Microsoft Excel: Beginner to Expert All-in-One Course
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 and 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 Curriculum
- 1.course intro
- 2. Basic Excel Functionalities & Merging data in excel
- 3. Table Formattting and Conditional Formatting
- 4. Advanced Conditional Formatting
- 5. Advanced Excel Fuctions
- 6. Advaced Excel Functions (part 2)
- 7. Searching and Filtering in Data
- 8. Data Cleaning using text functions
- 9. Styling Tabulation in Excel