Microsoft Excel – Excel from Beginner to Advanced
$0.99
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 2024 , this course bundles four intensive classes into one powerful package.
What you’ll learn
- Create and manage organized, professional Microsoft Excel spreadsheets from scratch
- Master essential Excel functions like SUM, VLOOKUP, IF, and more
- Analyze large Excel data sets with confidence and find key insights
- Build dynamic reports using Excel PivotTables and visualizations
- Automate repetitive tasks efficiently with Excel Macros and VBA
- Design interactive dashboards and reports with Excel PowerPivot
- Use advanced Excel functions to tackle real-world business problems
- Improve productivity with time-saving Excel shortcuts and best practices
- Gain the confidence to solve complex Excel tasks with ease
Course content
4444 sections • 271 lectures • Total duration 21 h 57 min
Microsoft Excel 101 Course Introduction
Microsoft Excel Fundamentals
Entering and Editing Text and Formulas
Working with Basic Excel Functions
Modifying an Excel Worksheet
Formatting Data in an Excel Worksheet
Inserting Images and Shapes into an Excel Worksheet
Creating Basic Charts in Excel
Printing an Excel Worksheet
Working with Excel Templates
Excel 101 - Practice What You've Learned (DOWNLOAD)
Congratulations! You've Built a Solid Microsoft Excel Foundation
Microsoft Excel 102 Course Introduction
Working with an Excel List
Excel List Functions
Excel Data Validation
Importing and Exporting Data
Excel PivotTables
Working with Excel's PowerPivot Tools
Working with Large Sets of Excel Data
Excel 102 Additional Practice Exercises
Congratulations! You're an Intermediate Excel User
Microsoft Excel 103 Course Introduction
Working with Excel's Conditional Functions
Working with Excel's Lookup Functions
Working with Excel's Text Based Functions
New Excel Functions for Excel 2019 and Microsoft 365 Excel Editions
Auditing an Excel Worksheet
Protecting Excel Worksheets and Workbooks
Mastering Excel's "What If?" Tools
Automating Repetitive Tasks in Excel with Macros
Excel 103 Additional Practice Exercises
Congratulations!
Microsoft Excel Macros and VBA Course Introduction
Project #1: Using Excel's Macro Recorder Tool
Excel VBA Concepts
Working with Excel VBA Logic Statements
Project #2: Moving Beyond the Basics and into VBA
Project #3: Preparing and Cleaning Up Data with Excel VBA
Project #4: Using VBA to Automate Excel Formulas
Project #5: Bringing it All Together and a Weekly Report
Project #6: Working with Excel VBA User Forms
Project #7: Importing Data from Text Files
Course Wrap Up