Good practices when you design your Excel workbook
Microsoft Excel is the standard and go-to application when using spreadsheets – there is hardly any spreadsheet user who has not worked with Excel at one point in their professional career before. Now that Microsoft has spread out beyond the PC onto tablets, smartphones, and has become cloud-based, its distribution is ubiquitous.
As such, it has become even more important to create professional spreadsheets that can be understood and collaborated on in a seamless manner – there, Google Docs has clearly shown the way. In this blog post by J. Carlton Collins, he details 15 highly useful and – may I state – necessary rules for designing meaningful Excel spreadsheets that start with adequate documentation and a table of contents, well-organised spreadsheets, named ranges/cells, and quality management to avoid errors and misconceptions. These steps are not dealing with style per se, but with good practice that will enhance your reputation as spreadsheet expert.