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)
1.5 - Absolute & Relative References - "ByDoing" Exercise
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock