INTRODUCTION TO EXCEL - Stage 1 Course

Overview

This course is for the student who has no or little previous knowledge of spreadsheet work. This course is also designed for students who may have been entering data to existing spreadsheets but have not actually created their own spreadsheets.

Prior Knowledge Requirements

Basic computer skills such as using a mouse, navigation through Windows and surfing the Internet.

The course covers the following areas:

Getting Started with Excel

• An overview of Excel
• Navigating in Excel
• Selecting data
• Entering data
• Save a Workbook
• Close and open files
• Get Help

Performing Calculations

• Create basic Formulas
• Using AutoSum
• Calculate with Functions
• Copy Formulas & Functions
• Check data with Status Bar options

Formatting a Worksheet

• Change Font Size & Type
• Add Borders & Colour to Cells
• Change Column Width & Row Height
• Merge Cells & Centre data
• Apply Number Formats
• Align Cell contents
• Apply an AutoFormat
• Using Auto Complete

What's next?

Excel Stage 2, the next course in this series, develops the student's Excel knowledge by covering areas such as grouping worksheets, using logical formula and Lookup functions. The course also includes more work with charts and graphics, filtering data, linking spreadsheet data and linking to other programs such as Word and PowerPoint.

Modifying a Worksheet

• Move & Copy data between Cells
• Fill Cells with a Series of data
• Edit Cell data
• Insert & Delete Cells, Column & Rows
• Find, Replace & Go To Cell data
• Spell Check a Worksheet

Printing Workbook Contents

• Create a Header & a Footer
• Set Page Margins
• Change Page Orientation

Customising Layouts

• Split a Worksheet
• Arrange Worksheets
• Freeze & Unfreeze Rows & Columns

Charts

• Creating Charts
• Modifying Charts
• Saving & Printing