Year-to-Date
The dataset contains unit and value sales per month for all years from 2018 to 2023. You would however like to look at different time periods to calculate your KPI's. Let's calculate the Year-To-Date (YTD) for all the dataset points in this exercise.
If you lost progress, close any open reports and load 1_3_year-to-date.xlsx
from the Workbooks folder.
This exercise is part of the course
Case Study: Net Revenue Management in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
