Generate Direct Linking HTML

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

Excel 2011 - Intro Training
- A. Basics
- - Introducing the Ribbon
  - Using the tabs on the Ribbon
  - Using the Contextual tabs
  - Minimizing the Ribbon
  - Changing Ribbon preferences pt. 1
  - Changing Ribbon preferences pt. 2
  - Customizing/resetting the Ribbon tab order pt. 1
  - Customizing/resetting the Ribbon tab order pt. 2
  - Understanding a worksheet and entering information into a cell
  - Changing the default number of worksheets and the cell movement
  - Using Save and Save As
  - Understanding the XML file format pt. 1
  - Understanding the XML file format pt. 2
  - Opening Excel 2011 files in earlier versions of Excel
  - Moving with the keyboard pt. 1
  - Moving with the keyboard pt. 2
  - Using the Template gallery pt. 1
  - Using the Template gallery 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 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
  - 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
  - Importing 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 the Layout tab
  - Changing the margins
  - Changing the page orientation and paper size
  - Setting manual page breaks
  - Setting repeat titles
  - Creating headers and footers pt. 1
  - Creating headers and footers pt. 2
  - Using the Page Setup dialog box
- H. Printing
- - Using Print and Print Preview
  - Using Share
  - Setting print areas
  - Adding to and clearing print areas

Excel 2011 - Intro Training

Platform: Mac

Microsoft^® Office Excel^® 2011 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. Learn the basics of using Excel in this thorough introductory-level tutorial training series.

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 Ribbon	85072	2:22
2.	Using the tabs on the Ribbon	85073	2:11
3.	Using the Contextual tabs	85074	1:16
4.	Minimizing the Ribbon	85075	1:39
5.	Changing Ribbon preferences pt. 1	85076	2:01
6.	Changing Ribbon preferences pt. 2	85077	2:10
7.	Customizing/resetting the Ribbon tab order pt. 1	85078	1:25
8.	Customizing/resetting the Ribbon tab order pt. 2	85079	1:24
9.	Understanding a worksheet and entering information into a cell	85080	2:03
10.	Changing the default number of worksheets and the cell movement	85081	2:00
11.	Using Save and Save As	85082	2:53
12.	Understanding the XML file format pt. 1	85083	1:14
13.	Understanding the XML file format pt. 2	85084	1:53
14.	Opening Excel 2011 files in earlier versions of Excel	85085	1:04
15.	Moving with the keyboard pt. 1	85086	2:19
16.	Moving with the keyboard pt. 2	85087	1:48
17.	Using the Template gallery pt. 1	85088	2:03
18.	Using the Template gallery pt. 2	85089	1:45
19.	Creating a PDF	85090	1:39

B. Working with Cells

		Key #	Length
1.	Using AutoComplete	85091	2:09
2.	Editing a cell	85092	1:59
3.	Using spell check	85093	1:38
4.	Selecting cell ranges pt. 1	85094	2:43
5.	Selecting cell ranges pt. 2	85095	2:46
6.	Entering values in a cell range	85096	1:22
7.	Using AutoFill	85097	2:16
8.	Using Cut, Copy and Paste	85098	2:22
9.	Using Paste options	85099	2:39
10.	Using Paste Special	85100	2:08
11.	Using the scrapbook	85101	1:03
12.	Using Drag and Drop editing	85102	1:08
13.	Using Undo and Redo	85103	1:50
14.	Using the Clear command	85104	0:49

C. Formulas and Functions

		Key #	Length
1.	Using AutoCalculate	85105	1:26
2.	Using AutoSum	85106	3:05
3.	Creating formulas	85107	3:02
4.	Using functions in formulas	85108	2:02
5.	Using the Formula Builder	85109	3:34
6.	Editing formulas	85110	2:55
7.	Checking formulas for errors	85111	1:29
8.	Using relative cell referencing	85112	2:19
9.	Understanding absolute cell references	85113	2:44
10.	Creating an absolute cell reference	85114	1:38

D. Formatting Cells

		Key #	Length
1.	Formatting numbers using the Ribbon	85115	2:01
2.	Formatting text using the Ribbon	85116	1:51
3.	Using the Alignment and Indentation commands	85117	1:19
4.	Rotating information in a cell	85118	2:03
5.	Wrapping text in a cell	85119	0:58
6.	Using the Merge and Center command	85120	1:26
7.	Using the Borders command	85121	3:18
8.	Formatting cells using the Format Cells dialog box	85122	2:30
9.	Using the Format Painter command	85123	1:30

E. Working with Columns and Rows

		Key #	Length
1.	Selecting columns and rows pt. 1	85124	2:18
2.	Selecting columns and rows pt. 2	85125	1:53
3.	Changing column width	85126	2:47
4.	Changing row height	85127	2:35
5.	Hiding and unhiding columns and rows	85128	2:55
6.	Inserting columns	85129	2:26
7.	Inserting rows	85130	2:18
8.	Deleting columns and rows	85131	2:01
9.	Inserting and deleting cells	85132	2:22

F. Styles, Themes, and Tables

		Key #	Length
1.	Using cell styles	85133	1:38
2.	Creating a custom cell style by example	85134	1:58
3.	Creating a custom cell style	85135	2:33
4.	Deleting a custom cell style	85136	0:40
5.	Modifying a custom cell style	85137	1:33
6.	Importing custom cell styles	85138	1:08
7.	Using themes	85139	0:45
8.	Customizing themes	85140	1:01
9.	Formatting as a table pt. 1	85141	1:48
10.	Formatting as a table pt. 2	85142	1:53
11.	Creating a custom table style pt. 1	85143	1:21
12.	Creating a custom table style pt. 2	85144	1:27
13.	Deleting a custom table style	85145	1:02

G. Workbook Views and Page Setup

		Key #	Length
1.	Using Normal view	85146	1:29
2.	Using Page Layout view	85147	2:45
3.	Using the Layout tab	85148	2:30
4.	Changing the margins	85149	1:57
5.	Changing the page orientation and paper size	85150	0:38
6.	Setting manual page breaks	85151	1:19
7.	Setting repeat titles	85152	1:38
8.	Creating headers and footers pt. 1	85153	2:29
9.	Creating headers and footers pt. 2	85154	1:54
10.	Using the Page Setup dialog box	85155	1:10

H. Printing

		Key #	Length
1.	Using Print and Print Preview	85156	2:44
2.	Using Share	85157	2:38
3.	Setting print areas	85158	2:47
4.	Adding to and clearing print areas	85159	1:49

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.