Welcome to your weekly 3 tip Friday update, it’s just a short dose of Excel help before you start the weekend. Each week we’ll cover a tip, a shortcut and a function - making it super easy for you to get better at Excel.
A quick win you can learn today -
When you open Excel, 3 blank sheets are created by default. If your use of Excel is anything like mine - this can be annoying, in most cases I only need 1 sheet. You can set your Excel options to only create a single sheet in new files by going to File -> Options and change the ‘Include this many sheets’ option to the number of sheets you’d like.
A keyboard shortcut I'm adding to my list -
Ctrl + A is a pretty common (and useful!) keyboard shortcut, but I’m always surprised to find how few people know it! Use Ctrl + A to select all of the cells in the current table or sheet.
A function I've found super useful this week -
Standard deviation is a useful mathematical tool to quantify the variation of a data set - for example if a set of figures are closely bunched together spread out. The smaller the standard deviation, the more closely bunched together the data is.
The STDEV function allows an easy calculation of the standard deviation of a data set, and it’s easy to use too. Just type =STDEV( followed by the range you want to measure.
Until next time, good luck with your Excel endeavours.
East Lothian, Scotland