Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0

Topics include: templates, forms, sharing workbooks and tracking changes, customizing excel, numeric formats (including custom numeric formats), advanced filter, scenarios, pivot tables, group & outline & subtotals, and importing & exporting data.

Course Outline

This course looks at some of the Advanced features in Excel.  Topics covered will speed up repetitive actions, and further customize Excel.

This course is classroom style instruction: Instructor-led, hands-on training.

Creating a Template
Using In a New File
Templates and Inserting Sheets
Auto templates
For default Books or Sheets
Form Templates
Designing the Form
Tools-Combo Boxes, List Boxes, etc.
Control Properties
Protecting the Form
Sharing Workbooks and Tracking Changes
Sharing workbooks on a network
Multiple users in the same file
Controlling which changes are saved
Customizing Excel
Tools, Options
Custom Lists

Numeric Formats
Custom Numeric Formats
Formatting Codes
Dates & Times
Special Characters
Codes That React To Different Number Types

Advanced Filter
Setting Up the Ranges
Performing the Filter
Setting Up the Criteria Range
Using Database Functions
Entering/Changing Criteria

Creating and Saving the Scenario
Displaying Scenarios
Other Scenario Options - Edit, Merge, Summary, etc.

Pivot Tables
Creating a Pivot Table
Summarizing Data
Using Totals and Subtotals

Group & Outline, & Subtotals
Grouping Rows/Columns on a Sheet
Showing/Hiding Details in an Outline
Display/Hide Outline Symbols
Adding Automatic Subtotals
Adding Other Automatic Analysis (Average, Mode, etc)
Removing Subtotals

Importing and Exporting
Importing Text Files
Importing Access Tables
Exporting Data


Prerequisites & Certificates

Course Prerequisite: Required: Solid understanding of all Excel Introduction and Intermediate Level I topics. Recommended: Knowledge of Excel Intermediate Level II 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 ]


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 695 times.