This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

At the completion of this course you should be able to:

• navigate your way around Microsoft Excel 2016
• create and work with a new workbook
• open and navigate within workbooks and worksheets
• make changes to data in a workbook
• understand and work with ranges in a worksheet
• copy and paste data in Excel
• use the fill operations available to fill a data series
• move the contents of cells and ranges within and between workbooks
• understand, create and work with formulas and functions
• understand and use formula cell referencing
• use font formatting techniques
• align the contents of cells in a number of ways
• understand and use the number formatting features in Excel
• format rows and columns in a worksheet
• work with elements that make up the structure of a worksheet
• sort data in a list in a worksheet
• filter data in a table
• print your workbook data
• create effective charts in Microsoft Excel
• obtain help for Excel whenever you need it
• understand points to consider to avoid problems in your worksheets