Excel 2010 - Intermediate View a tutorial on this topic

Platform: PC

Description

Learn how to use Microsoft® Office Excel® 2010. In this online tutorial series, you'll learn how to utilize worksheets, including creating, re-arranging and viewing multiple worksheets at the same time. You will also learn how to create and edit charts to maximize the impact of your data.
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.
Key # Length
1. preview Activating and moving between worksheets 83022 2:40
2. preview Selecting multiple worksheets 83023 2:28
3. locked Adding a worksheet to a workbook 83024 2:17
4. locked Deleting a worksheet from a workbook 83025 1:01
5. locked Changing the name of a worksheet 83026 1:50
6. locked Changing the sheet tab color 83027 0:53
7. locked Rearranging the worksheets pt. 1 83028 2:16
8. locked Rearranging the worksheets pt. 2 83029 2:26
9. locked Hiding and unhiding worksheets 83030 1:32
Key # Length
1. locked Zooming in and out of a worksheet 83031 1:17
2. locked Viewing a worksheet in multiple windows 83032 1:43
3. locked Viewing workbooks side-by-side 83033 1:02
4. locked Splitting the worksheet window 83034 2:24
5. locked Freezing and unfreezing panes 83035 2:32
6. locked Monitoring cells with the Watch Window 83036 2:07
7. locked Viewing using full screen 83037 0:33
8. locked Creating custom views 83038 2:25
Key # Length
1. locked Creating range names 83039 2:43
2. locked Moving to a named range 83040 0:55
3. locked Using range names in formulas 83041 1:02
4. locked Managing named ranges pt. 1 83042 2:03
5. locked Managing named ranges pt. 2 83043 1:35
6. locked Creating a 3D range name 83044 1:57
Key # Length
1. locked Adding a comment to a cell 83045 1:08
2. locked Reading comments 83046 0:36
3. locked Showing and hiding comments 83047 1:12
4. locked Editing comments 83048 0:48
5. locked Formatting comments 83049 2:26
6. locked Changing a comment shape 83050 0:41
7. locked Printing comments 83051 1:55
8. locked Deleting a comment 83052 0:27
Key # Length
1. locked Creating a chart 83053 1:08
2. locked Changing the chart layout 83054 1:32
3. locked Changing the data orientation in a chart 83055 0:42
4. locked Changing the chart type 83056 1:00
5. locked Understanding chart types pt. 1 83057 1:53
6. locked Understanding chart types pt. 2 83058 2:02
7. locked Creating an embedded chart or a chart sheet 83059 1:28
8. locked Moving and resizing an embedded chart 83060 1:17
9. locked Adding a chart title 83061 0:51
10. locked Adding axis titles 83062 1:46
11. locked Changing the location of the chart legend 83063 0:43
12. locked Adding data labels 83064 1:00
13. locked Adding a data table to a chart 83065 0:53
14. locked Changing the chart axis 83066 1:03
15. locked Changing the gridlines 83067 1:35
16. locked Formatting chart elements 83102 1:54
17. locked Moving, resizing, and deleting chart elements 83068 0:59
18. locked Deleting a chart 83069 0:43
19. locked Printing a chart 83070 1:26
Key # Length
1. locked Introducing Sparklines 83103 1:15
2. locked Creating Sparklines 83104 1:21
3. locked Grouping and ungrouping Sparklines 83112 2:04
4. locked Editing the Sparkline data 83106 2:05
5. locked Changing the Sparkline type 83105 0:53
6. locked Showing Sparkline data points 83107 1:43
7. locked Formatting the Sparkline 83108 2:25
8. locked Changing Axis settings 83109 2:56
9. locked Changing Hidden and Empty Cell settings 83110 1:20
10. locked Clearing Sparklines 83111 0:40
Key # Length
1. locked Inserting a shape 83071 1:08
2. locked Inserting a picture 83077 0:45
3. locked Inserting clip art 83072 1:27
4. locked Inserting a SmartArt® graphic 83073 1:45
5. locked Using screenshots 83113 1:46
6. locked Inserting a text box 83074 0:46
7. locked Inserting WordArt 83075 0:38
8. locked Selecting objects 83076 1:10
9. locked Resizing a graphic object 83078 2:44
10. locked Reshaping a graphic object 83079 0:33
11. locked Rotating a graphic object 83080 1:02
12. locked Moving a graphic object 83081 0:58
13. locked Aligning graphic objects 83082 1:43
14. locked Copying a graphic object 83083 1:24
15. locked Deleting a graphic object 83084 0:17
16. locked Grouping graphic objects 83085 1:05
17. locked Stacking graphic objects 83086 1:27
18. locked Formatting the fill of a graphic object 83087 1:53
19. locked Formatting the outline of a graphic object 83088 1:19
Key # Length
1. locked Understanding conditional formatting 83089 1:27
2. locked Applying Highlight Cells rules pt. 1 83090 2:15
3. locked Applying Highlight Cells rules pt. 2 83091 2:09
4. locked Applying Highlight Cells rules pt. 3 83115 1:24
5. locked Applying Top/Bottom rules 83114 2:26
6. locked Applying data bars 83092 1:33
7. locked Applying color scales 83093 1:36
8. locked Applying icon sets 83094 1:41
9. locked Creating a Conditional Formatting rule 83097 1:59
10. locked Managing Conditional Formatting rules 83095 3:13
11. locked Clearing Conditional Formatting rules 83096 1:00
Key # Length
1. locked Using COUNT functions 83098 2:57
2. locked Using the IF function 83099 2:04
3. locked Using the VLOOKUP function 83100 2:21
4. locked Using the HLOOKUP function 83101 2:56
5. locked Using Concatenate pt. 1 83116 2:31
6. locked Using Concatenate pt. 2 83117 0:59
7. locked Using Text to Columns 83118 2:00
Key # Length
1. locked Section A - Working with Worksheets 91961 0:00
2. locked Section B - Controlling the Worksheet 91962 0:00
3. locked Section C - Using Names to Work with Ranges 91963 0:00
4. locked Section D - Understanding Cell Comments 91964 0:00
5. locked Section E - Working with Charts 91965 0:00
6. locked Section F - Working with Sparklines 91966 0:00
7. locked Section G - Working with Graphics 91967 0:00
8. locked Section H - Conditional Formatting 91968 0:00
9. locked Section I - Functions 91969 0:00
Tutorial series by Beth Bruestle, narration by Flip Crummer
Box shot reprinted by permission from Microsoft Corporation. Microsoft, Excel and SmartArt are registered trademarks of Microsoft Corporation in the United States and/or other countries.