Excel for Data Analytics 4

What's inside

Excel for Data Analytics 4: 13 courses, 260 hands-on lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.

• 13 complete courses, 260 lessons, 260 exam questions with answers
• Worksheets with row and column labels – easy to type in
• Tasks with exact solutions and hints in the appendix
• All figures are fictional practice data

Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.

Courses in this book

• 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
• Election Night Analytics: Turnout, Vote Shares, Swing, Seat Projections & Disproportionality
• Traffic Count Analysis: Hourly Volumes, Peak-Hour Factors, Directional Splits, Vehicle Classes, Annual Averages & Growth Projections
• Population Analysis & Projections: Age-Band Profiles, Birth & Death Rates, Migration, Cohort Projections and Dependency Ratios
• Vehicle Telematics Analytics: Trips from GPS Logs, Distance & Speed, Idling, Fuel per 100 km, Utilisation & Fleet Exception Reports
• Tourism Statistics by the Numbers: Arrivals vs Overnight Stays, Length of Stay, Bed & Room Occupancy, Seasonality Indices and Regional Reports
• Time-Series Models by Hand: Stationarity, Differencing, Autocorrelation, AR & MA Terms, ARIMA Forecasts and Residual Checks
• BI-Style Measures with Formulas: Filter Context, Removing Filters, Semi-Additive Balances, Top-N with Others, New vs Returning Customers & Dynamic Segments
• SQL Beyond the Basics in a Spreadsheet: Subqueries, IN & EXISTS, Correlated Subqueries, Step-by-Step CTEs, UNION vs UNION ALL, INTERSECT & EXCEPT, Self-Joins, Date Spines & NULL Logic

Details

Format	PDF, US Letter (8.5 × 11 in)
Language	English
Pages	725
Series	The Tabellab Workbook, volume 4
Author	Babala Özdemir
Delivery	Instant download after payment