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.
| Key # | Length | |||
|---|---|---|---|---|
| 1. | Adding a worksheet to a workbook | 46892 | 2:29 | |
| 2. | Activating and moving between worksheets | 46890 | 2:43 | |
| 3. | Selecting multiple worksheets | 46891 | 2:47 | |
| 4. | Deleting a worksheet from a workbook | 46893 | 1:17 | |
| 5. | Changing the name of a worksheet | 46894 | 1:54 | |
| 6. | Rearranging the worksheets pt. 1 | 46895 | 2:26 | |
| 7. | Rearranging the worksheets pt. 2 | 46896 | 2:49 | |
| 8. | Hiding and unhiding worksheets | 46897 | 1:18 | |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | Zooming in and out of a worksheet | 46898 | 1:02 | |
| 2. | Viewing a worksheet in multiple windows | 46899 | 1:32 | |
| 3. | Splitting the worksheet window | 46900 | 2:39 | |
| 4. | Freezing and unfreezing panes | 46901 | 2:04 | |
| 5. | Viewing using full screen | 46902 | 0:42 | |
| 6. | Creating custom views | 46903 | 2:45 | |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | Creating range names pt. 1 | 46904 | 1:51 | |
| 2. | Creating range names pt. 2 | 46960 | 1:13 | |
| 3. | Moving to a named range | 46905 | 0:54 | |
| 4. | Using range names in formulas | 46906 | 1:13 | |
| 5. | Creating a 3-D range name | 46907 | 2:36 | |
| 6. | Editing a named range | 46961 | 1:32 | |
| 7. | Deleting a named range | 46962 | 0:29 | |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | Adding a comment to a cell | 46908 | 1:13 | |
| 2. | Reading comments | 46909 | 0:39 | |
| 3. | Showing and hiding comments | 46910 | 1:24 | |
| 4. | Using the Comments toolbar | 46963 | 1:24 | |
| 5. | Editing comments | 46911 | 0:45 | |
| 6. | Formatting comments | 46912 | 2:09 | |
| 7. | Printing comments | 46913 | 2:22 | |
| 8. | Deleting a comment | 46914 | 0:24 | |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | Creating a chart | 46915 | 1:06 | |
| 2. | Changing the chart type | 46917 | 1:11 | |
| 3. | Understanding chart types pt. 1 | 46918 | 2:02 | |
| 4. | Understanding chart types pt. 2 | 46919 | 2:17 | |
| 5. | Creating an embedded chart or a chart sheet | 46920 | 1:46 | |
| 6. | Moving and resizing an embedded chart | 46921 | 1:40 | |
| 7. | Changing the data orientation in a chart | 46916 | 1:30 | |
| 8. | Adding a chart title | 46922 | 0:54 | |
| 9. | Adding axis titles | 46923 | 1:14 | |
| 10. | Changing the location of the chart legend | 46924 | 0:44 | |
| 11. | Adding data labels | 46925 | 1:06 | |
| 12. | Adding a data table to a chart | 46926 | 1:02 | |
| 13. | Changing the gridlines | 46927 | 1:20 | |
| 14. | Formatting chart elements | 46959 | 1:56 | |
| 15. | Moving, resizing, and deleting chart elements | 46928 | 1:04 | |
| 16. | Deleting a chart | 46929 | 0:45 | |
| 17. | Printing a chart | 46930 | 1:22 | |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | Inserting a shape | 46931 | 1:32 | |
| 2. | Inserting a picture | 46937 | 0:45 | |
| 3. | Inserting clip art | 46932 | 2:18 | |
| 4. | Inserting a SmartArt graphic | 46933 | 2:36 | |
| 5. | Inserting a text box | 46934 | 0:47 | |
| 6. | Inserting WordArt | 46935 | 1:38 | |
| 7. | Selecting objects | 46936 | 1:01 | |
| 8. | Resizing a graphic object | 46938 | 2:44 | |
| 9. | Reshaping a graphic object | 46939 | 0:36 | |
| 10. | Rotating a graphic object | 46940 | 1:07 | |
| 11. | Moving a graphic object | 46941 | 1:02 | |
| 12. | Aligning graphic objects | 46942 | 2:00 | |
| 13. | Copying a graphic object | 46943 | 1:30 | |
| 14. | Deleting a graphic object | 46944 | 0:17 | |
| 15. | Grouping graphic objects | 46945 | 1:14 | |
| 16. | Stacking graphic objects | 46946 | 1:30 | |
| 17. | Formatting the fill of a graphic object | 46947 | 2:52 | |
| 18. | Formatting the outline of a graphic object | 46948 | 3:03 | |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | Applying Conditional Formatting | 46949 | 2:31 | |
| 2. | Adding additional Conditional Formatting | 46950 | 1:45 | |
| 3. | Finding Conditional Formatting | 46951 | 1:05 | |
| 4. | Modifying existing Conditional Formatting | 46952 | 0:53 | |
| 5. | Adding records to conditional formatted cells | 46953 | 1:32 | |
| 6. | Deleting Conditional Formatting | 46954 | 1:03 | |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | Using COUNT functions | 46955 | 3:21 | |
| 2. | Using the IF function | 46956 | 2:20 | |
| 3. | Using the VLOOKUP function | 46957 | 2:34 | |
| 4. | Using the HLOOKUP function | 46958 | 3:19 | |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | Creating a list using the List wizard pt. 1 | 46964 | 2:11 | |
| 2. | Creating a list using the List wizard pt. 2 | 46965 | 2:46 | |
| 3. | Adding records to the list | 46966 | 0:47 | |
| 4. | Adding records using a data form | 46967 | 1:28 | |
| 5. | Inserting a column into the list | 46968 | 1:22 | |
| 6. | Inserting a row within the list records | 46969 | 0:41 | |
| 7. | Moving columns and rows | 46970 | 1:17 | |
| 8. | Deleting a column or row | 46971 | 0:54 | |
| 9. | Using the Total Row command | 46975 | 1:21 | |
| 10. | Changing the column settings and formatting the list | 46972 | 1:30 | |
| 11. | Filtering a list | 46973 | 2:16 | |
| 12. | Sorting a list | 46974 | 1:41 | |
Generate Direct Linking HTML