Explanation
Waterfall graphs or bridge charts provide good visualizations for Management Reports. In this course you will learn how to add a variation of the Waterfall Chart to your reports. No VBA or Add-ins required. Would you like to impress your management and colleagues by introducing new techniques to create simple and effective Waterfall charts? Then this course is for you! A waterfall chart or bridge chart is a chart that is very popular with management. For good reason too. They provide an effective way to visualize your data to help you understand how you got from one balance to another. They are common in financial figures – they allow you to see the progress of profits – how you got from gross sales to net income or how your income has improved from last year to this year. But it’s also a good story for non-financial data.
Many people use Excel add-ins to create Waterfall charts. What is the reason? Because they save frustration and headaches from preparing data correctly in charts. On the downside, sometimes add-ons don’t do exactly what you’d like and some charts you might want to scratch. You may also be interested in knowing the best way to create Waterfall charts from scratch in Excel. If you are, this is the course for you! You can take this course regardless of the version of Excel you have. The course is in Excel 2016 but you can also follow your own version. Everything can be restored in the previous version of Excel – 2007, 2010 & 2013, except of course the new waterfall chart in Excel 2016. Every time I use a technique that is available in a particular version of Excel, I mention it in the video. You don’t have to worry about compatibility when you share your charts. Something you need to worry about if you use a water level chart in Excel 2016.
What will you learn?
-
Add the stunning & dynamic variation of the Waterfall chart to your Management Reports
-
Create a Waterfall Chart from scratch (which also works with negative values)
-
Download the Excel Template and use it now for your reports
-
Adjust the Waterfall chart for presentations
-
Create vertical Waterfall charts from scratch (which works with negative values too)
-
Create overlapping Waterfall charts
-
Learn the above charting techniques in Excel that you can apply to your other charts to improve your reports.
Who is this course for?
- You want to learn how to create different types of Waterfall charts in Excel
- Financial Analysts & Controllers
- Persons responsible for the preparation of Management Reports
- People who are interested in learning new Excel techniques to create amazing charts
Especially the Ultimate Excel Waterfall Chart Course
- Publisher: Udemy
- Teacher: Leila Gharani
- Language : English
- Level: All levels
- Number of courses: 34
- Duration : 5 hours and 7 minutes
The Ultimate Excel Waterfall Chart Course Contents
Requirements
-
Existing experience and knowledge of basic Excel charting options and formats
-
Demonstrations will be done in Excel 2016 but all charts can be created in older versions of Excel unless otherwise specified.
-
Depending on your version of Excel, chart options are available differently, which is why knowledge of Excel charts is recommended.
Pictures
Sample Clip
Installation Guide
Extract files and watch your favorite player
Subtitle : English
Quality: 720p
Download Links
Password file: free download software
file size
1.29 GB