5 hours
Any Level
Available
Leila Gharani
Impressive Excel Waterfall Charts for Your Reports - From Scratch. No Add-ins, No VBA - For ANY Excel Version!
Want to Include impressive Waterfall / Bridge Charts in your Corporate Reports?
Waterfall graphs or bridge charts provide great visualizations for Management Reports.
In this course you learn how to include different variations of the Waterfall Chart in your reports. No VBA or Add-ins are required.
The best part is you can use ANY version of Excel too.
You'd like to impress your Management and colleagues by introducing new techniques to create simple and effective Waterfall charts? Then this course is for you!
Course includes:
Downloadable Excel Workbook of all Waterfall Charts covered. Feel free to use these as your Waterfall Templates.
Cheat Sheets in PDF format as your Quick Reference Guide for the future.
Why use a Waterfall Chart?
A waterfall chart or a bridge chart is a very liked chart by Management. For good reason too. They provide an effective way of visualizing your data that helps you understand how you got from one balance to another balance. They are common for financial figures – they allow you to see the profit development – how you got from gross sales to net income or how your earnings developed from last year to this year. But they are also a good story teller for non-financial data.
Do you use Excel add-ins for your Waterfall or struggle with your data preparation?
Many people use Excel add-ins to create the Waterfall chart. Why? Because they save on the frustration and headache that comes with preparing the data properly for the charts. On the downside, sometimes add-ins can't do exactly what you'd like and for some charts you might want to do it from scratch. You might also be interested to find out what the best method is for creating Waterfall charts from scratch in Excel. If you are, this is the right course for you!
Waterfall Charts Covered
Excel 2016 Waterfall chart (for those that have Excel 2016)
The most flexible method to create the Waterfall chart (for any Excel version)
How to tweak the Waterfall chart for presentation purposes, e.g. long category labels can result in an "untidy" look for the chart and divert attention from your message, adding dynamic, moving arrows that reflect the total difference between end and beginning values, etc.
Vertical Waterfall chart - bar Waterfall version - (for any Excel version)
and much more - new lectures will be added to address different business issues
Excel Version
You can take this course no matter which Excel version you have. The course is done on Excel 2016 but you can follow along on your version as well. Everything can be recreated in older version of Excel – 2007, 2010 & 2013, except of course the new Excel 2016 waterfall chart. Whenever I use a technique that’s available from a specific Excel version, I do state it in the video. You don’t need to worry about compatibility when you share your charts. Something you need to worry about if you use Excel 2016 standard waterfall chart.
Praise for Visualization Secrets for Impressive Reports
"She frames the content in ways that are applicable to my current job..." -- Lauren Brown, Udemy Student
"She has me thinking of different ways to organize my data...and to better present my results to my readers..." -- Robert Goodman, Udemy Student
"I have purchased several courses on this topic from Udemy, but this is by far the best..." --Merchant, Udemy Student
"Every video I learn something new." -- Darshan Patel, Udemy Student
"Leila does an excellent job to show how to easily update graphs dynamically, and best visualize your data..." -- Ugur, Udemy Student
"Course is clear, to the point and very dynamic. Excellent!" -- Paul Guirlet, Udemy Student
Lore delivers value at the intersection of learning, interests and skills.
Access learning options recommended by industry experts, professionals and thought leaders.
Quickly search, select and add learning options to your learning list.
Tell us more about yourself to access the latest learning options, curated just for you.