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.
Switching From Page To Page
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
Unsplitting and Unfreezing
Views and Cell Comments
Full Screen Display
Setting Zoom Levels
Attaching Comments to Cells
Editing and Deleting Comments
Opening Multiple Files
Displaying Multiple Files
Linking Cells Between Files (not formulas)
Closing All Files
Creating a Range Name
Using Range Names For Navigation
Using Names Already Entered As Headings
Range Names As Bookmarks
Setting Up A Database
The Current Region
Sorting Lists Alphabetically/Numerically
Using AutoFilter to Extract Information
The List Feature (Excel 2003)
Find & Replace
Finding Text, Values, Functions
Advanced Page Setup and Printing
Headers and Footers
Printing Column And Row Titles
Review Of Page Breaks And Printing
- Prerequisites & Certificates
Course Prerequisite: Required: Understanding of Excel Introduction topics.
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
[ View Provider's Profile ]
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.
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 619 times.