Excel 2011 - Intermediate Training
Platform: Mac
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!
Try out the unlocked free sample tutorials below, or learn more about subscription options.
Tutorial Number | Availability Status | Tutorial Title | Key # | Length | ||
---|---|---|---|---|---|---|
1. | ![]() |
Adding a worksheet to a workbook
: opens dialog
|
87773 | 01m:40s | ||
2. | ![]() |
Deleting a worksheet from a workbook
: opens dialog
|
87774 | 01m:18s | ||
3. | Activating and navigating between worksheets : opens video player dialog | 87771 | 02m:35s | |||
|
||||||
4. | Selecting multiple worksheets : opens video player dialog | 87772 | 01m:52s | |||
|
||||||
5. | ![]() |
Changing the name of a worksheet
: opens dialog
|
87775 | 01m:41s | ||
6. | ![]() |
Changing the sheet tab color
: opens dialog
|
87776 | 00m:58s | ||
7. | ![]() |
Rearranging the worksheets pt. 1
: opens dialog
|
87777 | 01m:29s | ||
8. | ![]() |
Rearranging the worksheets pt. 2
: opens dialog
|
87778 | 01m:41s | ||
9. | ![]() |
Hiding and unhiding worksheets
: opens dialog
|
87779 | 01m:15s | ||
This section does not have any training resources. |
Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
---|---|---|---|---|---|
1. | ![]() |
Zooming in and out of a worksheet
: opens dialog
|
87780 | 01m:22s | |
2. | ![]() |
Viewing a worksheet in multiple windows
: opens dialog
|
87781 | 01m:27s | |
3. | ![]() |
Splitting the worksheet window
: opens dialog
|
87782 | 01m:47s | |
4. | ![]() |
Freezing and unfreezing panes
: opens dialog
|
87783 | 01m:56s | |
5. | ![]() |
Viewing using Full Screen
: opens dialog
|
87784 | 00m:41s | |
6. | ![]() |
Creating custom views
: opens dialog
|
87785 | 02m:40s | |
This section does not have any training resources. |
Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
---|---|---|---|---|---|
1. | ![]() |
Creating range names pt. 1
: opens dialog
|
87786 | 01m:50s | |
2. | ![]() |
Creating range names pt. 2
: opens dialog
|
87787 | 01m:35s | |
3. | ![]() |
Moving to a named range
: opens dialog
|
87788 | 01m:05s | |
4. | ![]() |
Using range names in formulas
: opens dialog
|
87789 | 01m:18s | |
5. | ![]() |
Creating a 3-D range name
: opens dialog
|
87790 | 03m:02s | |
6. | ![]() |
Editing a named range
: opens dialog
|
87791 | 01m:35s | |
7. | ![]() |
Deleting a named range
: opens dialog
|
87792 | 00m:41s | |
This section does not have any training resources. |
Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
---|---|---|---|---|---|
1. | ![]() |
Adding a comment to a cell
: opens dialog
|
87793 | 01m:21s | |
2. | ![]() |
Reading comments
: opens dialog
|
87794 | 00m:59s | |
3. | ![]() |
Showing and hiding comments
: opens dialog
|
87795 | 01m:15s | |
4. | ![]() |
Editing comments
: opens dialog
|
87796 | 00m:43s | |
5. | ![]() |
Formatting comments
: opens dialog
|
87797 | 01m:21s | |
6. | ![]() |
Printing comments
: opens dialog
|
87798 | 01m:25s | |
7. | ![]() |
Deleting a comment
: opens dialog
|
87799 | 00m:29s | |
This section does not have any training resources. |
Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
---|---|---|---|---|---|
1. | ![]() |
Introducing Sparklines
: opens dialog
|
87819 | 01m:11s | |
2. | ![]() |
Creating Sparklines
: opens dialog
|
87820 | 01m:47s | |
3. | ![]() |
Grouping and ungrouping Sparklines
: opens dialog
|
87821 | 01m:16s | |
4. | ![]() |
Editing the Sparkline data
: opens dialog
|
87822 | 01m:21s | |
5. | ![]() |
Changing the Sparkline type
: opens dialog
|
87823 | 00m:49s | |
6. | ![]() |
Showing Sparkline data points
: opens dialog
|
87824 | 01m:13s | |
7. | ![]() |
Formatting the Sparkline
: opens dialog
|
87825 | 00m:57s | |
8. | ![]() |
Changing Axis settings
: opens dialog
|
87826 | 01m:30s | |
9. | ![]() |
Changing Hidden and Empty Cell settings
: opens dialog
|
87827 | 01m:19s | |
10. | ![]() |
Clearing Sparklines
: opens dialog
|
87828 | 00m:54s | |
This section does not have any training resources. |
Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
---|---|---|---|---|---|
1. | ![]() |
Understanding conditional formatting
: opens dialog
|
87847 | 02m:13s | |
2. | ![]() |
Applying highlight cells rules pt. 1
: opens dialog
|
87848 | 01m:33s | |
3. | ![]() |
Applying highlight cells rules pt. 2
: opens dialog
|
87849 | 01m:45s | |
4. | ![]() |
Applying highlight cells rules pt. 3
: opens dialog
|
87850 | 01m:25s | |
5. | ![]() |
Applying top/bottom rules
: opens dialog
|
87851 | 00m:50s | |
6. | ![]() |
Applying data bars
: opens dialog
|
87852 | 00m:44s | |
7. | ![]() |
Applying color scales
: opens dialog
|
87853 | 00m:56s | |
8. | ![]() |
Applying icon sets
: opens dialog
|
87854 | 01m:01s | |
9. | ![]() |
Managing conditional formatting rules
: opens dialog
|
87855 | 01m:42s | |
10. | ![]() |
Clearing conditional formatting rules
: opens dialog
|
87856 | 00m:48s | |
This section does not have any training resources. |
Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
---|---|---|---|---|---|
1. | ![]() |
Using COUNT functions
: opens dialog
|
87857 | 02m:11s | |
2. | ![]() |
Using the IF function
: opens dialog
|
87858 | 01m:26s | |
3. | ![]() |
Using the VLOOKUP function
: opens dialog
|
87859 | 01m:28s | |
4. | ![]() |
Using the HLOOKUP function
: opens dialog
|
87860 | 01m:27s | |
5. | ![]() |
Using Concatenate
: opens dialog
|
87861 | 01m:39s | |
6. | ![]() |
Using Text to Columns pt. 1
: opens dialog
|
87862 | 01m:48s | |
7. | ![]() |
Using Text to Columns pt. 2
: opens dialog
|
87863 | 01m:10s | |
This section does not have any training resources. |