Du Soleil O. Guerrilla Data Analysis...Microsoft Excel..3ed 2022 torrent

Textbook in PDF format

Guerrilla Data Analysis Using Microsoft Excel: Excel Skirmishes and Conquering Crap Data Third Ed. goes beyond Excel tips & tricks and includes real world warnings and case studies.?When asked about the motivation for this book, Oz replied: “this is for the person who’s been thrown into the fire with Excel and data. They may not have a background for this work but they still have to perform because the world doesn’t wait for you to graduate from beginner to intermediate and then to advanced. No. You have to perform and deliver.”?In other words, GDA3 is a survival guide whether you’re new to Excel or a longtime professional who needs a reference guide. The book is light and quick, giving you bite-sized lessons, but going deep on critical topics like pivot tables and Power Query.
Introduction. Welcome to the World of Guerrilla Data Analysis!
Reviewing the Basics
Excel Tables: The Glue in Dynamic Spreadsheet Development
Collaboration Tools
Summing and Counting with Criteria
VLOOKUP and XLOOKUP
Pivot Tables: The Turning Point!
Power Query
Conditional Formatting
De-duping in Excel
Dynamic Arrays
Data Is Never 100% Clean (Not for Very Long)
Data Validation. Controlling Inputs and Maintaining Data Integrity
Protecting Sheets and Cells.
Octopus Spreadsheets
INDIRECT
OFFSET
Using OFFSET to Sum a Range
Recognizing Patterns
Data Types and Stock History
Graphing
The Dangers of Just Diving In
The LET Function
Warnings About Machine Learning–Driven Features in Excel and Power Query
Avoid Working on Your Source Data
Using Slicers
Data Models and Relationships
People, Processes, and Tools
Keeping Your Data in as Few Places as Possible
Rough-and-Tumble Tips and Insights
Spreadsheet Layout and Development