EXCEL: Data Slicing with SUMIFS and SUMPRODUCT (2 hrs) – 1 pm Toronto, 11 am Calgary, 10 am Vancouver
EXCEL: Enhancing Analysis and Reports with Conditional Formatting and Sparklines. – 12 pm Toronto, 9 am Vancouver, 10 am Alberta.
EXCEL: Introduction to Dynamic Array Formulas with Office 365. 1 pm Toronto, 10 am Vancouver, 11 am Calgary
EXCEL: Analytical techniques with Pivot Tables (2 hrs) – 1 pm Toronto, 11 am Calgary, 10 am Vancouver
Excel: Powerful Charts with Office 365 – Waterfall, Pareto, Treemap, Maps and more – 1 pm Toronto, 11 am Calgary, 10 am Vancouver
POWERPOINT – Introducing Excel Data in PowerPoint Presentations – 1 pm Toronto, 11 am Calgary, 10 am Vancouver
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.
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.
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.
Payment details and Refund Policy
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.
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.
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
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