Generate Direct Linking HTML

Select the tutorials you would like to include in the Direct Linking HTML, then click the "Preview" button.

Excel 2008 - Advanced
- A. Templates
- - Creating custom templates
  - Creating a workbook from a template
  - Modifying a template file
- B. Working with Dates and Times
- - Entering dates into a cell
  - Formatting date entries
  - Displaying the current date
  - Generating a series of dates
  - Using date related functions
  - Entering times into a cell
  - Formatting time entries
  - Displaying the current time
- C. Custom Number Formats
- - Formatting numbers automatically
  - Understanding custom number formatting
  - Creating a custom number format
  - Creating custom date and time formats
  - Hiding the contents of a cell using a custom format
  - Deleting a custom format
- D. Advanced Charting
- - Selecting elements in a chart
  - Formatting chart elements
  - Modifying the chart area
  - Modifying the plot area
  - Adding text to a chart
  - Modifying the legend
  - Modifying the value axis
  - Modifying the category axis
  - Deleting a data series from a chart
  - Adding a data series to a chart pt. 1
  - Adding a data series to a chart pt. 2
  - Adding a trend line to a chart
  - Creating a combination chart
  - Creating picture charts
- E. Data Validation
- - Specifying data validation criteria
  - Creating Data Validation Rule messages pt. 1
  - Creating Data Validation Rule messages pt. 2
  - Creating a data validation drop-down list
  - Finding cells that contain Data Validation Rules
  - Clearing existing Data Validation Rules
- F. Sorting and Filtering
- - Sorting data in a worksheet
  - Sorting by multiple columns or criteria
  - Filtering data in a worksheet using AutoFilter pt. 1
  - Filtering data in a worksheet using AutoFilter pt. 2
  - Clearing a filter in a worksheet
  - Creating and/or statements using AutoFilter
  - Creating a criteria range
  - Defining criteria using the criteria range
  - Creating and/or statements using the criteria range pt. 1
  - Creating and/or statements using the criteria range pt. 2
- G. Outlines
- - Creating an outline automatically
  - Creating a manual outline
  - Displaying levels in an outline
  - Hiding the outline symbols
  - Clearing an outline
  - Adding subtotals to a worksheet pt. 1
  - Adding subtotals to a worksheet pt. 2
- H. Linking and Consolidating Worksheets
- - Creating a Link formula within the same workbook
  - Creating a Link formula to another workbook
  - Consolidating worksheets using formulas pt. 1
  - Consolidating worksheets using formulas pt. 2
  - Consolidating worksheets using formulas pt. 3
  - Using the Consolidate command pt. 1
  - Using the Consolidate command pt. 2
  - Opening a workbook with External Reference formulas
  - Breaking links to external references
- I. What-if Analysis
- - Creating scenarios pt. 1
  - Creating scenarios pt. 2
  - Displaying scenarios
  - Modifying scenarios
  - Generating a Scenario report
  - Deleting a scenario
  - Using Goal Seek
- J. Workbook Protection
- - Protecting a worksheet
  - Unprotecting a worksheet
  - Using a password to protect a worksheet
  - Protecting a workbook pt. 1
  - Protecting a workbook pt. 2
  - Protecting a workbook pt. 3
  - Unprotecting a workbook
- K. Auditing and Error Checking
- - Displaying formulas
  - Identifying precedent cells
  - Identifying dependent cells
  - Checking for errors pt. 1
  - Checking for errors pt. 2
- L. Sharing Data with Word
- - Copying and pasting static information
  - Copying and pasting as a link
  - Importing a text file into Excel

Excel 2008 - Advanced

Platform: Mac

Microsoft^® Office Excel 2008 is a spreadsheet application that features calculation, graphing tools, pivot tables, and more. Learn about the more advanced features of this very popular and versatile office tool.

Click here to learn about subscribing to this collection!

Click any of the highlighted titles to view free sample tutorial movies. Atomic Training subscribers to this collection have access to all of the following movies, plus thousands of tutorials on other applications.

Expand all / Collapse all

A. Templates

		Key #	Length
1.	Creating custom templates	72553	2:16
2.	Creating a workbook from a template	72552	0:45
3.	Modifying a template file	72554	1:21

B. Working with Dates and Times

		Key #	Length
1.	Entering dates into a cell	72555	1:05
2.	Formatting date entries	72556	0:46
3.	Displaying the current date	72557	1:08
4.	Generating a series of dates	72558	1:00
5.	Using date related functions	72559	3:22
6.	Entering times into a cell	72560	0:35
7.	Formatting time entries	72561	0:43
8.	Displaying the current time	72562	1:16

C. Custom Number Formats

		Key #	Length
1.	Formatting numbers automatically	72563	1:07
2.	Understanding custom number formatting	72564	2:59
3.	Creating a custom number format	72565	2:28
4.	Creating custom date and time formats	72566	2:22
5.	Hiding the contents of a cell using a custom format	72567	1:05
6.	Deleting a custom format	72568	0:52

D. Advanced Charting

		Key #	Length
1.	Selecting elements in a chart	72570	0:58
2.	Formatting chart elements	72571	0:50
3.	Modifying the chart area	72569	1:10
4.	Modifying the plot area	72572	1:39
5.	Adding text to a chart	72573	1:16
6.	Modifying the legend	72574	1:03
7.	Modifying the value axis	72575	2:49
8.	Modifying the category axis	72576	1:55
9.	Deleting a data series from a chart	72577	1:33
10.	Adding a data series to a chart pt. 1	72578	2:52
11.	Adding a data series to a chart pt. 2	72630	1:22
12.	Adding a trend line to a chart	72579	3:29
13.	Creating a combination chart	72580	1:57
14.	Creating picture charts	72581	1:51

E. Data Validation

		Key #	Length
1.	Specifying data validation criteria	72582	2:56
2.	Creating Data Validation Rule messages pt. 1	72583	1:20
3.	Creating Data Validation Rule messages pt. 2	72631	2:15
4.	Creating a data validation drop-down list	72584	2:33
5.	Finding cells that contain Data Validation Rules	72585	1:45
6.	Clearing existing Data Validation Rules	72586	2:01

F. Sorting and Filtering

		Key #	Length
1.	Sorting data in a worksheet	72608	1:08
2.	Sorting by multiple columns or criteria	72611	2:23
3.	Filtering data in a worksheet using AutoFilter pt. 1	72612	1:58
4.	Filtering data in a worksheet using AutoFilter pt. 2	72632	1:13
5.	Clearing a filter in a worksheet	72613	0:58
6.	Creating and/or statements using AutoFilter	72614	2:06
7.	Creating a criteria range	72615	0:50
8.	Defining criteria using the criteria range	72616	1:43
9.	Creating and/or statements using the criteria range pt. 1	72617	1:23
10.	Creating and/or statements using the criteria range pt. 2	72633	1:13

G. Outlines

		Key #	Length
1.	Creating an outline automatically	72587	2:11
2.	Creating a manual outline	72588	0:47
3.	Displaying levels in an outline	72589	1:46
4.	Hiding the outline symbols	72590	0:45
5.	Clearing an outline	72591	1:33
6.	Adding subtotals to a worksheet pt. 1	72609	2:04
7.	Adding subtotals to a worksheet pt. 2	72610	1:05

H. Linking and Consolidating Worksheets

		Key #	Length
1.	Creating a Link formula within the same workbook	72592	1:29
2.	Creating a Link formula to another workbook	72597	1:52
3.	Consolidating worksheets using formulas pt. 1	72593	2:22
4.	Consolidating worksheets using formulas pt. 2	72596	1:15
5.	Consolidating worksheets using formulas pt. 3	72598	1:52
6.	Using the Consolidate command pt. 1	72599	2:36
7.	Using the Consolidate command pt. 2	72600	3:17
8.	Opening a workbook with External Reference formulas	72594	2:21
9.	Breaking links to external references	72595	1:13

I. What-if Analysis

		Key #	Length
1.	Creating scenarios pt. 1	72601	2:53
2.	Creating scenarios pt. 2	72602	1:08
3.	Displaying scenarios	72603	0:48
4.	Modifying scenarios	72604	0:58
5.	Generating a Scenario report	72605	1:03
6.	Deleting a scenario	72606	0:35
7.	Using Goal Seek	72607	1:32

J. Workbook Protection

		Key #	Length
1.	Protecting a worksheet	72620	1:17
2.	Unprotecting a worksheet	72618	0:29
3.	Using a password to protect a worksheet	72619	1:17
4.	Protecting a workbook pt. 1	72621	2:11
5.	Protecting a workbook pt. 2	72622	1:02
6.	Protecting a workbook pt. 3	72634	1:23
7.	Unprotecting a workbook	72623	0:45

K. Auditing and Error Checking

		Key #	Length
1.	Displaying formulas	72625	0:49
2.	Identifying precedent cells	72624	1:44
3.	Identifying dependent cells	72626	0:55
4.	Checking for errors pt. 1	72627	2:15
5.	Checking for errors pt. 2	72635	2:26

L. Sharing Data with Word

		Key #	Length
1.	Copying and pasting static information	72628	1:11
2.	Copying and pasting as a link	72636	1:06
3.	Importing a text file into Excel	72629	2:54

Tutorial series by Beth Bruestle

Box shot reprinted by permission from Microsoft Corporation. Microsoft is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries.