The New Frontier of Excel Analysis and Reporting with Excel Array Formulas and LET & LAMBDA Functions : Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight - Mike Girvin

The New Frontier of Excel Analysis and Reporting with Excel Array Formulas and LET & LAMBDA Functions

Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight

By: Mike Girvin

Paperback | 9 July 2025

At a Glance

Paperback


RRP $39.99

$37.25

or 4 interest-free payments of $9.31 with

 or 

Available: 9th July 2025

Preorder. Will ship when available.

Array Formulas have been around since the beginning of Excel. The author wrote a whole book about them back in 2012. Array Formulas were powerful, but complicated. Then Microsoft invented the new Worksheet Calculation Engine in Microsoft 365 Excel and just like that, 40 years of Excel worksheet formula methods changed overnight. Dynamic Spilled Array Formulas, born inside this new calc engine, can now spill results from a single cell and dynamically update when new source data changes. Now we don' t have to lock most cell references; no need to manually copy most formulas, editing formulas is now a simple task, and insane old school filtering, sorting and unique list formulas are a thing of the past with new Array Functions like FILTER, SORT and UNIQUE. Microsoft also gave us the LET function which eliminates duplicate formula elements by allowing us to define variables within the formula itself. In addition, Microsoft gave us the LAMBDA function which allows us to define re-usable functions without using VBA code. There are also LAMBDA Helper Functions like BYROW which solves the problem of " how do I spill an aggregate total?" Does all this sound too good to be TRUE? Too good is no

More in Spreadsheet Software

Microsoft Excel 365 Bible : Bible - Michael Alexander

RRP $95.95

$62.25

35%
OFF
Financial Modeling in Excel For Dummies : 2nd edition - Danielle Stein Fairhurst
Excel 2019 For Dummies : Excel for Dummies - Greg Harvey

RRP $52.95

$39.35

26%
OFF
Microsoft 365 Excel VBA Programming For Dummies - Dick Kusleika
Microsoft Power BI Dashboards Step by Step : Step by Step - Errin O'Connor
Microsoft Excel 2019 Step by Step : Step by Step - Curtis Frye

RRP $60.95

$44.35

27%
OFF
Excel Formulas & Functions For Dummies : 6th edition - Ken Bluttman
Excel Dashboards & Reports For Dummies : 4th edition - Michael Alexander
Excel VBA Programming For Dummies : 6th edition - Dick Kusleika

RRP $69.95

$47.25

32%
OFF
Excel Data Analysis For Dummies : 5th edition - Paul McFedries

RRP $69.95

$40.25

42%
OFF
Problem Solving Cases In Microsoft Access & Excel : 16th edition - Ellen Monk
Financial Analysis with Microsoft Excel : 9th edition - Timothy Mayes
Excel 2010 : The Missing Manual - Matthew MacDonald

RRP $76.00

$35.75

53%
OFF
Advancing into Analytics : From Excel to Python and R - George Mount
Excel Hacks : Hacks - David Hawley

RRP $57.00

$28.25

50%
OFF
Learning Statistics and EXCEL in Tandem - Saroja Selvanathan

RRP $104.95

$89.50

15%
OFF