Written by Andy Trainer– Fri 19 Oct 2012
In this post I share three of my favourite Excel tips that - once you know how - become very useful. Most people who use Excel have only just scratched the surface, if you take the time to learn more about Excel, you could really achieve a lot more at work and at home. Learning Excel is time consuming, and a near impossible task to do on your own. We provide regular Excel resources and tips on the blog, but nothing beats hands-on, classroom based Excel training.
Here are three Excel tips that come in handy once you know what you're doing:
When you have a long list of data that stretches across the page it can sometime be difficult to read each line precisely across. One way to help you, and your eyes, is to make every other row a different colour.
Adding a drop down list to your spreadsheets not only looks good, but it also helps stop the wrong data being entered into the system. In this example, we're going to use days on the week:
When you click on a cell which contains a formula then the formula appears at the top, but sometimes you may want to hide it because it’ll look neater and/ or you don’t want others copying your complex formulas.
Now the formula cells are set as Hidden and the cells without formulas in are set as Unlocked, but this is all useless unless the spreadsheet is protected, to do this you will have to click Review > Protect Sheet, this should protect the sheet and if you want an added bit of security you can set a password.
Image by fdecomite on Flickr
ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® courses on this website are offered by The Knowledge Academy, ATO of AXELOS Limited. ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® are registered trade marks of AXELOS Limited. All rights reserved.