Excel 2010 - Advanced Training View a tutorial on this topic

Platform: PC

Description

Become even more productive in Microsoft® Excel® with this advanced-level online tutorial series. Learn how to create templates, charts and outlines; sort and filter data; protect your workbook; 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 Viewing templates 87423 3:29
2. preview Creating a workbook from a template 87424 0:53
3. locked Creating custom templates 87425 2:08
4. locked Modifying a template file 87426 0:59
5. locked Deleting a template 87427 1:20
Key # Length
1. locked Entering dates into a cell 87428 0:58
2. locked Formatting date entries 87429 0:44
3. locked Displaying the current date 87430 1:06
4. locked Generating a series of dates 87431 0:49
5. locked Using date related functions pt. 1 87432 2:56
6. locked Using date related functions pt. 2 87433 0:44
7. locked Entering times into a cell 87434 0:40
8. locked Formatting time entries 87435 0:50
9. locked Displaying the current time 87436 1:09
Key # Length
1. locked Formatting numbers automatically 87437 0:58
2. locked Understanding custom number formatting 87438 2:30
3. locked Creating a custom number format 87439 2:12
4. locked Creating custom date and time formats 87440 2:01
5. locked Hiding the contents of a cell using a custom format 87441 1:01
6. locked Deleting a custom format 87442 0:48
Key # Length
1. locked Selecting elements in a chart 87444 0:52
2. locked Formatting chart elements 87445 1:10
3. locked Modifying the chart area 87443 1:03
4. locked Modifying the plot area 87446 1:25
5. locked Adding text to a chart 87447 0:54
6. locked Modifying the legend 87448 0:56
7. locked Creating a chart template 87449 2:43
8. locked Modifying the value axis 87450 2:37
9. locked Modifying the category axis 87451 1:42
10. locked Deleting a data series from a chart 87452 1:05
11. locked Adding a data series to a chart 87453 2:54
12. locked Adding a trendline to a chart 87454 1:17
13. locked Creating a combination chart 87455 1:30
14. locked Creating picture charts 87456 1:37
Key # Length
1. locked Specifying data validation criteria 87457 2:46
2. locked Creating data validation rule messages 87458 3:19
3. locked Identifying invalid data within a data validation range 87459 1:03
4. locked Creating a data validation drop-down list 87460 2:06
5. locked Finding cells that contain data validation rules 87461 1:15
6. locked Clearing existing data validation rules 87462 1:45
Key # Length
1. locked Sorting data in a worksheet 87484 1:02
2. locked Sorting by multiple columns or criteria 87487 2:43
3. locked Filtering data in a worksheet using AutoFilter 87488 2:30
4. locked Clearing a filter in a worksheet 87489 0:45
5. locked Creating and/or statements using AutoFilter 87490 1:45
6. locked Creating a criteria range 87491 0:41
7. locked Defining criteria using the criteria range 87492 1:29
8. locked Creating and/or statements using the criteria range 87493 1:48
Key # Length
1. locked Creating an outline automatically 87463 2:16
2. locked Creating a manual outline 87464 0:35
3. locked Displaying levels in an outline 87465 1:36
4. locked Hiding the outline symbols 87466 0:41
5. locked Clearing an outline 87467 1:27
6. locked Adding subtotals to a worksheet pt. 1 87485 1:53
7. locked Adding subtotals to a worksheet pt. 2 87486 0:53
Key # Length
1. locked Creating a link formula within the same workbook 87468 1:19
2. locked Creating a link formula to another workbook 87473 1:38
3. locked Consolidating worksheets using formulas pt. 1 87469 2:04
4. locked Consolidating worksheets using formulas pt. 2 87472 1:17
5. locked Consolidating worksheets using formulas pt. 3 87474 1:39
6. locked Using the Consolidate command pt. 1 87475 2:22
7. locked Using the Consolidate command pt. 2 87476 2:34
8. locked Opening a workbook with external reference formulas 87470 1:26
9. locked Breaking links to external references 87471 1:03
Key # Length
1. locked Creating scenarios pt. 1 87477 2:42
2. locked Creating scenarios pt. 2 87478 1:04
3. locked Displaying scenarios 87479 0:51
4. locked Modifying scenarios 87480 0:53
5. locked Generating a scenario report 87481 1:03
6. locked Deleting a scenario 87482 0:37
7. locked Using goal seek 87483 1:28
Key # Length
1. locked Protecting a worksheet 87496 1:18
2. locked Unprotecting a worksheet 87494 0:26
3. locked Using a password to protect a worksheet 87495 0:56
4. locked Protecting a workbook pt. 1 87497 2:17
5. locked Protecting a workbook pt. 2 87498 1:12
6. locked Unprotecting a workbook 87499 0:41
Key # Length
1. locked Displaying formulas 87501 0:31
2. locked Identifying precedent cells 87500 1:27
3. locked Identifying dependent cells 87502 0:40
4. locked Checking for errors 87503 2:23
5. locked Evaluating a formula 87504 2:25
Key # Length
1. locked Recording a macro 87505 2:32
2. locked Running a macro 87506 1:00
3. locked Editing a macro 87507 1:56
Key # Length
1. locked Copying and pasting static information 87508 1:05
2. locked Copying and pasting as a link 87509 1:03
3. locked Importing a text file into Excel 87510 2:57
Tutorial series by Beth Bruestle, narration by Flip Crummer
Box shot reprinted by permission from Microsoft Corporation. Microsoft is a registered trademark in the United States and/or other countries.