Spreadsheets: Creating professional spreadsheets

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

Learn to create spreadsheets that are efficient, easy to understand and reliable.

The next step, once you have mastered the essentials of how to make a spreadsheet, is to build good working practices. Some good habits will mean your spreadsheets will be well laid out, simple to read and reliable.

You will work with data and formulae, using a range of the interesting functions offered by Excel. You will learn how to use date and logic functions to save time and improve accuracy. Some tips and tricks will make life more efficient, working with large worksheets and multiple sheets in 3 dimensions.


Note: These materials were used with a previous version of the course. For current materials, look at "Data analysis: Good practice in spreadsheet design"