Microsoft Office Excel - Introduction

1 Day Duration


This introductory course is aimed at users who have little or no previous working knowledge of Microsoft Office Excel. This will provide delegates with hands on experience of creating spreadsheets from scratch, printing and page set up options, as well as chart creation. Delegates will leave with the ability to work confidently within Microsoft Office Excel.

Introducing Excel

Toolbars – standard and formatting
Formula Bar
Status Bar and scroll bars
Columns, rows, cells and ranges
Navigating through cells

Getting started

Selecting cells, rows, columns and ranges
Entering text and numbers into cells
Moving cell contents
Editing cell contents
Deleting cell contents

Formula Creation

BODMAS theory
Creating formulas using the keyboard and mouse
Copying formulas across ranges
Introducing simple functions

Chart Creation

Chart types – choosing the right chart for your data
Working through the chart wizard
Chart type
Source data
Chart options
Chart location
Formatting chart elements
Altering chart elements
One key chart creation

Preparing to Print

Page set up options
Headers and footers
Printing options

Saving Spreadsheets

Saving spreadsheets for the first time
Saving changes
Choosing file locations
Choosing file names