Description
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.
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Using labels in formulas | 17138 | 1:59 | |
| 2. | Using multiple stacked headings in a formula | 17139 | 1:13 | |
| 3. | Using an intersection cell name in a formula | 17140 | 1:27 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Creating an outline group | 17141 | 1:21 | |
| 2. | Collapsing and expanding an outline | 17142 | 1:12 | |
| 3. | Clearing an outline | 17143 | 0:55 | |
| 4. | Using auto outline | 17144 | 1:27 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Creating an Excel database | 17145 | 1:14 | |
| 2. | Making changes to an Excel database | 17146 | 1:29 | |
| 3. | Sorting records | 17147 | 1:27 | |
| 4. | Using data validation | 17148 | 1:14 | |
| 5. | Validating data using a list | 17149 | 1:27 | |
| 6. | Clearing data validation restrictions | 17150 | 1:40 | |
| 7. | Creating subtotals in a list | 17151 | 1:47 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Using data form to view records | 17152 | 1:13 | |
| 2. | Making changes to data form records | 17153 | 0:51 | |
| 3. | Adding a new record in data form | 17154 | 1:39 | |
| 4. | Defining criteria in data form | 17155 | 1:16 | |
| 5. | Deleting a data form record | 17156 | 1:01 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Creating a criteria range | 17157 | 1:03 | |
| 2. | Using a criteria range to search a list | 17158 | 2:05 | |
| 3. | Working with comparison criteria | 17159 | 2:00 | |
| 4. | Using the advanced AND condition | 17160 | 1:07 | |
| 5. | Using the advanced OR condition | 17161 | 1:12 | |
| 6. | Copying filtered conditions | 17162 | 1:17 | |
| 7. | Using database functions | 17163 | 2:40 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Exporting data as a text file | 17164 | 1:33 | |
| 2. | Exporting data for a database application | 17165 | 2:05 | |
| 3. | Exporting data to an xml file | 17166 | 1:32 | |
| 4. | Importing data from a text file | 17167 | 2:44 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Adding or removing chart gridlines | 17168 | 1:16 | |
| 2. | Formatting a chart axis | 17169 | 2:00 | |
| 3. | Changing the axis scaling | 17170 | 1:14 | |
| 4. | Formatting a chart data series | 17171 | 1:25 | |
| 5. | Using the secondary axis in a chart | 17172 | 1:20 | |
| 6. | Changing a data series chart type | 17173 | 0:54 | |
| 7. | Adding a trendline to a chart | 17174 | 1:01 | |
| 8. | Creating a custom chart type | 17175 | 1:47 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Cascading and tiling multiple open workbooks | 17176 | 0:49 | |
| 2. | Copying information between workbooks | 17177 | 0:50 | |
| 3. | Saving multiple workbooks as a workspace | 17178 | 1:02 | |
| 4. | Closing all workbooks at one time | 17179 | 0:23 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Applying conditional formatting | 17180 | 1:31 | |
| 2. | Making changes or deleting conditional formatting | 17181 | 0:55 | |
| 3. | Adding additional conditional formatting | 17182 | 1:04 | |
| 4. | Adding records in conditional formatted cells | 17183 | 0:48 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Saving a workbook as a template | 17184 | 1:32 | |
| 2. | Making changes to a saved template | 17185 | 1:11 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Copying a value between worksheets | 17186 | 1:33 | |
| 2. | Copying formulas between worksheets | 17187 | 1:31 | |
| 3. | Using paste special in a mathematical operation | 17188 | 1:24 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Protecting a worksheet | 17189 | 2:06 | |
| 2. | Assigning and removing a workbook's password | 17190 | 1:35 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Setting up a VLOOKUP table | 17191 | 1:33 | |
| 2. | Creating a VLOOKUP function | 17192 | 2:18 | |
| 3. | Setting up an HLOOKUP table | 17193 | 0:59 | |
| 4. | Creating an HLOOKUP function | 17194 | 1:40 | |
| 5. | Using the IF function | 17195 | 1:52 | |
| 6. | Using nested IF functions | 17196 | 2:35 | |
| 7. | Using an AND condition with the IF function | 17197 | 2:05 | |
| 8. | Using an OR condition with the IF function | 17198 | 1:18 | |
| 9. | Using the round function | 17199 | 1:04 | |
| 10. | Limiting the precision of numbers | 17200 | 1:29 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Displaying dependent arrows with the Auditing toolbar | 17201 | 1:02 | |
| 2. | Displaying precedent arrows with the Auditing toolbar | 17202 | 1:46 | |
| 3. | Using the Trace Error button | 17203 | 1:11 | |
| 4. | Using the Error Checking button | 17204 | 0:51 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Recording a macro | 17205 | 1:41 | |
| 2. | Assigning a Macro to a menu | 17206 | 1:43 | |
| 3. | Deleting a Macro from a menu | 17207 | 0:41 | |
| 4. | Writing a macro | 17208 | 2:31 | |
| 5. | Entering macro comments | 17209 | 1:44 | |
| 6. | Editing a Macro command | 17210 | 1:04 | |
| 7. | Testing a macro from the code window | 17211 | 0:44 |
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
|---|---|---|---|---|
| 1. | Creating a custom toolbar | 17212 | 1:16 | |
| 2. | Adding a Custom button to a toolbar | 17213 | 1:28 | |
| 3. | Attaching a custom toolbar to a workbook | 17214 | 0:54 | |
| 4. | Deleting a custom toolbar | 17215 | 0:55 | |
| 5. | Creating a custom menu | 17216 | 1:38 |


Generate Direct-Linking HTML