© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. MurrayAdvanced Excel Formulashttps://doi.org/10.1007/978-1-4842-7125-4_1

1. Excel Formulas: A Quick Primer

Alan Murray1  
(1)
IPSWICH, UK
 

This is a short chapter to lay a solid foundation on using formulas in Excel before we get to the really exciting stuff.

Although this is an advanced Excel formulas book, I felt this chapter would be useful to plug any gaps that may exist in your knowledge. Also, it can serve as a reference point that you can revisit to help understand some of the formulas later.

This chapter will begin by explaining the anatomy of formulas and the use of the different characters, for example, !, $, >. We then explain the use of workbook ...

Get Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas 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.