Posted by clearert on May 22, 2017
Ten Top Tips in Excel
I was recently asked for my ten top tips in Excel so here they are. Follow the links for more explanation.
Plan the data layout in your spreadsheet. Whether you’re storing accounts info, stock control, wages or expenses, work out what gets repeated regularly and plan a system to record it.
Make sure constant values used in calculations are clearly visible and labelled.
Make sure you understand use of constants and apply $ signs using Function key F4.
Use formatting to draw attention to data entry area vs calculations.
Unlock data entry areas and add protection to calculated areas.
Once data has been added, double-click on Auto-fill handle to extend formula to bottom of data.
Display (and print, if wanted) formulas instead of results.
Use keyboard shortcuts for many repetitive tasks.
Use conditional formatting to recognise exceptions and approaching deadline values.
Always test your formulas. Use data whose values you will easily be able to check.