Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Basics
Downloadable Excel documents
Basic Excel book
Excel Quick Reference Guide
The Excel enviroment
Introducing ribbons, backstage and Excel environment (4:41)
Entering and editing data in Excel
Entering data (13:33)
Using auto fill when entering data (4:43)
Excel cut, copy, paste shortcuts (2:18)
Navigating in Excel worksheets and workbooks
Four cursors (5:08)
Navigating using shortcut keys (5:51)
Basic formulas and introducing functions
Formula and function information
Basic formulas (6:36)
Average and Count Formulas (3:21)
Absolute reference formulas (4:41)
Formatting cells, worksheets and workbooks
Format cells (3:43)
Copy workbooks (4:10)
Format Dialogue Box (2:37)
Format Bold, Underline, Italicize (2:37)
Grouping, Ungrouping, and Linking worksheets
Grouping and ungrouping worksheets (2:52)
Linking worksheets within a workbook (4:30)
Basic charts
Column and pie charts (1:37)
Completed Workbook for Practice
Teach online with
Excel Quick Reference Guide
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock