Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas

© 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 Murray¹  

(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 ...