Business Analytics in Excel
KPIs, pivot-style summaries, rankings, Pareto, trends, statistics, forecasts and cohorts: 8 labs on realistic business data.
Data & Analytics · 5 courses
Data analysis courses in Excel
Excel is still where most business data gets analysed, and these data analysis courses teach you to do it properly: clean the data first, summarise it with formulas you can audit, and test whether a difference is real before you report it. Each course works on one realistic dataset, and every lab is graded cell by cell in a spreadsheet in your browser.
Business Analytics in Excel covers KPIs, pivot-style SUMIFS summaries, rankings, Pareto analysis and cohorts. Data Cleaning & Preparation turns messy exports into analysis-ready tables with TRIM, text-to-number conversions, mapping tables and duplicate checks. Business Statistics & Regression explains standard errors, confidence intervals, hypothesis tests and regression without heavy theory. Forecasting & Time-Series Analysis builds a seasonal 12-month forecast and measures its accuracy with MAPE, and Survey & Customer Feedback Analysis works through Likert scales, NPS, cross-tabs, weighting and significance tests. The courses suit analysts, controllers, marketers and students who need statistics in Excel rather than in a separate tool.
Courses in Data & Analytics
Business Statistics & Regression in Excel
Standard error, confidence intervals, hypothesis tests, two-group comparisons, correlation and regression: 8 labs on realistic business data.
Data Cleaning & Preparation in Excel
Trim, split, convert, map, de-duplicate, fill, flag and validate: 8 labs that turn messy exports into analysis-ready tables.
Forecasting & Time-Series Analysis in Excel
Growth rates, smoothing, seasonal indices, trend × season forecasts, accuracy metrics and driver-based scenarios: 8 labs on one consistent retail dataset.
Survey & Customer Feedback Analysis in Excel
Response rates, Likert scales, NPS, cross-tabs, weighting, margins of error, significance tests and open-text coding: 8 labs on one customer survey.
Guides with worked examples
How to Calculate NPS in Excel: Formula and Example
How to calculate NPS in Excel with COUNTIF and COUNTIFS: promoters minus detractors, a score from −100 to +100 and its margin of error. Excel example.
How to Calculate MAPE in Excel (with MAE, Bias and WAPE)
How to calculate MAPE in Excel step by step, plus MAE, bias, the tracking signal and WAPE for zero or small actuals. Worked example with every formula.
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.
Frequently asked questions
Can I learn data analysis in Excel without Python or SQL?
Yes. Every course here works entirely in a spreadsheet. Python and SQL are useful later, but the ideas, such as cleaning, summarising, testing and forecasting, are the same, and Excel is where most teams share their numbers.
Do I need to know statistics first?
No. Business Statistics starts from samples and the standard error and explains each test with a business question. Basic Excel formulas such as SUM, AVERAGE and IF are enough to begin.
Do the courses use PivotTables?
The labs build pivot-style summaries with SUMIFS and COUNTIFS, which shows exactly what a PivotTable calculates and keeps the result live. If you want to automate real PivotTables, the Excel VBA track has a course on that.
More categories
Open your first lab in under a minute
Free lessons work without an account. Sign up to save your progress.