Troubleshooting formulas in Excel is easy thanks to the Formula Auditing Tools. Make sure to learn these tips and apply them as soon as today. Video: Four Essential Tools to make sure your formulas in Excel are correct Tip 1 – Display formulas instead of values ...
You already know that when you select a cell with a date and drag the Auto Fill handle, Excel creates a series of sequential dates by adding one day each time. Did you know that you can control how many days are added? A list of all the Mondays until December Type two...
Excel can talk to you. Text-to-speech saves you time because you don’t need to look up at your screen while entering and checking data. Instant accuracy. Instant productivity. Let your ears do the reading. How to: Make Excel talk with text-to-speech. In the Tools...
If, as I expect, you have a list of figures and need to calculate a running total (aka cumulative sum), use this super quick Excel formula tip which uses the Excel SUM function and combines it with absolute cell references (e.g. $B$1). The trick? Use the SUM function...