Home / Online Workshops

Online Workshops

Course Listing

EXCEL 365: Introduction to Power Pivot and the Data Model (3 hrs. 12 pm Toronto, 9 am Vancouver, 10 am Calgary)

A powerful 3-hour workshop that will introduce Power Pivot and the concept of the data model in Excel. Learn the concepts of flat data versus a data-model, data relationships, New Pivot Table features with the data-model, and powerful reporting techniques unlocked by Power Pivot. A working knowledge of Pivot Tables is required before you take this course. ...
08 Apr
12:00 pm - 3:00 pm

POWERPOINT: Animation for Business Users

Learn quick and powerful techniques to leverage PowerPoint Animation capabilities in a business context. Explore some techniques that are both, easy to use as well as powerful for introducing information without appearing frivolous. Includes, object animation, text animation, smart art animation and chart animation. ...
10 Apr
10:00 am - 12:00 am

EXCEL: Building better business charts with Office 365

Learn how Microsoft Office 365 enhances the powerful charting capabilities of Excel with new chart types like Waterfall Charts, Treemap Charts and other useful chart types. Learn about Chart Sub-types and Combo charts and powerful new enhancements to the charting features in Excel that make for professional and quick business reports and presentations. ...
10 Apr
1:00 pm - 3:00 pm

EXCEL:Intermediate Excel (4 hrs)

Our most popular course. A 4-hour accelerated workshop that gives participants a platform on which to build expert level skills. The course will cover data management, dynamism, lookup formulas, criteria-based formulas, Pivot Tables, and plenty of tips and tricks to enhance your productivity and quality of output. ...
17 Apr
10:00 am - 3:00 pm
No event found!
Terms

Online Classes Terms of Service and Disclaimer

These general terms govern all courses, workshops, webinars and other activities  conducted by Avancer Learning Inc, online or in-classroom, hereinafter called “online courses”, “classroom courses, or “courses”.

Passwords and Credentials

Your login access details (links and/or passwords) and other credentials are particular to you and should not be shared with anyone.  Please note for online courses our system will deny access to a second instance of the same credentials being used for the same course.

Purpose of Information

Avancer Learning Inc courses are solely for information purposes and not intended to be professional advice. For professional advice you should take engage the services of an appropriate professional.

Intellectual Property

Avancer Learning Inc reserves all rights to its publications and content. Any material you receive as part of Avancer Courses remains the copyright of Avancer Learning Inc. Audio, Video, and Screen recording of any Avancer Courses is prohibited.

Cancellations

Avancer Learning Inc. reserves the right to cancel courses at any time. A full refund will be made to you of any fees paid in advance to us for a course, in the event of its cancellation.

Disclaimer of Warranty & statement of No Liability

You agree that we are under no obligation whatsoever to you, your company, your representatives or any of your assigns. You also agree that we have not expressed any promises, warranties or guarantees, either implied or stated, in accordance with our work, not even the implied warranty of merchantability or fitness for a particular purpose.

YOU AGREE THAT WE ARE AND SHALL BE UNDER NO LIABILITY TO YOU, YOUR COMPANY, YOUR REPRESENTATIVES OR ANY OF YOUR ASSIGNS. IN NO EVENT SHALL WE BE LIABLE FOR ANY LOSS OF PROFIT OR ANY OTHER COMMERCIAL DAMAGES, INCLUDING BUT NOT LIMITED TO SPECIAL, INCIDENTAL, CONSEQUENTIAL, OR OTHER DAMAGES. These apply to the extent permissible by law and do not affect any of your statutory rights as a consumer.

IMPORTANT NOTICE – Firewalls and Antivirus

It is your responsibility to ensure you have up-to-date virus safeguards and internet firewalls before you connect to the internet, or when you download and use any files in relation to any of our training workshops.

Other Content on our website is governed by our website terms of use.

Payments and Refunds

Payment details and Refund Policy

Payments

Avancer Learning Inc accepts payments by cheque or by PayPal. Please note that we do not collect any credit card information from you. All credit card payments are handled by PayPal. For more information on PayPal’ security and privacy policy, please see www.paypal.ca

Cancellations and Refunds

Cancellations by us: You will receive a full refund of any fees paid to us for a course, in the event of a cancellation by us. Please allow for PayPal standard processing lead times for your refund.

Cancelling your registration: You may cancel your registration for a full refund at any time before a course begins which is usually 60 minutes before the scheduled course start time.

To cancel your registration: locate and click on the cancellation link within your registration confirmation email.

We regret that we are unable to issue refunds for cancellations done after that time or for no-shows.

System Requirements

Online classes – System Requirements

For working hands-on 

In the case of hands-on workshops, you will also need a working copy of the software being demonstrated. For most workshops “Starter Edition” is NOT adequate. Please ensure you have a full working copy so as to be able to try out the examples. Most workshop will be demonstrated using Microsoft Office 2010  or 2013 or later.

Important specifics

Microsoft Outlook courses – ONLY version 2010+ can be used for hands-on courses. If you use versions prior to 2010, you may not be able to try out all the examples.

Microsoft Office 2013 or later – wherever specified in the title, if the course pertains to version 2013 or later, participants must use version 2013 or later if they wish to try out all the examples

For Viewing / Listening

Avancer Learning Inc uses the Citrix GoToTraining server system. This is a user-friendly and fast system with a high degree of compatibility.

Audio and Video System

A headset or speakers is usually adequate for listening to the audio part of the course. However if you have trouble with this you can also use the Telephone to dial-in.

Using the Telephone requires you to make a call to a call-in number which is NOT TOLL FREE. Depending on where you are calling from, long distance charges may apply.

You can select your audio mode from the audio panel of your controls once you join a course

Browser compatibility

A list of compatible browsers is available on the Citrix GoToTraining website at http://support.citrixonline.com/en_US/Training/help_files/G2T010003

Test your system in advance

Before you join a course you can test your system in advance at http://support.citrixonline.com/en_US/GoToMeeting/help_files/GTM140010?title=Test+Your+GoToMeeting+Connection

New Instant Join feature – Usually the desktop app of GoToTraining gives you the most complete experience. However you can also connect through a lighter faster interface called “Instant Join” available through some browsers. This video will give you more information: http://support.citrixonline.com/en_US/training/video/G2TV00079

Heads Up: Good To Know
  • Privacy First – Participants can only interact with the Instructor. No one else can see your chat stream. Microphones are muted. Webcams are disabled
  • Break Time – Courses longer than two hours have a break scheduled. Usually this is midway. So a four hour course would have a half-hour or one-hour break after the first two hours. Check timings carefully. Not all breaks are the same length.
  • If for some reason you are unable to attend the course, you will still get a link to the course recording with access for a month, so you won’t miss the instruction.
What's Included
  • Live Instruction with hands-on practice (except for free webinars)
  • Practice Data and PDF file of Course Notes (except for free webinars)
  • Access to the Course Recording for a limited time
Top