Tabellab
Excel Beginner

Excel for Beginners: Your First Real Spreadsheet

Build a small online shop's sales workbook from scratch – formulas, $ references, IF, SUMIF, XLOOKUP, charts and a mini dashboard – then percent change and running totals, SUMIFS, IF with AND and OR, dates, text formulas, .90 pricing, IFERROR and data validation, repeat customers, pie and stacked charts, top sellers, a 2027 plan and a half-year dashboard: 20 hands-on labs, every cell checked and a certificate at the end.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

Learn Excel by building one real workbook for a small online stationery shop, in 20 short labs that check every cell as you type. The first twenty labs cover the basics: formulas and AutoSum, $ references, SUM, AVERAGE, MIN and MAX, IF, SUMIF and COUNTIF, XLOOKUP, your first column and line charts and a mini dashboard with conditional formatting. The next twelve take the same shop further: percent change and running totals for the second half-year, a category-by-channel table with SUMIFS, gift and packing rules with AND and OR, days to ship from dates, clean product names and SKU codes with text formulas, .90 prices with ROUNDUP, an error-proof order form with IFERROR and data validation, repeat customers, pie and stacked charts, a top-seller podium, a 2027 plan and a final half-year dashboard.

Who this course is for

  • You have never built a spreadsheet of your own.
  • You know how to type into Excel but formulas still feel unclear.
  • You want to learn by building one real workbook, step by step.

Not the right fit if you already use lookups and SUMIFS with confidence: Excel for Finance is the better next step.

Next step: Excel for Finance

Lessons

  1. Your First Workbook: Data, Formulas & AutoSumLabFree
  2. Relative & Absolute References: Shares and a DiscountLab Locked
  3. SUM, AVERAGE, MIN & MAX: Six Months of SalesLab Locked
  4. IF: Let Excel Decide (Reorder & Bonus)Lab Locked
  5. SUMIF & COUNTIF: Totals by CategoryLab Locked
  6. XLOOKUP: Fill In Product and Price AutomaticallyLab Locked
  7. Your First Charts: Column and LineLab Locked
  8. Mid-course project: Mini Dashboard with Profit, Margin & Conditional FormattingLab Locked
  9. Percent Change & Running Totals: July to DecemberLab Locked
  10. SUMIFS & COUNTIFS: A Category × Channel TableLab Locked
  11. IF with AND & OR: Free Gifts and Priority PackingLab Locked
  12. Dates in Excel: Days to Ship & Late OrdersLab Locked
  13. Text Formulas: Clean Product Names and Build SKU CodesLab Locked
  14. Setting Prices: Markup, .90 Endings & MarginLab Locked
  15. An Error-Proof Order Form: IFERROR & Data ValidationLab Locked
  16. Repeat Customers: COUNTIF per Row, Duplicates & Revenue ShareLab Locked
  17. Charts for Parts of a Whole: Pie and Stacked ColumnsLab Locked
  18. Top Sellers: RANK, LARGE & a Bar Chart of All ProductsLab Locked
  19. Planning 2027: Assumptions, ROUND & What-IfLab Locked
  20. Final Project: The Second Half-Year DashboardLab Locked

Questions about this course

What will I build in this Excel beginner course?

A sales workbook for a small online shop: revenue formulas, totals by category, an order form with XLOOKUP, column, line and pie charts, and finally a half-year dashboard that you build on your own.

Which Excel skills does it cover?

Relative and absolute references, SUM, AVERAGE, MIN and MAX, IF with AND and OR, SUMIF, SUMIFS and COUNTIFS, XLOOKUP, dates, text formulas, IFERROR, data validation, RANK and LARGE, and charts.

Do I pay once or every month?

Once. The full course costs $9.90 as a one-time payment, with no subscription. All lessons, labs, the exam and the certificate open right after payment.

Do I need Excel installed?

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

Do I get a certificate?

Yes, if you complete all lessons and pass the final exam of 18 questions with at least 75 %. It confirms that you completed the course; it is not an official, state-recognised or professional qualification.

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy