After learning the basics in the Introduction course, this course is an absolute must to get the most out of Excel. You will learn important features that will save you time and make you much more efficient with the program.
This course is classroom style instruction: Instructor-led, hands-on training.
Multiple Sheets
Switching From Page To Page
Modifying Sheets
Moving and Copying Sheets
Setting Defaults for All Sheets
Changing the Number of Pages
Window Panes And Freezing Titles
Splitting a Window into 2 Or 4 Panes
See Widely Separated Areas of a Spreadsheet Simultaneously
Freezing Titles
Unsplitting and Unfreezing
Views and Cell Comments
Full Screen Display
Setting Zoom Levels
Attaching Comments to Cells
Editing and Deleting Comments
Multiple Files
Opening Multiple Files
Displaying Multiple Files
Linking Cells Between Files (not formulas)
Closing All Files
Range Names
Creating a Range Name
Using Range Names For Navigation
Using Names Already Entered As Headings
Range Names As Bookmarks
Using AutoCorrect
Database Tools
Setting Up A Database
The Current Region
Sorting Lists Alphabetically/Numerically
Using AutoFilter to Extract Information
The List Feature (Excel 2003)
Data Forms
Find & Replace
Finding Text, Values, Functions
Replacing Text
Replacing Functions
Advanced Page Setup and Printing
Headers and Footers
Printing Column And Row Titles
Page Order
Review Of Page Breaks And Printing
