© The Author(s), under exclusive license to APress Media, LLC , part of Springer Nature 2021
A. MurrayAdvanced Excel Successhttps://doi.org/10.1007/978-1-4842-6467-6_2

2. The Ten Power Functions of Excel

Alan Murray1  
(1)
Ipswich, UK
 

I love using formulas in Excel. They are the heartbeat of a spreadsheet.

They turn a static spreadsheet into a dynamic and interactive spreadsheet that can make decisions, change over time, and react to user requests.

Excel has many tools now to create powerful reports including Power Query, VBA, and Power Pivot. However, formulas are still the heartbeat of a smart spreadsheet.

Many users learn to use a function to complete a specific task at work. And they will often learn this from a colleague or from a Google (or Bing) ...

Get Advanced Excel Success: A Practical Guide to Mastering Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.