2 years ago

XelplusVis Advanced Excel charts Microsoft Excel Tutorials excel for Controllers and managers Data Visualization in Excel Excel for business analysts excel graphs Leila Gharani Excel 2016 Excel 2016 Waterfall Waterfall Graph

Oct 27, 2016
For the complete course click here: https://courses.xelplus.com/

Excel Waterfall Chart Tutorials show you how to design any Waterfall Chart in Excel - In ANY version of Excel too.
Ultimate Excel Waterfall Chart course summary:

A waterfall or a bridge chart is a way of visualizing data that explains the movement from one balance to another balance. They are common in corporate reports – because they help to easily visualize the factors that are responsible for the change – for example how you got from gross sales to net income or how your profit developed from last year to this year. But they are also a good story teller for non-financial data.

In this course you will learn to create different impressive variations of the waterfall from scratch.

By the end of this course, you will be able to create your own customized variation of the waterfall chart which you can include in your corporate reports. You’re also going to learn a handful of useful tricks which you can use to create other amazing charts.
Your colleagues and management will certainly be impressed.
Here is an overview of the topics covered:
- Shortcomings of Excel 2016 in-built Waterfall Chart
- How to create the easiest Waterfall Chart EVER – (No stacked columns - works with negative values as well)
- How to add sub-totals to the waterfall chart
- Real business examples of Waterfall charts
- How to overcome real-world issues such as
- Long category labels on the horizontal axis
- Adding dynamic connectors to improve readability
- How to deal with very small delta values
- Vertical Waterfall chart (bar version of the Waterfall) and creating them in impressive ways
- Over 4 hours of Waterfall variations
- Workbook included and Cheat sheets to be uploaded soon

In this training I’m going to cover different alternatives for creating the waterfall chart. One alternative is obviously the new Excel 2016 standard waterfall, but as we dig deeper we will come across many limitations which will lead us to create it from scratch. That’s why you can take this course, no matter which Excel version you have.

The target audience for this course is anyone who is interested in creating different variations of the waterfall in Excel. You might be a controller, financial analyst, someone responsible for creating corporate reports or you might just be interested to improve your Excel charting skills and want to learn advanced tricks to create impressive graphs.

Other Chart videos:
https://youtu.be/9y2OubgWhpE
https://youtu.be/cYHOezDL8SQ
https://youtu.be/FPxCKs4OlWE
https://youtu.be/5nf8rucx80E
https://youtu.be/_U2gbLmEwec

Loading comments...