As we move into December we have the last few editions of Excel 3 Tip Friday for 2018 - I’ve been running these weekly updates since March to provide you with an easy bite-sized way to learn some extra Excel.
I hope that you get value out of these tips - if you have any suggestions for future topics please hit reply and let me know.
A quick win you can learn today -
Cell styles are a useful way to quickly colour cells - including creating table headers, highlighting cells and more. If your organisation uses a common font, colour, or size you can set up custom cell styles so that they’re ready to use over and over again.
To create a custom cell style in Microsoft Excel, click into the cell styles menu on the home ribbon, and select New Cell Style. Give the style a name, and configure how you’d like your style to look. You can then apply the style easily to any cell or range using the cell styles menu.
A keyboard shortcut I'm adding to my list -
This week, another common Excel shortcut, in case you don’t already know it, is Ctrl + O - use this to show the open file box, instead of having to go into the file menu.
A function I've found super useful this week -
You might be familiar with the Excel functions MAX and MIN which will return the highest or lowest values in a range. But what if you want to return to the second highest, or the third smallest? There’s 2 easy to use functions that can do this, LARGE and SMALL. Each has just 2 components, first the range, just like in a MAX or MIN function, and second the position number you’d like to return. For example, to select the 2nd highest value in A1:A10, type =LARGE(A1:A10,2) or to return the 3rd smallest use = SMALL(A1:A10,3).
As always, I hope you find these Excel tips useful, and please do reply if you have any comments or questions!