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
Printing
Print preview
Changing the page setup
Defining the print area
Printing
Inserting a page break
Page break preview |
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
Charts and Drawing
Creating a chart Changing the chart type
Using the drawing tools
|
Book