Excel 101

Purchase this course to access all lessons and start learning.

A Tour of Excel
Video Time
Save Video 1. What is Excel? Watched 2:32
Save Video 2. A tour of the Excel interface Watched 2:34
Save Video 3. A tour of the Excel Ribbon Watched 3:09
Getting started
Video Time
Save Video 4. How to create a new workbook Watched 2:06
Save Video 5. How to save a workbook Watched 2:16
Save Video 6. How to navigate a workbook Watched 2:32
Save Video 7. How to undo and redo changes in Excel Watched 2:39
The worksheet
Video Time
Save Video 8. How to select cells in Excel Watched 2:21
Save Video 9. How to select rows and columns in Excel Watched 1:43
Save Video 10. Shortcuts for selecting cells in Excel Watched 2:09
Entering data
Video Time
Save Video 11. How to enter data in Excel Watched 1:42
Save Video 12. How to delete data in Excel Watched 2:00
Save Video 13. How to edit data in Excel Watched 1:22
Building a Workbook
Video Time
Save Video 14. How to insert and delete worksheets Watched 2:30
Save Video 15. How to name and format worksheet tabs Watched 2:21
Save Video 16. How to move and copy worksheets in Excel Watched 2:20
Formula basics
Video Time
Save Video 17. What is a cell reference? Watched 2:15
Save Video 18. What is a formula? Watched 2:28
Save Video 19. What is a function? Watched 2:16
Save Video 20. How to enter a formula with cell references Watched 2:28
Save Video 21. How to edit a formula Watched 2:26
Cell references
Video Time
Save Video 22. What's a relative reference? Watched 2:38
Font formatting
Video Time
Save Video 23. How to format font and font size in Excel Watched 3:05
Save Video 24. How to change the font color in Excel Watched 2:40
Save Video 25. How to insert symbols and special characters in Excel Watched 3:18
Borders and fills
Video Time
Save Video 26. How to apply a border to cells in Excel Watched 3:11
Save Video 27. How to apply a fill to cells in Excel Watched 2:48
Conditional Formatting
Video Time
Save Video 28. What is conditional formatting? Watched 2:33