One of the biggest strengths that Excel has is its wide range of functions that are essentially pre-programmed shortcuts that allow you to perform powerful analysis or transform your text and numeric entries in a wide variety of ways.

This book will walk you through the way formulas and functions work in Excel and how to find and troubleshoot them. It also covers the most useful functions available in Excel 2024, from the most basic, such as SUM, to newer functions such as IFS, TEXTJOIN, XLOOKUP, RANDARRY, TEXTBEFORE, and TEXTAFTER.