Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Supporting your high street Find out how »
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 Dyna, Paperback / softback Book

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 Dyna Paperback / softback

Paperback / softback

Out of stock

Description

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

Information

Save 12%

£19.95

£17.55

Out of stock
Add to Basket
Sign in to add to wishlist
 
Free Home Delivery

on all orders

 
Pick up orders

from local bookshops

Information