Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Business & Operations Intermediate

Sales & Marketing Analytics in Excel

Measure funnels, campaign ROI, pipeline forecasts, commissions, discounts, RFM segments, A/B tests and shop KPIs in real spreadsheets, with every cell checked as you go.

8 lessons 8 labs 1.8 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.

  • Turn Fernway Outdoor's shop funnel into step conversion rates, find the leakiest step and size the prize of fixing checkout.
  • Compare five marketing channels and find the one that looks fine on ROAS but loses money.
  • Weight every open deal by its stage probability and build the Q2 forecast and pipeline coverage.
  • Calculate each rep's quota attainment and pay their commission from a tier table with an approximate-match lookup.
  • Test a 15% promotion on Fernway's best-selling tent and work out how many more units it must sell just to keep the same profit.
  • Score twelve customers on recency, frequency and spend, then find the Champions and how much revenue they bring.
  • Read out a checkout A/B test: conversion rates, relative lift and whether the difference is likely to be real.
  • Build Fernway's quarterly KPI block: average order value, return rate, repeat customer rate and net revenue per customer.

About this course

Marketing and sales teams sit on plenty of data but often lack a quick way to turn it into decisions. This course provides eight practical analyses. You measure funnel conversion and drop-off, compare campaigns on CTR, CPA, ROAS and ROI, and build a weighted pipeline forecast with lookups and SUMPRODUCT. Quota attainment feeds a tiered commission, and a discount lab calculates how much extra volume is needed to protect margin. You segment customers by recency, frequency and monetary value, evaluate an A/B test with lift and a simple z-test, and track online shop KPIs such as order value, return rate and repeat buyers. For marketers, sales analysts and business students.

Curriculum

Course content

8 lessons · 8 labs · 1.8 h · final exam

  1. Funnel Conversion Rates and Drop-offLab12 min5 checked tasks
    Unlocked when you buy the course
  2. Campaign Metrics: CTR, CPA, ROAS and ROILab14 min5 checked tasks
    Unlocked when you buy the course
  3. Weighted Pipeline Forecast with XLOOKUP and SUMPRODUCTLab15 min4 checked tasks
    Unlocked when you buy the course
  4. Quota Attainment and Tiered CommissionLab14 min4 checked tasks
    Unlocked when you buy the course
  5. Discounts, Margin and the Volume You NeedLab13 min4 checked tasks
    Unlocked when you buy the course
  6. RFM Segmentation: Recency, Frequency, MonetaryLab15 min4 checked tasks
    Unlocked when you buy the course
  7. A/B Test Results: Lift and a Simple z-TestLab14 min4 checked tasks
    Unlocked when you buy the course
  8. E-commerce KPIs: AOV, Return Rate and Repeat CustomersLab12 min4 checked tasks
    Unlocked when you buy the course
  9. 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 Business & Operations courses →
$9.99one-time payment
Buy course