Excel contains over 400 built-in functions, and a number of related shortcuts.
To start off, there’s a shortcut for the Autosum feature, which automatically enters the SUM function.
it’s possible for you to use this for both rows and columns.
you might even Autosum an entire table.
When you’re entering a function, you’re free to use autocomplete.
Start typing the function name, then use TAB to complete a match.
On a Mac, you’ll need to use the down arrow key to grab the best match first.
Note that when you’re entering a single function, you don’t need to enter a closing parentheses.
Excel will do that for you.
Once you choose a function, the Function Arguments dialog will open.
After you enter a formula, you might use the same shortcut to kick off the dialog again.
you’re able to also pop pop the Function Arguments dialog directly when you’re entering a formula.
Once a function is recognized, throw in Control + Shift + A.
Then just double click to select and replace.
Remember that you might use function screen tips to navigate and select specific arguments precisely.
When functions require multiple cell references, you don’t need to enter a comma.
Just hold down the control key in windows or command key on the mac and click.
Excel will enter commas as needed.
