Excel Introduction

Duration:

1 day

Versions Available:

97, 2000, XP, 2003 , 2007, 2010
COURSE OUTLINE
Introduction
What is a Spreadsheet
Starting Excel
Parts of the screen
The office assistant
Quitting Excel

Basic Skills
Cursor movement
Using Go To
Highlighting areas of the worksheet
Entering data
Editing a cell entry
Deleting a cell or range of cells
Undoing the last command
Redoing the last command
Drag and drop
Filling a range
Insert and delete
AutoComplete
Inserting deleting rows and columns
Smart Tags
Opening, closing and saving
Creating a new file
Viewing a list of open files
Version compatibility
Email a spreadsheet
File search

 Entering Formulae
Entering simple calculations
Circular references
Using AutoSum
Using Paste Function
Statistical functions
Relative and absolute cell referencing
Formula auditing mode
Printing cell formulae
Using AutoCalculate
Error correction
Screen tips for function arguments

Formatting
Using the formatting toolbar
Adjusting column widths and row heights
Changing cell alignment
Formatting numbers
Changing fonts and attributes
Borders and patterns
Using the shortcut menu
Copying styles
Cut, copy and paste
Copying data into Word

Printing
Print preview
Changing the page setup
Defining the print area
Printing
Inserting a page break
Page break preview
Charts and Drawing
Creating a chart
Changing the chart type
Using the drawing tools
Print Friendly Print Get a PDF version of this webpage PDF

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>