Certificate in Using Microsoft Excel

Our spreadsheet courses are for students wanting to learn about creating and using spreadsheets with Microsoft Excel for a variety of work and accounting tasks. Students will learn to use spreadsheets 'hands on' and have the opportunity to practice new skills that they can utilise in the workplace.

Course Details 

Week 1. Create Spreadsheets

1.1 Introduction to Microsoft Excel 

1.2 Alternatives to Microsoft Excel 

Week 2. Plan Spreadsheet Design 

2.1 Spreadsheet Information Requirements 

2.2 Spreadsheet Style and Layout Requirements 

2.3 Style Sheets and Automatic Functions 

Week 3. Use Spreadsheets

3.1 Enter, Check and Amend Data 

3.2 Format Spreadsheet, Adjust Layout 

3.3 Test Formulas to Confirm Output 

3.4 Overcome Problems with Spreadsheet Design and Production

Week 4. Produce Charts and Finalise Spreadsheets

4.1 Select Appropriate Chart Type and Design 

4.2 Create Charts Using Appropriate Data Ranges 

4.3 Modify Chart Type and Layout 

4.4 Preview, Adjust and Print Spreadsheet and Charts 

4.5 Deliver Document to Required Stakeholders

4.6 Name and Store Spreadsheets