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-requested 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.
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.
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.
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.
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.)
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)
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
Improve Team Productivity – half day advanced course on Outlook techniques
Discover our incredible half-day Outlook workshop that focuses on increasing productivity while working with email and the calendar. This concise and powerful workshop is a hands-on course that takes employees through essential and advanced Outlook techniques that are geared towards managing their inbox effectively, sending and replying to mails easily and tips and tricks to increase productivity with appointments and schedules.
Key Learning Outcomes include:
- Managing your Inbox – Powerful tools and techniques – explore powerful methods that are allied to methods in Excel for Inbox Management – Conditional Formatting, Adding Special fields based on Formulas, and other tips and tricks.
- Managing your Inbox through Views, and in-cell editing
- Techniques for creating and replying to mail – Understanding Quick Parts and Auto Text
- Managing incoming and outgoing mail through Rules – understanding the automation of rules in Outlook, creating rules for incoming mail
- Exploring Templates – Speed up recurrent mail like monthly reports and bulletins, or recurrent meetings like product and strategy meetings, through templates
- Creating Templates and Autoresponders through Rules for Outgoing Mail – VERSION 2013 ONLY
- Tips and Tricks with Mail, Tasks and Calendar – Transferring Mail to the Calendar for Appointments, Group Schedules with the Calendar, Managing Time Zones.
For more information on course participation, pricing and other details, click here to Send Enquiry
Stream your classroom workshop to employees in other locations – Live!
Now organizations conducting in-house workshops with us can include employees who are in other locations but unable to travel and attend. If the workshop location is broadband wireless internet enabled, the classroom workshop can be streamed live to your employees in other locations. Attendees at other locations will be able to interact with the facilitator, ask questions, participate in hands-on activities, with almost the experience of being physically present. Interested in knowing more? For your next in-house workshop, ask us how, when you Send us an enquiry.
Presentation Skills with PowerPoint – Hybrid workshop delivers powerful customer experience
Avancer Learning Inc hybrid Soft-skills and Technology-skills expertise pays off for clients with this one-day workshop, now fine-tuned over many courses. It is a critical blend of techniques in efficiency, and skills in effectiveness. The course is developed as a completely hands-on workshop which is instructor-led, and takes participants through some highly efficient techniques in creating slide presentations. All the while, overarching principles of information effectiveness are experienced and learned. It has quickly become one of our more popular courses with client organizations as well as with participants.
- Focus on content creation first and slide deck development last
- Effective techniques to make slide deck development a question of minutes instead of hours
- Critical features to ensure Corporate identity guidelines are met
- Effective introduction of spreadsheet concepts where presentations are data-driven
- Experiential learning on information concepts to enable a result orientation of a presentation
- Key result areas of presentations when presenting to senior executive teams
- Many other concepts, techniques, tips and tricks that can be tailored to customer needs
This workshop is customizable to a great degree and can work with groups of participants from 6 to 16 in one workshop. For more details visit our PowerPoint page here.
If you would like to request a case-study on how this workshop was customized for two large but very different corporate organizations, or if you want more information, Click here to request a copy or send us a message.