Home / Archive by category "Blogpost"


In-person Classroom Workshops Resumed!

In-person Classroom Workshops Resumed! June 15, 2022 Avancer Learning is pleased to resume it's in-person classroom training workshops! After 2 long years of long-distance interaction with our clients, we are happy to resume our interactions in person! This brings with it all the hallmarks of the Avancer methodology that you've become used to over the years: Outstanding personal attention to...
Read More

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 c...
Read More

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 ...
Read More

Examples of Charts and Dashboards

Excel PowerPoint dashboard by a student
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 e...
Read More

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 mo...
Read More

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 ...
Read More

A brief look at Vlookup

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 Vlooku...
Read More

Our Outlook course on Udemy.com gets great reviews

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...
Read More