Close [X]
Tutorial Playlist
Excel 2007 - Intro
| Using the new Excel 2007 interface | Playing... | |
| Using and minimizing the ribbon |   |
|
| Using the Quick Access toolbar |  |
|
| Customizing the Quick Access toolbar | |
|
| Understanding a worksheet and entering information into a cell | |
|
| Changing the default worksheets and cell movement | |
|
| Using a template | |
|
| Using save and save as | |
|
| Using compatibility mode | |
|
| Opening Excel 2007 files in earlier versions of Excel | |
|
| Moving with the keyboard pt. 1 | |
|
| Moving with the keyboard pt. 2 | |
|
| Using keytips | |
|
| Creating a PDF | |
| Using AutoComplete | |
|
| Editing a cell | |
|
| Using spell check | |
|
| Selecting cell ranges pt. 1 | |
|
| Selecting cell ranges pt. 2 | |
|
| Entering values in a cell range | |
|
| Using AutoFill | |
|
| Using cut, copy and paste | |
|
| Using Paste options | |
|
| Using the paste list and paste special | |
|
| Using the clipboard | |
|
| Using drag and drop editing | |
|
| Using undo and redo | |
|
| Using the Clear command | |
| Using autocalculate | |
|
| Using auto sum | |
|
| Creating formulas | |
|
| Using functions and the function wizard pt. 1 | |
|
| Using functions and the function wizard pt. 2 | |
|
| Editing formulas | |
|
| Checking formulas for errors | |
|
| Using relative cell referencing | |
|
| Understanding absolute cell references | |
|
| Creating an absolute cell reference | |
| Formatting numbers using the ribbon | |
|
| Formatting text using the ribbon | |
|
| Using the Alignment and Indentation commands | |
|
| Rotating information in a cell | |
|
| Wrapping text in a cell | |
|
| Using the Merge and Center command | |
|
| Using the Borders command | |
|
| Drawing cell borders | |
|
| Formatting information using the format cells dialog box | |
|
| Using the Format Painter command | |
| Selecting columns and rows pt. 1 | |
|
| Selecting columns and rows pt. 2 | |
|
| Changing column width | |
|
| Changing row height | |
|
| Hiding and unhiding columns and rows | |
|
| Inserting columns | |
|
| Inserting rows | |
|
| Deleting columns and rows | |
|
| Inserting and deleting cells | |
| Using cell styles | |
|
| Creating a custom cell style by example | |
|
| Creating a custom cell style | |
|
| Deleting a custom cell style | |
|
| Modifying a custom cell style | |
|
| Merging custom cell styles | |
|
| Using themes | |
|
| Customizing themes | |
|
| Formatting as a table pt. 1 | |
|
| Formatting as a table pt. 2 | |
|
| Creating a custom table style pt.1 | |
|
| Creating a custom table style pt. 2 | |
|
| Deleting a custom table style | |
| Using Normal view | |
|
| Using Page Layout view | |
|
| Using Page Break preview | |
|
| Using the Page Layout command tab | |
|
| Changing the margins | |
|
| Changing the page orientation and paper size | |
|
| Setting manual page breaks | |
|
| Setting print titles | |
|
| Creating headers and footers | |
|
| Using the Page Setup dialog box | |
| Using print preview | |
|
| Printing | |
|
| Printing selected ranges | |
|
| Setting, adding to, and removing print areas pt. 1 | |
|
| Setting, adding to, and removing print areas pt. 2 | |
| Using Help | |
Close [X]
Close [X]
Download URLs will open in a separate window when clicked.
This tutorial © Copyright
2009
Atomic Learning, Inc. All rights reserved.