Site Map

  1. Overview
  2. Module Objectives, Course Duration, Pre-requisite
  3. Concept Map
  4. Chapter Test
  5. Lesson 1: Getting Started with Microsoft Excel
    1. Section 1.1 Introduction to Microsoft Excel
    2. Section 1.2 How to start the MS Excel Spreadsheet Program
    3. Section 1.3 Microsoft Excel Screen Elements
    4. Activity 1
    5. Activity 2
  6. Lesson 2: Creating a New Worksheet
    1. Section 2.1 Creating a New Worksheet
    2. Section 2.2 Entering and Changing Data in a Cell
    3. Section 2.3 Saving the Worksheet
    4. Activity 1
    5. Activity 2
  7. Lesson 3: Modifying the Appearance of a Worksheet
    1. Section 3.1 Applying Font Properties Font Group Table
    2. Activity 1
    3. Activity 2
    4. Section 3.2 Formatting Numbers
    5. Section 3.3 Inserting a Row or Column in a Worksheet
    6. Section 3.4 Renaming and Coloring the Worksheet Tab
    7. Activity 3
  8. Lesson 4: Managing an Excel Worksheet
    1. Section 4.1 Using the Undo and Redo Buttons
    2. Section 4.2 Using Cut, Copy and Paste Commands
    3. Activity 1
    4. Activity 2
  9. Lesson 5: Inserting Formula and Functions
    1. Arithmetic Operation and Corresponding Keyboard Sign
    2. Section 5.1 Entering Labels and Data
    3. Section 5.2 Using the Excel Functions (Sum, Average, Max, Min and Count)
    4. Section 5.3 Using the SUM Function
    5. Section 5.4 Using the AVERAGE Function
    6. Section 5.5 Using the MAX Function
    7. Section 5.6 Using the MIN Function
    8. Activity 1
    9. Activity 2
  10. Chapter Test