4 hour Excel Course

Excel Basic to Advanced

A beginner-friendly Excel Course that builds strong spreadsheet skills through guided, hands-on lessons.

  • Learn by Doing

  • LMS Ready

  • Earn Certificates

Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Try this Course with a Free Trial

Excel Basic to Advanced Course Outline

Verified Learning

Skill Pre-assess Lesson Post-assess Learning mode
Excel Fundamentals
Understand the Excel Screen

Find tools fast with the Excel ribbon

Not Started Not Started Not Started
Create Workbooks

Start a blank workbook in Excel

Not Started Not Started Not Started
Navigate Worksheets

Move between sheets in Excel quickly

Not Started Not Started Not Started
Open Workbooks

Launch files from Recent or Browse in Excel

Not Started Not Started Not Started
Save Workbooks

Quick steps to save your work in Excel

Not Started Not Started Not Started
AutoRecover

Restore your in-progress spreadsheet easily

Not Started Not Started Not Started
The Quick Access Toolbar

Add shortcuts with the Quick Access Toolbar

Not Started Not Started Not Started
Print

Control what prints by setting print area

Not Started Not Started Not Started
Help

Get quick Excel help when you need it

Not Started Not Started Not Started
Close and Exit

Close workbooks fast and wrap up your session

Not Started Not Started Not Started
Skill Pre-assess Lesson Post-assess Learning mode
Edit a Workbook
Select Cells and Ranges

Highlight multiple areas with shortcuts

Edit Cell Data

Quick ways to edit cells in Excel

Cut, Copy, and Paste

Master cut copy paste shortcuts in Excel

Undo, Redo, Repeat

Fix mistakes fast with undo and redo

More Pasting Options

Paste Special Excel values and formats

Insert and Move Cells

Learn how to move cells in excel easily

Delete Cells

Delete cells in Excel while keeping sheets tidy

Check Spelling

Catch errors quickly with Excel spell check

Find and Replace Text

Find and replace text in Excel quickly

Hide Columns and Rows

Hide and reveal rows and columns in Excel

Document Properties

Update Excel document properties to stay organized

Skill Pre-assess Lesson Post-assess Learning mode
Basic Formulas
Formula Basics

Essential Excel formulas for beginners

AutoFill

Copy Excel patterns or series instantly

Sums and Averages

Apply Excel's SUM formula for fast totals

MIN and MAX

Find smallest and largest in Excel

COUNT

Count the values you need with a simple formula

Skill Pre-assess Lesson Post-assess Learning mode
Basic Formatting
Format Text

Format text cleanly with excel text tools

Align and Merge Cells

Excel center text and merge cells

Format Numbers and Dates

Quickly apply date and number formats for clarity

Borders and Background Colors

Make cells pop with crisp borders and fills

Copy Formatting

Copy a cell’s look and apply it in one click

Row Heights and Column Widths

Quickly resize rows and columns with AutoFit

Skill Pre-assess Lesson Post-assess Learning mode
Insert Objects
Images

Learn how to insert a picture in Excel

Shapes

Use shapes to enhance your worksheets

Hyperlinks

Add hyperlinks in Excel for easy navigation

Object Properties and Alt Text

Set Excel object properties and alt text

Skill Pre-assess Lesson Post-assess Learning mode
Manage Worksheets
View Worksheets

Zoom in and out to view Excel sheets

Multiple Windows

Work in two windows of the same workbook

Move and Copy Worksheets

Quickly copy or move sheets in Excel

Insert, Rename, and Delete Worksheets

Quickly add, rename, or delete Excel sheets

Freeze Rows and Columns

Freeze Excel rows and columns to stay oriented

Hide Worksheets and Gridlines

Remove gridlines and hide sheets in Excel

Skill Pre-assess Lesson Post-assess Learning mode
Charts
Create Charts

How to Create Charts in Excel tutorial

Move and Resize

Quickly resize and move charts in Excel

Chart Types

Choose the right chart type for clear insights

Layout and Style

Adjust chart layout and style in Excel

Titles and Legends

Customize chart titles and legend text

Gridlines, Labels, and Data Tables

Make charts clearer with labels and data tables

Chart Elements

Fine-tune chart layout, labels and data clarity

Modify Chart Data

Learn how to change chart data range in Excel

Filter Charts

Quickly refine chart data with filters

Trendlines

Add a trendline to highlight data trends clearly

Dual-Axis Charts

Add a secondary axis in Excel for clearer charts

Chart Templates

Save time by reusing custom chart layouts

Sparklines

Embed mini-charts in cells to show data trends

Skill Pre-assess Lesson Post-assess Learning mode
Print and Distribute
Page Size and Scale

Adjust size and scaling for one-page printing

Print Area and Page Breaks

Select and lock the exact cells you want to print

Print Titles, Gridlines, and Headings

Enable headings & gridlines for cleaner printouts

Headers and Footers

Add a header and footer in Excel quickly

Margins and Orientation

Adjust margins and orientation in Excel

Inspect for Issues

Check for problems with Excel’s inspect tool

Skill Pre-assess Lesson Post-assess Learning mode
Intermediate Formulas
Reference External Worksheets

Reference other sheets in formulas

Absolute and Relative References

Lock cells with absolute references in Excel

Order of Operations

Know calculation order so formulas behave right

Cell and Range Names

Name cells and ranges for smarter formulas

Insert Functions

Use the insert function tool in Excel

CONCAT Function

Merge text from multiple cells into one formula

PMT and NPER Functions

Compute loan payment amounts quickly

Display Formulas

Learn how to show formulas in Excel

Date Formulas

Calculate time fast with Excel date functions

Skill Pre-assess Lesson Post-assess Learning mode
Manage Data
Quick Analysis

Apply fast visuals and summaries to your data

Outline and Subtotal

Create data groups with built-in subtotals

Data Validation

Keep entries accurate with data validation

Flash Fill

Let flash fill Excel auto-complete data

Import and Export Data

Import and export data in Excel easily

Skill Pre-assess Lesson Post-assess Learning mode
Tables
Insert a Table

Create a table in Excel for cleaner data

Sort Data

Sort your data alphabetically or by value

Filter Data

Use Excel filter to focus on key data

Add Rows and Columns

Add a Total Row to Excel tables

Table Styles

Apply a table format for structured, stylish data

Remove Duplicates

Clean up sheets by removing duplicate rows

Slicers

Filter tables instantly with clickable buttons

Structured References

Refer to table columns directly in formulas

Skill Pre-assess Lesson Post-assess Learning mode
Intermediate Formatting
Apply Conditional Formatting

Conditional Formatting Excel rules

Apply and Remove Cell Styles

Cell Styles Excel formatting tips

Create and Modify Cell Styles

Create or update styles for consistent formatting

Find and Replace Formatting

Find and replace formatting in Excel fast

Apply a Theme

How to Change Theme Colors in Excel

Skill Pre-assess Lesson Post-assess Learning mode
Collaboration
Cell Comments

Leave notes on cells for clearer context

Share Workbooks

Invite others to collaborate on the same workbook

Co-author Workbooks

Work together in real-time on the same workbook

Version History

Revert to a previous file version in seconds

Protect a Worksheet

Lock specific cells so data stays unchanged

Protect Workbook Structure

Lock workbooks to prevent edits

Password Protection

Secure files by setting a password

Skill Pre-assess Lesson Post-assess Learning mode
PivotTables
Create PivotTables

Turn raw data into insights with Excel Pivot Table

Add Multiple PivotTable Fields

Excel Pivot Table from multiple columns

Change a PivotTable's Calculation

Adjust how your value fields calculate data

Add Calculated Fields

Excel Pivot Table Calculated Field tips

The GETPIVOTDATA Function

Pull pivot values with GETPIVOTDATA

Filter PivotTables

Learn how to filter an Excel Pivot Table

Timelines

Use a pivot table timeline to filter dates

PivotTable Layout

Change layout form to customise your Pivot Table view

Group Values

Use Pivot Table grouping to organize values

Refresh a PivotTable

Refresh pivot table data in Excel

Format a PivotTable

Format your Pivot Table for a cleaner look

Skill Pre-assess Lesson Post-assess Learning mode
PivotCharts
Create PivotCharts

Create dynamic charts from Pivot Table data

PivotChart Options

Keep your Pivot Chart up to date with new data

PivotChart Styles

Apply a built-in visual style for instant clarity

Drill-Down Data

Reveal insights with drill down Excel charts

Skill Pre-assess Lesson Post-assess Learning mode
Troubleshoot Formulas
Formula Errors

Identify and correct Excel formula errors

The Watch Window

Monitor key cells with Watch Window

Evaluate Formulas

Use Excel evaluate formula to check each step

Skill Pre-assess Lesson Post-assess Learning mode
Advanced Formatting
Customize Conditional Formatting

Use custom formatting to spotlight data

Conditional Formatting with Formulas

Apply formula rules to spotlight key values

Manage Conditional Formatting

Edit conditional formatting rules in Excel

International Currency and Formats

Use Excel international formats for global data

Body and Heading Options

Switch theme fonts to polish your workbook look

Color Formats

Pick and apply workbook color palettes with ease

Custom Themes

Apply brand-ready styles with Excel themes

Form Controls

Add interactive elements with Excel forms

Save Form Templates

Save an Excel forms template for reuse

Skill Pre-assess Lesson Post-assess Learning mode
Advanced Formulas
IF Function

Use IF to check conditions in Excel

Nested Functions

Resize and move charts for a perfect layout

AND, OR, and NOT Functions

Combine data logic with Excel formulas

SUMIF, AVERAGEIF, and COUNTIF Functions

Do conditional totals with the SUMIF function

VLOOKUP

Find matches with VLOOKUP in Excel

HLOOKUP

Find values across rows in Excel

INDEX and MATCH

Use INDEX and MATCH in excel for precise lookups

UPPER, LOWER, and PROPER

Change text case in Excel UPPER LOWER PROPER

RIGHT, LEFT, and MID

Pull text with LEFT RIGHT MID in Excel

Formula Calculation Options

Control when Excel auto-calculates formulas

Skill Pre-assess Lesson Post-assess Learning mode
Analyze Data
Goal Seek

Let Excel goal seek solve for the right value

Scenario Manager

Compare what if scenarios in Excel

Consolidate Data

Combine and summarize data across sheets

Skill Pre-assess Lesson Post-assess Learning mode
Macros
Enable Macros

Turn on macros in Excel to use automation

Create Macros

Automate your workflow by recording custom tasks

Modify Macros

Edit macros in Excel to update automation

Copy Macros

Copy macros to reuse your automation anywhere

Student Downloads
Instructor Downloads

Get a Completion Certificate

Share your certificate with prospective employers and your professional network.

Certificate of Verified Skills

Your Name

For verified skills in: Excel Basic to Advanced

Issued on November 24, 2025

Master Excel Basic to Advanced Skills

Unlock powerful skills to boost your productivity and career growth.
Start learning today — sign up for free!

Sign Up Free