Microsoft Excel


Begin your journey to becoming an Excel
professional today

Get in Touch With Us
Microsoft Excel


Begin your journey to becoming
an Excel professional today

Begin your journey to becoming an Excel professional today

You already know how to get Excel® to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others.
But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data.
In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.
Key Learning Outcomes

Upon completion, participants should be able to demonstrate each of the following outcome:-

  • Learn different techniques for data analysis that can beeasily implemented in Excel
  • Transform Data into insight using powerful methods of analysis, techniques and tools
  • Bring your skills of Excel from Basic or Intermediate levels to Expert level
  • Learn best practices for data analysis and data presentation
  • Work in Excel faster by using hotkey shortcuts
Course Modules Covered in the Microsoft Excel Intermediate program
Module 1 - Working With Functions

Working With Functions

  1. Work with Ranges
    •Create name range
    •Using name range in formulas
    •Edit name range
    •Deleting name range
  2. Work with Logical Functions
    •And, Or
  3. Work with Date & Time Functions
    •Getting the current date
    •Getting the current date and time
    •Getting the day of the week from date
    •Calculating date difference
  4. Work with Text Functions
    •Converting text to different cases
    •Segregating text into multiple column
Module 2 - Working With Lists

Working With Lists

  1. Sort Data
  2. Filter Data
  3. Using advanced filter
  4. Query Data with Database Functions
  5. Outline and Subtotal Data
Module 3 - Analyzing Data

Analyzing Data

  1. Create and Modify Tables
  2. Advantage of converting range into table
  3. Performing calculation in a table
  4. Editing table range
  5. Converting a table into range
  6. Apply Intermediate Conditional Formatting
Module 4 - Visualizing Data With Charts

Visualizing Data With Charts

  1. Create Charts
  2. Modify and Format Charts
  3. Use Advanced Chart Features
Our Training Methodology
Program Key Highlights

48 hours of Remote Online Learning
Additional Coaching Hours
Live Hands-on Projects
Certified by International Body
Mentorship with Industry Experts
Designed for Beginners & Professionals
Get in Touch With Us Today!

This training program is suitable for anyone who intends to enter into the field of Microsoft Excel. This program is being conducted in Malaysia and can be joined by anyone, anywhere in the world remotely.
Program Fee

MYR 1300 per pax.

Funding Schemes for Companies who are claiming from their HRDF levy or from the SBL Khas scheme.

One-time fee. One year access to course materials and resources.

Please fill in the form and a Program Advisor will reach out to you. You can also reach out to us at or +60123661502
Contact us on Whatsapp for more enquiries