As you start typing a formula, Excel shows auto-complete suggestions. Tab: Auto-complete functions, names, structural references.
Excel will show a list of all names and pick what you want. Whenever you want to type a name, press F3 instead. When you have a lot of names, often remembering them can be tricky. When you select a cell and press F2, Excel places cursor at the end and lets you edit the cell value / formula. So today, let us learn 5 important keyboard shortcuts that will save you a lot of time and help you write better formulas. As an analyst (or manager), I bet a good portion of your Excel time is spent writing formulas and getting the results.
