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.
Controlling costs in business - Microsoft Excel Tutorial
From the course: Excel for Business Analysts
Controlling costs in business
- [Instructor] Business analysts are often asked to look at data and then opine on what might happen under a set of scenarios in the future. Excel can help us with this. Now we all know of course that we can build models to let us see what might happen in a scenario with Excel. But Excel also has scenario analysis tools that lets us go through and examine certain sets of circumstances. Let's take a look. I'm in the 04 08 begin Excel spreadsheet. Now what we've got here is a firm that has set of actual historical data for the last six months of 2020. And then they've got a hypothetical budget plan going forward in 2021. The firm wants to understand what might happen to their profitability at the end of the year. You know, it's a growing company, so they're trying to grow profits over time. They want to understand what might happen to that profitability as they change different things as different factors get changed in…
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)
-
-