Skip to content Skip to navigation Skip to login

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