Microsoft Excel Introduction

Microsoft Excel Introduction

One Day Course

Assumed Knowledge:
A basic understanding of PCs, use of a keyboard and mouse plus knowledge of Microsoft Windows is required, gained either by previous experience or by attending a Jarrold Training "PCs, Windows and Internet Introduction" course.

Course Outline:

Introduction to MS Excel
· What is a spreadsheet?
Getting Started
· Starting Excel
· The Excel screen
· Menus and shortcut keys
· Formula bar and name box
· Sheet tabs and the status bar
· Active cell, column and row headers
· Moving around the spreadsheet
· Exiting Excel
Spreadsheet Basics
· Creating a new workbook
· Data types
· Entering and editing data
· Entering dates and times
· Deleting data
· Undo
· Selection techniques
· Saving and closing a workbook
· Opening a workbook
Cut, Copy and Paste
· The clipboard
· Using cut, copy and paste
· Drag and drop
· AutoFill
· Custom lists
Entering Basic Calculations
· Entering calculations
· AutoSum
· Statistical functions
Formatting the Worksheet
· Working with columns and rows
· Formatting toolbar
· Number formats
· Date and time formats
· Alignment and orientation
· Borders and patterns
· Format painter
Printing
· Print preview
· Page setup
· Page breaks
· Print titles
· Printing
Working with Larger Spreadsheets
· Splitting the screen
· Freezing panes
Introduction to Charting
· Creating a chart
· Printing a chart