LIVE ZOOM 8 Nov 2023 (Wed) | 9am - 5pm

TRAINING 9 Nov 2023 (Thu) | 9am - 5pm

In this course, you will learn how to link workbooks and worksheets, work
with range names, sort and filter range data, and analyze and organize
with tables. You will also apply conditional formatting, outline with
subtotals and groups, display data graphically with charts and sparklines.
Additionally, you will also understand PivotTables, PivotCharts, and
slicers.

 Learn the building blocks of Intermediate Excel functionality.

 Link Workbooks and Worksheets.
 Work with Range Names and Sort and Filter Range Data.
 Analyze and Organize with Tables.
 Use Conditional Formatting and Display Data Graphically.
 Outline with Subtotals and Groups.
 Understand PivotTables, PivotCharts, and Slicers

Those wishing to increase their knowledge of Excel to create more

in-depth worksheets and improve the presentation of data.

 A working knowledge of creating/formatting simple spreadsheets,

basic formulas and functions
 Excel Introduction course or equivalent knowledge or experience.

For Enquiries, Please Call: 012-588 2175 | Email: otc.irene2@outlook.com | Website: www.otc.com.my
For Enquiries, Please Call: 012-588 2175 | Email: otc.irene2@outlook.com | Website: www.otc.com.my
 COURSE CONTENT
1. Linking Workbooks and Worksheets
1.1 Linking Workbooks and Worksheets
1.2 Linking Worksheets with 3D References
1.3 Understanding the Consolidate Feature

2. Working with Range Names

2.1 Using the Name Box and Define Name
2.2 Using Create from Selection

3. Sorting and Filtering Range Data

3.1 Differences Between Sorting and Filtering
3.2 Sorting Lists
3.3 Filtering Lists
3.4 Creating Subtotals

4. Analyzing and Organizing with Tables

4.1 Creating Tables and Understand the Benefits
4.2 Understanding the Elements of a Table
4.3 Formatting a Table
4.4 Sorting and Filtering Tables
4.5 Filtering with Slicers
4.6 Calculating with Tables

5. Using Conditional Formatting

5.1 Highlight Cells and Top Bottom Rules
5.2 Data Bars, Icon Sets, and Color Scales
5.3 Using Custom Fonts and Colors
5.4 Using Custom Conditional Formatting
5.5 Modifying or Removing Conditional Formatting

6. Displaying Data Graphically

6.1 Creating Charts
6.2 Understanding Chart Elements
6.3 Formatting Charts
6.4 Creating Dual Axis Charts
6.5 Creating a Chart Template
6.6 Displaying Trends with Slicers

7. Understanding PivotTables, PivotCharts and Slicers

7.1 Creating a PivotTable
7.2 Working with PivotTable Fields Pane
7.3 Formatting PivotTable
7.4 Creating a PivotChart
7.5 Formatting PivotChart
7.6 Using Slicers and Timeline Slicers

For Enquiries, Please Call: 012-588 2175 | Email: otc.irene2@outlook.com | Website: www.otc.com.my
 OUR CONSULTANT
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 Malaysiato 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
1999 – Bachelor of Computer Science (Honours) · Computing (Single Major) - USM
2001 – Master 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)

For Enquiries, Please Call: 012-588 2175 | Email: otc.irene2@outlook.com | Website: www.otc.com.my
 OUR CONSULTANT
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

For Enquiries, Please Call: 012-588 2175 | Email: otc.irene2@outlook.com | Website: www.otc.com.my
 REGISTRATION FORM
(Please make copies of this page for registration required)
ONLINE TRAINING PROGRAM (VIA ZOOM)
8 Nov 2023 (Wed) | 9am - 5pm
9 Nov 2023 (Thu) | 9am - 5pm
Microsoft Excel - Intermediate Level
(SBL KHAS PROGRAM ID: 1000128136)
CANCELLATION & SUBSTITUTIONS
50% of the training fees would be imposed for the cancellation before 1 week of the event.
Full training fees would be charged for the cancellation within 1 week prior to the event or absence during the event.
Substitutions are welcomed at anytime.

Term and condition for HRD Corp Claimable Course application only:
1. Client is advisable and compulsory to apply for training program approval for HRD Corp Claimable Course at least 7 working
days before training start.
2. Client need to pay full amount for CONFIRMED training cost to Training Provider if failed to get approval from HRD Corp
Claimable Course or failed to meet the requirement and rejected by HRD Corp Claimable Course .

TRAINING FEES

ONLINE TRAINING FEE

14 hours online training RM 1,320.00/pax (excluded 6% SST)

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

REGISTRATION DETAILS
Please tick : [ ] Group Registration [ ] Early Bird Fee [ ]Normal Fee [ ] Special Grant
(Total Number of Pax: _____ Fees Per Pax: ________)
Do you apply HRD Corp Claimable Course (YES / NO) : __________
Organization : ___________________________________________
Please complete the registration form then
Contact Person : ___________________________________________ EMAIL to us at: otc.irene2@outlook.com
Designation : ___________________________________________
For More Enquiries, contact us at:
Email : ___________________________________________
Deskphone / Mobile No.: ____________________________________
OTC TRAINING CENTRE SDN BHD
Address : ___________________________________________ Tel: 012-588 2175 (Irene)
____________________________________________
Visit us at: www.otc.com.my
____________________________________________

PARTICIPANT DETAILS
FULL NAME: MOBILE NO.:
1
DEPARTMENT/
EMAIL:
DESIGNATION::

FULL NAME: MOBILE NO.:

2
DEPARTMENT/
EMAIL: AUTHORISED SIGNATURE
DESIGNATION::

FULL NAME: MOBILE NO.:

3
DEPARTMENT/
EMAIL:
DESIGNATION::

FULL NAME: MOBILE NO.:

4
DEPARTMENT/
EMAIL:
DESIGNATION::

FULL NAME: MOBILE NO.:

5 COMPANY STAMP
DEPARTMENT/
EMAIL:
DESIGNATION::

For Enquiries, Please Call: 012-588 2175 | Email: otc.irene2@outlook.com | Website: www.otc.com.my