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.

Previous
Previous

Adding a running total to a waterfall chart

Next
Next

Off to production