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.
- 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 First Column
- Freeze Panes Based on Selection
- Eliminating Typing Errors with Spell Check
- Customizing the Spell Check Settings
- Adding words to a custom dictionary
- Using Find and Replace
- Worksheet Basics
- Ribbons
- Customizing Quick Access Toolbar
- Create a Worksheet
- Navigating
- Formula Bar
- Status Bar
- Options
- What's New in Excel 2007?
- New Worksheet Functions
- Worksheet Tables
- Larger Worksheets
- Styles and Themes
- SmartArt
- Other Features
- Customizing the Excel Menus and Toolbars
- Adding Macros and Links to Toolbars and Menus
- Rearrange Toolbars and Menus
- Create your own toolbars and menus
by updated