Spreadsheets: Techniques for managing and checking data

  • Excel icon course pack | Publicly viewable | v. 2013

An exploration of techniques that can be used  to help identify and avoid errors in Excel worksheets.

The course includes advice on the design of new Excel solutions.The course includes a three stage approach where issues about organising data, managing it over time and designing new solutions is discussed in a workshop style.

The course is suitable for anyone who would like to find out more about common errors in Excel and how to avoid them. Attendees should have some experience of Excel but it is not necessary to be an expert. The course does not include detailed instructions (as other Excel courses are available for this) but focuses on the approach to take and ideas for what things should be checked to ensure mistakes are kept to a minimum. The concepts can be used in other data management environments where a structured approach and the adoption of methodical development processes can help reduce problems.