Skip to content

Home
Excel Training
How it works
About
Blog
FAQ

Excel 365 — Complete Course: MOS Associate & Expert (MO-210 / MO-211), ICDL Core & Advanced + AI

Written by

in

Current Status

Not Enrolled

Enroll in this course to get access

Price

Free

Get Started

Log In to Enroll

Not enrolled yet? See the Excel training courses, syllabus and pricing.

A complete Excel 365 course, from your first workbook to automation and AI. Parts 1 and 2 follow the international ICDL syllabi (Core Spreadsheets 6.0 and Spreadsheets advanced 3.1). Part 3 goes beyond ICDL with Power Query, Power Pivot, dashboards, generative AI, Copilot, Office Scripts and VBA. Part 4 prepares you for the Microsoft Office Specialist certifications: Excel Associate (MO-210) and Excel Expert (MO-211).

Every objective of both MOS exams is covered and marked with a MOS badge on the modules that teach it. Part 4 explains how the exams work and includes two timed, project-based practice exams in real Excel, one for MO-210 and one for MO-211.

Each module includes a short video, step-by-step screens with annotated screenshots, downloadable practice files and a quiz. Each chapter ends with a chapter quiz, and each part with a review exercise or practice exam.

Course Content

Chapter 1 — Getting Started with Excel and Managing Workbooks 10 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/10 Steps

1.1 — Getting Microsoft 365, Opening and Closing Excel

1.2 — The Excel Interface

1.3 — Creating and Opening Workbooks

1.4 — Saving a Workbook

1.5 — Working with Multiple Workbooks

1.6 — Excel Options

1.7 — Workbook Properties and Help

1.8 — Inspecting a Workbook: Document Inspector, Accessibility, and Compatibility Checkers

1.9 — Custom Views, Worksheet Views, and the Quick Access Toolbar

Chapter 2 — Entering and Organizing Data 11 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/11 Steps

2.1 — Entering and Editing Data

2.2 — Selecting Cells

2.3 — Organizing a Data List the Right Way

2.4 — Undo, Redo, and Repeat

2.5 — Find and Replace

2.6 — Copy, Cut, Paste, and Move

2.7 — The Fill Handle and Series

2.8 — Clearing Contents or Formatting

2.9 — Sorting Data

2.10 — Inserting and Deleting Cells

Chapter 3 — Working with Rows, Columns, and Worksheets 7 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/7 Steps

3.1 — Inserting and Deleting Rows and Columns

3.2 — Row Height and Column Width

3.3 — Hiding and Unhiding Rows and Columns

3.4 — Freeze Panes and Split

3.5 — Managing Worksheets

3.6 — Moving and Copying a Worksheet

Chapter 4 — Your First Formulas and Functions 9 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/9 Steps

4.1 — Building a Formula

4.2 — Copying Formulas: Relative References

4.3 — Absolute and Mixed References

4.4 — AutoSum, SUM, AVERAGE, MIN, MAX, and ROUND

4.5 — Counting: COUNT, COUNTA, COUNTBLANK

4.6 — The IF Function

4.7 — COUNTIF and SUMIF

4.8 — Understanding Error Values

Chapter 5 — Formatting Your Worksheets 11 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/11 Steps

5.1 — Number Formats: Decimal Places and Thousands Separator

5.2 — Currency, Accounting, and Percentage Formats

5.3 — Date and Time Formats

5.4 — Fonts, Styles, and Colors

5.5 — Copying Formatting with Format Painter

5.6 — Alignment, Wrap Text, and Orientation

5.7 — Merge & Center

5.8 — Borders and Gridlines

5.9 — Format as Table

5.10 — Structured References in Excel Tables

Chapter 6 — Creating Your First Charts 8 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/8 Steps

6.1 — Choosing the Right Chart

6.2 — Creating a Column or Bar Chart

6.3 — Creating a Line or Pie Chart

6.4 — Editing, Moving, and Resizing a Chart

6.5 — Chart Title, Legend, and Data Labels

6.6 — Chart Colors and Formatting

6.7 — Quick Layouts, Chart Styles, and Alt Text

Chapter 7 — Page Setup and Printing 7 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/7 Steps

7.1 — Margins, Orientation, and Paper Size

7.2 — Fitting a Printout on One or More Pages

7.3 — Headers and Footers

7.4 — Checking Before You Print: Spelling, Formulas, and Gridlines

7.5 — Print Titles, Page Breaks, and Print Preview

7.6 — Printing a Selection, a Worksheet, a Chart, or the Entire Workbook

7.7 — Review Exercise and ICDL Core Practice Exam

Chapter 8 — Advanced Formatting and Worksheet Management 9 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/9 Steps

8.1 — Conditional Formatting: Highlight Rules, Data Bars, and Icon Sets

8.2 — Formula-Based Conditional Formatting, Whole-Row Highlighting, and Managing Rules

8.3 — Custom Number Formats

8.4 — Text to Columns

8.5 — Splitting the Window: Moving and Removing Split Bars

8.6 — Hiding and Unhiding Worksheets; Copying or Moving Sheets Between Workbooks

8.7 — Saving a Workbook as a Template and Modifying a Template

8.8 — Finding and Removing Duplicates

Chapter 9 — Advanced Functions 23 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/23 Steps

9.1 — Date and Time Functions: TODAY, NOW, DAY, MONTH, YEAR, and NETWORKDAYS

9.2 — Logical Functions: AND, OR, NOT

9.3 — Two-Level Nesting: Nested IF, IF with AND/OR, and IFERROR

9.4 — ROUND, ROUNDDOWN, and ROUNDUP

9.5 — Statistical Functions: SUMIF, SUMIFS, COUNTIF, COUNTBLANK, and RANK

9.6 — Text Functions: LEFT, RIGHT, MID, and TRIM

9.7 — CONCATENATE, the & Operator, and the TEXT Function

9.8 — Financial Functions PMT, PV, and FV: Loans and Savings

9.9 — Depreciation and Investment Functions: XNPV, SLN, and DB

9.10 — VLOOKUP

9.11 — HLOOKUP, XLOOKUP, and INDEX/MATCH

9.12 — Database Functions: DSUM, DAVERAGE, DMIN, DMAX, DCOUNT

9.13 — 3-D References in SUM, AVERAGE, MIN, and MAX

9.14 — Mixed References in Practice

9.15 — Text Functions: UPPER, LOWER, PROPER, LEN, and CONCAT

9.16 — IFS and SWITCH

9.17 — Conditional Statistics: AVERAGEIF(S), COUNTIFS, MAXIFS, and MINIFS

9.18 — The LET Function

9.19 — WEEKDAY and WORKDAY

9.20 — Dynamic Arrays: Spill, SORT, and UNIQUE

1 of 2

Chapter 10 — Advanced Charts 10 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/10 Steps

10.1 — Combo Charts: Column and Line, Column and Area

10.2 — Secondary Axis and Changing the Chart Type of a Single Series

10.3 — Adding or Removing a Data Series

10.4 — Sparklines: Create, Edit, and Delete

10.5 — Repositioning the Chart Title, Legend, and Data Labels

10.6 — Axis Scale (Minimum, Maximum, Major Unit) and Display Units

10.7 — Filling Columns, Bars, Pie Slices, or Areas with a Picture

10.8 — Statistical Charts: Histogram, Pareto, and Box & Whisker

10.9 — Waterfall, Funnel, and Sunburst Charts

Chapter 10 Quiz

Chapter 11 — Sorting, Filtering, and Outlining Data 8 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/8 Steps

11.1 — Sorting by Multiple Columns

11.2 — Custom Lists and Custom Sorts

11.3 — AutoFilter

11.4 — Advanced Filter with a Criteria Range

11.5 — Outlines: Group and Ungroup, Manually or Automatically

11.6 — Subtotals and Outline Levels

11.7 — Flash Fill and Advanced Fill Series Options

Chapter 11 Quiz

Chapter 12 — PivotTables 10 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/10 Steps

12.1 — Introduction and Preparing the Source Data

12.2 — Building Your First PivotTable

12.3 — PivotTable Layout: Rows, Columns, Values, Filters, and Summary Functions

12.4 — Changing the Data Source and Refreshing

12.5 — Sorting and Filtering a PivotTable; Slicers and Timelines

12.6 — Grouping Manually or Automatically and Renaming Groups

12.7 — Calculated Fields and Show Values As Percentages

12.8 — PivotCharts: Create, Filter, and Sort

12.9 — Formatting a PivotTable; Expanding and Collapsing

Chapter 12 Quiz

Chapter 13 — What-If Analysis 7 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/7 Steps

13.1 — One-Variable Data Tables

13.2 — Two-Variable Data Tables

13.3 — Scenario Manager: Create, Show, Edit, and Delete Scenarios

13.4 — Scenario Summary Reports

13.5 — Goal Seek

13.6 — Consolidating Data from Multiple Ranges

Chapter 13 Quiz

Chapter 14 — Data Validation and Formula Auditing 9 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/9 Steps

14.1 — Data Validation: Whole Number, Decimal, Date, and Time

14.2 — Drop-Down Lists

14.3 — Input Messages and Error Alerts

14.4 — Tracing Precedents and Dependents

14.5 — Finding Cells with No Dependents and Checking for Errors

14.6 — Showing Formulas Instead of Values

14.7 — Notes and Comments: Insert, Edit, Delete, Show, and Hide

14.8 — Calculation Options, Error Checking Rules, and the Watch Window

Chapter 14 Quiz

Chapter 15 — Productivity and Automation 13 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/13 Steps

15.1 — Naming Ranges: Name Manager and Deleting Names

15.2 — Using Names in Functions

15.3 — Group Mode: Editing Multiple Worksheets at Once

15.4 — Paste Special: Values and Transpose

15.5 — Paste Special Operations: Add, Subtract, Multiply, Divide

15.6 — Hyperlinks: Insert, Edit, and Remove

15.7 — Linking Data Within and Between Workbooks: Updating and Breaking Links

15.8 — Importing a Delimited Text File (TXT or CSV)

15.9 — The Developer Tab: Recording a Macro

15.10 — Running a Macro, the .xlsm Format, and Macro Security

15.11 — Assigning a Macro to a Button

15.12 — Copying and Editing Macros Between Workbooks

Chapter 15 Quiz

Chapter 16 — Collaboration and Security 8 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/8 Steps

16.1 — Locking and Unlocking Cells; Password-Protecting a Worksheet

16.2 — Hiding and Unhiding Formulas

16.3 — Protecting the Workbook Structure

16.4 — Passwords to Open and Modify: Adding and Removing

16.5 — Compare and Merge Workbooks; Co-authoring on OneDrive

16.6 — Version History and Recovering Unsaved Work

16.7 — Restricting Editing: Allow Edit Ranges, Read-Only Recommended, and Mark as Final

16.8 — Review Exercise and ICDL Professional (Advanced) Practice Exam

Chapter 17 — Power Query: Importing and Transforming Data 16 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/16 Steps

17.1 — Introduction to Power Query and Use Cases

17.2 — The Power Query Editor: Interface and Applied Steps

17.3 — Importing an Excel Workbook or Table

17.4 — Importing a CSV or Text File

17.5 — Importing Data from the Web

17.6 — Importing All Files from a Folder

17.7 — Queries & Connections and Data Source Settings

17.8 — Why Data Types Matter

17.9 — Filtering and Removing Duplicates and Null Values

17.10 — Splitting and Merging Columns

17.11 — Custom and Conditional Columns

17.12 — Group By

17.13 — Appending and Merging Queries

17.14 — Creating a Parameter to Filter Data

17.15 — Handling Errors and Organizing Queries

Chapter 17 Quiz

Chapter 18 — Power Pivot and the Data Model 13 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/13 Steps

18.1 — Introduction to Power Pivot and Enabling the Add-in

18.2 — The Power Pivot Interface

18.3 — Adding Tables to the Data Model

18.4 — Creating Relationships Between Tables

18.5 — Diagram View and Perspectives

18.6 — Calculated Columns

18.7 — DAX Measures: SUM, COUNTROWS, and DIVIDE

18.8 — The CALCULATE Function

18.9 — Creating a Date Table

18.10 — Hierarchies

18.11 — Key Performance Indicators (KPIs)

18.12 — PivotTables Based on the Data Model

Chapter 18 Quiz

Chapter 19 — Project: Building a Dashboard 13 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/13 Steps

19.1 — Designing a Dashboard: Goals and Mockup

19.2 — Importing and Cleaning the Data with Power Query

19.3 — Preparing the Sales Dates

19.4 — Building the Data Model and Measures

19.5 — Dashboard PivotTables and PivotCharts

19.6 — Pie Chart and Combo Chart

19.7 — Slicers and Timelines Connected to Multiple PivotTables

19.8 — KPIs and Conditional Formatting

19.9 — Navigation Buttons

19.10 — Final Report Formatting

19.11 — Protecting and Refreshing the Dashboard

19.12 — Sharing the Dashboard (OneDrive, PDF)

Chapter 19 Quiz

Chapter 20 — Excel and Generative AI 11 Topics

You don't currently have access to this content

Lesson Content

0% Complete 0/11 Steps

20.1 — Writing an Effective Excel Prompt for AI

20.2 — Error-Free Sums and Calculations

20.3 — Conditional Formulas with IF, AND, and OR

20.4 — Cleaning Text with LEFT, RIGHT, and MID

20.5 — Calculating Date Differences with DATEDIF

20.6 — Error-Free VLOOKUP and XLOOKUP

20.7 — SUMIFS and COUNTIFS

20.8 — Building and Explaining a Complex Formula

20.9 — Generating a VBA Macro

20.10 — Fixing and Improving a VBA Macro

Chapter 20 Quiz

1 of 2

More posts

Excel Crash Course: The 20% of Excel That Covers 80% of Your Work

October 24, 2026
Excel for Small Business: 6 Practical Uses and a Step-by-Step Example

October 23, 2026
Excel Pivot Table Training: A Step-by-Step PivotTable Tutorial

October 23, 2026
Excel for Accounting: Reconciliations, Aging Reports and Checks

October 22, 2026

Online courses for your next learning goal.

Our course catalogue is coming soon.

Explore Gnosarium

Home
Excel Training
How it works
About
Blog
FAQ

© Gnosarium. All rights reserved.

Always Active

Necessary cookies enable essential site features like secure log-ins and consent preference adjustments. They do not store personal data.

None

Functional Cookies

Functional cookies support features like content sharing on social media, collecting feedback, and enabling third-party tools.

None

Analytical Cookies

Analytical cookies track visitor interactions, providing insights on metrics like visitor count, bounce rate, and traffic sources.

None

Advertisement Cookies

Advertisement cookies deliver personalized ads based on your previous visits and analyze the effectiveness of ad campaigns.

None

Unclassified cookies are cookies that we are in the process of classifying, together with the providers of individual cookies.

None