Home Excel 2007 Tutorials Getting Started

Excel 2007 Tutorials - Getting Started

In this tutorial you'll learn the following techniques:

• Techniques of inserting, deleting and renaming worksheets
• Automatically move the cell pointer in any direction after pressing enter, change the number of Recent Documents, see headings as you scroll around a report, freeze top row, first column or freeze panes based on selection.
• Spell checking a worksheet can go a long way towards eliminating typos that get by the program's AutoCorrect feature. Learn how to check spells, update dictionary, use custom dictionary and more.
• Find and Replace feature to quickly locate every occurrence of a specific string (a series of characters) in a worksheet and then have Excel actually update the cells that it finds with new text or numbers.
• Parts of Excel's window, Ribbon user interface, shortcut menus, dialog boxes and how to navigate Excel worksheets.
• Overview of what's new and what's changed in Excel 2007.
• Customizing the Excel toolbars and pulldown menus. Taking the time to get the Excel toolbars and the pull-down menus the way you want them saves your valuable time when creating and editing your spreadsheets.

Table of content (tutorial index)