Create Easy Links

Select the tutorials you would like to include in your Easy Links, 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
- I. Practice and Quiz Sets Beta
- - Section A - Basics
  - Section B - Working with Cells
  - Section C - Formulas and Functions
  - Section D - Formatting Cells
  - Section E - Working with Columns and Rows
  - Section F - Styles, Themes, and Tables
  - Section G - Workbook Views and Page Setup
  - Section H - Printing

Excel 2010 - Intro

Platform: PC

Learn how to use Microsoft^® Office Excel^® 2010. In this online tutorial series, you'll learn how to create and format basic spreadsheets, including how to efficiently modify cells, rows and columns. You'll be on your way to analyzing data, sharing information, and making more informed decisions.

Click any of the unlocked titles to view free sample tutorial movies. Depending upon subscription level, Atomic Learning users have access to all of the following movies, plus thousands of other tutorials and resources on other applications and topics.

Learn About Subscription Options »

Expand all / Collapse all

A. Basics

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

B. Working with Cells

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

C. Formulas and Functions

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

D. Formatting Cells

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

E. Working with Columns and Rows

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

F. Styles, Themes, and Tables

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

G. Workbook Views and Page Setup

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

H. Printing

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

I. Practice and Quiz Sets Beta

Tutorial Number	Tutorial Title	Key #
1.	Section A - Basics	91823
2.	Section B - Working with Cells	91824
3.	Section C - Formulas and Functions	91825
4.	Section D - Formatting Cells	91826
5.	Section E - Working with Columns and Rows	91827
6.	Section F - Styles, Themes, and Tables	91828
7.	Section G - Workbook Views and Page Setup	91829
8.	Section H - Printing	91830

Tutorial series by Beth Bruestle, narration by Flip Crummer

Box shot reprinted by permission from Microsoft Corporation. Microsoft and Excel are registered trademarks of Microsoft Corporation in the United States and/or other countries.

Tools

Create Easy Links

Achieve Professional Designation

Leverage the knowledge you’ve earned to achieve the Certified Business Laureate designation.

Preview Easy Links

Get Easy Links HTML

Create Easy Links

Excel 2010 - Intro

Description

Tools

Achieve Professional Designation

Username: Password:
	Forgot username or password?