Overcoming Crap Data and Excel Skirmishes
by Oz du Soleil & Bill Jelen
Tame Your Data. Transform Your Work. Become the Guerrilla Analyst Your Team Needs.
Data rarely arrives neat, clean, and ready to use. Most of the time, it’s messy, incomplete, and downright confusing. That’s where Guerrilla Data Analysis comes in. Written by Excel MVPs Bill Jelen (MrExcel) and Oz du Soleil, this practical guide shows you how to wrestle unruly spreadsheets into meaningful analysis—fast.
Packed with real-world strategies, clever workarounds, and insider tips, this 3rd Edition has been fully updated with the latest Excel tools, including dynamic arrays, Power Query, XLOOKUP, Data Types, the LET function, and more.
What You’ll Learn Inside
Excel Essentials Refreshed – Functions, formulas, text tricks, IF statements, helper columns, and more.
Excel Tables as Your Secret Weapon – Create dynamic models, dropdowns, and smarter references.
Pivot Tables Demystified – Summarize, filter, group, and analyze with power and speed.
Power Query for Cleaning Chaos – Split, unpivot, merge, append, and fuzzy match like a pro.
Spot & Stop Data Errors – Use data validation, conditional formatting, and built-in error-handling.
De-duping Made Easy – Multiple approaches to eliminate duplicates without losing your sanity.
Dynamic Arrays – FILTER, SORT, UNIQUE, RANDARRAY, and the spill revolution.
Protect & Collaborate – Lock down sheets, share workbooks, and use sheet views.
Charting & Visualization – From histograms to slicers, turn numbers into insight.
Rough-and-Tumble Guerrilla Tips – Quick fixes, hidden gems, and tricks you won’t find in the manual.
Why This Book?
Unlike traditional Excel books, this one is all about survival tactics for real-world data messes. You’ll learn the fastest, smartest, and most practical ways to handle whatever spreadsheet disaster lands on your desk.
Whether you’re an accountant, analyst, manager, or simply the “Excel person” in your office, this book will help you:
Save hours cleaning and reshaping data.
Build spreadsheets that adapt and update automatically.
Spot errors before they become embarrassing mistakes.
Turn raw chaos into reports your boss (or clients) will love.
Guerrilla Data Analysis Using Microsoft Excel, 3rd Edition is your field guide to mastering data in the wild. Don’t just work in Excel—outsmart it.
Books on Microsoft Excel, Power Query, Power BI, ChatGPT by Excel MVPs.
Holy Macro! Books is a niche publishing company dedicated to empowering Excel users worldwide with expert-level guides on Microsoft Excel, Power Query, Power BI, and more. Founded by Excel legend Bill Jelen, the company features books authored by Microsoft MVPs, former MVPs, and top industry experts who know their way around formulas, pivot tables, and data transformations. Whether you're a beginner or a power user, Holy Macro! delivers practical, straight-to-the-point content that turns spreadsheet struggles into spreadsheet superpowers.
Train Your GPT is a hands-on, no-code guide to creating AI assistants that actually work the way you do. Whether you're a content creator, consultant, or spreadsheet nerd, you'll learn how to train ChatGPT to follow your style, use your files, and save you serious time — all without needing to know a single line of code.
A beginners guide to mastering the art of Data Metamorphosis to Get Just the Data Structure Needed to Create Insightful Data Analysis Solutions
by Mike “excelisfun” Girvin
Solving Advanced Data Cleaning Problems Using M
by Chandeep Chhabra
Unlock the Power of TypeScript to Automate Excel in the Modern Era
Visual Basic for Applications isn’t the only game in town anymore. With Programming Excel with Office Scripts: Straight to the Point, Eduardo N. Sanchez cuts through the noise and gives you a fast-paced, example-packed guide to automating Excel using Office Scripts and TypeScript.
Whether you're new to scripting or transitioning from VBA, this book shows you how to manipulate ranges, build pivot tables, generate charts, insert shapes, and even trigger scripts from Power Automate—all through clear, concise TypeScript examples.
You'll explore:
The essentials of TypeScript for Excel scripting
Advanced range, table, chart, and shape manipulation
Integration with Power Automate to build hands-free workflows
Real-world scripts, complete with visuals and step-by-step guidance
Perfect for Excel pros, analysts, and developers looking to modernize their automation toolkit, this book delivers exactly what the title promises: straight to the point.
A Beginner's Guide to Overcoming Excel's Frustrations
by Tyler Nash, Kevin Jones, and Tom Urtis & Bill Jelen
How to Excel at Being a Lazy (That Means Efficient) Modeller!
by Liam Bastick
Working on those Optimal Figures for the (Financial) Modelling Industry
by Liam Bastick
Forecasting Business Intelligently
by Liam Bastick and Jonathan Liau
Being Positive About Funding
by Liam Bastick and Oscar Hagan
Leveraging Power Query to Get & Transform Your Task Flow
by Ken Puls & Miguel Escobar