Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Basics
Welcome and Downloadable Excel documents
Welcome
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)
Downloable Handouts
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
New section
What's next?
Teach online with
Welcome
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock