From the course: Excel for Business Analysts
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Growing revenue with business analytics - Microsoft Excel Tutorial
From the course: Excel for Business Analysts
Growing revenue with business analytics
- [Instructor] A big part of business analytics is simply being able to do modeling to understand the different results the business is going to face. That could be in the form of financial modeling like for sales or profits. It could be in the form of operations to understand say deliveries or production constraints or it could be in the form of marketing. There's a variety of different areas where this type of modeling will come up. But regardless of your functional area, Excel can help with this. I'm in the 04 04 Begin Excel file. Now what we have here is a simple set of financial statements and a budget for a firm, right? And this is all hypothetical, but we're at a point at the end of 2020, and the firm is trying to figure out what they want to do going forward in 2021 because they have a little bit of a problem. They've been losing money so far. And while they had plenty of cash to start with, they're bleeding…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Examining financial data4m 27s
-
(Locked)
Waterfall charts in Excel3m 35s
-
(Locked)
Competitor analysis and benchmarking5m 21s
-
(Locked)
Growing revenue with business analytics6m 18s
-
(Locked)
Business strategy and business analytics3m 53s
-
(Locked)
Product pricing with business analytics5m 41s
-
(Locked)
Price, volume, and sensitivity analysis6m 10s
-
(Locked)
Controlling costs in business4m 54s
-
(Locked)
-
-