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.
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.
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.
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.
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
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
- This event has passed.
Advanced Excel Functions and Formulas
May 11 @ 10:00 am - 3:00 pm EDT$120
Course No: RHWE-1223
Format: HANDS-ON ONLINE WORKSHOP
Duration: 4 Hours. 2 sessions of 2 hours each with a 1-hour break in between. Participants will work on examples hands-on with the instructor
PRICE: $120 per participant.
Key Learning Outcomes
• Revision of the concept of Range Names and using names in formulas
• Understand complex formulas for slicing and dicing data using the powerful SUMPRODUCT function
• Understand the concept of rolling calculations and work with the OFFSET function for dynamic calculations
• Explore the power of ARRAY formulas for amazing flexibility in complex analysis and summarization of data using functions like IF, COUNTIF, VALUE, IFERROR, and VLOOKUP and more, in single-cell or multi-cell array formulas
• 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. Microsoft Office Starter Edition will not be adequate.