Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Excel Beginner

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.

8 lessons 8 labs 1.9 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

  • Calculate each category's share of revenue with one copyable formula, a budget as a percentage of revenue, and show the shares in a pie chart.
  • Calculate growth per channel, replace #DIV/0! for a new channel with IFERROR, handle a negative base with ABS and find the biggest decline.
  • Raise five prices by different percentages and work backwards from a discounted price and a tax-inclusive price to the original amounts.
  • Calculate markup and margin for five products, then set a price that hits a 40% margin and translate it into a markup.
  • State the change of five rates both in percentage points and in percent, convert a rate cut into basis points and name the right unit.
  • Calculate a revenue-weighted margin with SUMPRODUCT and an overall conversion rate from totals, and see how far a plain AVERAGE is off.
  • Calculate yearly growth and the compound annual growth rate of six years of revenue, project it forward and annualise a monthly rate.
  • Build a sales progress table: % of target per rep, a percent rank, the team's true % of target and a red highlight for everyone below 100%.

About this course

Percentages look simple until a report shows a 300 % drop or an average of averages. This course covers the cases that cause real mistakes. You calculate shares of a total with the right absolute references, measure percent change and handle zero and negative starting values, and increase, decrease or reverse a percentage. Markup and margin are calculated, converted into each other and used to price to a target. You separate percentage points from percent and basis points, average percentages correctly with weights, and annualise growth with CAGR and compounding. The last lab tracks progress against targets with percent rank and conditional formatting. For sales, finance, retail and marketing staff, students and anyone writing reports with percentages.

Curriculum

Course content

8 lessons · 8 labs · 1.9 h · final exam

  1. Percent of Total: Shares, the % Format & Absolute ReferencesLab14 min4 checked tasks
    Unlocked when you buy the course
  2. Percent Change & Growth: the Zero-Base and Negative-Base TrapsLab15 min4 checked tasks
    Unlocked when you buy the course
  3. Increase or Decrease by a %, and Reverse a PercentageLab14 min4 checked tasks
    Unlocked when you buy the course
  4. Markup vs Margin: Calculate, Convert and Price to a TargetLab15 min4 checked tasks
    Unlocked when you buy the course
  5. Percentage Points vs Percent (and Basis Points)Lab12 min4 checked tasks
    Unlocked when you buy the course
  6. Weighted Averages: Averaging Percentages CorrectlyLab13 min3 checked tasks
    Unlocked when you buy the course
  7. CAGR & Annualised Rates: POWER, RRI and CompoundingLab15 min4 checked tasks
    Unlocked when you buy the course
  8. % of Target, Percent Rank & a Progress Table with Conditional FormattingLab15 min4 checked tasks
    Unlocked when you buy the course
  9. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Excel courses →
$9.99one-time payment
Buy course