Excel Waterfall Chart Course
4.5 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
8 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Waterfall Chart Course to your Wishlist.

Add to Wishlist

Excel Waterfall Chart Course

Create an Excel 2016 Waterfall Chart in under 35 minutes. No VBA or Add-ins needed.
4.5 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
8 students enrolled
Last updated 9/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 31 mins on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Ability to make waterfall charts in Excel 2016
  • Ability to use these charts for your own business and personal use
View Curriculum
Requirements
  • Excel 2016 is an absolute mandatory requirement for this course- This course will not work on prior versions of Excel
Description

This Excel 2016 course for business users will show you how to make a waterfall chart (also known as bridge chart) in under 35 minutes. 

• A waterfall chart is a chart where you start from the left hand side and as you go to the right, your figures get broken down until you reach your end data point on the chart.

• They are very easy to read and clearly show your figures.

• We will focus on two variations of this chart - for business and personal use.

This course will walk you through using Excel 2016's waterfall chart feature along with some expert tips on how to make a perfect waterfall chart for your business/personal use.

This course assumes a beginners to intermediate level use of Excel. Support is given via the discussion forums and all workbooks are provided.

I look forward to seeing you on the other side!

Who is the target audience?
  • Users with a business who want to document their expenses and income
  • Users who have a beginners to intermediate level use of Excel
  • Users with a project management background would find this useful for illustrating performance
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Introduction to Excel course
1 Lecture 02:18

Lecture introduces course

Preview 02:18
+
Excel workbook materials
1 Lecture 00:10

This section provides the Excel workbook materials needed to help you on the course.

Excel workbook materials
00:10
+
Overview of Excel chart we are going to build
1 Lecture 05:15
+
Monthly sales changes Excel chart
1 Lecture 07:11

Lecture shows you how to make a waterfall chart for changes in sales per month

Preview 07:11

Quiz on waterfall chart basics

Waterfall basics quiz
3 questions
+
Personal expense and income Excel chart
1 Lecture 06:45

Lecture shows you how to make a personal expenses chart

Making the personal expense and income Excel chart
06:45
+
Monthly business expenses and income Excel chart
1 Lecture 03:15

Lecture shows you how to make a monthly expense/income chart

Making the Excel monthly business expense/income chart
03:15
+
Using the Excel waterfall method for a total revenue statement
1 Lecture 05:16

This lecture shows you a waterfall chart with 3 totals. An example using a simulated total revenue statement is given.

Making an Excel waterfall chart with 3 totals
05:16
+
The end!
2 Lectures 02:57

Wrap up lecture

End lecture
00:45

Bonus lecture- Discounts to our other Excel courses
02:12
About the Instructor
Mach 42 Productions
4.3 Average rating
549 Reviews
16,742 Students
13 Courses
Excel Consulting- 16,700+ Students

Our Udemy Excel courses have been developed to cover a wide range of needs for the Excel user. There is a course to suit everyone from beginners level to advanced. We provide all workbooks and full support via the discussion forums. Simply put our Excel courses use real life examples and not just theory to help you learn and improve yourself and give you proper skills you can use in your workplace.

Our Excel IT Consultant/Instructor Navin has been in the IT industry for approximately ten years. Recently featured nationwide in Costco Magazine, Navin has over 6 years experience as an Analyst. Having self-taught himself Microsoft Excel and VBA, he achieved MCAS (now known as Microsoft Office Specialist) certification in Excel in 2010. His work in Excel has been varied having worked on automating and streamlining reports to building and deploying real time dashboards to monitor performance.

During his time as an Analyst, he often assisted colleagues who needed problems solved in Excel. By relating the functions to use, to the context of their problem, his colleagues were able to grasp the concepts of what functions to use and in what context.

This spurned Navin's need to develop these range of Excel courses which to date have over 16,700 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.