Excel 2007 - Intro
Platform: PC
Description
Microsoft® Office Excel 2007 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the new results-oriented interface and rich data visualization, professional-looking charts are easier to create and use.
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. |  |
Using the new Excel 2007 interface | 28638 | 2:43 |
| 2. | |
Using and minimizing the ribbon | 28639 | 2:02 |
| 3. | |
Using the Quick Access toolbar | 28640 | 2:23 |
| 4. | |
Customizing the Quick Access toolbar | 28641 | 3:14 |
| 5. | |
Understanding a worksheet and entering information into a cell | 28642 | 2:16 |
| 6. | |
Changing the default worksheets and cell movement | 28643 | 2:30 |
| 7. | |
Using a template | 28644 | 1:22 |
| 8. | |
Using save and save as | 28645 | 2:53 |
| 9. | |
Using compatibility mode | 28646 | 3:02 |
| 10. | |
Opening Excel 2007 files in earlier versions of Excel | 28647 | 1:11 |
| 11. | |
Moving with the keyboard pt. 1 | 28648 | 2:26 |
| 12. | |
Moving with the keyboard pt. 2 | 28649 | 2:06 |
| 13. | |
Using keytips | 28650 | 1:06 |
| 14. | |
Creating a PDF | 37748 | 2:30 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Using AutoComplete | 28651 | 2:05 |
| 2. | |
Editing a cell | 28652 | 2:01 |
| 3. | |
Using spell check | 28653 | 1:53 |
| 4. | |
Selecting cell ranges pt. 1 | 28654 | 2:54 |
| 5. | |
Selecting cell ranges pt. 2 | 28655 | 3:01 |
| 6. | |
Entering values in a cell range | 28656 | 1:31 |
| 7. | |
Using AutoFill | 28657 | 2:27 |
| 8. | |
Using cut, copy and paste | 28669 | 2:28 |
| 9. | |
Using Paste options | 28670 | 2:25 |
| 10. | |
Using the paste list and paste special | 28671 | 1:39 |
| 11. | |
Using the clipboard | 28672 | 1:41 |
| 12. | |
Using drag and drop editing | 28673 | 1:29 |
| 13. | |
Using undo and redo | 28674 | 1:48 |
| 14. | |
Using the Clear command | 28675 | 0:51 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Using autocalculate | 28658 | 1:50 |
| 2. | |
Using auto sum | 28659 | 2:54 |
| 3. | |
Creating formulas | 28660 | 3:03 |
| 4. | |
Using functions and the function wizard pt. 1 | 28661 | 2:07 |
| 5. | |
Using functions and the function wizard pt. 2 | 28662 | 3:18 |
| 6. | |
Editing formulas | 28663 | 3:05 |
| 7. | |
Checking formulas for errors | 28664 | 1:33 |
| 8. | |
Using relative cell referencing | 28665 | 2:40 |
| 9. | |
Understanding absolute cell references | 28666 | 3:04 |
| 10. | |
Creating an absolute cell reference | 28667 | 1:37 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Formatting numbers using the ribbon | 28668 | 2:37 |
| 2. | |
Formatting text using the ribbon | 28676 | 2:53 |
| 3. | |
Using the Alignment and Indentation commands | 28677 | 1:34 |
| 4. | |
Rotating information in a cell | 28678 | 2:16 |
| 5. | |
Wrapping text in a cell | 28679 | 0:39 |
| 6. | |
Using the Merge and Center command | 28680 | 1:44 |
| 7. | |
Using the Borders command | 28681 | 1:49 |
| 8. | |
Drawing cell borders | 28682 | 1:39 |
| 9. | |
Formatting information using the format cells dialog box | 28683 | 3:03 |
| 10. | |
Using the Format Painter command | 28684 | 1:43 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Selecting columns and rows pt. 1 | 28685 | 2:29 |
| 2. | |
Selecting columns and rows pt. 2 | 28686 | 1:46 |
| 3. | |
Changing column width | 28687 | 3:08 |
| 4. | |
Changing row height | 28688 | 3:08 |
| 5. | |
Hiding and unhiding columns and rows | 28689 | 2:49 |
| 6. | |
Inserting columns | 28690 | 2:50 |
| 7. | |
Inserting rows | 28691 | 2:27 |
| 8. | |
Deleting columns and rows | 28692 | 2:37 |
| 9. | |
Inserting and deleting cells | 28693 | 2:32 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Using cell styles | 28694 | 1:50 |
| 2. | |
Creating a custom cell style by example | 28695 | 2:12 |
| 3. | |
Creating a custom cell style | 28696 | 3:00 |
| 4. | |
Deleting a custom cell style | 28697 | 0:46 |
| 5. | |
Modifying a custom cell style | 28698 | 1:25 |
| 6. | |
Merging custom cell styles | 28699 | 1:18 |
| 7. | |
Using themes | 28705 | 0:46 |
| 8. | |
Customizing themes | 28706 | 1:13 |
| 9. | |
Formatting as a table pt. 1 | 28700 | 1:44 |
| 10. | |
Formatting as a table pt. 2 | 28701 | 2:27 |
| 11. | |
Creating a custom table style pt.1 | 28702 | 1:42 |
| 12. | |
Creating a custom table style pt. 2 | 28703 | 2:27 |
| 13. | |
Deleting a custom table style | 28704 | 1:10 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Using Normal view | 28707 | 1:22 |
| 2. | |
Using Page Layout view | 28708 | 2:07 |
| 3. | |
Using Page Break preview | 28709 | 3:34 |
| 4. | |
Using the Page Layout command tab | 28710 | 3:25 |
| 5. | |
Changing the margins | 28711 | 3:01 |
| 6. | |
Changing the page orientation and paper size | 28712 | 1:13 |
| 7. | |
Setting manual page breaks | 28713 | 1:58 |
| 8. | |
Setting print titles | 28714 | 2:13 |
| 9. | |
Creating headers and footers | 28715 | 2:04 |
| 10. | |
Using the Page Setup dialog box | 28716 | 1:08 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Using print preview | 28717 | 1:30 |
| 2. | |
Printing | 28718 | 1:53 |
| 3. | |
Printing selected ranges | 28719 | 1:56 |
| 4. | |
Setting, adding to, and removing print areas pt. 1 | 28720 | 3:03 |
| 5. | |
Setting, adding to, and removing print areas pt. 2 | 28721 | 1:14 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Using Help | 28722 | 2:00 |
Generate Direct Linking HTMLBrowse Training
Find an Answer to a Tech Question