Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel 2007 Basics: Learn the basics of Excel in less than a day. Start now!
Introduction
Welcome Excel 2007 basics (1:56)
What you need to know for this course (1:15)
What is excel (0:48)
Training files
Tour of the interface
The office button (2:48)
The ribbon (3:46)
Excel options (5:02)
Exploring the quick access toolbar (4:04)
The minimize maximize restore and close buttons (1:45)
The zoom area (4:26)
The status bar (2:05)
Page preview icon area (1:12)
The header area (0:58)
Exploring the ribbon tabs
Home tab clipboard group (4:14)
Home tab font group (4:25)
Home tab alignment group (3:56)
Home tab number group (2:28)
Home tab styles group (1:25)
Insert tab tables group (2:34)
Insert tab illustrations group (5:40)
Page layout tab themes group (1:16)
Page layout tab page setup group part one (3:14)
Page layout tab page setup group part two (4:40)
Page layout tab sheet options group (1:00)
Formulas tab function library group (1:49)
Formulas tab defined names group (2:14)
Data tab sort and filter group part one (5:44)
Data tab sort and filter group part two (2:38)
Review tab proofing group (3:09)
Review tab comments group (2:59)
View tab workbook views group (1:02)
View tab show hide group (0:40)
View tab zoom group (1:39)
View tab window group part one (2:45)
View tab window group part two (4:08)
Working with workbooks
What is a workbook (0:54)
Creating a new workbook (3:07)
Saving a workbook (5:24)
Opening and closing a workbook (2:37)
Deleting a workbook (2:21)
Renaming a workbook (1:33)
Working with worksheets
What is a worksheet (3:05)
Creating worksheets (5:34)
Opening a worksheet (1:08)
Saving a worksheet (1:18)
Deleting a worksheet (2:27)
Renaming worksheets (1:49)
Moving and copying worksheets (5:46)
Changing sheet colours (2:38)
Exploring the autofills (8:25)
Hiding and unhiding sheets (2:48)
Selecting several worksheets (2:37)
Columns, rows and cells
What are columns (5:41)
What are rows (3:23)
What are cells (4:01)
Resizing column widths (4:15)
Resizing row heights (4:34)
Hiding and unhiding columns and rows (5:33)
Dealing with data
Text to columns (11:15)
Removing duplicates (5:45)
Finding data (7:16)
Replacing data (5:06)
Printing
Printing basics part 1 (5:16)
Printing basics part 2 (4:49)
Working with print preview (4:53)
Page setup options part 1 (5:53)
Page setup options part 2 (4:20)
Printing your spreadsheet (0:57)
Formulas
What is a formula (8:47)
The formula bar (3:06)
Remember bodmas (3:59)
Relative reference (4:02)
Absolute reference (6:21)
The formula auditing group part 1 (5:23)
The formula auditing group part 2 (4:13)
The calculation group (3:41)
Functions
What is a function (0:53)
Types of functions (5:58)
The autosum function (4:31)
Minimum and maximum functions (4:00)
Finding the average of numbers (1:47)
The trim function (2:04)
The left and right functions (2:09)
Lower proper and upper functions (2:34)
Merging two cells (2:49)
Count function (4:47)
Date functions (1:50)
Bonus
Opening and closing workbooks (1:35)
Switching between workbooks (1:55)
Minimize window (0:51)
Inserting worksheets (1:05)
Renaming worksheets (1:09)
Switching between worksheets (0:56)
Selecting all worksheets (1:37)
Conclusion
Goodbye Excel 2007 basic (1:08)
Teach online with
Hiding and unhiding columns and rows
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock