MICROSOFT EXCEL Advanced Level

20-21 Nov, 2025, CONCORDE HOTEL KUALA LUMPUR

Register Now
PDF Brochure

IPA Training is Registered with

Learn from the Best

FAKHRUL SYAHMI
Data Analytics & Data Science Consultant | Certified Trainer | AI & Automation Specialist
Master’s Degree in Data Science

 

Fakhrul Syahmi is an accomplished data analytics and AI specialist with a proven track record in helping organisations harness technology for smarter decision-making and enhanced productivity. Armed with a Master’s Degree in Data Science, he brings deep expertise in data analytics, business intelligence, automation solutions, and AI-powered workplace tools.

 

His technical proficiencies span Microsoft Excel, Power BI, Power Platform (Power Apps, Power Automate), Looker Studio, AppSheet, AI tools (Microsoft Copilot, ChatGPT), and advanced automation workflows. He has also delivered data science solutions in predictive analytics, machine learning, time series forecasting, and text mining.

 

As a certified trainer, Fakhrul is known for his dynamic, hands-on training style that blends real-world scenarios, case studies, and interactive exercises. His sessions consistently equip participants with immediately applicable skills while driving both individual capability and organisational growth.

 

Fakhrul has designed and delivered customised training programmes, data solutions, and analytics projects for a wide range of industries — including banking, manufacturing, oil & gas, and government-linked companies. His holistic approach focuses on knowledge transfer, capability development, and measurable business outcomes.

 

Training & Project Specialties
• Data Science: Predictive Analytics, Machine Learning, Time Series, Text Mining
• Advanced Excel & Data Analytics
• Business Intelligence & Dashboard Development (Power BI, Looker Studio)
• Automation Solutions (Power Platform, AppSheet)
• AI-Powered Data Analysis for Decision-Making
• Workplace Productivity with AI Assistants (Copilot, ChatGPT, Notion AI)

 

Notable Clients
Petronas Chemicals Bhd, AgroBank, Bank Simpanan Nasional (BSN), Al-Rajhi Bank, Shell, Teleperformance Malaysia, Berjaya Group, Menteri Besar Incorporated (MBI), Medivest, and more.

Venue Details

CONCORDE HOTEL KUALA LUMPUR
2 Jalan Sultan Ismail, 50250 Kuala Lumpur, Malaysia,
Phone : 03 2144 2200

https://kualalumpur.concorde hotelsresorts.com/

Contact us

Juliany,
03 2283 6109
juliany@ipa.com.my

Phoebe,
03 2283 6100
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Jane,
03 2283 6101
Jane@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

FOCUSING ON

Session 1: Advanced Excel Skills and Techniques
• Advanced Formulas and Functions
• Data Analysis Tools
• Advanced Data Visualization
• Power Query and Power Pivot

Session 2: Advanced Data Analysis and Reporting
• Advanced PivotTables
• Advanced Data Analysis
• Data Consolidation and Data Validation
• Collaborative Tools and Sharing
• Advanced Charting and Dashboard Creation

OBJECTIVES

This comprehensive one-day training course is designed to build upon your existing Excel knowledge and take your skills to the next level. Throughout the day, we will dive into intermediate-level concepts and techniques that will empower you to manipulate data, perform advanced calculations, and create visually appealing reports and analyses.

This course is specifically tailored for individuals who are familiar with the basics of Excel and are eager to expand their proficiency in this powerful spreadsheet software. Whether you’re a business professional, analyst, student, or anyone who works with data, this course will equip you with the necessary tools and techniques to work more efficiently and effectively in Excel.

We have carefully structured the course agenda to cover a wide range of topics, including data manipulation and analysis, formulas and functions, advanced formatting techniques, data analysis tools, data validation, and collaboration features. By the end of the day, you will have gained valuable skills and knowledge that can be immediately applied to your everyday work tasks.

Throughout the training course, we encourage active participation, as you will have opportunities to practice the concepts through hands-on exercises and engage in discussions. Additionally, we will provide you with valuable resources and references to support your continued learning beyond this training.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Applying Advanced Data Manipulation Techniques:
    • Sort and filter data efficiently.
    • Utilize advanced filtering options for complex data analysis.
    • Work effectively with tables and structured references.
    • Implement conditional formatting to highlight data patterns.
  2. Demonstrating Proficiency In Using Formulas And Functions:
    • Utilize intermediate-level functions such as IF, VLOOKUP, and SUMIF.
    • Apply logical functions (AND, OR, NOT) for complex calculations.
    • Nest functions to perform advanced calculations.
  3. Implementing Advanced Formatting Techniques:
    • Customize cell formatting to enhance visual appeal.
    • Apply styles and themes for consistent formatting.
    • Create and modify templates for efficient document creation.
    • Utilize conditional formatting to visually represent data trends.
  4. Utilizing Data Analysis Tools Effectively:
    • Create and modify PivotTables and PivotCharts for data analysis.
    • Use slicers and timelines to interactively analyse data.
    • Apply What-If Analysis tools (Goal Seek, Scenario Manager decision-making.
WHO SHOULD ATTEND
All Levels.
METHODOLOGY
  • Interactive Presentation
  • Group Discussions
  • Group Activities
  • Role Play
  • Simulation
  • Sharing Experience
  • Gamification Method
  • Case Studies
DAY 1
 

SESSION 1: ADVANCED EXCEL SKILLS AND TECHNIQUES

9:00

ADVANCED FORMULAS AND FUNCTIONS

  • Nested functions and advanced logical functions (IF, AND, OR)
  • Lookup functions: VLOOKUP, HLOOKUP, INDEX, and MATCH
  • Array formulas and their applications
10.45

DATA ANALYSIS TOOLS

  • Sorting and filtering data effectively
  • Data validation and drop-down lists
  • Advanced filtering techniques: Text, Number, Date filters
  • Subtotal and Consolidation tools
1:00 Lunch
2:00

ADVANCED DATA VISUALIZATION

  • Creating dynamic charts and graphs
  • Using PivotCharts for interactive data analysis
  • Conditional formatting and data bars
  • Sparklines for visual trend analysis
3:45

POWER QUERY AND POWER PIVOT

  • Importing and transforming data with Power Query
  • Creating relationships and calculated columns in Power Pivot
  • DAX (Data Analysis Expressions) basics for advanced calculations
5:00 End of Day 1

DAY 2

 

SESSION 2: ADVANCED DATA ANALYSIS AND REPORTING

9:00

ADVANCED PIVOTTABLES

  • Grouping and ungrouping data in PivotTables
  • Slicers and Timelines for interactive filtering
  • Calculated fields and items in PivotTables
10.45

ADVANCED DATA ANALYSIS

  • What-If Analysis with Scenario Manager
  • Goal Seek and Solver for optimization problems
  • Data tables and sensitivity analysis
1:00 Lunch
2:00

DATA CONSOLIDATION AND DATA VALIDATION

  • Consolidating data from multiple
    worksheets or workbooks
  • Advanced data validation rules and custom error messages
  • Handling duplicate data effectively
 

COLLABORATIVE TOOLS AND SHARING

  • Sharing workbooks and collaborating in real- time
  • Comments and annotations for effective communication
  • Version history and document recovery
3:45

ADVANCED CHARTING AND DASHBOARD CREATION

  • Combination charts and dual-axis charts
  • Dynamic charts using data validation lists
  • Introduction to Excel Dashboards: Design principles and best practices
5:00 End of Course