Home / Page /

Course ListingTerms and ConditionsPayments and RefundsSystem RequirementsFAQs

Hands-on, Instructor-led, Online Classes.

Avancer Online Classes are fully Hands-on, led by an instructor with opportunity to interact, ask questions, and contribute suggestions, all from the privacy of your office or home.

 CORPORATE / ORGANIZATIONAL CUSTOMERS: Take advantage of our group booking discounts for 3 or more participants. Do you have 6 or more participants? Ask us about scheduling a custom session for you at a convenient date and time. Contact Us 

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.

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.

Customer Satisfaction: We hope you never need to avail of this, but if you are unhappy or dissatisfied with the course you took, let us know in writing, within 7 days of taking the course and we will issue you a full refund.

System Requirements

For working (hands-on workshops only)

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+ – wherever specified in the title or the requirements, if the course specifies only version 2013+, then participants must use version 2013+ 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

 

Online Courses – Frequently Asked Questions.

What materials will be provided?

What software do I need?

What are my System requirements?

Will I be able to view the course recording later?

If I am unable to attend will I be able to view the recording?

Will I be able to access the materials after the workshop?

Will I be able to interact with the instructor?

How is my privacy protected?

 

Loading Events

« All Events

Excel: Analytical techniques with Pivot Tables (Advanced)

October 26 @ 12:00 pm - 2:00 pm EDT

$60

Course No: RHWE-1418

Format: HANDS-ON ONLINE WORKSHOP

Duration: 2 Hours in 1 module of 2 hours. Participants will work on examples hands-on with the instructor

PRICE: $60 per participant.

Key Learning Outcomes

Pivot Table Advanced Techniques and Various Analytical techniques

• Understanding Summarizations and how to manage summarizations for a variety of analysis
• Rolling up Pivot Tables through field manipulation
• Understanding Formula Fields
• Creating and working with Calculated Fields and Calculated Items
• Tips and tricks in managing and displaying formula fields
• Plenty of Extras, and Tips & Tricks for powerful and elegant Pivot Tables

Important Instructions:
• Version 2013 will be used in the workshop demonstration. Participants are welcome to use older versions, but significant differences may exist and where possible the instructor will mention suitable workarounds.
• Essential requirements are a Coputer with broadband internet access, audio headset or speakers, and working copy of Microsoft Office. Microsoft Office Starter Edition will not be adequate.

Details

Date:
October 26
Time:
12:00 pm - 2:00 pm
Cost:
$60
Event Category:
Website:
https://attendee.gototraining.com/rt/48326123061231361

Venue

Online
Canada

Other

Availability
Open
Registration
https://attendee.gototraining.com/rt/48326123061231361
What's Included

  • Live Instruction with hands-on practice
  • Practice Data
  • PDF file of Course Notes
  • Access to the Course Recording for one month

Heads Up: Good To Know

  • Privacy First – Only the instructor sees the questions you ask and answers you submit. Webcams are disabled. Microphones are muted.
  • Break Time – Courses longer than two hours have a break scheduled. Usually this is midway. So a four hour course would have a one hour break after the first two hours.
  • 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.

Top