MICROSOFT EXCEL
INTERMEDIATE LEVEL

8.30 AM - 5.30 PM (2 DAYS)
PARTICIPANTS : 7 - 25

This program is designed to build on participants' existing Excel skills, focusing on intermediate techniques for data management, analysis, and visualization. Participants will learn to work more efficiently with Excel's powerful functions and tools, such as advanced formulas, data validation, conditional formatting, and chart creation, to enhance their proficiency in handling data for commercial office applications and reporting. Ideal for those looking to elevate their Excel knowledge and apply it in practical, business-focused scenarios.

RM 12,000 (2 Days)
(Subject to further discussion)
(Excluding venue and F&B cost ;
Including 8% SST)

LEARNING OUTCOMES

  • Utilize advanced functions and formulas

    Develop skills in using functions like IF, VLOOKUP, and INDEX-MATCH for effective data analysis and decision-making.

  • Create and manage dynamic data ranges and tables

    Learn how to set up dynamic ranges, structured tables, and manage large datasets efficiently

  • Clean and prepare data using text functions and Power Query

    Understand how to use text functions and Power Query to clean, transform, and prepare data for analysis.

  • Apply effective data validation methods

    Ensure data integrity by applying advanced data validation techniques, reducing errors in data entry and maintaining consistency

WHO

SHOULD

ATTEND?

LEARN MORE
  • Office Professionals, Data Coordinators
  • Analysts with Foundational Excel
    Knowledge seeking more analytical skills
HomeAbout UsContact Us

Terms  .  Privacy Policy  
All Rights Reserved Start iiX Sdn Bhd.