Using the Office Assistant

 

The Excel Window

• Understanding the Spreadsheet Concept
• Exploring the Screen Layout
• Working With Toolbars and Menus

 

Creating a Worksheet

• Entering and Editing Data
• Selecting Ranges and Entering a Range of Data
• Erasing Data
• Using the Undo Facility and Search and Replace
• Using AutoComplete

 

Formulae

• Creating and Editing Formulae
• Changing the Order if a Calculation
• Understanding Error Messages

 

File Procedures

• Saving, Closing and Opening a Workbook
• Starting a New Workbook
• Saving a Workbook in Another File Format
• Saving a Workbook for the Internet

 

Moving, Copying and Sorting Data

 

Functions and absolute References

• Using Statistical Functions
• Using AutoSum and AutoCalculate
• Absolute Cell References

Spreadsheet Presentation

• Inserting and Deleting Rows and Columns
• Modifying Row Heights and Column Widths
• Aligning and Rotating Data
• Changing the Font Size and Type
• Altering the Number Display
• Adding Borders and Shading
• Spell Checking

 

Printing

• Viewing a Spreadsheet
• Changing the Page Setup and Inserting Page Breaks
• Setting Print Areas

 

Working With Multiple Sheets and Files

• Creating Multiple Sheets and Linking Them
• Copying and Pasting Between Worksheets
• Working With Multiple Workbooks

 

Producing Charts

• Creating Embedded and Separate Charts
• Changing the Chart Type and Adding Text
• Adding a Legend and Gridlines
• Changing the Scale
• Modifying the colours in the Chart

 

Working With Images and Other Objects

• Inserting Clipart Pictures
• Importing and Manipulating Images and Other Objects