Contents

1.  Introduction to Microsoft Excel

•  What is a spreadsheet?

•  What is it used for?

•  Ways to access MS-Excel

2. Components of Microsoft Excel 2000

3.  Features of Microsoft Excel 2000

4.  Understanding the worksheet

•  Create a worksheet / templates

•  Save a worksheet

•  Open/close a worksheet

•  Navigating a worksheet

5.  Data handling in a worksheet

•  Entering data

•  Editing data

•  Deleting data

•  Copying and moving data

•  Selecting data

•  Formatting data

•  Sorting data

•  Filtering data

•  Formula

•  Functions

6.  Analyzing data in worksheets

•  Summarizing – totals/subtotals

7. Charts

•  Need for charts

•  Types of charts

•  Create charts

•  Add chart elements

•  Edit chart data

•  Display charts

•  Print charts

8.  Printing a worksheet

 

Appendix 1 – How to get help while you work

Appendix 2 - Guidelines for searching help