Tabellab
Free course Beginner

Excel for Finance

The formulas every finance job uses, practised in a live spreadsheet that checks your work.

8 lessons 8 labs 1.6 h Certificate

This course is free, including the certificate. Create an account to save your progress.

About this course

This free Excel for finance course teaches the formulas finance and accounting teams use every day: percentages, absolute references, SUM and AVERAGE, IF, SUMIFS and COUNTIFS, VLOOKUP and XLOOKUP, rounding and payment-term dates. Every lesson is a practice exercise in a live spreadsheet that checks your answer instantly, and the course ends with a final exam and a free, verifiable certificate.

Lessons

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