Skip to main content
HomeExcel

Course

Case Study: Net Revenue Management in Excel

IntermediateSkill Level
4.8+
91 reviews
Updated 05/2024
You will use Net Revenue Management techniques in Excel for a Fast Moving Consumer Goods company.
Start Course for Free

Included withPremium or Teams

ExcelApplied Finance4 hr6 videos24 Exercises1,900 XP3,190Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

Fast Moving Consumer Goods

The world of Fast Moving Consumer Goods (FMCG) is a dynamic world that plays a significant role in our daily lives. Have you ever wondered how well-known brands like Coca-Cola, Nivea, and Lays are being managed? This case study will help you get a better understanding of this industry. You will start by analyzing a big dataset and by performing your own market analysis. You will go from calculating market share to creating clear visuals to reveal actionable insights.

Net Revenue Management

Next, you will use the principles of Net Revenue Management (NRM), which will help you to identify new growth opportunities for your company. You will have to use a variety of Excel tools and functions to calculate the true potential of these growth buckets. You will not only master everything which relates to PivotTables, VLOOKUP, and forecasting but also have a better understanding of what is happening behind the scenes of your favorite FMCG brands. Are you ready to use your Excel skills to build a complete business case?

Prerequisites

Data Analysis in Excel
1

Fast Moving Consumer Goods

Start Chapter
2

Net Revenue Management

Start Chapter
3

Optimizing Net Revenue

Start Chapter
Case Study: Net Revenue Management in Excel
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Enroll Now

Don’t just take our word for it

*4.8
from 91 reviews
92%
7%
0%
0%
1%
  • Michele
    2 days

    Interesting course. I learned so much.

  • ahmed
    9 days

  • Amna
    9 days

    great

  • Muhammad Hairolfahmi
    11 days

  • EBY
    15 days

    super ,

  • Muhammad
    17 days

    It's a perfect course that guides you step by step in understanding the pillars and the necessary KPIs for that case study. Also, I learned how to calculate net sales and gross margin. I knew the promotion analysis and how to select the best promotion plan based on ROI.

"Interesting course. I learned so much."

Michele

ahmed

"great"

Amna

Join over 17 million learners and start Case Study: Net Revenue Management in Excel today!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.