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

how to slick back natural 4c hair wholesale virgin hair vendors in atlanta ga hair extensions best synthetic braiding hair bellatique virgin brazilian hair cheap hair extensions micro bead hair extensions itchy eurasian curly hair hair wigs nbhairboutique website wedding updo wigs lace front wigs

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