Description
Ultimate Excel Waterfall Chart (Bridge Chart) Course, Leila Gharani – Ultimate Excel Waterfall Chart (Bridge Chart) Course, Ultimate Excel Waterfall Chart (Bridge Chart) Course download, Leila Gharani – Ultimate Excel Waterfall Chart (Bridge Chart) Course review, Ultimate Excel Waterfall Chart (Bridge Chart) Course free torent
Leila Gharani – Ultimate Excel Waterfall Chart (Bridge Chart) Course
Ultimate Excel Waterfall Chart (Bridge Chart) Course
Impressive Excel Waterfall Charts – From Scratch. No Add-Ins, No VBA, And For ANY Excel Version!
Want to Include impressive Waterfall Charts / Bridge graphs 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!
When you enroll today you’ll get instant access to:
5 hours of video content you can watch on your desktop, smartphone or tablet
Business examples of the Waterfall chart as well as many variations
Secret chart tricks you can use on ANY other chart to get the effect you want
Ability to think outside-the-box when it comes to Excel charts
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.
Waterfall graphs 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.
Waterfall Charts Covered
Excel 2016 Waterfall chart – advantages & limitations (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).
Stacked Waterfall charts – different variations.
and much more.
Excellent course! All about Waterfall Charts, just what I wanted to learn. Highly professional delivery and extremely helpful supporting material. It’s already my second course with this instructor and I knew what I could expect You did again a fantastic job, Leila. Thank you for this great course.
– Ulrika Garner
Would highly recommend for anyone who works with numbers and scared of graphs, simply amazing! Brilliant teacher!
– Edward Madziwa
Your Instructor
Leila Gharani
My courses & tutorials are for ambitious beginners and professionals who want to upgrade their data analysis skills. If you hate doing things manually, you’ll love my approach.
I don’t just want to show you solutions to specific problems, but to teach you to find solutions to ALL your future data analysis problems.
On my YouTube channel, I share Office Productivity tips & tricks based on questions I get from our online community & professionals at my training sessions.
I am a Certified Microsoft Excel Expert and was given the Microsoft MVP award in 2017. I have over 15 years of experience implementing and training users on Management Information Systems of different sizes and nature – these include SAP BW and Oracle HFM.
My background is: Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. My passion is teaching and solving difficult Excel problems. I am also addicted to learning and enjoy taking online courses on a variety of topics.
I founded my online learning company, XelPlus, in 2015. Our aim is to help you gain the knowledge you need so you can create useful tools, solve problems and get more done.
Let’s start now.
Course Curriculum
Introduction to Waterfall Charts
Course Introduction & Scope
When to Use a Waterfall Chart? Business Case Examples
Download Excel File HERE
Where to leave comments, questions & download cheat sheets
Excel In-built Waterfall Chart in 2016 Version
Excel 2016 Waterfall Chart & it’s Limitations
Excel 2016 Waterfall – Advantages Versus Disadvantages
Excel Waterfall Chart from Scratch for ANY Excel Version
Easiest Method to Create the Waterfall in ANY Excel Version
Flexible Waterfall Chart – Step by Step
How to use this Waterfall Chart as Your Template
Adding Subtotals to the Excel Waterfall Chart
Your Challenge – Create the Waterfall from Scratch
Improving the Waterfall Chart for Better Presentation
What to do When Category Labels are Too Long – Long Horizontal Axis Labels
My Favorite Trick – Handling Long Category Labels in Reports
Add Dynamic Elbow Connectors from Start-to-End and Show Total Change
Add Dynamic Arrows from Start-to-End and Show Total Change
What to do When Delta Values are Too Small
Your Challenge – Add Dynamic Arrows to the Waterfall
Vertical Waterfall (Bar Waterfall) Excel Chart
Easy Method to Create a Vertical Waterfall Chart
Vertical Waterfall Chart With Improved Data Labels
Flexible Vertical Waterfall Chart – Positive & Negative
Full Proofing the Vertical Waterfall Chart
The Quickest Vertical Waterfall Chart – Use This to Save Time
Waterfall Add-on: Vertical Dynamic Arrows to Show Total Change
Waterfall Add-on: Horizontal Dynamic Arrows to Show Total Change
Your Challenge: Create a Vertical Waterfall Chart
Traditional Excel Waterfall Chart: Stacked Approach
Traditional Approach for Waterfall Charts Using Stacked Columns
Traditional Stacked Approach Tweaked to Work Below the Axis (negative values)
An Alternative Method for the Waterfall Connectors
Stacked Excel Waterfall Charts
Overview – Different Approaches to Stacked Waterfall Charts
Option 1 for Excel Stacked Waterfall Chart
Option 2 for Excel Stacked Waterfall Charts – Part 1
Option 2 Continued for Excel Stacked Waterfall Charts
BONUS: Dynamic Deltas in Waterfall
Download Bonus File for Dynamic Deltas
Final Words & Cheat Sheets
Final Quiz
Download Waterfall Cheat Sheets HERE
Final Words
Do you use Excel add-ins for your Waterfall or struggle with your data preparation?
Some 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.
Here’s the problem though when working with waterfall chart add-ins:
We update the data and forget to re-run or “refresh†the add-in (unfortunately this happens more than we’d like)
Management likes to slightly change the visualization provided by the add-in (unfortunately we’re not flexible enough to change this)
Management requests other complex variations of the waterfall chart
Our add-in doesn’t work with the latest version of Excel
That’s why it pays off to KNOW how to create waterfalls charts from scratch!
Excel Version
You can take this course no matter which Excel version you have. The course is created 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.
Great information & love the ability to move along and practice myself whilst watching. Some of it is high paced, however, clicking back and pausing helps me follow along. Probably 1 of the best Excel graph chart training videos I’ve come across, learnt a great deal. Thanks John
– John Bostock
