|
Module 2: Microsoft Excel-
1 Week (14 hours) |
Lesson 1: Entering Text
and Numbers
- The Microsoft Excel Window
- Moving Quickly Around the Microsoft
Excel Worksheet
- Selecting Cells
- Entering Data
- Editing a Cell
- Changing a Cell Entry
- Wrapping Text
- Deleting a Cell Entry
- Entering Numbers as Labels or Values
- Smart Tags
- Saving a File
- Closing Microsoft Excel
|
|
Lesson 2: Formatting Text and
Performing Mathematical Calculations
- Choosing a Default Font
- Adjusting the Standard Column Width
- Cell Alignment
- Adding Bold, Underline, and Italic
- Changing the Font, Font Size, and
Font Color
- Working with Long Text
- Changing a Single Column Width
- Moving to a New Worksheet
- Setting the Enter Key Direction
- Making Numeric Entries
- Performing Mathematical Calculations
- he AutoSum Icon
- Automatic Calculation
- Formatting Numbers
- More Advanced Mathematical Calculations
- Cell Addressing
- Deleting Columns
- Deleting Rows
- Inserting Columns
- Inserting Rows
- Creating Borders
- Merge and Center
- Adding Background Color
- Using Auto Format
- Saving Your File
- Closing Microsoft Excel
|
|
Lesson 3: Numbers and Mathematical
Calculations
- Reference Operators
- Functions
- Typing a Function
- Calculating an Average
- alculating Min
- Calculating Max
- Calculating Count
- Filling Cells Automatically
- Printing
- Print Preview
- Saving Your File
- Closing Microsoft Excel
|
|
Lesson 4: Creating Charts
- Creating a Column Chart
- Changing the Size and Position of
a Chart
- Modify Your Chart
- Saving Your File
- Closing Microsoft Excel
- Interview questions and answers discussion
- Written test
- Oral presentation test
|
