Description
The Ultimate Excel Waterfall Chart Course is published by Udemy Academy. Waterfall charts or bridge charts provide a good visual for management reports. In this lesson, you will learn how to include different variations of the waterfall chart in your reports. No VBA or Add-ins required. A waterfall chart or bridge chart is a very popular management chart. They provide an effective way to visualize your data that helps you understand how you got from one value to another. They are mostly used for financial figures that allow you to see your profit development, how you went from gross sales to net income, or how your revenues have increased from last year to this year.
But they are also a good view for non-financial data. Many people use Excel add-ins to create waterfall charts. Because these plugins create suitable conditions for the correct preparation of data for charts. On the other hand, sometimes plugins can’t do exactly what you want and for some charts you might want to do it from scratch. You may also be interested to know what is the best way to create a waterfall chart from scratch. You can take this course regardless of which version of Excel you have. This course is done in Excel 2016, but you can also have your own version. Everything can be recreated in older versions of Excel 2007, 2010 and 2013, except for the new Excel 2016 waterfall chart. Whenever I use a technique that is available in a particular version of Excel, I will explain it in the video. You don’t have to worry about compatibility when you share your charts.
What you will learn
- Include the dramatic and dynamic changes of the waterfall chart in your management reports
- Create a standard waterfall chart from scratch (which also works with negative values)
- Download the Excel template and use it for your reports.
- Optimize the waterfall diagram for presentations
- Create vertical waterfall charts from scratch (which also work with negative values)
- Creating Stacked Waterfall Charts
- Learn advanced Excel charting techniques that you can use in other charts to enhance your reports.
Who is this course suitable for?
- You want to learn how to create different variations of a waterfall chart in Excel.
- Financial analysts and controllers
- People responsible for preparing management reports
- People interested in learning new Excel techniques to create impressive charts
Details of the Ultimate Excel Waterfall Chart Course
- Publisher: Udemy
- teacher : Leila Gharani
- English language
- Education level: all levels
- Number of courses: 34
- Training duration: 5 hours and 7 minutes
Chapters of the Ultimate Excel Waterfall Chart Course
Course prerequisites
-
Existing experience and knowledge of Excel’s basic charting options and formulas
-
Demonstration will be done in Excel 2016 but all charts can be created in older versions of Excel unless otherwise specified
-
Depending on your Excel version, the chart options can be accessed differently, that is why familiarity with Excel charts is recommended
Pictures
Sample video
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
1.29 GB
Be the first to comment