Instructor-Led Excel Training for Beginners

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

Main Objectives

Fundamentals
Prepare for more complex topics
Basic to Advanced Functions
Learn how to calculate sub-limits, average of unique values etc.
Excel Lists
Save time by using this often underutilized functionality.
Printing Functions
Explore many options to print exactly the way that you need.
Importing Data
Use data sources like SQL databases and XML
Excel Tricks
Learn how to do things efficiently from our experts

Duration

Two days

Requirements

None.

Topics Covered

  • Types of cells
  • Sorting Rows
  • Formats, Styles
  • SUM, MIN and MAX
  • AVERAGE, COUNT
  • Autosum
  • DSUM, DCOUNT,DAVERAGE
  • SUBTOTAL
  • Print Preview
  • Margins, Scaling and Orientation
  • Page Layout, Header and Footer
  • Importing Text Files
  • Importing Structured Files
  • Working with Databases
  • Basics of Excel Lists
  • Single and Multi-Level Sorts
  • Autofilter
  • Existing Templates
  • Custom Templates

Register for Public Training

Nov 01 – Nov 02
2 days from Monday to Tuesday
Excel for Intermediate Users
Boston
$960 $800
Nov 01 – Nov 02
2 days from Monday to Tuesday
Excel for Intermediate Users
Toronto
$960 $800
Nov 15 – Nov 16
2 days from Monday to Tuesday
Excel for Intermediate Users
New York
$960 $800
Nov 29 – Nov 30
2 days from Monday to Tuesday
Excel for Intermediate Users
New York
$960 $800
Nov 29 – Nov 30
2 days from Monday to Tuesday
Excel for Intermediate Users
San Francisco
$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