Microsoft Excel

All classes taught using
Excel 2003, 2007, or 2010

EX1 Excel for Daily Users – The Important Stuff You didn’t Teach Yourself
$165.00 + HST
(For Multiple Seat Discounts, Click here)

Many Excel users are self-taught, and while they get more and more comfortable with the software, they frequently miss important fundamentals.  This is our most popular class!

At Excel for Daily Users, you’ll discover:

  • Tips, tricks, and shortcuts to accelerate everyday tasks like cut, copy, and paste
  • The easiest way to write basic math formulas
  • The critical skill every Excel user needs to know (A1 vs. $A$1… if you don’t know the difference, you need this class)
  • Why the data you thought you were protecting isn’t secure
  • And more

EX2 Excel Power Formulas—converting Excel from a calculator to a personal assistant
$165.00 + HST
(For Multiple Seat Discounts, Click here)

Once you know the basics (add, subtract, multiply and divide) plus a few others (like AUTOSUM) you may be hungry for more.

This class will teach you:

  • How to get Excel to THINK like you do and analyze your document for you with Excel’s most powerful formula, IF
  • How to retrieve specific information instantly from a list with VLOOKUP
  • How to create an Executive Summary with SUMIF, COUNTIF
  • How to put formulas into formulas
  • How to write LESS formulas that do more
  • How to resolve errors and identify why the formula doesn’t work
  • and besides all that… more and more formulas.

Feel the Power of Excel!

May 17 8:30 – 12:00

EX3 Excel List Management – Switch from Analysis to Action
$165.00 + HST
(For Multiple Seat Discounts, Click here)

Do you spend a lot of time pouring over lists, looking for the answer?

Customer Lists, Product Lists, Inventory Lists, Financial Statements… so many decisions you make are based on the information in these lists.  Unleash the power of excel to analyze your lists for you to find the information you are looking for.  Spend your time solving the problems instead of trying to find them.

Discover

  • How to use Filter and Advanced Filter to present the issues to you
  • How Database Formulas can instantly pull the numbers you are looking for
  • How to automate your report simply so you have an instant list analyst
  • How to use Pivot tables to chart and graph the numbers any way you like

May 10th 8:30 – 12:00

EX4 Excel-erate at the Push of a Button – Automate your doc’s with Macros:
1-on-1 Training
$395.00 + HST

So, now you know it all and you want more… Maybe Macros are the answer.  A Macro is the code behind the button, so when you push the copy button it copies and so on.  If you want to create your own buttons and shortcuts and decide what happens, from reformatting the document, to rearranging information between one or more workbooks, to writing formulas, and more… MUCH MORE… then this class is for you.

You will need a solid understanding of Excel’s formulas, functions and features and be willing to invest the time in eliminating repetitive tasks.  This class is not for the squeamish, but if you want to hit the stratosphere with your Excel documents, let’s set up a time.

This class will be limited to one-on-one training, so that we can work on your own document and simplify your job. (Or if you prefer, sample documents will be provided.)

Let’s turn hours of work into minutes together.