Percent Change & Growth: the Zero-Base and Negative-Base Traps
This lesson is part of the course
In this lesson
You calculate growth per channel, replace #DIV/0! for a new channel with IFERROR, handle a negative base with ABS and find the biggest decline.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Percent of Total: Shares, the % Format & Absolute References Locked
- Percent Change & Growth: the Zero-Base and Negative-Base Traps Locked
- Increase or Decrease by a %, and Reverse a Percentage Locked
- Markup vs Margin: Calculate, Convert and Price to a Target Locked
- Percentage Points vs Percent (and Basis Points) Locked
- Weighted Averages: Averaging Percentages Correctly Locked
- CAGR & Annualised Rates: POWER, RRI and Compounding Locked
- % of Target, Percent Rank & a Progress Table with Conditional Formatting Locked