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.

Prior knowledge of PC’s assumed.

In this course you will learn:

• 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

What to bring:

• Pen
• Paper

The Next Step:

Keen to learn more? We suggest Excel Intermediate.

Other Information:

• To ensure resources are ready for you at the start of your course, we ask you ideally enrol at least one week before the course commences.
• All courses need a minimum number of students to run ("we try our hardest to get those") . If your course does not have enough students it will be cancelled before the commencement and you will be informed.