This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Essentials
Getting Started
Welcome to ExcelByDoing - Essentials (2:35)
A Brief History of Microsoft Excel and Spreadsheet Software
Section 1 - Foundational Excel Features
1.1 - Workbooks, worksheets & cells - Introduction (4:36)
1.1 - Workbooks, Worksheets, & Cells - Walk-through Example (4:45)
1.1 - Workbooks, worksheets & cells - "ByDoing" Exercise (1:19)
1.2 - Rows & Columns- Introduction (2:57)
1.2 - Rows & Columns - Walk-through Example (2:12)
1.2 - Rows & Columns - "ByDoing" Exercise (2:05)
1.3 - Cell Addresses & The Name Box - Introduction (2:49)
1.3 - Cell Addresses & The Name Box - Walk-through Example (1:35)
1.3 - Cell Addresses & The Name Box - "ByDoing" Exercise (1:37)
1.4 - Ranges & References - Introduction (4:49)
1.4 - Ranges & References - Walk-through Example (4:19)
1.4 - Ranges & References - "ByDoing" Exercise (1:53)
1.5 - Absolute & Relative References - Introduction (1:53)
1.5 - Absolute & Relative References - Walk-through Example (2:31)
1.5 - Absolute & Relative References - "ByDoing" Exercise (1:35)
1.6 - Understanding Check - Section 1 Quiz
Section 2 - Working With Data
2.1 - Toolbar & Menus- Introduction (3:51)
2.1 - Toolbar & Menus - Walk-through example (5:50)
2.1 - Toolbars & Menus - "ByDoing" Exercise (4:37)
2.2 - Copy, Cut, & Paste - Introduction (2:58)
2.2 - Copy, Cut, & Paste - Walk-through Example (5:04)
2.2 - Copy, Cut, & Paste - "ByDoing" Exercise
2.3 - Filtering & Sorting - Introduction (3:48)
2.3 - Filtering & Sorting - Walk-through Example (2:21)
2.3 - Filtering & Sorting - "ByDoing" Exercise (1:49)
2.4 - Simple Formulas - Introduction (2:54)
2.4 - Simple Formulas - Walk-through Example (2:01)
2.4 - Simple Formulas - "ByDoing" Exercise (1:13)
2.5 - Understanding Check - Section 2 Quiz
Section 3 - Basic Functions
3.1 - Sum & Autosum - Introduction (3:37)
3.1 - Sum & Autosum - Walk-through Example (2:00)
3.1 - Sum & Autosum - "ByDoing" Exercise (0:59)
3.2 - Count & CountA - Introduction (2:43)
3.2 - Count & CountA - Walk-through Example (0:42)
3.2 - Count & CountA - "ByDoing" Exercise (1:34)
3.3 - Average & AverageA - Introduction (4:33)
3.3 - Average & AverageA - Walk-through Example (3:16)
3.3 - Average & AverageA - "ByDoing" Exercise (0:25)
3.4 - Max & Min - Introduction (2:19)
3.4 - Max & Min - Walk-through Example (0:39)
3.4 - Max & Min - "ByDoing" Exercise (1:01)
3.5 - Understanding Check - Section 3 Quiz
Final Real-world Challenges
Final Real-world Challenges - Instructions
Final Real-world Challenges - Solutions (13:16)
2.2 - Copy, Cut, & Paste - Walk-through Example
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock