Generate Direct Linking HTML

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

Excel 2010 - Intermediate
- A. Working with Worksheets
- - Activating and moving between worksheets
  - Selecting multiple worksheets
  - Adding a worksheet to a workbook
  - Deleting a worksheet from a workbook
  - Changing the name of a worksheet
  - Changing the sheet tab color
  - Rearranging the worksheets pt. 1
  - Rearranging the worksheets pt. 2
  - Hiding and unhiding worksheets
- B. Controlling the Worksheet View
- - Zooming in and out of a worksheet
  - Viewing a worksheet in multiple windows
  - Viewing workbooks side-by-side
  - Splitting the worksheet window
  - Freezing and unfreezing panes
  - Monitoring cells with the Watch Window
  - Viewing using full screen
  - Creating custom views
- C. Using Names to Work with Ranges
- - Creating range names
  - Moving to a named range
  - Using range names in formulas
  - Managing named ranges pt. 1
  - Managing named ranges pt. 2
  - Creating a 3D range name
- D. Understanding Cell Comments
- - Adding a comment to a cell
  - Reading comments
  - Showing and hiding comments
  - Editing comments
  - Formatting comments
  - Changing a comment shape
  - Printing comments
  - Deleting a comment
- E. Working with Charts
- - Creating a chart
  - Changing the chart layout
  - Changing the data orientation in a chart
  - Changing the chart type
  - Understanding chart types pt. 1
  - Understanding chart types pt. 2
  - Creating an embedded chart or a chart sheet
  - Moving and resizing an embedded chart
  - Adding a chart title
  - Adding axis titles
  - Changing the location of the chart legend
  - Adding data labels
  - Adding a data table to a chart
  - Changing the chart axis
  - Changing the gridlines
  - Formatting chart elements
  - Moving, resizing, and deleting chart elements
  - Deleting a chart
  - Printing a chart
- F. Working with Sparklines
- - Introducing Sparklines
  - Creating Sparklines
  - Grouping and ungrouping Sparklines
  - Editing the Sparkline data
  - Changing the Sparkline type
  - Showing Sparkline data points
  - Formatting the Sparkline
  - Changing Axis settings
  - Changing Hidden and Empty Cell settings
  - Clearing Sparklines
- G. Working with Graphics
- - Inserting a shape
  - Inserting a picture
  - Inserting clip art
  - Inserting a SmartArt^® graphic
  - Using screenshots
  - Inserting a text box
  - Inserting WordArt
  - Selecting objects
  - Resizing a graphic object
  - Reshaping a graphic object
  - Rotating a graphic object
  - Moving a graphic object
  - Aligning graphic objects
  - Copying a graphic object
  - Deleting a graphic object
  - Grouping graphic objects
  - Stacking graphic objects
  - Formatting the fill of a graphic object
  - Formatting the outline of a graphic object
- H. Conditional Formatting
- - Understanding conditional formatting
  - Applying Highlight Cells rules pt. 1
  - Applying Highlight Cells rules pt. 2
  - Applying Highlight Cells rules pt. 3
  - Applying Top/Bottom rules
  - Applying data bars
  - Applying color scales
  - Applying icon sets
  - Creating a Conditional Formatting rule
  - Managing Conditional Formatting rules
  - Clearing Conditional Formatting rules
- I. Functions
- - Using COUNT functions
  - Using the IF function
  - Using the VLOOKUP function
  - Using the HLOOKUP function
  - Using Concatenate pt. 1
  - Using Concatenate pt. 2
  - Using Text to Columns

Excel 2010 - Intermediate

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. Take your understanding of this versatile application to the next level with this intermediate tutorial 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. Working with Worksheets

		Key #	Length
1.	Activating and moving between worksheets	83022	2:40
2.	Selecting multiple worksheets	83023	2:28
3.	Adding a worksheet to a workbook	83024	2:17
4.	Deleting a worksheet from a workbook	83025	1:01
5.	Changing the name of a worksheet	83026	1:50
6.	Changing the sheet tab color	83027	0:53
7.	Rearranging the worksheets pt. 1	83028	2:16
8.	Rearranging the worksheets pt. 2	83029	2:26
9.	Hiding and unhiding worksheets	83030	1:32

B. Controlling the Worksheet View

		Key #	Length
1.	Zooming in and out of a worksheet	83031	1:17
2.	Viewing a worksheet in multiple windows	83032	1:43
3.	Viewing workbooks side-by-side	83033	1:02
4.	Splitting the worksheet window	83034	2:24
5.	Freezing and unfreezing panes	83035	2:32
6.	Monitoring cells with the Watch Window	83036	2:07
7.	Viewing using full screen	83037	0:33
8.	Creating custom views	83038	2:25

C. Using Names to Work with Ranges

		Key #	Length
1.	Creating range names	83039	2:43
2.	Moving to a named range	83040	0:55
3.	Using range names in formulas	83041	1:02
4.	Managing named ranges pt. 1	83042	2:03
5.	Managing named ranges pt. 2	83043	1:35
6.	Creating a 3D range name	83044	1:57

D. Understanding Cell Comments

		Key #	Length
1.	Adding a comment to a cell	83045	1:08
2.	Reading comments	83046	0:36
3.	Showing and hiding comments	83047	1:12
4.	Editing comments	83048	0:48
5.	Formatting comments	83049	2:26
6.	Changing a comment shape	83050	0:41
7.	Printing comments	83051	1:55
8.	Deleting a comment	83052	0:27

E. Working with Charts

		Key #	Length
1.	Creating a chart	83053	1:08
2.	Changing the chart layout	83054	1:32
3.	Changing the data orientation in a chart	83055	0:42
4.	Changing the chart type	83056	1:00
5.	Understanding chart types pt. 1	83057	1:53
6.	Understanding chart types pt. 2	83058	2:02
7.	Creating an embedded chart or a chart sheet	83059	1:28
8.	Moving and resizing an embedded chart	83060	1:17
9.	Adding a chart title	83061	0:51
10.	Adding axis titles	83062	1:46
11.	Changing the location of the chart legend	83063	0:43
12.	Adding data labels	83064	1:00
13.	Adding a data table to a chart	83065	0:53
14.	Changing the chart axis	83066	1:03
15.	Changing the gridlines	83067	1:35
16.	Formatting chart elements	83102	1:54
17.	Moving, resizing, and deleting chart elements	83068	0:59
18.	Deleting a chart	83069	0:43
19.	Printing a chart	83070	1:26

F. Working with Sparklines

		Key #	Length
1.	Introducing Sparklines	83103	1:15
2.	Creating Sparklines	83104	1:21
3.	Grouping and ungrouping Sparklines	83112	2:04
4.	Editing the Sparkline data	83106	2:05
5.	Changing the Sparkline type	83105	0:53
6.	Showing Sparkline data points	83107	1:43
7.	Formatting the Sparkline	83108	2:25
8.	Changing Axis settings	83109	2:56
9.	Changing Hidden and Empty Cell settings	83110	1:20
10.	Clearing Sparklines	83111	0:40

G. Working with Graphics

		Key #	Length
1.	Inserting a shape	83071	1:08
2.	Inserting a picture	83077	0:45
3.	Inserting clip art	83072	1:27
4.	Inserting a SmartArt^® graphic	83073	1:45
5.	Using screenshots	83113	1:46
6.	Inserting a text box	83074	0:46
7.	Inserting WordArt	83075	0:38
8.	Selecting objects	83076	1:10
9.	Resizing a graphic object	83078	2:44
10.	Reshaping a graphic object	83079	0:33
11.	Rotating a graphic object	83080	1:02
12.	Moving a graphic object	83081	0:58
13.	Aligning graphic objects	83082	1:43
14.	Copying a graphic object	83083	1:24
15.	Deleting a graphic object	83084	0:17
16.	Grouping graphic objects	83085	1:05
17.	Stacking graphic objects	83086	1:27
18.	Formatting the fill of a graphic object	83087	1:53
19.	Formatting the outline of a graphic object	83088	1:19

H. Conditional Formatting

		Key #	Length
1.	Understanding conditional formatting	83089	1:27
2.	Applying Highlight Cells rules pt. 1	83090	2:15
3.	Applying Highlight Cells rules pt. 2	83091	2:09
4.	Applying Highlight Cells rules pt. 3	83115	1:24
5.	Applying Top/Bottom rules	83114	2:26
6.	Applying data bars	83092	1:33
7.	Applying color scales	83093	1:36
8.	Applying icon sets	83094	1:41
9.	Creating a Conditional Formatting rule	83097	1:59
10.	Managing Conditional Formatting rules	83095	3:13
11.	Clearing Conditional Formatting rules	83096	1:00

I. Functions

		Key #	Length
1.	Using COUNT functions	83098	2:57
2.	Using the IF function	83099	2:04
3.	Using the VLOOKUP function	83100	2:21
4.	Using the HLOOKUP function	83101	2:56
5.	Using Concatenate pt. 1	83116	2:31
6.	Using Concatenate pt. 2	83117	0:59
7.	Using Text to Columns	83118	2:00

Tutorial series by Beth Bruestle, narration by Flip Crummer

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