Generate Direct Linking HTML

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

Excel 2007 - 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 3-D 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 Graphics
- - Inserting a shape
  - Inserting a picture
  - Inserting clip art
  - Inserting a SmartArt graphic
  - 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
- G. Conditional Formatting
- - Understanding conditional formatting
  - Applying highlight cells rules pt. 1
  - Applying highlight cells rules pt. 2
  - Applying data bars
  - Applying color scales
  - Applying icon sets
  - Creating a Conditional Formatting Rule
  - Managing Conditional Formatting Rules
  - Clearing Conditional Formatting Rules
- H. 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 2007 - Intermediate

Platform: PC

Microsoft^® Office Excel 2007 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	30871	2:53
2.	Selecting multiple worksheets	30872	2:31
3.	Adding a worksheet to a workbook	30873	2:26
4.	Deleting a worksheet from a workbook	30874	1:04
5.	Changing the name of a worksheet	30875	1:54
6.	Changing the sheet tab color	30876	0:59
7.	Rearranging the worksheets pt. 1	30877	2:16
8.	Rearranging the worksheets pt. 2	30878	2:42
9.	Hiding and unhiding worksheets	30879	1:36

B. Controlling the Worksheet View

		Key #	Length
1.	Zooming in and out of a worksheet	30880	1:05
2.	Viewing a worksheet in multiple windows	30881	1:30
3.	Viewing workbooks side by side	30882	1:02
4.	Splitting the worksheet window	30883	2:27
5.	Freezing and unfreezing panes	30884	2:33
6.	Monitoring cells with the Watch window	30885	2:22
7.	Viewing using full screen	30886	0:34
8.	Creating custom views	30887	2:33

C. Using Names to Work with Ranges

		Key #	Length
1.	Creating range names	30888	2:48
2.	Moving to a named range	30889	0:57
3.	Using range names in formulas	30890	1:03
4.	Managing named ranges pt. 1	30891	2:15
5.	Managing named ranges pt. 2	30892	1:42
6.	Creating a 3-D range name	30893	2:06

D. Understanding Cell Comments

		Key #	Length
1.	Adding a comment to a cell	30894	1:14
2.	Reading comments	30895	0:39
3.	Showing and hiding comments	30896	1:16
4.	Editing comments	30897	0:51
5.	Formatting comments	30898	2:29
6.	Changing a comment shape	30899	0:44
7.	Printing comments	30900	1:55
8.	Deleting a comment	30901	0:29

E. Working with Charts

		Key #	Length
1.	Creating a chart	30902	1:13
2.	Changing the chart layout	30903	1:45
3.	Changing the data orientation in a chart	30904	0:44
4.	Changing the chart type	30905	1:05
5.	Understanding chart types pt. 1	30906	1:57
6.	Understanding chart types pt. 2	30907	2:12
7.	Creating an embedded chart or a chart sheet	30908	1:36
8.	Moving and resizing an embedded chart	30909	1:24
9.	Adding a chart title	30910	0:58
10.	Adding axis titles	30911	2:09
11.	Changing the location of the chart legend	30912	0:49
12.	Adding data labels	30913	1:07
13.	Adding a data table to a chart	30914	1:02
14.	Changing the chart axis	30915	1:05
15.	Changing the gridlines	30916	1:45
16.	Formatting chart elements	30917	1:59
17.	Moving, resizing, and deleting chart elements	30918	1:02
18.	Deleting a chart	30919	0:45
19.	Printing a chart	30920	1:26

F. Working with Graphics

		Key #	Length
1.	Inserting a shape	30921	1:12
2.	Inserting a picture	30922	0:47
3.	Inserting clip art	30923	1:44
4.	Inserting a SmartArt graphic	30924	1:44
5.	Inserting a text box	30925	0:49
6.	Inserting WordArt	30926	0:36
7.	Selecting objects	30927	1:14
8.	Resizing a graphic object	30928	2:43
9.	Reshaping a graphic object	30929	0:35
10.	Rotating a graphic object	30930	1:04
11.	Moving a graphic object	30931	1:01
12.	Aligning graphic objects	30932	1:53
13.	Copying a graphic object	30933	1:30
14.	Deleting a graphic object	30934	0:17
15.	Grouping graphic objects	30935	1:04
16.	Stacking graphic objects	30936	1:17
17.	Formatting the fill of a graphic object	30937	1:53
18.	Formatting the outline of a graphic object	30938	1:35

G. Conditional Formatting

		Key #	Length
1.	Understanding conditional formatting	30939	1:13
2.	Applying highlight cells rules pt. 1	30940	2:25
3.	Applying highlight cells rules pt. 2	30941	3:32
4.	Applying data bars	30942	1:33
5.	Applying color scales	30943	1:45
6.	Applying icon sets	30944	1:33
7.	Creating a Conditional Formatting Rule	30945	2:19
8.	Managing Conditional Formatting Rules	30946	3:07
9.	Clearing Conditional Formatting Rules	30947	1:06

H. Functions

		Key #	Length
1.	Using COUNT functions	30948	3:12
2.	Using the IF function	30949	2:20
3.	Using the VLOOKUP function	30950	2:32
4.	Using the HLOOKUP function	30951	3:14
5.	Using Concatenate pt. 1	72727	2:49
6.	Using Concatenate pt. 2	72728	1:12
7.	Using Text to Columns	72729	2:12

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.