MICROSOFT EXCEL INTRODUCTION COURSE OVERVIEW

A 1 day Introduction Course, aimed to give users the confidence and knowledge to create and use Excel spreadsheets. By the end of the day, users will be able to create, amend and manipulate their own spreadsheets.

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

• Menu bar
• Ribbon
• Status bar

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

• Creating new documents
• Saving spreadsheets
• Closing Excel

Spreadsheet Data

Gain an understanding of how to insert text, numbers, dates, currency.

• Autofill Tools
• Format Cells
• Absolute Cell References

Formatting Excel

Changing the look and feel of spreadsheets.

• Selecting cells, columns and rows
• Displaying data as currency (£)
• Displaying figures as percentages (%)
• Changing cell, text and border colour

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

• Understanding simple formulas
• Using AutoSum
• Calculating using SUM, COUNT, MAX, MIN and AVERAGE

Printing

Explain how to print in the most effective manner possible.

• Setting print areas
• Using headers and footers
• Setting page scales

Charts

How to use your data in various chart types.

• Using the Chart Wizard
• Select appropriate chart types
• Specifying the data source
• Customising your charts