98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
Improving Navigation Of Your Worksheets In Excel
Mon 17th May 2010
Break it down
It's very tempting to slap all your data in one worksheet - especially if you're the one working on it. However most people want to see patterns and results of formulas in the data - not the data itself.
Let's say you're trying to present your boss with sales at a car factory. He or she wouldn't necessarily want to look at every single sale to every single person - they just want a quick way of seeing the results for each car model, or each colour. Remember that you can keep the master document and then create a copy to split up into more worksheets for distribution. The easier you make it for your boss, the more impressed they'll be.
Watch the formatting
It sounds simple, but a little colour goes a long way, as does correct formatting in your Excel document. Remember to use line breaks in cells, so the content of them doesn't stretch across into other columns, obscuring their contents.
Colour, when used sparingly and thoughtfully, can be effective in getting your data across. Going back to the car example - if your boss has asked for the profit margin on each car, this column can be in red or another eye-catching colour so he/she can differentiate it from other data. Or - use the stock market colours that are instantly recognisable - blue for a positive number, red for a negative, and green for unchanged. That means you can get an overall picture of the results, just by scanning the prevalence of each colour.
Think in website mode
Most people are proficient in surfing the web, less so when navigating an Excel spreadsheet. Many people forget that you can create certain features of your workbooks - like hyperlinks - to let someone 'surf' your data in an easier fashion. You could even create a basic webpage with all the data "behind" it and being called up on demand, with a database. Even if it's not this complex, you can still use web-related features to enhance the viewing experience of your data.
Remember, the most important person who will read your data is you, the creator. Some of these tips will make it easier on yourself to come back to a worksheet that you don't use very often. Bear in mind the correct audience when you're changing your navigation. Is it someone who is well-versed in Excel, and who can manipulate your data themselves? Or is it someone who needs a quick, less detailed summary to see what your results are, fast? Depending on where your data ends up - keep the user in mind, and remember - data can be good, but it's not always accessible to its audience!
Author is a freelance copywriter. For more information on excel training london, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-898-improving-navigation-worksheets-excel.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsArcturus Publishing Ltd
Foreign Rights Assistant Dayna Wolton Excel Intermediate Martin was so helpful and patient! Great size class too so you have a lot of attention and time to ask questions. Foreign Currency Direct
Sales Director Daniel Wright Excel Introduction Thank you to Fred, very helpful trainer. Will be booking intermediate in the future. Jewish Blind & Disabled
Head Of Tenancy Support Miriam Marsden Introduction to Management I didn’t take advantage of the lunch, hence the low score!! Otherwise great Probably a few more delegates would’ve brought a wider variety of situations and experiences to the course - but it was really excellent!! |
PUBLICATION GUIDELINES