Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Excel Beginner

Excel Essentials: Beginner to Advanced

From your first formula to lookups, text, dates and SUMIFS: 10 hands-on labs, every cell checked instantly.

10 lessons 10 labs 2.7 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.

  • Price an office-supply order: line totals, a subtotal and the total including sales tax.
  • Build a price list with one markup cell and a commission table that works when copied in both directions.
  • Summarise monthly revenue for 12 stores, two of which have not reported yet.
  • Flag unpaid invoices, set priorities, sort them into aging buckets and stop a #DIV/0! error.
  • Complete 8 sales orders by looking up product, price, category and shipping rate from two reference tables.
  • Turn a messy customer export into clean names, split customer codes and build a readable label.
  • Turn an export with separate year/month/day columns into real dates and calculate renewal and due dates for 6 contracts.
  • Summarise a 20-row sales ledger by region and product, the formula version of a PivotTable.

About this course

This is a full workout for everyday Excel, from typing the first value to delivering a monthly report. Over ten labs you enter data and write formulas, then see why relative, absolute and mixed references behave differently when copied. You summarise numbers with SUM, AVERAGE, COUNT and MEDIAN, make decisions with IF, AND, OR, IFS and IFERROR, and retrieve values with VLOOKUP, HLOOKUP, INDEX/MATCH and XLOOKUP. Text functions tidy names and codes, date functions calculate deadlines and working days, and SUMIFS, COUNTIFS and AVERAGEIFS answer multi-condition questions. A data cleaning lab splits codes, fixes case and converts text to numbers, and the final project builds a monthly sales report. For beginners who want to reach a confident intermediate level.

Curriculum

Course content

10 lessons · 10 labs · 2.7 h · final exam

  1. Entering Data & Your First FormulasLab12 min4 checked tasks
    Unlocked when you buy the course
  2. Relative, Absolute & Mixed ReferencesLab14 min4 checked tasks
    Unlocked when you buy the course
  3. Math & Stats Functions: SUM, AVERAGE, COUNT, MEDIANLab13 min5 checked tasks
    Unlocked when you buy the course
  4. Logical Functions: IF, AND, OR, IFS, IFERRORLab15 min4 checked tasks
    Unlocked when you buy the course
  5. Lookups: VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUPLab18 min4 checked tasks
    Unlocked when you buy the course
  6. Text Functions: LEFT, MID, TRIM, PROPER, TEXT & JoiningLab15 min4 checked tasks
    Unlocked when you buy the course
  7. Date Functions: DATE, EDATE, EOMONTH, NETWORKDAYSLab15 min4 checked tasks
    Unlocked when you buy the course
  8. SUMIFS, COUNTIFS & AVERAGEIFSLab16 min5 checked tasks
    Unlocked when you buy the course
  9. Data Cleaning: Split Codes, Fix Case, Convert Text to NumbersLab17 min4 checked tasks
    Unlocked when you buy the course
  10. Final Project: Monthly Sales ReportLab25 min5 checked tasks
    Unlocked when you buy the course
  11. 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