Data Analytics with Microsoft Excel (Basics to Intermediate) – 2 Days

Date : 14/07/2025 - 15/07/2025
Time : 9:00 am - 5:00 pm
Location : The HUB, Jaya One, PJ

Contact Person : Esther Yong
Email : inquiry@knowledgehub-asia.com
Mobile : +012-2662728
Office Tel : +603-7622 0578
Normal Rate : MYR 0.00
Promotion Rate : Contact us for discounted rate.

Course Overview

This dynamic training program, “Data Analytics with Microsoft Excel,” equips all

participants with the essential skills to harness the power of Excel for effective data analysis and compelling Analytical Dashboard.

Over the course, participants will delve into Excel functions, pivot tables, and data visualization techniques, enabling them to extract actionable insights from raw data. To harness the power of Excel & Pivot Table, Microsoft introduced Power Pivot with Power Query as back-end database manipulation engine.

What is Power Pivot? It is Microsoft Excel add-in that individual can use to manage large and powerful data analysis to create a sophisticated data model.

Ability to do data analysis and mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily

Course Objective

1. Develop critical thinking skills: Enhance your ability to think critically, analyze information objectively, and evaluate alternative
2. Understand problem-solving methodologies: Learn different problem-solving frameworks and methodologies that will guide you through the process of identifying, defining, and solving problems effectively.

4. Utilize analytics for problem-solving: Discover how to collect and analyze data using various analytical tools and techniques to gain insights and support decision-making.
5. Apply data-driven decision making: Learn how to integrate data analysis into the decision- making process to make informed and evidence-based
6. Enhance problem-solving creativity: Explore methods to stimulate creative thinking and generate innovative solutions to complex

Learning Outcome

Upon completion, participants will be able to:

1. Use PivotTables and functions effectively to summaries and augment Data in Microsoft Excel.
2. Visualize data & create analytical dashboards for reporting with Microsoft
3. Utilize Microsoft Excel for basic data management and
4. Optimize their operational workflow/schedule by incorporating their analytical skills of Microsoft Excel.
5. Be able to present key findings within their visualization tool that is easily understood by their audience.
6. Build automated processes to clean and transform data using the Excel Power Tools, especially in performing Data Analysis and Data Visualization.
7. Create powerful, interactive reporting mechanisms. Slicing data into views and gaining visibility with different perspective.

For registration please Contact :