Excel Cookbook update

Written By Dawn Griffiths

The Excel Cookbook's early release has recently had a major update. It now includes Chapters 1 to 15—just over 80% of the completed book!

The early release now includes the following areas (and more):

  • General features, including AutoFill, Flash Fill, conditional formatting, and custom data validation.

  • A wealth of functions and formulas covering text manipulation, dates and times, lookup functions, and dynamic array formulas.

  • Dedicated chapters for financial analysis, statistics, and math and engineering.

  • PivotTables, including using different aggregations, filters, adding custom calculations, and working with the PivotTable cache.

  • Using charts and graphics, including sparklines and 3D Maps.

  • Tools such as the Analysis ToolPak, Forecast Sheets, Scenario Manager, Goal Seek, and Solver.

  • Getting and transforming data with Power Query, including custom columns and functions.

You can read the early release on the O'Reilly learning platform. The platform also hosts my live online training courses—see my training page for upcoming dates, with more courses on the way!

Dawn Griffiths
Previous

Off to production
Next

Adding a timestamp column using Power Query