Microsoft Excel Introductory Training Course

Click here to Buy MS Office today!

Microsoft Excel Introduction

Course Aims
This course is designed to introduce new users to Microsoft Excel . Users will learn how to create, modify and print spreadsheets. This entirely 'hands on' course includes specially prepared exercises that give participants practical experience of using Excel's tools.

Pre-requisites
A basic understanding of using PCs, a keyboard and a mouse, plus knowledge of MS Windows is required, gained either by previous experience or by attendance on an "MS Windows User Introduction" course.

Target Audience
New or intending users of MS Excel who want to gain a good broad understanding of the software. The topics listed below indicate the range of features which, depending on the interests of the course attendees, can be covered on the course.

Course Outline:

Getting Started

Starting the Program

The Excel Screen

The Task Pane

Moving Around the Worksheet

The Excel Menus

Shortcut Menus

Toolbars

Entering and Editing Data

Entering Data

Changing the Contents of a Cell

Using Undo

Workbook Operations

Saving a Workbook

Closing a Workbook

Closing the Program

Starting a New Workbook

Opening a Workbook

Working with Formulas and Functions

Basic Formulas

Functions

Absolute Cell References

Previewing and Printing Data

Printing a Workbook

Print Preview

Page Break Preview Mode

Changing Page Layout

Page Setup

Page Settings

Margins Settings

Headers and Footers

Sheet Settings

Copying & Moving Data

Copying Data

Moving Data

Using Autofill to Create Sequences

Working with Columns and Rows

Inserting Rows

Inserting Columns

Inserting Cells

Deleting Rows, Columns and Cells

Changing the Height of a Row

Changing the Width of a Column

Cell Formatting

Number Formats

Alignment

Fonts

Borders

Patterns

Format Painter

Charts

The Chart Wizard

Adding Titles

Axes

Adding Gridlines

Adding a Legend

Adding Data Labels

Adding a Data Table

Moving the Chart

Resizing a Chart

Selecting the Chart

Deleting the Chart

Printing a Chart

At the end of this course you will be able to:

Enter and edit data on a worksheet, create calculations using formulas and functions, format your worksheets and print them out, and represent your numeric data in a graphical format