Contact Us

Contact Us





    Microsoft Excel online training courses

    Excel is the spreadsheet application in the Microsoft Office suite. And it does so much more than just tally numbers – you can easily organize, visualize, and discover insights from your data with Excel. Whether you’re just learning how to create spreadsheets or you need to perform advanced data analysis with functions, our training will get you up and running comfortably.

    Where is it?

    Due to Covid-19, all courses
    are online in real time with
    a real instructor.

    What’s included

    • Free after-class support
    • Hands-on practice throughout
    • Course Certificate
    • Free retake policy

    Why choose us?

    • Small class sizes
    • Top instructors
    • Better practice exercises
    • Free after-class support
    • Money Back guarantee
    Training Calgary - Money Back Guarantee
    Most classes are guaranteed to run. Training is available on your choice of Mac or PC.

    Excel – Power Query « click for details
    1 Day | 7 hours | $449 PLUS TAX

    Prerequisite: Experience with Excel

    No matter where your data comes from – whether it’s a small or very large data set – you can connect, clean, analyze, and share your data faster using Power Query. This course guides you through the essentials of data extraction and transformation, teaching you to seamlessly integrate data from multiple sources and transform the time-consuming chore of data preparation into an efficient, automated process. 

    Dates

    • Online:
    • Runs on request. Please call to arrange dates.
    More dates

    Microsoft Excel – Level 1 « click for details
    1 Day | 7 hours | $349 PLUS TAX

    Prerequisite: Familiarity with computers

    This one-day course teaches you the basics of work books and work sheets. You will learn how to enter and format data, text, and formulas; how to use pre-defined functions for basic calculations; and how to avoid errors. You will also learn how to organize and manage lists and tables (including sorting, filtering, and analyzing). 

    Dates

    • Online:
    • Sep 25
    • Oct 04
    • Oct 25
    • Nov 04
    • Nov 15
    More dates

    Microsoft Excel – Level 2 « click for details
    2 Days | 14 hours | $549 PLUS TAX

    Prerequisite: Knowledge of Excel 1

    With this intermediate Excel course you’ll really ramp up your productivity. Using robust formulas and surprisingly simple techniques, you will be slicing and dicing to discover the power of data analysis. You’ll create Pivot Tables, build fully functional financial dashboards, and complete relevant exercises. At this level, Excel is an eye-opener. 

    Dates

    • Online:
    • Oct 09-10
    • Nov 06-07
    • Nov 26-27
    • Dec 19-20
    • Jan 14-15
    More dates

    Microsoft Excel – Level 3 « click for details
    2 Days | 14 hours | $549 PLUS TAX

    Prerequisite: Knowledge of Excel 2

    Are you an advanced Excel user? Do you need to consolidate data from several worksheets, work with external data, or perform What-IFs? Would you like to learn how to use macros or create rolling charts? This two-day course will teach you all that and a whole lot more with sought-after techniques and formulas. Where the entire class is using Excel 365 or later, you will be introduced to the exciting new Dynamic Array formulas. 

    Dates

    • Online:
    • Oct 15-16
    • Nov 20-21
    • Dec 23-24
    • Jan 22-23
    • Feb 19-20
    More dates

    Microsoft Excel – Pivot Tables « click for details
    1 Day | 7 hours | $449 PLUS TAX

    Prerequisite: Knowledge of Excel 1

    Pivot Tables – one of the most powerful features of Excel – allow large amounts of data to be summarized and analyzed with just a few mouse clicks, and without any formulas. You'll be able to drag and drop fields directly into a Pivot Table to change your report layout to whatever you want, whenever you want. This one-day workshop culminates in building a sophisticated, yet uncomplicated dashboard that communicates financial information with power and ease you never thought possible. 

    Dates

    • Online:
    • Sep 26
    • Oct 17
    • Dec 11
    • Jan 21
    • Feb 18
    More dates

    Excel – Finance Functions « click for details
    1⁄2 Day | 3 hours | $299 PLUS TAX

    Prerequisite: Excel Level 1

    This course is especially beneficial to accountants, financial managers, and analysts. We explore: » determining monthly payments for a loan» creating an amortization table for a mortgage» computing present and future value for a series of payments or amounts» calculating internal rate of return for cash flows» calculating the number of months to pay off […] 

    Dates

    • Online:
    • Runs on request for 2 or more. Please call for dates
    More dates

    Excel – Financial Forecasting « click for details
    1⁄2 Day | 3 hours | $349 PLUS TAX

    Prerequisite: Excel Level 1

    Forecasting is a valuable tool in business planning. It allows you to reliably predict company performance, trends, etc. Forecasting applies to expenses as well as revenues, and can provide a clearer understanding of future profits and losses. Ultimately, business forecasting enables better decision-making. Historical data is analyzed to detect patterns which helps to predict future […] 

    Dates

    • Online:
    • Runs on request for 2 or more. Please call for dates
    More dates

    Excel – Custom Training « click for details
    1–2 Days | 7–14 hours | $399/day PLUS TAX

    Prerequisite:

    When other Excel courses do not fit your needs, you can cherry-pick your own topics of interest and create a course agenda that meets your needs. If you want, we can help you plan exactly how you want to enhance your productivity with Excel. Custom Training courses have a very high satisfaction rating from our […] 

    Dates

    • Online:
    • Runs on request for 2 or more. Please call for dates
    More dates

    Dynamic Arrays « click for details
    1 Day | 7 hours | $449 PLUS TAX

    Prerequisite: Knowledge of Excel 2

    Dynamic Arrays are the most significant enhancement to Excel in years. Traditional array formulas (one formula, multiple results) have always been possible but they’re complicated and cumbersome to use, and usually require careful replication. New functions you will learn include: XLOOKUP, UNIQUE, FILTER, and SORT. Now, with Dynamic Arrays, formulas are simpler and easier to manage, and they usually require no replication at all. Dynamic Arrays are available to users of Excel 365 or later. 

    Dates

    • Online: Runs on request. Please call.
    More dates

    I really liked the course overall. It covered a great deal of information and provided a lot of reference materials. Ashley M.

    Cancellation & Rescheduling Policy

    Plans change, and we can accommodate all reasonable requests. Sometimes there are hard costs
    involved but we’ll work with you to reduce or avoid them altogether. Please direct all cancellation
    and rescheduling emails to learning@thetrainingcompany.ca

    Cancellations

    » Cancellations made more than 5 days before a course date qualify for a full refund minus a $35 administration fee per student.

    » Cancellations made less than 5 days before a course do not qualify for a refund but the class may be rescheduled.

    » Cancellations made within 48 hours of the start time are not eligible for a refund and may not be rescheduled.

    » We are not able to offer refunds or rescheduling for no-shows or uncompleted courses.

    Rescheduling

    » There is no charge for rescheduling when you inform us at least 3 days before the course.

    » An administration fee of $35 per person is charged when rescheduling less than 3 days before a course.

    » Student substitutions are free. If you cannot take a course maybe your colleague can. Just let us know.

    » It is rare that classes do not run as scheduled but we do reserve the right to reschedule previously confirmed classes.