Every Excel expert knows how to navigate without ... Have you struggled to start a new line of text within a cell? Well, you need to learn these less popular but extremely useful shortcuts.

Excel's INDIRECT function turns a text string into a reference ... in our AVERAGE calculation is B7, which is one cell upwards from B8. So, adding to our formula means that Excel will create ...