Generate Direct Linking HTML

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

Excel 2008 - Intro
- A. Basics
- - Introducing the new features in Office 2008 pt. 1
  - Introducing the new features in Office 2008 pt. 2
  - Using the toolbars
  - Using the Office Toolbox
  - Using the Elements gallery
  - Understanding a worksheet and entering information into a cell
  - Changing the default worksheets and cell movement
  - Using ledger sheets
  - Using Save and Save As
  - Understanding the new XML file format pt. 1
  - Understanding the new XML file format pt. 2
  - Opening Excel 2008 files in earlier versions of Excel
  - Moving with the keyboard pt. 1
  - Moving with the keyboard pt. 2
  - Creating a PDF
- B. Working with Cells
- - Using AutoComplete
  - Editing a cell
  - Using spell check
  - Selecting cell ranges pt. 1
  - Selecting cell ranges pt. 2
  - Entering values in a cell range
  - Using AutoFill
  - Using cut, copy and paste
  - Using paste options
  - Using paste special
  - Using the scrapbook
  - Using drag and drop editing
  - Using undo and redo
  - Using the clear command
- C. Formulas and Functions
- - Using AutoCalculate
  - Using AutoSum
  - Creating formulas
  - Using functions in formulas
  - Using the Formula Builder
  - Editing formulas
  - Checking formulas for errors
  - Using relative cell referencing
  - Understanding absolute cell references
  - Creating an absolute cell reference
- D. Formatting Cells
- - Formatting numbers using the Formatting Palette
  - Formatting numbers using the Formatting toolbar
  - Formatting text using the Formatting palette
  - Formatting text using the Formatting toolbar
  - Using the alignment and indentation commands
  - Rotating information in a cell
  - Wrapping text in a cell
  - Using the Merge and Center command
  - Using the Borders command
  - Drawing cell borders
  - Formatting information using the format cells dialog box
  - Using the Format Painter command
- E. Working with Columns and Rows
- - Selecting columns and rows pt. 1
  - Selecting columns and rows pt. 2
  - Changing column width
  - Changing row height
  - Hiding and unhiding columns and rows
  - Inserting columns
  - Inserting rows
  - Deleting columns and rows
  - Inserting and deleting cells
- F. Using Styles and AutoFormat
- - Creating a custom cell style by example
  - Creating a custom cell style
  - Deleting a custom cell style
  - Modifying a custom cell style
  - Merging custom cell styles
  - Applying AutoFormat
- G. Workbook Views and Page Setup
- - Using Normal view
  - Using Page Layout view
  - Changing the margins
  - Changing the page orientation and the paper size
  - Setting manual page breaks
  - Setting print titles
  - Creating headers and footers pt. 1
  - Creating headers and footers pt. 2
- H. Printing
- - Printing
  - Setting, adding to, and removing print areas

Excel 2008 - Intro

Platform: Mac

Microsoft^® Office Excel 2008 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the new results-oriented interface and rich data visualization, professional-looking charts are easier to create and use.

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. Basics

		Key #	Length
1.	Introducing the new features in Office 2008 pt. 1	45607	3:15
2.	Introducing the new features in Office 2008 pt. 2	45608	2:18
3.	Using the toolbars	45609	2:13
4.	Using the Office Toolbox	45610	1:46
5.	Using the Elements gallery	45611	2:39
6.	Understanding a worksheet and entering information into a cell	45678	2:01
7.	Changing the default worksheets and cell movement	45612	2:08
8.	Using ledger sheets	45613	2:01
9.	Using Save and Save As	45614	2:52
10.	Understanding the new XML file format pt. 1	45615	1:11
11.	Understanding the new XML file format pt. 2	45679	1:39
12.	Opening Excel 2008 files in earlier versions of Excel	45616	1:03
13.	Moving with the keyboard pt. 1	45617	2:28
14.	Moving with the keyboard pt. 2	45618	1:57
15.	Creating a PDF	45619	1:48

B. Working with Cells

		Key #	Length
1.	Using AutoComplete	45620	2:10
2.	Editing a cell	45621	1:57
3.	Using spell check	45622	1:43
4.	Selecting cell ranges pt. 1	45623	2:44
5.	Selecting cell ranges pt. 2	45624	2:51
6.	Entering values in a cell range	45625	1:29
7.	Using AutoFill	45626	2:16
8.	Using cut, copy and paste	45638	2:39
9.	Using paste options	45639	2:05
10.	Using paste special	45640	1:24
11.	Using the scrapbook	45641	0:56
12.	Using drag and drop editing	45642	1:17
13.	Using undo and redo	45643	2:00
14.	Using the clear command	45644	0:45

C. Formulas and Functions

		Key #	Length
1.	Using AutoCalculate	45627	1:22
2.	Using AutoSum	45628	2:39
3.	Creating formulas	45629	2:57
4.	Using functions in formulas	45630	2:13
5.	Using the Formula Builder	45631	3:37
6.	Editing formulas	45632	2:46
7.	Checking formulas for errors	45633	1:35
8.	Using relative cell referencing	45634	2:29
9.	Understanding absolute cell references	45635	3:06
10.	Creating an absolute cell reference	45636	1:38

D. Formatting Cells

		Key #	Length
1.	Formatting numbers using the Formatting Palette	45637	2:11
2.	Formatting numbers using the Formatting toolbar	45680	1:07
3.	Formatting text using the Formatting palette	45645	2:23
4.	Formatting text using the Formatting toolbar	45681	1:48
5.	Using the alignment and indentation commands	45646	1:43
6.	Rotating information in a cell	45647	3:07
7.	Wrapping text in a cell	45648	1:19
8.	Using the Merge and Center command	45649	2:12
9.	Using the Borders command	45650	2:29
10.	Drawing cell borders	45651	2:02
11.	Formatting information using the format cells dialog box	45652	2:34
12.	Using the Format Painter command	45653	1:35

E. Working with Columns and Rows

		Key #	Length
1.	Selecting columns and rows pt. 1	45654	2:15
2.	Selecting columns and rows pt. 2	45655	1:50
3.	Changing column width	45656	2:58
4.	Changing row height	45657	2:58
5.	Hiding and unhiding columns and rows	45658	2:35
6.	Inserting columns	45659	2:22
7.	Inserting rows	45660	2:09
8.	Deleting columns and rows	45661	2:00
9.	Inserting and deleting cells	45662	2:17

F. Using Styles and AutoFormat

		Key #	Length
1.	Creating a custom cell style by example	45663	2:12
2.	Creating a custom cell style	45664	2:45
3.	Deleting a custom cell style	45665	1:00
4.	Modifying a custom cell style	45666	1:23
5.	Merging custom cell styles	45667	1:38
6.	Applying AutoFormat	45668	1:35

G. Workbook Views and Page Setup

		Key #	Length
1.	Using Normal view	45669	1:14
2.	Using Page Layout view	45670	1:37
3.	Changing the margins	45671	2:25
4.	Changing the page orientation and the paper size	45672	2:15
5.	Setting manual page breaks	45673	2:16
6.	Setting print titles	45674	2:20
7.	Creating headers and footers pt. 1	45675	2:48
8.	Creating headers and footers pt. 2	45682	2:06

H. Printing

			Key #	Length
1.		Printing	45676	2:51
2.		Setting, adding to, and removing print areas	45677	2:19

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.