Generate Direct Linking HTML

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

Excel 2010 - Intro
- A. Basics
- - Introducing the new Office 2010 Ribbon
  - Using and minimizing the Ribbon
  - Using the Quick Access toolbar
  - Customizing the Quick Access toolbar
  - Resetting the Quick Access toolbar
  - Customizing the Ribbon pt. 1
  - Customizing the Ribbon pt. 2
  - Adding a new tab to the Ribbon
  - Resetting Ribbon customizations
  - Importing/exporting Ribbon customizations
  - Using Backstage View
  - Understanding a worksheet and entering information into a cell
  - Changing the default number of worksheets and the cell movement
  - Using a template
  - Using Save and Save As
  - Using Compatibility mode
  - Opening Excel 2010 files in earlier versions of Excel
  - Moving with the keyboard pt. 1
  - Moving with the keyboard pt. 2
  - Using Keytips
- 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 Preview
  - Using Paste Special
  - Using the clipboard pt. 1
  - Using the clipboard pt. 2
  - 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 and the Function wizard pt. 1
  - Using functions and the Function wizard pt. 2
  - 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 Ribbon
  - Formatting text using the Ribbon
  - 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 cells 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. Styles, Themes, and Tables
- - Using cell styles
  - 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
  - Using themes
  - Customizing themes
  - Formatting as a table pt. 1
  - Formatting as a table pt. 2
  - Creating a custom table style pt. 1
  - Creating a custom table style pt. 2
  - Deleting a custom table style
- G. Workbook Views and Page Setup
- - Using Normal view
  - Using Page Layout view
  - Using Page Break preview
  - Using the Page Layout tab
  - Changing the margins
  - Changing the page orientation and paper size
  - Setting manual page breaks
  - Setting print titles
  - Creating headers and footers
  - Using the Page Setup dialog box
- H. Printing
- - Using Print and Print Preview
  - Using Save & Send
  - Setting print areas
  - Adding to and clearing print areas
  - Creating a PDF

Excel 2010 - Intro

Platform: PC

Microsoft^® Office Excel 2010 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. This thorough introductory-level tutorial series will teach you all you need to know about the basics of using Excel 2010.

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 Office 2010 Ribbon	80702	1:23
2.	Using and minimizing the Ribbon	80703	2:23
3.	Using the Quick Access toolbar	80704	2:15
4.	Customizing the Quick Access toolbar	80705	2:54
5.	Resetting the Quick Access toolbar	80784	1:26
6.	Customizing the Ribbon pt. 1	80785	2:24
7.	Customizing the Ribbon pt. 2	80786	1:49
8.	Adding a new tab to the Ribbon	80787	2:35
9.	Resetting Ribbon customizations	80788	2:13
10.	Importing/exporting Ribbon customizations	80789	3:11
11.	Using Backstage View	80790	2:33
12.	Understanding a worksheet and entering information into a cell	80706	2:14
13.	Changing the default number of worksheets and the cell movement	80707	2:23
14.	Using a template	80708	0:51
15.	Using Save and Save As	80709	2:46
16.	Using Compatibility mode	80710	3:07
17.	Opening Excel 2010 files in earlier versions of Excel	80711	1:06
18.	Moving with the keyboard pt. 1	80712	2:18
19.	Moving with the keyboard pt. 2	80713	1:53
20.	Using Keytips	80714	1:00

B. Working with Cells

		Key #	Length
1.	Using AutoComplete	80715	2:04
2.	Editing a cell	80716	1:56
3.	Using spell check	80717	1:46
4.	Selecting cell ranges pt. 1	80718	2:44
5.	Selecting cell ranges pt. 2	80719	2:55
6.	Entering values in a cell range	80720	1:29
7.	Using AutoFill	80721	2:20
8.	Using Cut, Copy and Paste	80733	2:31
9.	Using Paste Preview	80734	1:47
10.	Using Paste Special	80735	1:36
11.	Using the clipboard pt. 1	80736	2:41
12.	Using the clipboard pt. 2	81031	1:18
13.	Using drag and drop editing	80737	1:21
14.	Using Undo and Redo	80738	1:52
15.	Using the Clear command	80739	0:49

C. Formulas and Functions

		Key #	Length
1.	Using AutoCalculate	80722	1:40
2.	Using AutoSum	80723	2:37
3.	Creating formulas	80724	2:47
4.	Using functions and the Function wizard pt. 1	80725	2:05
5.	Using functions and the Function wizard pt. 2	80726	3:15
6.	Editing formulas	80727	2:58
7.	Checking formulas for errors	80728	1:32
8.	Using Relative Cell Referencing	80729	2:26
9.	Understanding Absolute Cell References	80730	2:58
10.	Creating an Absolute Cell Reference	80731	1:32

D. Formatting Cells

		Key #	Length
1.	Formatting numbers using the Ribbon	80732	2:23
2.	Formatting text using the Ribbon	80740	2:51
3.	Using the Alignment and Indentation commands	80741	1:27
4.	Rotating information in a cell	80742	2:02
5.	Wrapping text in a cell	80743	0:43
6.	Using the Merge and Center command	80744	1:33
7.	Using the Borders command	80745	1:36
8.	Drawing cell borders	80746	2:35
9.	Formatting cells using the Format Cells dialog box	80747	2:50
10.	Using the Format Painter command	80748	1:41

E. Working with Columns and Rows

		Key #	Length
1.	Selecting columns and rows pt. 1	80749	2:25
2.	Selecting columns and rows pt. 2	80750	1:36
3.	Changing column width	80751	3:00
4.	Changing row height	80752	2:52
5.	Hiding and unhiding columns and rows	80753	3:03
6.	Inserting columns	80754	2:36
7.	Inserting rows	80755	2:25
8.	Deleting columns and rows	80756	2:31
9.	Inserting and deleting cells	80757	2:26

F. Styles, Themes, and Tables

		Key #	Length
1.	Using cell styles	80758	1:42
2.	Creating a custom cell style by example	80759	2:05
3.	Creating a custom cell style	80760	2:41
4.	Deleting a custom cell style	80761	0:41
5.	Modifying a custom cell style	80762	1:34
6.	Merging custom cell styles	80763	1:08
7.	Using themes	80769	0:40
8.	Customizing themes	80770	1:06
9.	Formatting as a table pt. 1	80764	1:34
10.	Formatting as a table pt. 2	80765	1:58
11.	Creating a custom table style pt. 1	80766	1:41
12.	Creating a custom table style pt. 2	80767	1:52
13.	Deleting a custom table style	80768	1:05

G. Workbook Views and Page Setup

		Key #	Length
1.	Using Normal view	80771	0:49
2.	Using Page Layout view	80772	2:46
3.	Using Page Break preview	80773	3:17
4.	Using the Page Layout tab	80774	3:12
5.	Changing the margins	80775	2:30
6.	Changing the page orientation and paper size	80776	0:44
7.	Setting manual page breaks	80777	1:30
8.	Setting print titles	80778	1:49
9.	Creating headers and footers	80779	2:08
10.	Using the Page Setup dialog box	80780	1:12

H. Printing

		Key #	Length
1.	Using Print and Print Preview	80781	1:36
2.	Using Save & Send	80791	2:51
3.	Setting print areas	80782	2:50
4.	Adding to and clearing print areas	80783	1:28
5.	Creating a PDF	80792	2:38

Tutorial series by Beth Bruestle, narration by Flip Crummer

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.