Excel for Data Analytics – PDF Workbooks
Excel for Data Analytics as 4 hands-on PDF workbook volumes (2,554 pages, 962 lessons). Every volume has worked labs, quizzes and a full solutions appendix — instant download, free sample in every book.
More: Excel & Business Workbooks · all books
All 4 volumes
What you will learn in Excel for Data Analytics
These workbooks cover 48 complete courses (selection below):
- Excel for Data Entry & Records Clerks: Clean, Check and Match Data
- Business Analytics in Excel
- Business Statistics & Regression in Excel
- Data Cleaning & Preparation in Excel
- Forecasting & Time-Series Analysis in Excel
- Survey & Customer Feedback Analysis in Excel
- A/B Testing & Experimentation
- Data Storytelling with Charts
- Data Analyst Portfolio Projects in Excel
- Regression Analysis for Business in Excel
- Location Analytics in Excel: Distances, Catchments & Territories
- Customer Segmentation: RFM Scoring, Personas & k-Means by Hand
- Bayesian Statistics in Excel: Priors, Posteriors & Bayesian A/B Tests
- Nonparametric Statistics: Rank Tests, Spearman & Bootstrap
- Cross-Tabs & Chi-Square: Analysing Categorical Data in Excel
- Network & Graph Analysis in Excel: Degree, Paths & Centrality
- Customer Churn & Survival Analysis: Hazard Rates, Kaplan-Meier & Retention Curves
- Market Basket Analysis: Support, Confidence, Lift & Cross-Selling
- Causal Inference for Business: Difference-in-Differences, Matching & Natural Experiments
- ANOVA & Experimental Design in Excel: One-Way, Two-Way & Post-Hoc Tests
- Polling & Survey Sampling: Margin of Error, Weighting & Poll Averages
- E-commerce Cohort Analysis: Repeat Purchase, Revenue per Cohort & Payback
- Data Privacy in Practice: Pseudonymisation, k-Anonymity & Re-identification Risk
- Queue Simulation with Spreadsheets: Arrivals, Service Times & Waiting Lines
- Data Modeling Basics: Fact Tables, Dimensions, Keys & Star Schemas
- Competitor Price Monitoring: Price Index, Changes & Promotion Detection
- Forecast Accuracy & Forecast Value Added: MAPE, WAPE, Bias & FVA
- IoT Sensor Data Analysis: Resampling, Thresholds, Drift & Uptime
- Energy Bill & Load Profile Analytics: kWh, Peak Demand & Tariffs
- Education Analytics: Attendance, Grades, Pass Rates & Cohort Progress
- Fraud Detection Rules: Velocity Checks, Rule Scoring & Alert Tuning
- Index Numbers: Laspeyres, Paasche, Fisher & Building a Price Index
- Sample Size & Power Analysis: How Many Observations Do You Need?
- Principal Component Analysis in Excel: Standardise, Covariance, Eigenvectors & Scores
- Data Quality Metrics: Completeness, Validity, Uniqueness, Timeliness & DQ Scorecards
- Survey Weighting: Post-Stratification, Raking (IPF) & Design Effects
- Meta-Analysis in Excel: Effect Sizes, Fixed vs Random Effects & Forest Plots
- Process Mining with Spreadsheets: Event Logs, Case Durations, Variants & Bottlenecks
- Prioritisation Surveys: Ranking Questions, Best–Worst Scaling, TURF Reach & Kano Categories
- SQL Window Functions in a Spreadsheet: Running Totals, Ranks per Group, Previous-Row Values, Moving Averages & Sessions
Prices are $14.99 per PDF workbook. One-time payment, no subscription.