- Courses
- Excel Basic to Advanced
4 hour Excel Course
Excel Basic to Advanced
-
Learn by Doing
-
LMS Ready
-
Earn Certificates
4.9 out of 5 on G2
Try this Course with a Free Trial
Learn to:
- Create & edit spreadsheets
- Write formulas
- Apply formatting
- Manage workbooks
Features:
- Bite-sized lessons
- Learn by doing simulations
- Skill assessments
- Covers Certiport certification
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | Account Required | |||
|
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 | ||||
Get a Completion Certificate
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!