Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


Topics include: working with multiple sheets, window panes & freezing titles, views & cell comments, multiple files, creating range names, using autocorrect, sorting, autofilter, find & replace, using the list feature, and advanced page setup & printing.


 
Course Outline

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


 


Prerequisites & Certificates
Pre-Requisites

Course Prerequisite: Required: Understanding of Excel Introduction topics.

Certificates offered

Participants receive with this course: * courseware (notes on all topics covered, along with exercises used during course). * a certificate of completion


Cancellation Policy

Map & Reviews
Computer Help
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 598 times.