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.
- 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
- Your First Workbook: Data, Formulas & AutoSumFree
- Relative & Absolute References: Shares and a Discount Locked
- SUM, AVERAGE, MIN & MAX: Six Months of Sales Locked
- IF: Let Excel Decide (Reorder & Bonus) Locked
- SUMIF & COUNTIF: Totals by Category Locked
- XLOOKUP: Fill In Product and Price Automatically Locked
- Your First Charts: Column and Line Locked
- Mid-course project: Mini Dashboard with Profit, Margin & Conditional Formatting Locked
- Percent Change & Running Totals: July to December Locked
- SUMIFS & COUNTIFS: A Category × Channel Table Locked
- IF with AND & OR: Free Gifts and Priority Packing Locked
- Dates in Excel: Days to Ship & Late Orders Locked
- Text Formulas: Clean Product Names and Build SKU Codes Locked
- Setting Prices: Markup, .90 Endings & Margin Locked
- An Error-Proof Order Form: IFERROR & Data Validation Locked
- Repeat Customers: COUNTIF per Row, Duplicates & Revenue Share Locked
- Charts for Parts of a Whole: Pie and Stacked Columns Locked
- Top Sellers: RANK, LARGE & a Bar Chart of All Products Locked
- Planning 2027: Assumptions, ROUND & What-If Locked
- Final Project: The Second Half-Year Dashboard 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.