Leila Gharani – Ultimate Excel Waterfall Chart (Bridge Chart) Course

*** Proof of Product ***

Exploring the Essential Features of “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

Please see the full list of alternative group-buy courses available here: https://lunacourse.com/shop/