- 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 Exercies |  1 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
Private
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