The Complete Microsoft Excel Course: Master All Levels

Name: The Complete Microsoft Excel Course: Master All Levels
Rating: 4.2 (17 reviews)

Learn Excel the smart way — automate tasks, analyze data, and make informed business decisions.

Created byLogic Labs

Last updated 1/2026

English

English [Auto],

What you'll learn

Overview of Microsoft Excel Interface
Understanding Workbooks, Worksheets, and Cells
Basic Navigation and Shortcuts
Entering and Formatting Data
Basic Calculations with Formulas and Functions
Data Formatting (Font, Color, Alignment, Number Formats)
Basic Data Sorting and Filtering
Advanced Formatting Techniques (Conditional Formatting)
Working with Multiple Worksheets and Workbooks
Data Validation and Drop-Down Lists
Logical Functions (IF, AND, OR, NOT)
Nested Functions
Error Handling Functions (IFERROR, ISERROR)
Dynamic Array Functions (FILTER, SORT, UNIQUE, SEQUENCE)
Pivot Tables and Pivot Charts
Using the Analysis ToolPak
Descriptive Statistics and Data Analysis Techniques
And More

Course content

7 sections • 28 lectures • 3h 25m total length

Overview of Microsoft Excel Interface5:02
Explore the Excel interface, from the start screen and ribbon tabs to the quick access toolbar, learn about the workbook, cells, formula bar, status bar, and rename or add sheets.
Understanding Workbooks, Worksheets, and Cells4:50
Master the basics of Excel by understanding workbooks, worksheets, and cells as the building blocks; learn how to rename sheets, add new ones, save workbooks, and format cells.
Basic Navigation and Shortcuts6:42
Navigate Excel with confidence by mastering the interface, including the ribbon, formula and name boxes, and sheet tabs, then boost efficiency using essential shortcuts.
Creating, Saving, and Managing Excel Files5:12
Create a new Excel file, save with descriptive names and formats such as csv, and manage by opening existing files, renaming them, and organizing into folders.

Entering and Formatting Data5:00
Master the basics of Excel by entering and formatting data in a new or existing spreadsheet. Learn to format headers, apply borders, center alignment, and set currency for prices.
Basic Calculations with Formulas and Functions6:06
Learn to perform basic calculations with formulas and functions in Excel, including sum, average, max, and min, copy formulas to save time, and troubleshoot common errors.
Working with Rows, Columns, and Ranges5:00
Data Formatting (Font, Color, Alignment, Number Formats)7:27
Improve your Excel skills by formatting data with fonts, colors, alignment, and consistent number formats, then use format painter to copy styles for a polished, professional spreadsheet.
Basic Data Sorting and Filtering5:46
Select a data range, sort by multiple columns (age smallest to largest, name A to Z), and apply filters to focus on key rows.

Advanced Formatting Techniques (Conditional Formatting)8:09
Master advanced conditional formatting in Excel to highlight data and apply top and bottom rules. Use data bars, color scales, and icon sets, and manage custom rules for sales visuals.
Working with Multiple Worksheets and Workbooks6:32
navigate and organize data across multiple worksheets and workbooks by using tabs, adding and renaming sheets, color-coding, and linking data across sheets and workbooks.
Introduction to Charts and Graphs6:25
Master creating and customizing Excel charts by organizing clean data, inserting chart types like column, line, and pie, and adding titles, labels, and legends to tell a clear data story.
Data Validation and Drop-Down Lists8:03
Enhance data accuracy in Excel by mastering data validations and drop down lists, creating dynamic options and using input messages and error alerts to guide users.
Text Functions and Date Functions14:32
Master Excel text and date functions to clean and transform data, using concatenate, left, right, mid, trim, upper, lower, proper functions, and today, now, date value, year, month, day.

Logical Functions (IF, AND, OR, NOT)7:44
Explore Excel logical functions like if, and, or, and not to evaluate conditions and return results, with examples on sales targets and data analysis for automatic tasks.
Lookup Functions (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP)11:13
Explore vlookup, hlookup, index and match, and the game-changing xlookup to perform vertical and horizontal lookups in Excel, covering exact matches, table arrays, and practical retrieval techniques.
Nested Functions9:03
Master key Excel techniques for lookup and nested functions, using vlookup, xlookup, index, and match with if to extract departments and apply discounts.
Error Handling Functions (IFERROR, ISERROR)6:20
Master error handling in Excel with IFERROR and ISERROR to manage division by zero, missing values, and formula errors. Apply in a sales report example with wrapping and customizing outputs.
Dynamic Array Functions (FILTER, SORT, UNIQUE, SEQUENCE)6:28
Explore dynamic array functions in Excel, including filter, sort, unique, and sequence, which automatically spill results across cells, streamline data analysis, reporting, and time savings.

Pivot Tables and Pivot Charts6:28
Master pivot tables and pivot charts to summarize, analyze, and visualize data dynamically, using rows, columns, values, filters, and slicers to reveal actionable insights.
What-If Analysis (Scenario Manager, Goal Seek, Data Tables)7:07
Explore what-if analysis in Excel with Scenario Manager, Goal Seek, and Data Tables to test scenarios for planning, forecasting, and financial decisions.
Using the Analysis ToolPak6:42
Enable the Analysis ToolPak in Excel to access descriptive statistics, regression, and histograms for data analysis, and learn to set input ranges and interpret mean, standard errors, and standard deviations.
Descriptive Statistics and Data Analysis Techniques6:46
Master descriptive statistics in Excel, covering central tendency, variability, distributions, and visualizations; enable the Analysis ToolPak and create histograms, box plots, and scatter plots.

Creating Interactive Dashboards10:05
Learn to build an interactive Excel dashboard from scratch by organizing data into tables, creating pivot tables and charts, adding slicers for filtering, and styling the dashboard for readability.
Customizing Charts with Design and Layout Options6:21
Learn to customize Excel charts by organizing data, inserting a chart, choosing chart types, and refining titles, axis labels, grid lines, colors, and shapes for clear, visually appealing reports.

Recording and Running Macros5:27
Record and run macros in Excel to automate repetitive tasks, format tables with bold headers, borders, and colors, and save workbooks as macro-enabled.
Basic VBA Programming Concepts9:12
Learn the basics of VBA in Excel, writing simple macros, using the Visual Basic for Applications editor, and automating tasks with macros.
Automating Tasks with VBA11:56
Learn to automate repetitive Excel tasks with VBA by recording macros, formatting data, and highlighting high-value cells, then creating simple code in the VBA editor.

Requirements

You only need access to Microsoft Excel (Office 365, 2019, 2021 or recommended) and a computer.
No microsoft excel experience needed

Description

The Complete Microsoft Excel Course: Master All Levels is designed for anyone who wants to gain complete mastery over Excel, from beginner basics to advanced data analysis. Whether you are a student, professional, or entrepreneur, this course provides a comprehensive path to Excel proficiency.

Starting from the basics, you’ll learn Excel’s interface, navigation, and essential tools. You will understand how to create, format, and organize spreadsheets efficiently, making your work more structured and professional from day one.

As you progress, the course dives into formulas and functions, teaching you how to perform calculations, automate tasks, and analyze data accurately. You’ll gain hands-on experience with functions such as VLOOKUP, INDEX-MATCH, IF statements, and dynamic arrays, which are critical for solving real-world problems.

Data management and analysis are core focuses of this course. You’ll master techniques such as sorting, filtering, conditional formatting, data validation, and pivot tables. These tools will allow you to manage large datasets effectively and extract meaningful insights in minutes.

Visualization is another key skill you’ll develop. You’ll learn to create professional charts, graphs, and dashboards that turn complex data into clear, actionable insights. By the end of the course, you’ll be able to design visually appealing and interactive reports that communicate information effectively.

Advanced topics such as macros, VBA programming, and automation are also covered, enabling you to streamline repetitive tasks and increase productivity. These skills are especially valuable for professionals seeking to enhance efficiency and drive results in their organizations.

By the end of this course, you will not only be proficient in all aspects of Excel but also equipped to apply these skills in real-world scenarios—whether for business, finance, data analysis, or personal productivity.

Enroll now to transform the way you work with data and take your Excel expertise to the next level.

Who this course is for:

Anyone who wants to save time and get the most out of Microsoft Excel.
Anyone who wants learn Microsoft Excel.
Students and professionals who want to improve their excel skills.
Entrepreneurs and office workers who prepare financial report regularly.

The Complete Microsoft Excel Course: Master All Levels

What you'll learn

Explore related topics

Course content

Introduction to Microsoft Excel4 lectures • 22min

Excel Basics5 lectures • 29min

Intermediate Excel Skills5 lectures • 44min

Advanced Formulas and Functions5 lectures • 41min

Data Analysis Tools4 lectures • 27min

Data Visualization2 lectures • 16min

Excel Automation with Macros and VBA3 lectures • 27min

Requirements

Description

Who this course is for: