Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition


May 2022

Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition

Stop Being a Victim of Bad Data!

"Be aware: This is not just a technical book about spreadsheets but arguably a dense treaty on how to get yourself out from data conflicts, end unnecessary misery and make something happen with powerful Excel sorcery (Power Query, Pivot Tables, Dynamic Arrays, & more!). May this book lead you to begin the endless joyful journey of going from a “crude Excel user” to a “bona fide Excel beast”, and more importantly, may this book also help you claim victory over crappy datasets and become the hero for the people the data is connected to."

Carlos Barboza, Guerrilla Data Analyst & bilingual Excel & Power BI developer

category: Spreadsheets, Excel
covers: Microsoft 365, Excel 2019 - 2021

Product Details
  • 261 pages
  • Publisher: Holy Macro! Books
  • ISBN: 978-1-61547-074-7
  • PDF ISBN: 978-1-61547-160-7
"Excel Skirmishes and Conquering Crap Data"

Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts charged with taking mainframe data and turning it into useful information quickly. Topics include data quality, validation, perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables, and much more.

  • Introduction: Welcome to the World of Guerrilla Data Analysis!
  • Chapter 1: Reviewing the Basics
  • Chapter 2: Excel Tables: The Glue in Dynamic Spreadsheet Development
  • Chapter 3: Collaboration Tools
  • Chapter 4: Summing and Counting with Criteria
  • Chapter 5: VLOOKUP and XLOOKUP
  • Chapter 6: Pivot Tables: The Turning Point!
  • Chapter 7: Power Query
  • Chapter 8: Conditional Formatting
  • Chapter 9: De-duping in Excel
  • Chapter 10: Dynamic Arrays
  • Chapter 11: Data Is Never 100% Clean (Not for Very Long)
  • Chapter 12: Data Validation: Controlling Inputs and Maintaining Data Integrity
  • Chapter 13: Protecting Sheets and Cells
  • Chapter 14: Octopus Spreadsheets
  • Chapter 15: INDIRECT
  • Chapter 16: OFFSET
  • Chapter 17: Recognizing Patterns
  • Chapter 18: Data Types and Stock History
  • Chapter 19: Graphing
  • Chapter 20: The Dangers of Just Diving In
  • Chapter 21: The LET Function
  • Chapter 22: Warnings About Machine Learning–Driven Features in Excel and Power Query
  • Chapter 23: Avoid Working on Your Source Data
  • Chapter 24: Using Slicers
  • Chapter 25: Data Models and Relationships
  • Chapter 26: People, Processes, and Tools
  • Chapter 27: Keeping Your Data in as Few Places as Possible
  • Chapter 28: Rough-and-Tumble Tips and Insights
  • Chapter 29: Spreadsheet Layout and Development

Where to Buy

MrExcel Bookstore

eBook from MrExcel.

MrExcel Bookstore

Print book from MrExcel (Estimated release date: August 2022)


Other Editions


Guerilla Data Analysis

September 2002

Bill Jelen uses his combined experience and analytical ingenuity to de-mystify the arduous task of dealing with downloaded data.


Guerrilla Data Analysis 2nd Edition

May 2015

This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These tips have been honed by Oz du Soleil, a former financial analyst charged with taking mainframe data and turning it into useful information quickly, and "MrExcel" himself, Bill Jelen.


Related Products


Cleaning Excel Data With Power Query Straight To The Point

March 2019

This book provides a quick Straight-to-the-Point introduction to Power Query. There’s a lot here, and there’s also a lot that’s not here. Reading this book will be like sitting down at a café and striking up a conversation with the person at the next table, where you learn enough random stuff about that person to decide if you want to know more and keep in touch.


Excel Data Cleansing Straight To The Point

July 2019

This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy.