Excel Cookbook

Filled with tips, tricks, and techniques, this easy-to-use book is the perfect resource for intermediate to advanced users of Excel. You’ll find complete recipes for more than a dozen topics covering formulas, PivotTables, charts, Power Query, and more. Each recipe poses a particular problem and outlines a solution that you can put to use right away—without having to comb through tutorial pages.

Whether you’re a data analyst, project manager, or financial analyst, author Dawn Griffiths directs you straight to the answers you need. Ideal as a quick reference, Excel Cookbook is also perfect for learning how to work in a more efficient way, leading to greater productivity on the job. With this book, you’ll jump in and get answers to your questions—fast.

This cookbook shows you how to:

• Build compelling charts and use Sparklines, 3D Maps, and other visualizations
• Use PivotTables to slice, dice, and summarize datasets
• Perform statistical and financial analyses using formulas, Forecast Sheets, the Analysis ToolPak, and more
• Master dynamic array functions such as SEQUENCE, TEXTSPLIT, and FILTER
• Use Power Query to import, shape, and combine datasets
• Create custom functions using LAMBDA formulas
• Use developer options to write VBA code and create custom UserForms

Table of Contents

Chapter 1. Workbooks, Worksheets, and Cells

Chapter 2. References and Structured Data

Chapter 3. Using Formulas

Chapter 4. Math and Engineering

Chapter 5. Text Manipulation

Chapter 6. Dates and Times

Chapter 7. Array, Logic, and Lookup Functions

Chapter 8. Statistical Analysis

Chapter 9. The Analysis ToolPak

Chapter 10. Financial Analysis

Chapter 11. PivotTables

Chapter 12. Charts

Chapter 13. Graphics, Sparklines, and 3D Maps

Chapter 14. What-If Analysis

Chapter 15. Power Query

Chapter 16. Power Pivot and the Data Model

Chapter 17. LET, LAMBDA, and LAMBDA Helper Functions

Chapter 18. Developer Tools: Macros, VBA, Controls, and XML

About the Author

Dawn Griffiths is an author and trainer who has taught Excel to thousands of students worldwide. Her previous books include Head First Statistics, Head First Android Development, Head First Kotlin, Head First C, and React Cookbook.