ExcelExcel for Finance
The formulas every finance job uses, practised in a live spreadsheet that checks your work.
BeginnerCertificate$9.99
Excel
Excel, learned one formula at a time
Watching someone else build a spreadsheet rarely sticks. On Tutorvo you build it yourself: each lesson opens a working grid in your browser, you type the formula, and the checker tells you straight away whether the cell is right, whether you hard-coded a number, and what to try next. The function names and syntax match Microsoft Excel, so the habits you form here transfer directly to the workbook on your desk.
The 33 Excel courses run from a one-hour start for complete beginners to LET, LAMBDA and dynamic arrays. In between you will find focused tracks on lookups, logical functions, dates and times, text cleaning, rounding, conditional formatting, data validation, financial functions and pivot-style summaries built with formulas. Charts and dashboards are part of the programme too, and the checker looks at the chart you insert, not just the numbers behind it.
Courses in Excel
Excel
ExcelExcel Essentials: Beginner to Advanced
From your first formula to lookups, text, dates and SUMIFS: 10 hands-on labs, every cell checked instantly.
BeginnerCertificate$9.99
ExcelAdvanced Excel Formulas & Functions Masterclass
Two-way and multi-criteria lookups, SUMPRODUCT, array maths, text, date, statistical and financial formulas – 10 hands-on labs ending with a broken report you repair, every cell checked instantly.
AdvancedCertificate$9.99
ExcelExcel Charts & Data Visualization
Column, bar, line, pie, stacked, combo, scatter, histogram and waterfall charts plus conditional formatting and sparklines: 10 hands-on labs, every chart checked by the Coach.
BeginnerCertificate$9.99
ExcelWhat-If Analysis: Scenarios, Data Tables & Goal Seek
Build input-driven models, scenario selectors, one- and two-variable data tables, goal seek by bisection, break-even solving, tornado charts and a Monte-Carlo-style simulation, every cell checked live.
IntermediateCertificate$9.99
ExcelExcel Dashboards & Reports
Plan KPIs, build KPI cards with traffic-light rules, trend, ranking and target charts, sparklines and a month picker with INDEX/MATCH: 8 hands-on labs on one company's sales data, every chart checked by the Coach.
IntermediateCertificate$9.99
ExcelExcel Basics in 60 Minutes
Never used Excel? Six short, friendly labs: cells, your first formulas, SUM and AVERAGE, copying formulas, percentages and IF, and a mini budget with your first chart. Every cell is checked as you go.
BeginnerCertificate$9.99
ExcelGoogle Sheets for Business
Tidy shared tables, SUMIFS reports, lookups, validation, conditional formatting and a team tracker: 8 hands-on labs with Excel-compatible formulas that work the same in Google Sheets.
BeginnerCertificate$9.99
ExcelExcel for Accountants: Reconciliations, Ledgers & Month-End
Build a trial balance from a GL export, map accounts to the statements, match a bank reconciliation, age receivables, run prepayment, accrual and depreciation schedules, flag budget variances and check intercompany balances: 8 hands-on labs on one company's month-end.
IntermediateCertificate$9.99
ExcelExcel IF & Logical Functions: From Simple IF to IFS, SWITCH & Nested Logic
Master IF, AND, OR, NOT, nested IF, IFS, SWITCH, XLOOKUP tiers, text and date tests and error handling in 8 hands-on labs built on one company, every cell checked instantly.
BeginnerCertificate$9.99
ExcelExcel Dates & Times: DATE, EOMONTH, NETWORKDAYS, Time Math & Schedules
Master serial dates, DATE and TEXT, EDATE and EOMONTH, NETWORKDAYS and WORKDAY with holidays, DATEDIF and YEARFRAC, week numbers, overnight shifts, overtime timesheets and a project schedule in 8 hands-on labs, every cell checked instantly.
BeginnerCertificate$9.99
ExcelExcel Lookup Masterclass: XLOOKUP, INDEX/MATCH, VLOOKUP & Two-Way Lookups
Exact and approximate VLOOKUP, XLOOKUP match and search modes, INDEX/MATCH left lookups, two-way and multiple-criteria lookups, wildcards and an error-proof report in 8 hands-on labs at one company, every cell checked instantly.
IntermediateCertificate$9.99
ExcelExcel Text Functions: LEFT, MID, FIND, SUBSTITUTE & Clean Data
LEFT, RIGHT, LEN, FIND vs SEARCH, MID between delimiters, SUBSTITUTE and REPLACE, TRIM and PROPER, TEXTJOIN, TEXT formats and name, email and code splitting in 8 hands-on labs at one shop, every cell checked instantly.
BeginnerCertificate$9.99
ExcelExcel Data Validation & Error-Proof Templates
Number, date, list, dependent-list, text-pattern, duplicate and cross-field rules as check formulas, plus an input form with error messages, completeness tracking and a protection checklist: 8 hands-on labs on one wholesaler's templates.
IntermediateCertificate$9.99
ExcelExcel Conditional Formatting: Highlight Rules, Data Bars & Heat Maps
Highlight, top/bottom, average, duplicate and unique rules, colour-scale heat maps, data bars, formula-style rules, rule order and a KPI table with sparklines: 8 hands-on labs on one café chain's data, every rule checked by the Coach.
BeginnerCertificate$9.99
ExcelExcel Financial Functions: PMT, IPMT, NPV, XNPV, IRR, XIRR & RATE
FV, PV, PMT, IPMT/PPMT amortisation, RATE, NPER, NPV vs XNPV, IRR vs XIRR vs MIRR, depreciation, EFFECT/NOMINAL and an investment dashboard: 8 hands-on labs at one company, every cell checked instantly.
IntermediateCertificate$9.99
ExcelExcel Statistical Functions: AVERAGEIFS, MEDIAN, PERCENTILE, RANK & FREQUENCY
Mean, median and mode, AVERAGEIFS/MAXIFS/MINIFS, STDEV and IQR, percentiles and quartile bands, RANK and top-N, frequency histograms, correlation and z-scores, outlier flags: 8 hands-on labs on one sales team, every cell checked instantly.
IntermediateCertificate$9.99
ExcelSUMPRODUCT & Array Formulas: Multi-Condition Sums, Counts and Lookups
Weighted totals, the double unary, AND vs OR logic, partial-text criteria, distinct counts, two-way sums, conditional MAX/MIN with position lookups and a weighted scorecard: 8 hands-on labs at one coffee roaster, every cell checked instantly.
AdvancedCertificate$9.99
ExcelExcel Formula Errors & Auditing: #N/A, #VALUE!, #REF! and How to Fix Them
Repair broken reports: #DIV/0!, #N/A, #VALUE!, #REF!, #NAME? and #NUM!, classify errors with ISNA and ISERR, find totals that silently don't add up and build check cells with red flags, in 8 hands-on labs at one company.
IntermediateCertificate$9.99
ExcelExcel Rounding & Precision: ROUND, MROUND, CEILING, Currency & Floating-Point Traps
ROUND vs number formats, ROUNDUP/TRUNC/INT with negatives, MROUND and CEILING for prices, cases and time, VAT per line vs per invoice, penny allocation, floating-point comparisons and percentages that add to 100%, in 8 hands-on labs at one roastery.
IntermediateCertificate$9.99
ExcelExcel Invoice & Quote Templates: Line Items, Tax, Numbering & Payment Tracking
Build a self-calculating invoice system for a small print shop: line items and discounts, price-list lookups with bulk prices, tax per rate, invoice numbers with TEXT, due dates with WORKDAY and EDATE, quote-to-invoice deposits, a payment log with open balances and a customer statement with ageing, in 8 hands-on labs.
IntermediateCertificate$9.99
ExcelSorting & Filtering with Formulas: Top-N Lists, Dynamic Rankings & Extracts (No FILTER Needed)
Rank with ties and tie-breakers, build top and bottom lists with LARGE and SMALL, extract matching rows with a k-th match helper, pull distinct lists and sort text with COUNTIF "<" ranks, then finish with a dynamic leaderboard and chart: 8 hands-on labs with classic formulas that work in every Excel version.
IntermediateCertificate$9.99
ExcelExcel Time Intelligence: MTD, YTD, YoY, Rolling 12 Months & Fiscal Years
Build the time comparisons every management report needs with plain Excel formulas: month keys with EOMONTH, MTD and YTD windows with SUMIFS, prior-year YTD with EDATE, YoY growth, rolling 12 months, April fiscal years and quarters, like-for-like store growth and a KPI page with a current vs prior year chart, in 8 hands-on labs checked cell by cell.
IntermediateCertificate$9.99
ExcelExcel Named Ranges & Readable Models: Constants, Names and the Name Box
Replace $B$1 with TaxRate: use named constants, name ranges in the Name box, look up in named tables, drive scenarios from a named assumption block, follow Excel's naming rules, refactor a cell-reference model and build a named-range dashboard with a chart, in 8 hands-on labs checked cell by cell.
IntermediateCertificate$9.99
ExcelExcel Trackers: Habit, Task, Expense & Goal Trackers with Formulas
Build the trackers people actually use: a habit grid with streaks, a to-do list with overdue flags, an expense tracker with SUMIFS and budget vs actual, reading and savings goals with pace and months to goal, a workout log with personal bests, a mini-Gantt with formula rules and a dashboard, in 8 hands-on labs.
BeginnerCertificate$9.99
ExcelExcel Dynamic Arrays: FILTER, SORT, UNIQUE, SEQUENCE & Spill Ranges
Let one formula fill a whole table: spill ranges and #SPILL!, SORT and SORTBY with several keys, FILTER with AND/OR and an if-empty message, UNIQUE distinct lists and counts, SEQUENCE date series and calendars, A1# spill references, VSTACK/TAKE/CHOOSECOLS reports and a top-N dashboard with a chart: 8 hands-on labs, graded instantly.
IntermediateCertificate$9.99
ExcelExcel LET & LAMBDA: Readable Formulas, Custom Functions & MAP/REDUCE
Name intermediate results with LET, build your own functions with LAMBDA, use named LAMBDAs like built-ins, summarise rows and columns with BYROW/BYCOL, apply custom logic with MAP, run totals and compounding with SCAN and REDUCE, generate grids with MAKEARRAY and refactor a nested formula: 8 hands-on labs, graded instantly.
AdvancedCertificate$9.99
ExcelPivot-Style Summary Reports with Formulas: UNIQUE, SUMIFS, Cross-Tabs & Subtotals
Learn what a PivotTable does and rebuild every part with live formulas: UNIQUE/SORT row labels, SUMIFS values over spilled labels, a rows × columns cross-tab with TRANSPOSE, % of row, column and grand total, counts, averages and distinct counts, report filters with (All), month and quarter grouping, a SUBTOTAL report and charts: 8 hands-on labs, graded instantly.
IntermediateCertificate$9.99
ExcelPercentages in Excel: Percent Change, % of Total, Markup vs Margin & CAGR
How to calculate percentages in Excel the right way: shares with absolute references, growth without #DIV/0!, reverse percentages, markup vs margin, percentage points, weighted averages, CAGR and a % of target table. 8 graded labs.
BeginnerCertificate$9.99
ExcelExcel Calendars & Schedules: Dynamic Monthly Calendar, Shift Rota & Gantt with Formulas
Build the schedules teams actually print and share: a monthly calendar that redraws from one date, weekends, closed days and today in colour, ISO weeks, working days and paydays, a 4-on-4-off rota from one pattern, hours and overtime, a daily Gantt with progress bars, a milestone status board and a yearly planner with a chart, in 8 hands-on labs.
BeginnerCertificate$9.99
ExcelLoan Amortization Schedules in Excel: PMT, IPMT, PPMT, Extra Payments & Balloons
Build a real amortization schedule step by step: PMT and the sign convention, a full schedule copied down to zero, IPMT/PPMT and CUMIPMT/CUMPRINC for any month or year, extra monthly payments, lump sums and recasting, balloon loans, interest-only periods and an APR comparison with a balance chart. 8 hands-on labs, every cell checked. Educational only, not financial advice.
IntermediateCertificate$9.99
ExcelWeighted Scoring Models in Excel: Decision Matrices, Normalisation & Sensitivity
Weights that add up, min-max normalisation, SUMPRODUCT scores, knock-out criteria, pairwise (AHP-style) weights, sensitivity, evaluator panels and a decision dashboard: 8 labs for vendor selection, hiring and project prioritisation.
IntermediateCertificate$9.99
ExcelCombining Tables in Excel: VSTACK, HSTACK, Lookups, GROUPBY & Reconciliation
Turn monthly files and regional exports into one live table: VSTACK and DROP for stacking, HSTACK for a source column, XLOOKUP to merge columns, missing records in both directions, UNIQUE de-duplication, GROUPBY summaries, reconciliations with a formula rule and a combined dashboard chart: 8 hands-on labs, graded instantly.
IntermediateCertificate$9.99
Guides with worked examples
SUMIFS Examples: Sum with Multiple Criteria in Excel
SUMIFS examples with real data: two criteria, a date range, greater than, wildcards, "not equal" and COUNTIFS, plus the mistakes that return 0.
XLOOKUP vs VLOOKUP: Differences and When to Use Each
XLOOKUP vs VLOOKUP side by side: exact match defaults, lookups to the left, not-found values, approximate matches and compatibility, with a worked example.
How to Make a Waterfall Chart in Excel (2 Methods)
How to make a waterfall chart in Excel: the built-in chart with Set as Total, and the stacked-column method for older Excel. Example with formulas.
How to Make a Histogram in Excel: Bins, Chart & COUNTIFS
How to make a histogram in Excel: the built-in chart with bin width and overflow bins, a COUNTIFS bin table, FREQUENCY and the ToolPak. Excel example.
Excel Dashboard Tutorial: KPI Cards, Charts & a Month Picker
Excel dashboard tutorial in six steps: plan the KPIs, build KPI cards with INDEX/MATCH and SUMIFS, a month picker, trend and target charts, sparklines.
Nested IF vs IFS in Excel: Examples and When to Use Each
Nested IF vs IFS in Excel with a worked example: grade bands, commission tiers, why the order of tests matters, the TRUE fallback and XLOOKUP.
Frequently asked questions
Do I need a copy of Microsoft Excel?
No. The labs run in a spreadsheet inside your browser, so any laptop, tablet or phone works. Formulas use Excel names and syntax, so what you practise works the same in Excel and in Google Sheets.
I have never used a spreadsheet. Where do I begin?
Take Excel Basics in 60 Minutes first, then Excel Essentials. Once SUM, IF and cell references feel natural, move on to Excel for Finance and the lookup and logic courses.
How much does a course cost?
Each course is a single purchase of $9.99. That covers every lesson and lab, the final exam and the certificate, with no subscription and nothing that renews.
More categories
Ready to learn by doing?
Start with the recommended course and build your first result in the lab today.