This July 2024 session recording covers lots of tips, tricks and techniques to speed up the formula creation process. You will learn:
how to quickly start a formula
the benefits of the numeric keypad
to use AutoComplete to save typing
how to easily insert $ signs to fix references
about the calculation sequence
how to use the colours Excel displays when editing formulas
the tricks on selecting large ranges
using formulas and Format as Table together
a helpful technique when working with ranges in other sheets
an introduction to dynamic arrays