Instructor-Led Excel Training for Intermediate Users

  • 1 day training (2 days if it is taken online).
  • Hands-on learning of intermediate to advanced functionality of Excel
  • Learn advanced features of the latest version of Excel
  • Follow-ups are included
2 day training Lots of Hands-on Exercies1 project

Main Objectives

Pivot Tables
Summarize your data to quickly analyze it
Grouping Data
Organize rows, get totals and subtotals
Conditional Logic
Build complex formulas with complex if statements
Solver Tool
Calculate values with Excel’s help
Macros
Use macros to build very complex logic and calculations
Excel Tricks
Learn how to do things efficiently from our experts

Duration

Two days

Requirements

Basic knowledge of Excel. If you’re not familiar with it take Excel Training for Beginners.

Topics Covered

  • Creating Pivot Tables
  • Grouping Data, Modifying Calculations
  • PivotChart
  • Grouping Data
  • Consolidating Data
  • Named Ranges
  • IF and nested IF function
  • COUNTIF, SUMIF and IFERROR
  • LEFT, RIGHT and MID
  • LEN, SEARCH and CONCATENATE
  • Solver Tool
  • Goal Seek Tool
  • Introduction to Macros
  • Recording Macros
  • Introduction to VBA

Register for Public Training

Mar 08 – Mar 09
2 days from Monday to Tuesday
Excel for Intermediate Users
Live Online
$960 $800
Mar 22 – Mar 23
2 days from Monday to Tuesday
Excel for Intermediate Users
Live Online
$960 $800

Private Training

Contact Us to schedule a hackathon at your company.

Related Courses

Why Our Training?

Get Hands-on Skills

At least half of the time of the training is spent on exercises.

Online or In-Person

We run both online and in-person training. The material doesn’t change, the hands-on experience is the same. Usually online training is done over a few more days as it is more difficult for participants to concentrate.

Learn more about how we’re different

Multiple Locations

We run courses in Canada, US and Mexico. Recent locations:

Canada

  • Toronto
  • Montreal
  • Vancouver
  • Calgary

US

  • New York
  • Washington
  • Houston
  • Salt Lake City

Certificate

Every participant gets a verifiable certificate at the end of the training.

Follow-Ups

One follow-up for every day of training is included. It will help you with setting up best practices in the team and refreshing your knowledge. We will also answer any of your questions.

Other Courses

Please check available courses page