Microsoft Excel 2007 – Learn The Essentials

Difficulty Scale:
Easy = Medium = Hard = Advanced =

Video Title

Duration

Difficulty
1. Getting Started
2:03
a. Why use a spreadsheet?
1:39
b. The Microsoft Office Button
2:50
c. What's on the Ribbon?
1:06
d. Making your way around the Ribbon
1:23
2. Introduction to Worksheets
1:07
a. Opening a file
1:28
b. Navigate in a worksheet
1:42
c. Working with data
2:50
d. Selection methods
2:12
e. Entering data
2:21
f. AutoSum
3:04
g. Editing cell content
1:55
h. Adding and deleting worksheets
1:45
i. Saving a file
2:12
3. Basic Formatting in a Worksheet
0:50
a. Create a new spreadsheet
1:10
b. Width and height
2:10
c. Numeric formats
3:07
d. Alignment of data
2:12
e. Changing Fonts and other cell attributes
2:07
4. Creating formulas using mathematical operators
1:22
a. Create a Basic Formula
2:05
b. Order of operations
2:42
c. Using functions in formulas
2:17
d. Relative Formulas
1:42
e. Named Ranges
4:21
f. Absolute References
3:32
5. Worksheet Management
0:56
a. Cut/Copy/Paste
2:09
b. Delete Cell Range
1:04
c. Inserting and Deleting Rows/Columns
1:44
d. Viewing and zoom options
4:37
e. Freeze panes
2:33
f. Navigate multiple worksheets
2:06
g. 3-D formulas
2:03
6. Printing Options
0:48
a. Print preview and Page setup
5:46
b. The Page Layout Tab and Page Layout View
2:58
c. Page breaks
1:58
d. Printing a range
1:53
e. Printing Workbooks
1:11
f. Headers and Footers
3:05
7. Sharing Worksheets
0:43
a. Protecting a worksheet
2:03
b. Allowing others to edit ranges
2:12
c. Workbook Sharing
2:01
d. Track Changes
4:52
8. Number Crunching with Numbers and Formulas
0:57
a. Linking workbooks
4:22
b. Save a workspace
1:42
c. Insert Function
3:21
d. The IF function
3:06
e. The ROUND function
2:23
f. The VLOOKUP function
3:45
g. The NESTED IF function
2:22
h. The PMT function
3:14
i. The TODAY function
1:54
9. Charting In Excel
0:49
a. Planning and Creating a chart
2:31
b. Modifying a chart with chart tools
3:47
c. Creating a pie chart
3:24
d. Advanced charting options
4:15
e. Chart templates
1:59
f. Other Chart Types
2:56
g. Exporting an Excel chart to other Office applications
1:27
10. Pivot Tables
0:00
a. What are PivotTables and PivotCharts?
2:26
b. Creating a PivotTable
1:07
c. Laying out a PivotTable
1:21
d. Creating a PivotChart
1:50
11. Working with Macros
0:00
a. Introduction to Macros
1:48
b. Creating a macro
5:13
c. Macro security
2:40

Microsoft Excel 2007 – Learn The Essentials

The Series begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to create formulas. The series then moves into printing options, sharing worksheets, advanced formulas, charts, pivot tables and wraps up with an introduction to Macros.


Microsoft Excel 2007 – Learn The Essentials

** Subscription Required for Download link **