Guerrilla Data Analysis Using Microsoft Excel

Table of Contents

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