Skip to content Skip to navigation Skip to login

Excel 2011 - Advanced Training View a tutorial on this topic

Platform: Mac

Description

The Microsoft® Excel® 2011 Advanced online training series provides several ways to enhance the data in a workbook. You’ll learn how to create custom date, time and number formats; use data validation rules; create advanced sorting and filtering options; and use outlines. Also learn how to link and consolidate data within a single workbook or between multiple workbooks; use Goal Seek and Scenarios; protect your data; and share Excel data with Microsoft Word.
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.
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview Creating custom templates 89676 1:55
2. preview Creating a workbook from a template 89677 0:49
3. locked Modifying a template file 89678 1:02
4. locked Deleting a template 89679 0:46
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Entering dates into a cell 89680 0:43
2. locked Formatting date entries 89681 1:02
3. locked Displaying the current date 89682 1:05
4. locked Generating a series of dates 89683 0:53
5. locked Using date related functions 89684 2:56
6. locked Entering times into a cell 89685 0:31
7. locked Formatting time entries 89686 0:56
8. locked Displaying the current time 89687 1:16
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Formatting numbers automatically 89688 1:00
2. locked Understanding custom number formatting 89689 2:27
3. locked Creating a custom number format 89690 2:18
4. locked Creating custom date and time formats 89691 2:07
5. locked Hiding the contents of a cell using a custom format 89692 1:08
6. locked Deleting a custom format 89693 0:58
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Selecting elements in a chart 89694 1:01
2. locked Formatting chart elements 89695 0:38
3. locked Modifying the chart area 89696 1:09
4. locked Modifying the plot area 89697 1:29
5. locked Modifying the legend 89698 1:07
6. locked Modifying the value axis 89699 3:01
7. locked Modifying the category axis 89700 2:02
8. locked Deleting a data series from a chart 89701 1:07
9. locked Adding a data series to a chart pt. 1 89702 2:37
10. locked Adding a data series to a chart pt. 2 89703 1:13
11. locked Adding a trendline to a chart pt. 1 89704 1:26
12. locked Adding a trendline to a chart pt. 2 89705 2:42
13. locked Creating a combination chart 89706 1:30
14. locked Creating picture charts 89707 1:31
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Specifying data validation criteria 89708 2:49
2. locked Creating data validation rule messages 89709 3:28
3. locked Identifying invalid data within a data validation range 89710 1:05
4. locked Creating a data validation drop-down list 89711 2:10
5. locked Finding cells that contain data validation rules 89712 1:27
6. locked Clearing existing data validation rules 89713 1:49
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Sorting data in a worksheet 89714 1:21
2. locked Sorting by multiple columns or criteria 89715 3:17
3. locked Filtering data in a worksheet 89716 2:36
4. locked Clearing a filter in a worksheet 89717 1:08
5. locked Creating and/or statements 89718 1:29
6. locked Creating a criteria range 89719 0:43
7. locked Defining criteria using the criteria range 89720 1:43
8. locked Creating and/or statements using the criteria range 89721 1:53
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating an outline automatically 89722 2:17
2. locked Creating a manual outline 89723 0:34
3. locked Displaying levels in an outline 89724 1:30
4. locked Hiding the outline symbols 89725 0:40
5. locked Clearing an outline 89726 1:26
6. locked Adding subtotals to a worksheet pt. 1 89727 1:50
7. locked Adding subtotals to a worksheet pt. 2 89728 1:04
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a link formula within the same workbook 89729 1:19
2. locked Creating a link formula to another workbook 89730 1:39
3. locked Consolidating worksheets using formulas pt. 1 89731 2:10
4. locked Consolidating worksheets using formulas pt. 2 89732 1:16
5. locked Consolidating worksheets using formulas pt. 3 89733 1:38
6. locked Using the Consolidate command pt. 1 89734 2:26
7. locked Using the Consolidate command pt. 2 89735 2:39
8. locked Opening a workbook with external reference formulas 89736 2:03
9. locked Breaking links to external references 89737 1:08
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating scenarios pt. 1 89738 2:43
2. locked Creating scenarios pt. 2 89739 1:05
3. locked Displaying scenarios 89740 0:49
4. locked Modifying scenarios 89741 0:51
5. locked Generating a scenario report 89742 1:05
6. locked Deleting a scenario 89743 0:37
7. locked Using Goal Seek 89744 1:26
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Protecting a worksheet 89745 1:32
2. locked Unprotecting a worksheet 89746 0:33
3. locked Using a password to protect a worksheet 89747 0:59
4. locked Protecting a workbook pt. 1 89748 1:20
5. locked Protecting a workbook pt. 2 89749 1:10
6. locked Unprotecting a workbook 89750 0:42
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Displaying formulas 89751 0:33
2. locked Identifying precedent cells 89752 1:25
3. locked Identifying dependent cells 89753 0:41
4. locked Checking for errors 89754 2:00
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Copying and pasting static information 89755 1:03
2. locked Copying and pasting as a link 89756 1:02
3. locked Importing a text file into Excel 89757 2:43
Tutorial series by Beth Bruestle, narration by Flip Crummer
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.
©2012 Atomic Learning, Inc.   All rights reserved.