Skip to Content

GRAB YOUR FREE SEAT !!! Microsoft Excel (Basic Level) 28 & 29 July 2025

CLICK HERE TO DOWNLOAD BROCHURE

 

Please call 012-588 2728

 email to pearl-otc@outlook.com

HYBRID PUBLIC PROGRAM

MICROSOFT EXCEL

(BASIC LEVEL)

(** Choose either Zoom OR Physical Session)

Remote Online Training (Via Zoom)  &

OTC Training Centre Sdn Bhd Subang, Selangor  (Physical)

  (SBL Khas / HRD Corp Claimable Course)

Date : 28 July 2025 (Mon) |  9am – 5pm        By Siti

             29 July 2025 (Tue)  |  9am – 5pm           .        .

INTRODUCTION

This course covers all the essentials of Microsoft Office Excel. Topics covered include the new Flash Fill feature, using formulas and functions, and customizing the interface. Material is also included on how to format text, data, and workbooks; and chart data.

 

OBJECTIVES

·        How to create, open, and save workbooks

·        How to enter, select, and delete data

·        How to undo and redo

·        Using cut, copy, and paste functions

·        Inserting rows and columns

·        How to merge and split cells

·        Using Paste Special, find and replace, and hiding and unhiding cells

·        How to use basic formulas

·        How to learn basic and advanced functions

·        How to run spell check.

·        How to use the sort and filter tools to organize data

·        How to use AutoFill, Flash Fill, AutoSum, AutoComplete, and AutoCalculate

·        Various ways to format and work with text

·        Various methods to chart data

·        Ways to view and distribute a workbook

·        Ways to customize the interface

 

OUTLINE OF WORKSHOP

Module 1: The Basics

-       Creating a New Workbook

-       Parts of a Workbook

-       Saving a Workbook

-       Opening a Workbook

Module 2: Your First Workbook

-       Selecting Data

-       Entering and Deleting Data

-       Using Undo and Redo

-       Using Cut, Copy, and Paste

Module 3: Working with Data

-       Inserting Rows and Columns

-       Merging and Splitting Cells

-       Moving Cells

-       Using Paste Special

-       Using Find and Replace

-       Hiding and Unhiding Cells

Module 4: Using Basic Excel Tools

-       Understanding Cell References and Formulas

-       Using Basic Formulas

-       Using Basic Functions

-       Using Advanced Functions

-       Using Spell Check

-       Using Sort and Filter

Module 5: Using Timesaving Tools

-       Using AutoFill

-       Using Flash Fill

-       Using AutoSum

-       Using AutoComplete

-       Using AutoCalculate

Module 6: Formatting Text

-       Changing the Font Face, Size, and Color

-       Applying Text Effects

-       Applying Borders and Fill

-       Using the Font Tab of the Format Cells Dialog

-       Clearing Formatting 

Module 7: Formatting Data

-       Wrapping Text

-       Changing the Size of Rows and Columns

-       Adjusting Cell Alignment

-       Changing Text Direction

-       Changing Number Format

Module 8: Formatting the Workbook

-       Using Cell Styles

-       Formatting Data as a Table

-       Changing the Theme

-       Inserting Page Breaks

-       Adding a Background

Module 9: Charting Data

-       Creating Sparklines

-       Inserting Charts

Module 10: Viewing, Printing, and Sharing Your Workbook

-       Using Views

-       Saving a Workbook as PDF or XPS

-       Printing a Workbook

Module 11: Customizing the Interface

-       Changing Ribbon Display Options

-       Customizing the Quick Access Toolbar

-       Hiding and Showing Ribbon Tabs

-       Creating Custom Ribbon Tab

-       Resetting Interface Changes

** Certificate of attendance will be awarded for those who completed the course

 

ABOUT THE FACILITATOR

Siti

Microsoft Office Specialist (MOS)

Siti started her career as an Information Technology Lecturer in few local colleges and universities back in year 1999. In her 8 years’ experience as a lecturer, she picks up various discipline in IT related subjects. She also involved in giving Microsoft Office Applications training to various companies.

Since 20March 2006 till present, Siti Suriani decided for a career change. She moved to IT related training. As a Training Consultant, she focused more on Microsoft Office Applications training. She has facilitated training programs in link with broad-ranging groups of training institutes and clients. She is familiar and proficient with Microsoft Office Applications and during her training she will address the day to day issues faced by employees in today’s corporate environment.

In year 2007 till 2008 Siti Suriani had been appointed as one of the Master Trainer for The Teaching and Learning of Science and Mathematics in English (Pengajaran dan Pembelajaran Sains dan Matematik Dalam Bahasa Inggeris - PPSMI). Her role as a Master Trainer was to give training to all the trainers representing different states around Malaysia on how to deliver the training to all the teachers in various schools in Malaysia.

Aside to giving training, Microsoft Malaysia has engaged her to share her expertise on how to fully maximize the usage of Microsoft Office Applications since year 2008 till current. She had done many workshops around Malaysia for major Microsoft Malaysia customers mostly focusing on the Tips and Tricks and also best practices.

Siti was involved as a Handyman in Handyman Project under Shell Global Solutions, Malaysia since 2008 till 2011. To be given the opportunity to give One-to-one consultation with the client by looking, asking and solve problem related to the data provided by the clients. Examples of topics covered for Handyman sessions are E-mail and Calendar, Standard & Mobile Office, Archiving & Back-ups, NetMeeting, Livelink, Live Meeting? and Microsoft Office Applications.

Nov 2010 to Feb 2011 she was being given another golden opportunity by ExxonMobil Malaysia to be the lead trainer in the Migration from XME to GME project to train almost 3000 staffs. This training also includes Microsoft Office 2010 and Windows 7.

Academic Qualification

1999Bachelor of Computer Science (Honours) · Computing (Single Major) - USM

2001Master of Science · Distributed Computing - UPM

Working Experience

·        Cybernetics International College of Technology · Lecturer · (June 1999 to May 2002)

·        MARA University of Technology (UiTM Seri Iskandar) · Lecturer · (June 2002 to July 2003)

·        Cosmopoint College of Technology · Lecturer · (September 2005 to March 2006)

·        Iverson Associates Sdn Bhd · Senior Training Consultant · (March 2006 to February 2011)

·        Info Trek Sdn Bhd · Senior Training Consultant· (February 2011 to April 2017)

·        Fulltime Senior Training Consultant · (May 2017 to present)

Professional Certification

·        Microsoft Certified Application Specialist for Office Excel 2007

·        Microsoft Certified Application Specialist for Office PowerPoint 2007

·        Microsoft Certified Application Specialist for Office Word 2007

·        Microsoft Office Specialist for Office Excel 2016

·        Microsoft Office Specialist for Office Word 2016

·        PSMB Certified Trainer

Skills Expertise

Microsoft Office Excel version 95, 97, 2000, 2002, 2003, 2007, 2010, 2013, 2016, 2019, Office 365

Microsoft Office PowerPoint version 95, 97, 2000, 2002, 2003, 2007, 2010, 2013, 2016, 2019, Office 365

Microsoft Office Word version 95, 97, 2000, 2002, 2003, 2007, 2010, 2013, 2016, 2019, Office 365

Microsoft Office Project version 2003, 2007, 2010, 2013, 2016

Microsoft Office Outlook version 2000, 2002, 2003, 2007, 2010, 2013, 2016, 2019, Office 365

Microsoft Office Access version 97, 2000, 2002, 2003, 2007, 2010, 2013, 2016, 2019

Microsoft Office Workshops (Microsoft Malaysia)

·        Bahagian Teknologi Maklumat, Pejabat SUK Negeri Selangor

·        DIGI Telecommunications Sdn Bhd

·        Halal Industry Development Corporation

·        Institut Jantung Negara Sdn Bhd

·        Lembaga Tabung Haji

·        Newfield Sarawak Malaysia Inc

·        PERKESO

·        Securities Commission Malaysia

·        Sunway Medical Centre

·        Sutera Harbour Resort - The Pacific Sutera Hotel

·        BSN

(SBL Khas / HRD Corp Claimable Course)

TRAINING FEE

14 hours Remote Online Training (Via Zoom)

RM 1,296.00/pax     (excluded 8% SST)

2 days Face-to-Face Training (Physical Training)

RM 1,850.00/pax     (excluded 8% SST)

Group Registration: Register 3 participants from the same organization, the 4th participant is FREE.
(Buy 3 Get 1 Free) if
Register before 18 July 2025. Please act fast to grab your favourite training program!

  

We hope you find it informative and interesting and we look forward to seeing you soon.

Please act fast to grab your favorite training program!

Please call 012-588 2728 or email to pearl-otc@outlook.com

 

Do forward this email to all your friends and colleagues who might be interested to attend these programs

If you would like to unsubscribe from our email list at any time, please simply reply to the e-mail and type Unsubscribe in the subject area.

We will remove your name from the list and you will not receive any additional e-mail

Thanks 

Regards

Pearl


by "pearl@otcsb.com.my" <pearl@otcsb.com.my> - 03:06 - 10 Jun 2025