Excel 2007 - Advanced View a tutorial on this topic

Platform: PC

Description

Microsoft® Office Excel 2007 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 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 34262 3:01
2. preview Creating a workbook from a template 34263 1:19
3. locked Creating custom templates 34264 2:25
4. locked Modifying a template file 34265 1:04
5. locked Deleting a template 34266 1:41
Key # Length
1. locked Entering dates into a cell 34267 0:59
2. locked Formatting date entries 34268 0:46
3. locked Displaying the current date 34269 1:00
4. locked Generating a series of dates 34270 0:51
5. locked Using date related functions pt. 1 34271 3:06
6. locked Using date related functions pt. 2 34272 0:45
7. locked Entering times into a cell 34273 0:46
8. locked Formatting time entries 34274 0:54
9. locked Displaying the current time 34275 1:17
Key # Length
1. locked Formatting numbers automatically 34276 1:01
2. locked Understanding Custom Number formatting 34277 2:39
3. locked Creating a Custom Number format 34278 2:17
4. locked Creating custom date and time formats 34279 2:10
5. locked Hiding the contents of a cell using a Custom Format 34280 1:06
6. locked Deleting a Custom Format 34281 0:53
Key # Length
1. locked Selecting elements in a chart 34282 0:58
2. locked Formatting chart elements 34283 1:13
3. locked Modifying the chart area 34284 1:02
4. locked Modifying the plot area 34285 1:24
5. locked Adding text to a chart 34286 1:00
6. locked Modifying the legend 34287 0:59
7. locked Creating a chart template 34288 2:54
8. locked Modifying the Value axis 34289 2:28
9. locked Modifying the Category axis 34290 1:53
10. locked Deleting a data series from a chart 34291 1:05
11. locked Adding a data series to a chart 34292 3:04
12. locked Adding a trend line to a chart 34293 1:21
13. locked Creating a Combination chart 34294 1:35
14. locked Creating Picture charts 34295 1:41
Key # Length
1. locked Specifying Data Validation criteria 34296 3:03
2. locked Creating Data Validation Rule messages 34297 3:27
3. locked Identifying invalid data within a Data Validation range 34298 1:08
4. locked Creating a Data Validation drop down list 34299 2:18
5. locked Finding cells that contain Data Validation rules 34300 1:18
6. locked Clearing existing Data Validation rules 34301 1:56
Key # Length
1. locked Sorting data in a worksheet 34302 1:04
2. locked Sorting by multiple columns or criteria 34303 2:55
3. locked Filtering data in a worksheet using AutoFilter 34304 2:41
4. locked Clearing a filter in a worksheet 34305 0:48
5. locked Creating and/or statements using AutoFilter 34306 1:53
6. locked Creating a Criteria range 34307 0:45
7. locked Defining criteria using the Criteria range 34308 1:36
8. locked Creating And/Or statements using the Criteria range 34309 1:44
Key # Length
1. locked Creating an outline automatically 34310 2:27
2. locked Creating a Manual outline 34311 0:36
3. locked Displaying levels in an outline 34312 1:38
4. locked Hiding the outline symbols 34313 0:41
5. locked Clearing an outline 34314 1:32
6. locked Adding subtotals to a worksheet pt. 1 34315 1:54
7. locked Adding subtotals to a worksheet pt. 2 34316 0:55
Key # Length
1. locked Creating a link formula within the same workbook 34317 1:22
2. locked Creating a link formula to another workbook 34318 1:41
3. locked Consolidating worksheets using formulas pt. 1 34319 2:11
4. locked Consolidating worksheets using formulas pt. 2 34320 1:12
5. locked Consolidating worksheets using formulas pt. 3 34321 1:47
6. locked Using the Consolidate command pt. 1 34322 2:18
7. locked Using the Consolidate command pt. 2 34323 2:39
8. locked Opening a workbook with External Reference formulas 34324 1:23
9. locked Breaking links to External References 34325 1:02
Key # Length
1. locked Creating scenarios pt. 1 34326 2:43
2. locked Creating scenarios pt. 2 34327 1:04
3. locked Displaying scenarios 34328 0:50
4. locked Modifying scenarios 34329 0:54
5. locked Generating a Scenario report 34330 1:01
6. locked Deleting a scenario 34331 0:34
7. locked Using Goal Seek 34332 1:29
Key # Length
1. locked Protecting a worksheet 34333 1:21
2. locked Unprotecting a worksheet 34334 0:26
3. locked Using a password to protect a worksheet 34335 0:57
4. locked Protecting a workbook pt. 1 34858 2:03
5. locked Protecting a workbook pt. 2 34859 1:13
6. locked Unprotecting a workbook 34860 0:49
Key # Length
1. locked Displaying formulas 34861 0:32
2. locked Identifying precedent cells 34862 1:32
3. locked Identifying dependent cells 34863 0:45
4. locked Checking for errors 34864 2:30
5. locked Evaluating a formula 34865 2:38
Key # Length
1. locked Recording a macro 34866 2:36
2. locked Running a macro 34867 1:04
3. locked Editing a macro 34868 2:00
Key # Length
1. locked Copying and pasting static information 34869 1:07
2. locked Copying and pasting as a link 34870 1:03
3. locked Importing a text file into Excel 34871 3:07
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.