img
iTrainingExpert Logo

Microsoft Excel Intermediate

USD 820
REGISTER NOW IN HOUSE ENQUIRY

Available Sessions

Session Location Register
11 - 12 Mar 2025 SELANGOR, Malaysia Register
03 - 04 Jul 2025 SELANGOR, Malaysia Register
11 - 12 Sep 2025 SELANGOR, Malaysia Register
18 - 19 Nov 2025 SELANGOR, Malaysia Register
02 - 03 Dec 2025 SELANGOR, Malaysia Register

Description

Microsoft Excel has proven to be an essential tool in today's fast-paced, technical business environment world, accurate accounting, and calculations can mean the difference between success and failure.
This 2-day Excel: Intermediate training program is a follow up to our Excel Basic course with greater emphasis on data management skills and the features required for it.

This Microsoft Excel training for Intermediate Level is best suited for people who are already familiar with Excel 's basic functions and need to get more out of the software on a daily basis.
Upon completion of this course, you will have a good overview of more advanced Excel functions.

Clerks, operations personnel, security personnel, customer officers, front and backend staff who already have some foundation in Excel.

AGENDA
DAY 1: 9:00am - 5:00pm

9:00 - 10:30am
Module 1 : Main Excel objects

  • What are worksheets & workbooks?
  • Columns, row, cells & ranges
  • Navigating, important shortcut keys
  • The Backstage
  • The Ribbon

Module 2 : Worksheets & workbooks

  • Creating a worksheet
  • Creating a workbook
  • Save & save as

Module 3 : Formulas

  • What are excel formulas
  • The formula bar
  • Common mathematical operators
  • The order of operations


10:30- 11:00AM TEABREAK

11:00AM - 1:00PM
Module 4 : Insert functions

  • The Excel function
  • The function library
  • Important excel functions

Module 5 : Formula references

  • Absolute & relative references
  • References when copying formulas in an array

Module 6 : Important Excel functions

  • IF, VLOOKUP, SUMIF, COUNT

1:00- 2:00PM LUNCH

2:00- 3:30PM
Module 7 : Important excel aspects

  • Undo & redo
  • Autofill feature
  • Autofill options
  • Dragging & dropping cells
  • Cut, copy, & paste cells
  • How to cut, copy, & paste multiple cells
  • Using the clipboard
  • Paste special
  • The transpose option
  • Live preview
  • The Clear button
  • Excel spellchecking

Module 8 : Rows & columns

  • Inserting & deleting
  • Important shortcut keys
  • Adjusting width of rows & columns
  • Hiding & unhiding rows & columns

Module 9 : Finding & replacing data

  • The Find command
  • The Replace command
  • The Go to command

3:30PM - 4:00PM TEABREAK

4:00PM - 5:00PM
Module 10 : Excel fonts

  • Fonts & font type
  • The font group
  • The format cells dialog box
  • The format painter
  • Live preview & formatting
  • The mini toolbar

Module 11: Drawing borders & coloring cells

  • Border optins
  • Fill options
  • Sheet backgrounds

End of Day 1

Day 2: 9:00am - 5:00pm
9:00AM - 10:30AM
Module 12 : Apply number formats

  • Number formats
  • Excel number formats
  • Customizing number formats

Module 13: Cell alignment & cell styles

  • Alignment options
  • The indent command
  • Orientation options
  • The merge & center options
  • Cell styles
  • The style dialog box

10:30 - 11:00AM TEABREAK

11:00AM - 1:00PM
Module 14 : Printing excel worksheets

  • Print options in backstage view
  • Page setup dialog box
  • Print preview options
  • Inserting headers & footers
  • Header & footer settings
  • Page margins
  • Margins tab options
  • Setting page orientation

Module 15 : Page layout & other print options

  • Zoom options
  • Page breaks
  • Page break options
  • Setting the print area
  • Print titles
  • Scaling options

Module 16 : Worksheet tabs

  • Renaming worksheet tabs
  • Changing tab color
  • Hiding & unhiding worksheets
  • Deleting worksheets
  • Copying tabs
  • Moving tabs

1:00PM -2:00PM LUNCH 

2:00PM - 3:30PM
Module 17 : Worksheet views

  • Split command
  • Freeze panes options
  • Arrange all command
  • Arrange windows dialog box
  • View side by side command
  • Switch windows command
  • New window command

Module 18 : Formula Auditing

  • Tracking Dependents and Precedents
  • Showing formulas
  • Error checking and tracing errors

Module 19 : Sorting & Filtering

  • Working with lists
  • Applying Sorting and Filtering to a list
  • Simple sorting
  • Sorting by multiple columns
  • Using AutoFilter
  • Using custom filter
  • Using Advanced Filter
  • Removing duplicates from data

3:30PM - 4:00PM TEABREAK

4:00 - 5:00PM
Module 20 : Data Tools

  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Consolidate

Module 21 : Introduction to Excel charts

  • Types of Excel charts
  • Data ranges and selecting data
  • The bar graph
  • The pie chart
  • Advanced chart formatting

END OF DAY 2 

This is an activity-based workshop to cover Excel features and commands to jump start productivity for existing Excel users. Laptops required.

BEATRICE V.
Qualifications:

  • ICL Diploma in Computer Studies
  • NCC Diploma in Computer Studies
  • Microsoft Office User Specialist
  • Accredited Trainer by Pembangunan Sumber Manusia Berhad (PSMB/HRDF)

With 29 years of extensive experience in the training industry, Beatrice V. is one of the pioneering trainers in Microsoft Office training programs. Her expertise spans various corporate sectors, and she is proficient in delivering both in-person and remote training sessions via platforms such as Microsoft Teams, Zoom, and Google Meet.

As a certified Microsoft Office Training Consultant accredited by PSMB, Beatrice has honed her skills while working with premier Microsoft-certified training centers, including Iverson Associates, GHL Training, and NIIT Cats. She began her career as a programmer, where she developed specialized software solutions for the legal industry, before transitioning to the training field.

Her portfolio includes conducting product seminars, pre- and post-training evaluations, and developing comprehensive training materials in both English and Bahasa Malaysia. With fluency in both languages, she seamlessly delivers training to diverse audiences, including international participants. Notably, she has provided training for prestigious organizations such as the American Embassy, the International Labour Organization (Thailand), and various government agencies in Brunei.

Beatrice’s achievements include spearheading tailored Microsoft application training programs and delivering Microsoft Certified Application Specialist courses to senior executives, including Managing Directors and Senior Managers.

Renowned for her patience and adaptability, she tailors courses to meet participants\' specific needs, ensuring successful learning outcomes. Her ability to engage diverse audiences and deliver impactful training sessions has made her a highly sought-after trainer in the industry.


OR 

We have a faculty of experienced trainers who can cater to your specific training needs upon demand.
For training and advisory services, feel free to contact us at info@itrainingexpert.com or call us at +603 8082 3707 | +603 8074 9056 | +6012 6869 628 | +6018 2175 123

“I have learned a lot of knowledge from this course, Excel (Intermediate level). Both the training and the trainer are equally good. I would like to join other Microsoft Office course.”– Secretary, NUR Power Sdn Bhd

“Before attending the course, I felt ready to learn & improve my Excel skills. In the program I learned many methods to work on data in Excel. After the course, I feel I have improved some excel skills. The trainer went above & beyond and share a lot. His training is also easy to understand & very clear.” – Intan Diana, Science officer, ISTIC-UNESCO.

“I felt that I lacked the necessary skills to utilize Excel efficiently. During the course, I learned a lot of different excel functions that could help me in at work. After the 2 days training, I feel like an Excel master. The trainer was very engaging. He answered all my questions and explained them very well.”- Ahmad Safuan, Science officer, ISC ROAP.
 
“I didn’t have too much knowledge about Excel and its functions. By showing up in the 2 days Microsoft Excel course, I feel gained knowledge & discover many things in this application. The trainer was good at explaining.”- Zarmila Salmi, Admin & Finance officer, ISTIC-UNESCO.

Normal Fee Early Bird Group Fee
Sign up 1 pax Sign up 1 pax Sign up 3 pax or more
Pay 1 day(s) before course starts Pay 14 day(s) before course starts Pay 14 day(s) before course starts
MYR 2790 per pax MYR 2290 per pax MYR 2190 per pax
USD 820 per pax USD 670 per pax USD 640 per pax

Upon successful completion of this program, you will receive a Certificate of Achievement.

1. Online Payment by Credit card: You can opt to register and pay online with our latest payment integration system through our website.
2. Bank Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks.
3. HRD Corp Claimable Courses Skim Bantuan Latihan Khas - Applicable to Malaysian Employer Only

We'd happy to help.
Feel free to talk to us today, however most suitable for you.
Mobile call/ whatsapp: +6012 6869 628 | +6018 2175 123
Office: +603 8074 9056
Email: info@itrainingexpert.com
Website: www.itrainingexpert.com

Share to your friends