The Visual Guide to Good Spreadsheet Practice

The Visual Guide to Good Spreadsheet Practice

The spreadsheet is an integral part of modern day business, and love them or hate them, they are here to stay.

Excel is an extremely powerful tool both in and outside of the business world, but to use it most efficiently you need to know how to set it up properly.

Even for an Excel intermediate user there can still be many things to consider in avoiding the pit falls of poor spreadsheet practice.

For instance, would you know how to create a backup and control system, or implement consistent formulae? Do you have checks and controls in place for the creation of new workbooks?

If you work within a large organisation it's vital that you do, otherwise information quickly becomes disparate and unorganised, and in turn this leads to a loss of efficiency, and therefore time and money.

In this visual guide we examine best practices to setting up, formatting and controlling spreadsheets.

If you're dealing with a complex organisation handling thousands of workbooks or simply documenting your home finances, it's best to start on the right foot and have things well set up. You never know when it will be useful. Take a look at the Excel courses near me.

View the infographic (PDF)

View the infographic (PDF).

Add this to your website or blog

Copy and paste the HTML code to your page.

1000 pixels wide:

<a href="https://www.stl-training.co.uk/sharing/visual-guide-to-good-spreadsheet-practice/52"><img width="1000" height="1415" data-class="LazyLoad" src="data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9Im5vIj8+Cjxzdmcgd2lkdGg9IjEwMDAiIGhlaWdodD0iMTQxNSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4KCTxyZWN0IHdpZHRoPSIxMDAlIiBoZWlnaHQ9IjEwMCUiIG9wYWNpdHk9IjAiLz4KPC9zdmc+" data-src="https://www.stl-training.co.uk/asset/image/sharing/visual-guide-to-good-spreadsheet-practice.png" alt="The Visual Guide to Good Spreadsheet Practice" title="The Visual Guide to Good Spreadsheet Practice" border="0" /></a><br /><a href="https://www.stl-training.co.uk/sharing/visual-guide-to-good-spreadsheet-practice/52">The Visual Guide to Good Spreadsheet Practice</a> by <a href="https://www.stl-training.co.uk/">STL</a>

575 pixels wide:

<a href="https://www.stl-training.co.uk/sharing/visual-guide-to-good-spreadsheet-practice/52"><img data-class="LazyLoad" src="https://www.stl-training.co.uk/include/addon/W3speedster/assets/images/blank.png" data-src="https://www.stl-training.co.uk/asset/image/sharing/visual-guide-to-good-spreadsheet-practice-575.png" alt="The Visual Guide to Good Spreadsheet Practice" title="The Visual Guide to Good Spreadsheet Practice" border="0" /></a><br /><a href="https://www.stl-training.co.uk/sharing/visual-guide-to-good-spreadsheet-practice/52">The Visual Guide to Good Spreadsheet Practice</a> by <a href="https://www.stl-training.co.uk/">STL</a>