Home / Blog

Blog

The next evaluation Excel online-workshop is on November 9, 2018

Online workshops are extremely useful especially if you have employees that are geographically scattered. If you are looking to get your staff trained on some of the best Excel content available, here is your chance to experience it first hand, free of charge. An opportunity to attend a free one-hour session where you can experience how close it is to an in-class experience and how productive it can be. Please see the information below:

Productivity Tips and Tricks: Excel (one-hour online)

Objective: To give participants and decision makers an in-use experience of instructor-led online classes and to see how similar it is to an in-class workshop

Duration: One-hour

Date: November 9, 2018

Time: 1:00 pm to 2:00 pm ET

What will be covered: Three productivity techniques will be covered and participants will be able to practice along with the instructor:

  • Using Auto Outlines as an aid to information dissemination and printing (Some keyboard shortcuts will also be covered)
  • Docking commands on the Menu which are normally not accessible and using one of Excel’s very powerful, but lesser known commands (the Excel camera) for creating dashboards, reports and printing
  • Flash Fill for those participants who have version 2013 and later

This is a powerful sub-set of the topics that are normally covered in our two-hour Productivity Tips and Tricks course.

What is included:

  • All participants will receive a practice data file to practice along with the instructor and a PDF file of course notes.
  • A Free one-page Excel quick reference cheat-sheet will also be provided

Who should attend:

Anyone wishing to evaluate Avancer Learning Inc content, our unique methodology of live, interactive online hands-on workshops, and wanting to get a feel of how this method measures up to an in-class experience. This is also a great opportunity for anyone wanting to evaluate such sessions for lunch-n-learn ideas.

If Interested:

Please use the contact-us page to send us the name and email address of your nominee for registration. The participant will then directly receive login credentials as instructions on how to get the materials.

Privacy information:  We do not use participants email addresses for marketing or unsolicited mail. Unless the participant initiates a conversation with us separately, their names and email addresses are used ONLY to communicate the login credentials, reminder of the course, and to communicate the link to the recording of the course

Struggling with Spreadsheets and Data? Get Hands-on with Excel Pivot Tables

An Intermediate Training Course from Avancer Learning

In this information era, we’re all working with large, and often unwieldy data sets. Many of us must extract accurate insights from thousands of cells of data in Excel spreadsheets. And we’re asked to provide these insights quickly, often with short lead times.

With pivot tables, you can summarize and analyze complex data sets with a few mouse clicks. You may have worked with pivot table data or created a basic table using an online tutorial. But just as working out with a trainer makes your visits to the gym more productive, maximizing the analytical muscle of Excel pivot tables requires hands-on personalized training. We’re here to help to you realize the full potential of Excel pivot tables.

Simplifying Excel Pivot Tables

Our ‘Getting Hands-on with Excel Pivot Tables’ course explores the following topics:

  • Understanding how pivot tables work
  • Setting up data sets for pivot table success
  • Overview of pivot table structure and insights into how you can troubleshoot common problems
  • Making pivot tables work for you through formatting, creating multiple levels or tiers, logic-based filtering
  • Exploring pivot table options and tips to create professional reports.

Top 3 Takeaways from Avancer’s Excel Training Course

Avancer’s hands-on training provides you with several important benefits. Here are 3 valuable takeaways from our online training course on pivot tables:

  1. The session allows you to repeatedly practice working with pivot tables.
  2. Using business data provides realistic scenarios for you to tackle.
  3. You’ll have an actual instructor available to answer questions, interact with, and give feedback.

Interactive learning keeps you engaged and more likely to retain what you’ve learned.

Sessions are scheduled for 2 hours with time to address questions and verify understanding. Training is private (no webcams) to enhance interaction with our instructor.

In addition to providing hands-on training, Avancer develops free online resources to address frequently asked questions.

Watch these videos:

https://www.youtube.com/watch?v=dQDQPiSn4z4

https://www.youtube.com/watch?v=H46lohidSp8

Why Training on Pivot Tables is Important

Having the ability to organize and rapidly summarize data sets with Pivot Tables can benefit you professionally and personally.

  • In a work environment, you’ll be able to provide richer analyses and timely, accurate reports. Adding pivot table expertise to your resume increases it’s value to your current employer. You may just become the ‘go-to’ person in your organization to answer questions about pivot tables!
  • Those same skills will also allow you to organize your own investment and household data using pivot tables to help you in your decision making.

Are you ready to put Excel pivot tables to work for you? Our next ‘Getting Hands-on with Excel Pivot Tables’ training is June 7th from 9-11 am EST.

Register here and get ready to maximize the power of data by getting a running start on how to use Excel pivot tables effectively.

Avancer Learning has partnered with Plan International Canada supporting it’s “Because I am a Girl” campaign. Enrolling in one of our courses will empower you with refined skills and empower girls through this outreach initiative. A percentage of all our online training revenue goes to Plan International Canada. 

Examples of Charts and Dashboards

I've written this blog post as an addition to our FAQs on our Excel courses. I've recently been asked about some examples of charts that we create during our charts and dashboards class, and I thought it was time we pulled these out of our Excel practice files and put them into a blog post!

So here are a few examples but the exact mix will vary from course to course. Also, there are many more examples than I have room to display here so these are just some of the hundreds of charts we have worked on:

Waterfall Charts / Bridge Charts – new in Excel 2016

UPDATE – October 2016

Our webinar in September 2016 explored how waterfall charts can be created in Excel version 2010 and in version 2016. For those of you who missed that webinar, the recording is available below. We hope you enjoy watching it.

 

The Waterfall chart or bridge chart has long been a favorite of the financial community and sales/business development community. It is the most-requwaterfallested chart during our Advanced Charts and Dashboards workshop. Creating a good robust chart template that can be reused often, requires some simple Excel formulas and chart tweaks. The charts pictured alongside were created in Excel version 2010. These are not native to Excel 2010 and are created through the use of the stacked-column chart. Proving that they have their ear to the ground, Microsoft has included the waterfall chart as a built-in chart to Excel version 2016. Now you no longer need to go through all the data manipulation required for a waterfall chart. One word of caution though – to customize your chart you still need to know how to tweak the charts the way you want them.

Don’t have Excel 2016? No problem – head over to our online courses section and take a look at our courses there. Or take a look at the One-day Advanced Charts and Dashboards classroom in-house training here.

New Excel Videos

Oftentimes we get questions about the effectiveness of Excel Training Online vs Classroom. While both methods have their pros and cons, you never really know how it will work for you till you try it. We thought it might help to look at some recordings of earlier online workshops and see what the online training experience is like and so we have uploaded some videos as well as videos of short tips and tricks. We will be adding more videos so bookmark our demo page and check back often. Click here for current videos.

Recording of Vlookup free webinar

Our Webinar on Vlookup was well attended and hopefully some of you were able to catch the recording later. Last week I was at a classroom workshop where I was again reminded of how popular Vlookup remains. Here is the uploaded video on You Tube for those of you who might want to take a look.

A brief look at Vlookup

VLOOKUP slideshare
A familiarization presentation about VLOOKUP on SlideShare

Ok I know that title is a bit corny, but the alternative: “A Brief Look Up at Vlookup” is too much like “A brief history of time” and would end up sounding pretentious! After all we all know Vlookup is not in the same class as astrophysics (but perhaps better known!).

Some of you might have seen the announcement about our free Vlookup familiarization class that sought to clarify what Vlookup is, what it can and what it cannot do. We’ve made the slides available for viewing, if you’d like to take a look, on SlideShare.

 

Five powerful things to learn in Excel

Read Paul’s article in DA Magazine on five important Excel features that can add power to your work. Catch the story here. DA Magazine is published by the Institute of Chartered Professional Accountants of Ontario. (link opens in a new window and you will be directed to a website outside Avancer learning Inc.)

Our Outlook course on Udemy.com gets great reviews

courseimage
Microsoft Outlook – Powerful Hacks for Inbox Efficiency

Beginning with Microsoft Outlook, Avancer Learning Inc courses are soon going to be available in Self-paced learning format. Our course “Powerful Hacks for Inbox Efficiency” is more than just a tips and tricks course. We believe it will be one hour well-spent and add significant efficiencies to the way you handle your mail. Visit our course at Udemy.com 

(Link will open a new window. Please note that Udemy.com is an independant marketplace and is not affiliated to Avancer Learning Inc and not governed by our website terms)

Excel VBA for the Non Programmer

Avancer Learning Inc announces the program dates for “Excel VBA for the Non-programmer”. This workshop series is designed to bring VBA within the skill set of most Excel users whether or not there has been any formal prior programming knowledge. The workshop focusses on the most commonly used techniques and routines that should allow regular Excel users to write adequate VBA macros and take their spreadsheets to the next level.

And like all Avancer Learning Inc’s workshops – it is designed to meet a wide range of skill-sets and follows the same methodology that has made these workshops so well-liked: Hands-on, Instructor-led, Interactive with real-life experience and practical examples.

For more information about the course, learning outcomes, course facilitator, and to register,  Click here to visit the course description page

 

Top