Skip to content Skip to navigation Skip to login

Excel 2008 - Advanced Training View a tutorial on this topic

Platform: Mac

Description

Microsoft® Office Excel 2008 is a spreadsheet application that features calculation, graphing tools, pivot tables, and more. Learn about the more advanced features of this very popular and versatile office tool.
Click any of the highlighted titles to view free sample tutorial movies. Atomic Learning subscribers to this collection have access to all of the following movies, plus thousands of tutorials on other applications.
Click here to learn about subscribing to this collection!
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview Creating custom templates 72553 2:16
2. preview Creating a workbook from a template 72552 0:45
3. locked Modifying a template file 72554 1:21
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Entering dates into a cell 72555 1:05
2. locked Formatting date entries 72556 0:46
3. locked Displaying the current date 72557 1:08
4. locked Generating a series of dates 72558 1:00
5. locked Using date related functions 72559 3:22
6. locked Entering times into a cell 72560 0:35
7. locked Formatting time entries 72561 0:43
8. locked Displaying the current time 72562 1:16
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Formatting numbers automatically 72563 1:07
2. locked Understanding custom number formatting 72564 2:59
3. locked Creating a custom number format 72565 2:28
4. locked Creating custom date and time formats 72566 2:22
5. locked Hiding the contents of a cell using a custom format 72567 1:05
6. locked Deleting a custom format 72568 0:52
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Selecting elements in a chart 72570 0:58
2. locked Formatting chart elements 72571 0:50
3. locked Modifying the chart area 72569 1:10
4. locked Modifying the plot area 72572 1:39
5. locked Adding text to a chart 72573 1:16
6. locked Modifying the legend 72574 1:03
7. locked Modifying the value axis 72575 2:49
8. locked Modifying the category axis 72576 1:55
9. locked Deleting a data series from a chart 72577 1:33
10. locked Adding a data series to a chart pt. 1 72578 2:52
11. locked Adding a data series to a chart pt. 2 72630 1:22
12. locked Adding a trend line to a chart 72579 3:29
13. locked Creating a combination chart 72580 1:57
14. locked Creating picture charts 72581 1:51
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Specifying data validation criteria 72582 2:56
2. locked Creating Data Validation Rule messages pt. 1 72583 1:20
3. locked Creating Data Validation Rule messages pt. 2 72631 2:15
4. locked Creating a data validation drop-down list 72584 2:33
5. locked Finding cells that contain Data Validation Rules 72585 1:45
6. locked Clearing existing Data Validation Rules 72586 2:01
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Sorting data in a worksheet 72608 1:08
2. locked Sorting by multiple columns or criteria 72611 2:23
3. locked Filtering data in a worksheet using AutoFilter pt. 1 72612 1:58
4. locked Filtering data in a worksheet using AutoFilter pt. 2 72632 1:13
5. locked Clearing a filter in a worksheet 72613 0:58
6. locked Creating and/or statements using AutoFilter 72614 2:06
7. locked Creating a criteria range 72615 0:50
8. locked Defining criteria using the criteria range 72616 1:43
9. locked Creating and/or statements using the criteria range pt. 1 72617 1:23
10. locked Creating and/or statements using the criteria range pt. 2 72633 1:13
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating an outline automatically 72587 2:11
2. locked Creating a manual outline 72588 0:47
3. locked Displaying levels in an outline 72589 1:46
4. locked Hiding the outline symbols 72590 0:45
5. locked Clearing an outline 72591 1:33
6. locked Adding subtotals to a worksheet pt. 1 72609 2:04
7. locked Adding subtotals to a worksheet pt. 2 72610 1:05
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a Link formula within the same workbook 72592 1:29
2. locked Creating a Link formula to another workbook 72597 1:52
3. locked Consolidating worksheets using formulas pt. 1 72593 2:22
4. locked Consolidating worksheets using formulas pt. 2 72596 1:15
5. locked Consolidating worksheets using formulas pt. 3 72598 1:52
6. locked Using the Consolidate command pt. 1 72599 2:36
7. locked Using the Consolidate command pt. 2 72600 3:17
8. locked Opening a workbook with External Reference formulas 72594 2:21
9. locked Breaking links to external references 72595 1:13
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating scenarios pt. 1 72601 2:53
2. locked Creating scenarios pt. 2 72602 1:08
3. locked Displaying scenarios 72603 0:48
4. locked Modifying scenarios 72604 0:58
5. locked Generating a Scenario report 72605 1:03
6. locked Deleting a scenario 72606 0:35
7. locked Using Goal Seek 72607 1:32
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Protecting a worksheet 72620 1:17
2. locked Unprotecting a worksheet 72618 0:29
3. locked Using a password to protect a worksheet 72619 1:17
4. locked Protecting a workbook pt. 1 72621 2:11
5. locked Protecting a workbook pt. 2 72622 1:02
6. locked Protecting a workbook pt. 3 72634 1:23
7. locked Unprotecting a workbook 72623 0:45
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Displaying formulas 72625 0:49
2. locked Identifying precedent cells 72624 1:44
3. locked Identifying dependent cells 72626 0:55
4. locked Checking for errors pt. 1 72627 2:15
5. locked Checking for errors pt. 2 72635 2:26
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Copying and pasting static information 72628 1:11
2. locked Copying and pasting as a link 72636 1:06
3. locked Importing a text file into Excel 72629 2:54
Tutorial series by Beth Bruestle
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.