Off to print
After months of work, the Excel Cookbook is at the printers! The ebook versions are available now, and the print copies should be ready soon. Thank you to all those who pre-ordered the book—I can't wait for you to read it.
The book contains over 350 recipes designed to make your Excel life easier. Each recipe poses a particular problem and outlines a solution that you can put to use right away.
Here's a list of the chapters:
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
You can order the Excel Cookbook from Amazon and elsewhere, or read it on the O'Reilly learning platform if you have a subscription.