1 Day


Public Class

Public Class

Excel Course: Master Microsoft Excel 2021 Foundation

Are you looking to boost your career prospects? Our Excel Course on Microsoft Excel 2021 Foundation is your ticket to unlocking a world of opportunities. Whether you’re a newbie or already have some spreadsheet experience, this course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels, and anyone eager to elevate their Microsoft Excel skills.

What You'll Learn

In this interactive and practical course, we delve into the core of Microsoft Excel 2021, breaking down complex spreadsheet concepts into easy-to-understand modules. You’ll discover how to navigate the Excel interface, create and format data, perform calculations, and manage large workbooks efficiently. By the end, you’ll be equipped with the skills to confidently handle tasks like data analysis, report creation, and more.

Elevate Your Career

In today’s fast-paced corporate world, Excel proficiency is a valuable asset. Whether you’re striving for a promotion, aiming for a new job, or simply looking to enhance your productivity, mastering Microsoft Excel 2021 through our Excel Course can set you on the path to success. Join us to harness the power of spreadsheets, and watch your career soar to new heights. It’s time to excel in Excel!

Course Details

Course Code: EX21F-1; Instructor-led



This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.


Basic knowledge of Windows is essential with the following pre-requisites:

  • Able to maneuver with the mouse – Point, Click, Drag and Double Click
  • Able to configure the desktop
  • Able to use the Control Panel
  • Able to move and re-size Application Windows
  • Able to switch between task applications


This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

Course Objectives

  • Give participant a systematic understanding of a spreadsheet ad its benefits
  • Equip participant with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment

Upon completion of this program, participants should be able to:

  • Getting Started with Microsoft Excel 2021, Identify the Elements and Interface of Excel
  • Performing Calculation, Basic Formula and Functions
  • Modify worksheet & Formatting Worksheet
  • Printing and managing large workbook


Topic A – Identify the Elements of the Excel Interface

  • Microsoft Excel 2021
  • What is Spreadsheet, Worksheet and Workbook
  • What are Columns, Row, Cells, and Ranges
  • The Excel Interface
  • Navigation Options

Topic B Creating a New Blank Workbook

  • The Ribbon
  • The File View
  • The Save and Save As Commands

Topic A: Formatting Fonts

  • Font type
  • Font size
  • Font color
  • Bold
  • Italic
  • Underline
  • The Mini Toolbar
  • The Clear Button


Topic B: Add Borders and Colors to Cells

  • Select Border
  • Select Fill


Topic C: Align Cell Contents

  • Horizontal Alignment
  • Vertical Alignment
  • Increase or Decrease Indent
  • Wrap Text
  • Orientation Options
  • Merge & Center


Topic D: Apply Formats

  • Format cell
    • Number
    • Date
    • Currency
  • Paste Format


Topic E: Move and Duplicate data

  • Dragging and Dropping Cells
  • Cut, copy, and paste cells
  • Cut, copy, and Paste Multiple cells
  • Using the Clipboard
  • Paste Value
  • Format Painter


Topic F: Apply Cell Styles

  • Cell Styles
  • Style Dialog Box

Topic G: Manipulate Data

  • Undo and Redo Commands
  • AutoFill Feature
  • Auto Fill Options
  • Transpose Option

Topic H: Insert, Manipulate, and Delete Cells, Columns, and Rows

  • Insert and Delete cell, row, column
  • Column Width and Row Height Alternation Methods
  • Hide and Unhide row, column

Topic A: Create Formulas in a Worksheet

  • Common Mathematical Operators
    • Addition
    • Subtract
    • Multiply
    • Divide
  • The Order of Operations


Topic B: Insert Functions in a Worksheet

  • Functions in Excel
    • SUM
    • COUNT
    • MIN
    • MAX
  • Worksheet References in Formulas

Topic A: Format Worksheet Tabs

  • Insert sheet
  • Renaming Worksheet Tabs
  • Changing sheet Tab Color

Topic B: Manage Worksheets

  • Repositioning Worksheets
  • Inserting or Deleting Worksheets
  • Hiding and Unhiding Worksheets

Topic C: Spell Check a Worksheet

  • The Spelling Dialog Box

Topic D: Search for and Replace Data

  • The Find Command
  • The Replace Command
  • The Go to Command

Topic E: Manage the view of Worksheets and Workbooks

  • Split Command
  • Freeze Panes
  • Arrange All Command
  • View Side by Side Command
  • Switch windows Command
  • New Window Command
  • Zoom Options

Topic A:  Define the Page Setup

  • Page size
  • Page orientation
  • Page Margins
  • Headers and Footers

Topic B: Print Options

  • Scale to fit
  • Page break
  • Print title



Interested In


Starting From
Intake Date
15 APR 2024
13 MAY 2024
10 JUNE 2024
15 JULY 2024
12 AUG 2024
2 SEPT 2024
7 OCT 2024
11 NOV 2024
2 DEC 2024
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Duration: 1 Day
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *