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
For default Books or Sheets
Designing the Form
Tools-Combo Boxes, List Boxes, etc.
Protecting the Form
Sharing Workbooks and Tracking Changes
Sharing workbooks on a network
Multiple users in the same file
Controlling which changes are saved
Custom Numeric Formats
Dates & Times
Codes That React To Different Number Types
Setting Up the Ranges
Performing the Filter
Setting Up the Criteria Range
Using Database Functions
Creating and Saving the Scenario
Other Scenario Options - Edit, Merge, Summary, etc.
Creating a Pivot Table
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)
Importing and Exporting
Importing Text Files
Importing Access Tables
- Prerequisites & Certificates
Course Prerequisite: Required: Solid understanding of all Excel Introduction and Intermediate Level I topics. Recommended: Knowledge of Excel Intermediate Level II 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 695 times.