Start Free Trial

Excel Courses

Learn Excel. Build Real Tools.

Four hands-on courses that teach you Excel by building actual business spreadsheets from scratch.

No login required
•
70+ video lessons
•
4 real business templates
Step 1

Download the Excel Workbooks

Get the spreadsheet for each course.

Event Planner Order Manager Basic Budget Project Tracker
Step 2

Open in Excel and follow along as you watch. Spreadsheets have data on them so you can see what was done, but you may click on the plus sign at bottom of screen to add a brand new tab to start from scratch as you follow along.

Course 1: Event Planner
35 lessons · Getting started through advanced features
Intro
Getting Started with Excel Course
3:35
Video 1
Ribbon Basics in Excel
12:09
Video 2
Cell Address and Cell Reference Type
7:28
Video 3
Freeze Panes
2:09
Video 4
Row and Column Features
3:48
Video 5
Wrap Text and Adding a Line
2:52
Video 6
Excel Proper Function
3:03
Video 7
Excel Formatting and Alignment
5:57
Video 8
Merge and Center
3:33
Video 9
Excel Icons and Shapes
3:33
Video 10
Excel Tables
2:55
Video 11
Rounding and Decimals
2:06
Video 12
Join Cells in Excel
2:04
Video 13
Flash Fill
1:01
Video 14
Checkboxes, IF, Count
7:40
Video 15
Nested IF, OR AND Statements
2:54
Video 16
Excel Macros
3:14
Video 17
Average, Max, Min
2:19
Video 18
XLOOKUP and VLOOKUP
11:36
Video 19
Math, Autosum, IFERROR
6:31
Video 20
Find and Replace
3:03
Video 21
Duplicates and Unique
3:37
Video 22
Sort and Custom Sort
3:10
Video 23
Filter in Excel
3:24
Video 24
Special Values
1:58
Video 25
Data Validation
4:54
Video 26
Protect in Excel
2:31
Video 27
Handling Multiple Tabs
3:24
Video 28
Excel Indicators
3:39
Video 29
AVERAGEIF, SUMIF, COUNTIF
3:57
Video 30
Conditional Formatting
1:51
Video 31
Text to Columns
2:25
Video 32
PivotTables and PivotCharts
18:05
Video 33
Excel Theme Colors
3:21
Video 34
Printing in Excel
5:12
Video 35
Slicers and Percent of Total
5:00
Course 2: Order Manager
15 lessons · Custom formats through slicers
Video 1
Custom Number Format
5:31
Video 2
Math Functions
8:18
Video 3
Data Validation Drop Downs and List
6:05
Video 4
Conditional Formatting
4:26
Video 5
Sort and Custom Sort
4:36
Video 6
Filter
3:32
Video 7
Moving Columns and Other Options
4:02
Video 8
PivotTables
6:23
Video 9
VLookup and XLookup
9:52
Video 10
Tables
3:04
Video 11
SUMIF
3:08
Video 12
Join Cells
3:20
Video 13
IF, AND, OR Statements
4:04
Video 14
Freeze Panes
2:06
Video 15
Slicers
2:24
Course 3: Basic Budget
9 lessons · Fill formulas through macros
Video 1
Fill Right and Down
3:28
Video 2
Alignment
1:12
Video 3
Data and Number Formatting
3:56
Video 4
More Math Functions
6:32
Video 5
Sparklines
2:58
Video 6
Rounding and Decimals
3:16
Video 7
Duplicates
2:11
Video 8
IFERROR
3:18
Video 9
Macros
3:19
Course 4: Project Tracker
8 lessons · Checkboxes through blank row cleanup
Video 1
Checkboxes and COUNTIF
4:49
Video 2
Progress Bar and COUNTA
3:35
Video 3
Conditional Formatting Continued
2:36
Video 4
Pie Chart
4:40
Video 5
Charts
6:54
Video 6
Merge and Center vs Center Across Selection
1:35
Video 7
Protect
2:31
Video 8
Removing Blank Rows
0:44

Ready to automate what you just learned?

The software does everything these templates do, automatically. Time tracking, invoicing, PTO, projects and more.

Start Your 14-Day Trial →