Multi-metric YoY growth dashboard
IntermediateYear-over-year growth helps you compare performance across periods without being distracted by the size of the underlying metric. In real analysis work, that makes it easier to compare revenue, transaction volume, and average order value on the same scale.
In this exercise, you will turn the raw yearly figures into a compact growth dashboard by filling the summary area and then labeling the direction of the trend for each metric.
How YoY growth works
The standard pattern is (current period - prior period) / prior period. The result can be formatted as a percentage to show the growth rate more clearly.
For the trend label, compare the later growth rate to the earlier one for the same metric. Use exactly "Accelerating" or "Decelerating".
Practice
Use the yearly values in the top table to complete the lower summary for Revenue, Transactions, and Average order value.
Calculate the two growth percentages under 2022 - 2023 growth and 2023 - 2024 growth so each result matches the year pair named in its header.
Then fill the Trend column using exactly "Accelerating" or "Decelerating", based on whether the later growth rate is higher or lower than the earlier one for the same metric.
When you're done, the summary section should show two growth percentages for each metric plus a trend label that tells you whether growth sped up or slowed down.
Need some help?
Hint 1
Build the growth percentages first and leave the trend labels for last. If you keep those year references relative instead of locking them with `$`, the same formula pattern can be filled across the summary and then down to the other metrics.
Hint 2
The Trend column should not look back at the raw data table. Compare only the two growth percentages in the same summary row, and use `IF` to return the allowed label based on which one is larger.
Multi-metric YoY growth dashboard
IntermediateYear-over-year growth helps you compare performance across periods without being distracted by the size of the underlying metric. In real analysis work, that makes it easier to compare revenue, transaction volume, and average order value on the same scale.
In this exercise, you will turn the raw yearly figures into a compact growth dashboard by filling the summary area and then labeling the direction of the trend for each metric.
How YoY growth works
The standard pattern is (current period - prior period) / prior period. The result can be formatted as a percentage to show the growth rate more clearly.
For the trend label, compare the later growth rate to the earlier one for the same metric. Use exactly "Accelerating" or "Decelerating".
Practice
Use the yearly values in the top table to complete the lower summary for Revenue, Transactions, and Average order value.
Calculate the two growth percentages under 2022 - 2023 growth and 2023 - 2024 growth so each result matches the year pair named in its header.
Then fill the Trend column using exactly "Accelerating" or "Decelerating", based on whether the later growth rate is higher or lower than the earlier one for the same metric.
When you're done, the summary section should show two growth percentages for each metric plus a trend label that tells you whether growth sped up or slowed down.
Need some help?
Hint 1
Build the growth percentages first and leave the trend labels for last. If you keep those year references relative instead of locking them with `$`, the same formula pattern can be filled across the summary and then down to the other metrics.
Hint 2
The Trend column should not look back at the raw data table. Compare only the two growth percentages in the same summary row, and use `IF` to return the allowed label based on which one is larger.