Courses by Category
Click on a category below to see a listing of courses.

This course is available for customized on-site delivery for groups of 3 or more students.
Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

Advanced Microsoft Excel (1 days)

Our Advanced MS Excel course is designed to teach even the most seasoned MS Excel users how to better manage and use MS Excel. This course covers advanced topics, such as PivotTables, designing custom charts, and macros.

Advanced Microsoft Excel Course Calendar (1 days)

Call for upcoming dates or on-site delivery.

1 Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services.
2 Include course and course materials only.
3 Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone.
For government and education pricing, please contact us.

Recommended Pre-requisites

We recommend that users attend our Intermediate MS Excel course before attending this one.

Course Outline/Agenda

  • Review of Intermediate Excel material
  • Using Excel filtering tools
  • Using formula auditing features
  • Using search & replace features
  • Data validation
  • Working with Excel add-ins
  • Using the "Conditional Sum" Wizard
  • Using the lookup wizard
  • Advanced graphics
  • Adding custom and user-defined charts
  • Automating repetitive tasks with macros

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Course Details
This course is delivered regularly, and updated after each delivery to ensure accuracy as well as depth of coverage.

Instructional Materials
The following materials are used to deliver this course:
  • OTG Course Guide
Adobe PDF Logo View course guide table of contents
Requires Adobe Acrobat Reader

Enroll in this course

View upcoming course calendar