img
iTrainingExpert Logo

Microsoft Excel- Advanced

USD 820
REGISTER NOW IN HOUSE ENQUIRY

Available Sessions

Session Location Register
25 - 26 Feb 2025 ESPIRA HOTEL KINRARA, Malaysia Register
27 - 28 May 2025 KUALA LUMPUR, Malaysia Register
21 - 22 Aug 2025 KUALA LUMPUR, Malaysia Register
15 - 16 Oct 2025 SELANGOR, Malaysia Register
17 - 18 Dec 2025 SELANGOR, Malaysia Register

Description

This Microsoft Excel - Advanced training is designed for experienced users who need to manage complex data and perform advanced functions. Over 2 days, you will delve into sophisticated formulas, powerful data analysis tools, and key Excel features to enhance your proficiency and efficiency.

Ideal for departments and professionals handling high volumes of data, this course covers advanced topics including array formulas, Pivot Tables, Power Query, and Conditional Formatting. You will learn to streamline data processing, create dynamic charts, and apply advanced techniques to solve complex problems.

By the end of this program, you will have a deep understanding of Excel’s advanced capabilities, enabling you to handle complex data tasks with greater speed and accuracy.

This 2-day program covers functions & formulas important to regular users of Excel who process and operate a medium-to-high volume of data in various complexities at the office. This course aims to bring your expertise in Excel to the advance level so that your turn-around-time in Excel spreadsheets are reduced.

HR managers, project managers, revenue managers, finance managers and administrative personnel who already have a BASIC to INTERMEDIATE understanding of Excel 2016 and are looking to expand it further.

DAY ONE (9.00AM-5.00PM)

9.00am - 10.30am
Module 1. Formula references
Absolute & relative references
References when copying formulas in an array

Module 2. Array formulas
New developments in array formulas
How to apply legacy CSE formulas
How to apply new platform array formulas

10.30am -10.45am - Break

10.45am -1.00pm
Module 3. Logical functions
IF function
IFS function (Microsoft 365, Excel 2021, Excel 2019 only)

Module 4. Lookup functions
VLOOKUP function
Match types-looking up an exact match and looking up a range
INDEX, MATCH Functions- basic & array formulas
XLOOKUP Function

1.00pm -2.00pm – Lunch Break

2.00pm -3.30pm
Module 5. SUM & COUNT functions
SUMIF, SUMIFS, COUNTIF, COUNTIFS Functions
DSUM & DCOUNT

Module 6. An introduction to Table
Function of the Table
Creating the Table
Advance Filtering
Slicers

3.30pm - 3.45pm - Break

3.45pm -5.00pm
Module 7. The Pivot Table
Creating the Pivot Table from a flat file
Populating the Pivot Table, formatting values & other Pivot Table options & settings
Slicers & Timelines
Pivot Charts
GETPIVOTDATA

End of 1 day Training

DAY TWO (9.00am-5.00pm)

9.00am - 10.30am
Module 8. The OLAP Pivot Table
What is OLAP?
Introduction to the OLAP Pivot Table
Tables and Data Models
OLAP Pivot Table formulas

10.30am -10.45am - Break

10.45am -1.00pm
Module 9. Form Controls & Drop-down boxes
Introduction to Form Controls- ScrollBar, Combobox, Data Validation List
Creating Form Controls and using them in data analysis
Creating drop-down boxes using the Data Validation List.

1.00pm -2.00pm - Lunch Break

2.00pm -3.30pm
Module 10. Extracting & combining data with Power Query
Extracting data of various file types and source
Transforming extracted data
Merging and appending data
Combining worksheets from a folder

Module 11. Excel charts
Introducing new graphs and charts in Excel
The primary & secondary axis
Chart styles
Custom chart templates
Sparklines

3.30pm - 3.45pm - Break

3.45pm -5.00pm
Module 12. Conditional Formatting
What is Conditional Formatting?
Conditional Formatting Rules, Data Bars, ColorScales and Icon Sets
Creating and managing formatting rules
Advance formatting using formula.

End of the training

The course is instructional, step-by step in approach. Participants are also put through exercises on interesting datasets to apply their understanding & learning.
LAPTOPS REQUIRED -"if you have two computer monitors, please use them."

SETUP REQUIREMENTS
1. Required software (either one): Excel 2016 Professional Plus, Excel 2019, Excel 2021, Microsoft 365.

2. Ensure Power Query and Power Pivot is working in your installed versions of your Excel.
Power Pivot info: https://support.microsoft.com/en-us/office/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b

3. Power Query info: https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16

4. Tutorial video: https://youtu.be/8tWi4nSUyWA.

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

"The trainer was very clear in this explanation on how to use the excel functions to enhance my work. Great job. Thanks" Farhan, Rail Transit.

“I have learned a lot of knowledge from this course, Excel based (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

“Thanks to my trainer. I learned to apply Microsoft Excel in my future work. He is good and expressive. He is able answer all my questions immediately. I hope to join for Microsoft Excel – Advanced Level.”– Accounts, Hiraki Timur Sdn Bhd.

“During the course, I learned to simplify my work using Excel. After the course, I am so excited and can’t wait to apply the knowledge that I learned from this course. My Excel training is an excellent and knowledgeable trainer. I hope to join Microsoft Excel – Advanced Level conducted by him.”– Accounts, Hiraki Timur 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.

“Before attending the course, I thought enough about Excel. On these 2 days course, I learned picked up many different Excel functions. I gained knowledge a lot from the training. The trainer well engaged and knowledgeable.’- Farah Atiqah, 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