Save content
Have you found this content useful? Use the button above to save it to your profile.

Excel Tip: Don't hold your data in Excel if you've got somewhere better!

30th Apr 2013
Save content
Have you found this content useful? Use the button above to save it to your profile.

Don'tFrom the Not Just Numbers blog:

Just a short post this week, and a one you might be surprised by. I am going to encourage you not to use Excel!

Yes, after years of telling you how to get the best out of Excel, I am going to tell you to avoid using it!

Well at least for one particular purpose...

Whereas a lot of my work is producing spreadsheets that are self-contained, I work with many clients where I use Excel as a tool to report from their database systems (typically accounting packages or ERP/MRP systems).

Many times, these reports are required because the system won't give them what they want - some of the time because all of the data they need isn't stored in the system.

In this scenario, it is very easy to store the additional data in the spreadsheet report, but I would urge you - DON'T!

Whereas the report will work just as well, if the additional data is stored in the spreadsheet, the information will not be available from within the system, or for other reports required in future. Very quickly, you can find  various different versions of the same data scattered around in spreadsheets all over the business.

If at all possible, find a way to start recording this data in the system - and use Excel to report on it like the rest of the data.

This is usually possible, although inevitably there are some systems that are not flexible enough for the company's true needs. Storing the data in a spreadsheet outside of the system will work as a patch, but is not the ideal solution.

Excel is a fantastic tool that has many applications - but it is important to know when not to use it too!

Click here for our our exclusive offer on Online Excel Training

If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get your free report "The 5 Excel features that you NEED to know".

Tags:

You might also be interested in

Replies (1)

Please login or register to join the discussion.

By Tara
01st Jul 2013 10:37

Excel - ups and downs....

I used to work for a large advertising agency, and we used Excel for everything. SO many times we had issues of one staff member updating the wrong version of a file, and then having to pick their new workings out from the old workings. Basically it was a bit of a nightmare.

I now work for a small business and we use the cloud for everything ( as we are a cloud based application ourselves) so Google spreadsheet is now where I do my workings! I must admit, I love the cloud, and the ability to access work and personal files anywhere on the go. 

However, having spent a few years where each day revolved around Excel, I miss the accuracy, the capabilities of formula tools, and some of the general functionality. When will Google step up their version of spreadsheets? It doesn't make sense that such an international digital powerhouse supplies such average tools. Do you have any insight on when this might happen?

Thanks (0)