Excel 2011 - Intermediate Training View a tutorial on this topic

Platform: Mac

Description

Enhance your productivity by working your way through this intermediate-level online tutorial series for Microsoft® Excel 2011. Learn how to work with charts and graphics, use conditional formatting, use names to work with ranges, and much more!
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 Adding a worksheet to a workbook 87771 2:35
2. preview Activating and navigating between worksheets 87772 1:52
3. locked Selecting multiple worksheets 87773 1:40
4. locked Deleting a worksheet from a workbook 87774 1:18
5. locked Changing the name of a worksheet 87775 1:41
6. locked Changing the sheet tab color 87776 0:58
7. locked Rearranging the worksheets pt. 1 87777 1:29
8. locked Rearranging the worksheets pt. 2 87778 1:41
9. locked Hiding and unhiding worksheets 87779 1:15
Key # Length
1. locked Zooming in and out of a worksheet 87780 1:22
2. locked Viewing a worksheet in multiple windows 87781 1:27
3. locked Splitting the worksheet window 87782 1:47
4. locked Freezing and unfreezing panes 87783 1:56
5. locked Viewing using Full Screen 87784 0:41
6. locked Creating custom views 87785 2:40
Key # Length
1. locked Creating range names pt. 1 87786 1:50
2. locked Creating range names pt. 2 87787 1:35
3. locked Moving to a named range 87788 1:05
4. locked Using range names in formulas 87789 1:18
5. locked Creating a 3-D range name 87790 3:02
6. locked Editing a named range 87791 1:35
7. locked Deleting a named range 87792 0:41
Key # Length
1. locked Adding a comment to a cell 87793 1:21
2. locked Reading comments 87794 0:59
3. locked Showing and hiding comments 87795 1:15
4. locked Editing comments 87796 0:43
5. locked Formatting comments 87797 1:21
6. locked Printing comments 87798 1:25
7. locked Deleting a comment 87799 0:29
Key # Length
1. locked Creating a chart 87800 1:13
2. locked Using Quick Layouts 87801 0:47
3. locked Changing the data orientation in a chart 87802 0:40
4. locked Changing the chart type 87803 0:37
5. locked Understanding chart types pt. 1 87804 1:45
6. locked Understanding chart types pt. 2 87805 1:18
7. locked Creating an embedded chart or a chart sheet 87806 1:21
8. locked Moving and resizing an embedded chart 87807 1:19
9. locked Adding a chart title 87808 0:54
10. locked Adding axis titles 87809 0:57
11. locked Changing the location of the chart legend 87810 0:39
12. locked Adding data labels 87811 0:36
13. locked Adding a data table to a chart 87812 0:42
14. locked Changing the chart axis 87813 1:15
15. locked Changing the gridlines 87814 1:33
16. locked Formatting chart elements 87815 1:10
17. locked Moving, resizing, and deleting chart elements 87816 1:12
18. locked Deleting a chart 87817 0:37
19. locked Printing a chart 87818 1:06
Key # Length
1. locked Introducing Sparklines 87819 1:11
2. locked Creating Sparklines 87820 1:47
3. locked Grouping and ungrouping Sparklines 87821 1:16
4. locked Editing the Sparkline data 87822 1:21
5. locked Changing the Sparkline type 87823 0:49
6. locked Showing Sparkline data points 87824 1:13
7. locked Formatting the Sparkline 87825 0:57
8. locked Changing Axis settings 87826 1:30
9. locked Changing Hidden and Empty Cell settings 87827 1:19
10. locked Clearing Sparklines 87828 0:54
Key # Length
1. locked Inserting a shape 87829 0:51
2. locked Inserting a photo 87830 1:28
3. locked Inserting clip art 87831 0:37
4. locked Inserting a SmartArt® graphic 87832 1:10
5. locked Inserting a text box 87833 0:38
6. locked Inserting WordArt 87834 0:56
7. locked Selecting objects 87835 0:27
8. locked Resizing a graphic object 87836 1:48
9. locked Reshaping a graphic object 87837 0:30
10. locked Rotating a graphic object 87838 0:57
11. locked Moving a graphic object 87839 0:30
12. locked Aligning graphic objects 87840 0:45
13. locked Copying a graphic object 87841 1:09
14. locked Deleting a graphic object 87842 0:24
15. locked Grouping graphic objects 87843 0:58
16. locked Stacking graphic objects 87844 0:52
17. locked Formatting the fill of a graphic object 87845 1:12
18. locked Formatting the outline of a graphic object 87846 1:05
Key # Length
1. locked Understanding conditional formatting 87847 0:49
2. locked Applying highlight cells rules pt. 1 87848 1:33
3. locked Applying highlight cells rules pt. 2 87849 1:45
4. locked Applying highlight cells rules pt. 3 87850 1:25
5. locked Applying top/bottom rules 87851 0:50
6. locked Applying data bars 87852 0:44
7. locked Applying color scales 87853 0:56
8. locked Applying icon sets 87854 1:01
9. locked Managing conditional formatting rules 87855 1:42
10. locked Clearing conditional formatting rules 87856 0:48
Key # Length
1. locked Using COUNT functions 87857 2:11
2. locked Using the IF function 87858 1:26
3. locked Using the VLOOKUP function 87859 1:28
4. locked Using the HLOOKUP function 87860 1:27
5. locked Using Concatenate 87861 1:39
6. locked Using Text to Columns pt. 1 87862 1:48
7. locked Using Text to Columns pt. 2 87863 1:10
Tutorial series by Adam Best
Box shot reprinted by permission from Microsoft Corporation. Microsoft, Excel and SmartArt are registered trademarks in the United States and/or other countries.