Off to production

I'm delighted to announce that Excel Cookbook has entered production! It will be a little while before the book is generally available, but in the meantime, you can read the early release.

The early release now includes a draft version of every chapter. As well as the areas mentioned previously, there are now three more chapters covering the following areas:

• Using Power Pivot to create more advanced PivotTables. For example, you can create PivotTables based on multiple related tables, insert measures and KPIs, and define more flexible layouts by converting a PivotTable to cube formulas.

• Writing LET and LAMBDA formulas. The LAMBDA function is a relatively new addition to Excel 365, and it lets you create custom functions without having to write macros or VBA. The book shows how to use this function, as well as LAMBDA helper functions such as BYROW, MAP, REDUCE, and SCAN. It also includes LET, which helps make complex formulas more efficient and readable.

• Using Developer options. If you want to record macros or write VBA code, the book's final chapter shows you how. It also includes areas such as using Form and ActiveX controls and their differences.

You can read the early release (and the full version when available) on the O'Reilly learning platform, which also hosts my live training events. If you don't already have a subscription, you can try a 30-day free trial.