Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Data & Analytics Intermediate

Business Analytics in Excel

KPIs, pivot-style summaries, rankings, Pareto, trends, statistics, forecasts and cohorts: 8 labs on realistic business data.

8 lessons 8 labs 2 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 two years of store figures into the four KPIs every manager asks for.
  • Rebuild a PivotTable by hand: revenue by region x month, % of total and a channel summary.
  • Rank 12 outdoor products by revenue, find the leaders and measure how concentrated sales are.
  • Find out which customers carry the business: share, cumulative share and an A/B/C class for each.
  • Analyse 24 months of revenue: month-over-month, year-over-year, a smoothed trend and the budget variance.
  • Describe 20 order values honestly, and spot the one order that distorts the average.
  • Fit a straight-line trend to 12 months of revenue and forecast month 13.
  • Turn a cohort table of active customers into retention rates and two honest summary numbers.

About this course

Most business questions can be answered with a well-organised table and the right formulas. This course trains exactly that. You calculate core KPIs such as growth, margin and average order value, then build pivot-style summaries with conditional sums and counts. Ranking labs find the top performers with lookups. A Pareto analysis classifies products into ABC groups, and variance labs compare month over month, year over year, moving averages and budget against actual. You describe data with medians, spread, percentiles and outliers, forecast with a linear trend and finish by analysing customer cohorts and retention. For managers, junior analysts and anyone who reports numbers at work.

Curriculum

Course content

8 lessons · 8 labs · 2 h · final exam

  1. KPI Basics: Growth, Margin & Average Order ValueLab12 min4 checked tasks
    Unlocked when you buy the course
  2. Pivot-Style Summary Tables with SUMIFS & COUNTIFSLab16 min4 checked tasks
    Unlocked when you buy the course
  3. Top-N & Ranking: RANK, LARGE, INDEX/MATCHLab14 min5 checked tasks
    Unlocked when you buy the course
  4. Contribution & Pareto (ABC) AnalysisLab15 min4 checked tasks
    Unlocked when you buy the course
  5. Variance & Trend: MoM, YoY, Moving Average, Budget vs ActualLab16 min4 checked tasks
    Unlocked when you buy the course
  6. Descriptive Statistics: Median, Spread, Percentiles, OutliersLab15 min4 checked tasks
    Unlocked when you buy the course
  7. Simple Forecasting with a Linear TrendLab15 min5 checked tasks
    Unlocked when you buy the course
  8. Customer Cohorts & RetentionLab17 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 Data & Analytics courses →
$9.99one-time payment
Buy course