Microsoft Excel 2007 Introduction

Microsoft Excel 2007 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.

Introduction to Microsoft Excel
·       What is a spreadsheet?
 
Getting Started
·       Starting Excel
 
·       The Excel screen and The Ribbon
 
·       Quick Access Toolbar 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
 
·       File Formats and Working in Compatibility mode
 
Cut, Copy and Paste
·       The clipboard
 
·       Using cut, copy and paste
 
·       Drag and drop
 
·       AutoFill
 
·       Custom lists and Excel Options
 
 
Entering Basic Calculations
·       Entering calculations
 
·       AutoSum
 
·       Auto Complete
 
·       Statistical functions
 
Formatting the Worksheet
·       Home and Page Layout Tab
 
·       Working with columns and rows
 
·       Number formats
 
·       Date and time formats
 
·       Alignment and orientation
 
·       Borders and patterns
 
·       Cell Styles
 
·       Format painter
 
Printing
·       Print preview
 
·       Page Layout View
 
·       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