Classes :: class description :

MS Excel 2000

Prerequisites

Students should have a basic knowledge of mouse and Keyboard usage.

Outline

Introduction to Microsoft Excel:

•  Overview of Excel
• Keyboard Commands to move around Excel

• Making a Spreadsheet

Using Cells in Excel

•  Data Entry in Excel.
• Formatting text color, fill color, Number Style
• Filtering, Sorting and Inserting Comments
• Concept of Absolute Value in Excel

Formatting Data in Excel:

•   Creating charts in Excel

• Using AutoFormat in Excel to design a spreadsheet    

• Merging Cells

• Using Pivotal Tables in excel.   

• Editing Pivotal Table

• Working with Data Consolidation

• Recording Macros in Excel

Understanding Formulas

•  Using Formula in Excel

• Using Advance Formula in Excel

• Protecting Worksheet /Workbook

• Share workbook.

Creating Objects in Excel:

• Creating Hyperlinks

• Extracting Data

• Inserting ClipArt and WordArt

• Exporting/Importing Excel Data