Introduction

This course is design to introduce participants to the basic functions and features of Microsoft Excel, a powerful spreadsheet tool used for recording, organizing, calculating, and analyzing numerical and statistical data. In response to the growing need for digital competency in data handling and reporting, this course supports individuals—particularly those with no prior experience—with foundational Excel skills for both professional and personal use. This course enables participants to enter and delete data, apply basic formulas, and create simple charts to visually present information

Learning Outcome

At the end of the program, participants will be able to:

• understand the use of a spreadsheet and its benefits.
• utilise spreadsheet software in a day-to-day business environment effectively.
•  indicate the names and functions of the Excel interface components.
• enter, edit, and format data and cells.
• construct formulas, including the use of built-in functions, and relative and absolute references.
• create and modify charts.
•  preview and print worksheets

Key Topics

Key topics include:

1. Exploring Spreadsheet
   • Creating a New Workbook
   • Opening and Closing a Workbook
   • Saving a Workbook
   • About Excel File Types
   • Using Worksheets
   • The Active Cell
   • Selecting Cells
   • Exploring a Worksheet
   • Using Zoom
2. Working with Excel
   • Columns, Rows, Cells, and Ranges
   • Creating Worksheet Labels
   • Entering and Deleting Data
3. Basic Excel Features
   • AutoFill
   • AutoSum
   • AutoComplete
   • Working with Basic Formula2
4. Moving the Data
   • Dragging and Dropping Cells
   • How to Cut, Copy, and Paste Cells
   • How to Cut, Copy, and Paste Multiple Cells
   • Using Paste Special
   • Inserting and Deleting Cells, Rows, and Columns
   • Using Undo, Redo, and Repeat
5. Modifying Cells and Data
   • Changing the Size of Rows or Columns
   • Adjusting Cell Alignment
   • Rotating Text
   • Creating Custom Number and Date Formats
6.  Cell Formatting
   • The Format Painter
   • Cell Merging and AutoFit
7.  Enhancing a Worksheet’s appearance
   • Adding Patterns and Colors
   • Adding Borders
   • Working with Styles
   • Working with Themes
8.  Working with Charts
   • Creating a Chart
   • Styling Charts with the Design Tab
   • Modifying Charts with the Layout Tab
   • Manipulating a Chart
9.  Using the View Tab
   • Using Normal View
   • Using Full-Screen View
   • Using Page Layout View
   • Page Break Preview
10. Printing the Workbook
    • Print Commands
    • Print Preview
    • Using Basic Print Options
    • Other Print Options

Duration

2 Days | 13 hours

Target Participant

• Executive Services 2 (ES 2) – Bahagian II:  B2
• Executive Services 3 (ES 3) – Bahagian III: C3 | C2 | C1
• Non- Executive Services (Non-ES) – Bahagian IV | V

Pre-Requisite

N/A

Language

Bahasa Melayu / English

Methodology

The course will be delivered using:

• Instructor-Led Training
• Hands-On Laboratory
• Demonstration
• Step-By-Step Guides

Assessment Methods

Pre-Test & Post-Test

Program Evaluation