Percentages in Excel: Percent Change, % of Total, Markup vs Margin & CAGR
How to calculate percentages in Excel the right way: shares with absolute references, growth without #DIV/0!, reverse percentages, markup vs margin, percentage points, weighted averages, CAGR and a % of target table. 8 graded labs.
The first 2 lessons are free — no account needed.
About this course
A percentages in Excel course that answers the everyday percentage questions of one fictional outdoor-gear shop, Fernhill Outdoor, in a spreadsheet, for beginners, office staff, small business owners and students who want to get percentages right. You calculate each category's share of revenue with an absolute reference and a pie chart, find the percent change per channel and stop #DIV/0! and negative bases from breaking it with IFERROR and ABS, raise prices by a percentage and work back from a discounted or tax-inclusive price, convert markup into margin and price to a 40% margin, tell percentage points from percent and basis points, average percentages correctly with SUMPRODUCT, calculate CAGR with POWER and RRI and annualise a monthly rate, and finish with a % of target table, a percent rank and conditional formatting. The first two labs are free.
Lessons
- Percent of Total: Shares, the % Format & Absolute ReferencesFree
- Percent Change & Growth: the Zero-Base and Negative-Base TrapsFree
- Increase or Decrease by a %, and Reverse a Percentage Pro
- Markup vs Margin: Calculate, Convert and Price to a Target Pro
- Percentage Points vs Percent (and Basis Points) Pro
- Weighted Averages: Averaging Percentages Correctly Pro
- CAGR & Annualised Rates: POWER, RRI and Compounding Pro
- % of Target, Percent Rank & a Progress Table with Conditional Formatting Pro