Tutorvo

Cell references & percentages

Lesson 1 of 810 minLab

This lesson is part of the course

In this lesson

You calculate a selling price with markup, a discounted price and the sales tax hidden in a gross amount.

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

  1. Cell references & percentagesLab10 min Locked
  2. Absolute references ($)Lab12 min Locked
  3. SUM, AVERAGE, MIN & MAXLab8 min Locked
  4. IF and nested IFLab12 min Locked
  5. SUMIFS & COUNTIFSLab12 min Locked
  6. VLOOKUP & XLOOKUPLab14 min Locked
  7. ROUND & MROUNDLab12 min Locked
  8. Dates, payment terms & early-payment discountLab14 min Locked