5 Quick Excel Efficiency Tips

1. Cycle through open spreadsheets - If you hold CTRL while hitting Page Up and Page Down (in Macs hold Fn also) you can go from one sheet to the next, just like switching open windows with Alt-Tab
2. Make tabs stand out - You have probably worked out that you can name tabs, but did you know in certain versions you can color them too? Right-click and select Tab Color.
3. Insert the current date - Hold CTRL and hit + (; on Mac) to enter today’s date into the current cell. If you want the cell to always contain the current date, rather than the date right now, use =NOW() formula.
4. Instant charts - Just press F11 and you can create a chart from the currently selected data
5. Quick sum - Have you seen that angular E like button on your toolbar? That is the “sum” button, hit that to sum the currently selected data rather than typing the formula =SUM()