AMPRO SOLUTIONS SDN BHD
  • Home
    • About Us
    • Authorized Training Partner
  • Our Services
    • On-Site Training
    • Off-Site Training
    • Coaching
    • Audit Support
    • Consultation Services >
      • Energy Management >
        • Remote Power Management Services
      • Management Systems >
        • ISO 50001 Energy Management System
        • ISO 9001 Quality Management System​
        • ISO 14001 Environmental Management System
        • ISO 45001 Occupational Health and Safety Management System
        • IATF 16949 International Automotive Task Force
        • ISO/IEC 17025 Testing and Calibration Laboratories
        • ISO 13485 Quality Management for Medical Devices
        • AS 9100 Quality Management System for Aerospace Industry
        • ISO 20000 IT Service Management
        • ISO 22301 Business Continuity Management
        • ISO 31000 Risk Management
        • ISO 37001 Anti-Bribery Management System
        • ISO 55000 Asset Management
        • TL 9000 The Telecom Quality Management System
        • Food Safety Management System
        • Integrated Management System (IMS)
      • The Malaysian Standard for Sustainable Palm Oil Production (MSPO) >
        • General Differences between MSPO and RSPO
        • Deadlines for MSPO Certification
        • MSPO Certification Process
        • Photo Gallery
      • Business Continuity Management >
        • How We Can Assist You
      • Halal Certification >
        • Certification Scheme
      • Safety and Health Officer Support
  • Training Courses
    • Soft Skills >
      • Leadership & Supervision Skills
      • Motivation & Teambuilding
      • Communication & Interpersonal Skills
      • Presentation & Public Speaking Skills
      • Clerical & Administrative Skills
      • Customer Relationship Management Skills
      • Negotiation Skills
      • Sales & Marketing
      • Creative Thinking & Problem Solving
      • Human Resource
      • Microsoft Office
    • Business Management >
      • Purchasing & Logistic
      • Supply Chain Management
      • Process Improvement & Core Tools
      • Responsible Business Alliance (RBA) and Sedex Members Ethical Trade Audit (SMETA)
      • Lean & Six Sigma
      • Electrical & Electronics
      • Project Management
      • Industry 4.0
    • Manufacturing Operations >
      • ISO 50001 Energy Management System / Energy System
      • ISO 9001 Quality Management System
      • ISO 14001 Environmental Management System
      • ISO 45001 Occupational Health and Safety Management System
      • ​IATF 16949:2016 International Automotive Task Force
      • ISO/IEC 17025 Testing and Calibration Laboratories
      • ISO 13485 Quality Management System for Medical Devices
      • AS 9100 Quality Management System for Aerospace Industry
      • ISO 22000 IT Service Management
      • ISO 22301 Business Continuity Management
      • ​ISO 31000 Risk Management
      • ​ISO 37001 Anti-Bribery Management System
      • ​ISO 55000 Asset Management
      • Food Safety Management System
      • TL 9000 Telecom Quality Management System
      • Integrated Management System
    • Health & Safety >
      • Occupational Health & Safety
      • First Aid
      • Fire Safety
      • Transportation Safety
    • Malaysian Standard for Sustainable Palm Oil Production (MSPO)
  • Events
    • Remote Online Training
    • Public Training in Johor Bahru
    • Public Training in Kuala Lumpur
    • Online Registration
  • External Info
    • Human Resource
    • Environment
    • Health & Safety
  • Contact Us
    • Career Opportunities

“The future belongs to those who learn more skills and combine them in creative ways.” 
​- Robert Greene

SMS-112     Microsoft® Excel Data Analysis and Interactive Dashboard Reporting -
                      Basic to Intermediate

  • Overview
  • Course Objectives
  • Course Content
  • For Whom
  • Schedule and Hours
<
>
Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you'll gain the widely sought after skills necessary to effectively analyze large sets of data. Once the data has been analyzed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report.
Upon successful completion of this course, participant will be able to:
  • Understand and Identify the principles of data analysis
  • Effectively summarize and present data clearly
  • Use effective design principles when creating and presenting data
  • Take full advantage of the built in tools Microsoft Excel offers in order to analyze and build dashboard reports such as Power Query and Power Pivot Tools
  • Build interactive dashboard reports
  • Analyze Excel data using Excels TEXT based Functions
  • Managing Raw Data​
  • Lab Assessment – Handing Massive Raw Data
  • Working with a Single Dataset
  • ​Working with Data Analysis​
  • Lab Assessment : Formula VS PivotTable 
  • Working with Multiple Datasets
  • Lab Assessment : Generating Invoices / Purchase Order in Excel
  • Working with Data Reporting
  • ​Lab Assessment : 10 Questions – 10 Quick Analysis
  • Preparing Dashboard and Visualization​  
  • Lab assessment : Design Dashboard for each department
  • Creating Interactive Dashboard
  • Lab Assignment : compiling multiple chart and prepare linked pivot table for future designs
  • Prepare and Distribute Reports
  • Lab Assessment : Dynamic Dashboard with extra macro inside
This course is designed for Experienced Microsoft Excel users who are looking to efficiently analyse large data sets and create dynamic dashboard reports.
This is a 2-days programme.
​

This course runs from 9:00am – 5:00pm with an hour for lunch and periodic short breaks.
 
This is an intensive session designed to include as much discussion as possible. Lunch and breaks provide an opportunity for further questioning and discussion with the instructors.
Picture
Picture

We are HRD Corp (Human Resource Development Corporation) Registered Training Provider.
​All of our training modules are claimable under HRD Corp.

Subscribe to our Mailing List
  Thank you for Signing Up
Please correct the marked field(s) below.
1,true,6,Contact Email,2
©  Ampro Solutions Sdn Bhd 2023
  • Home
    • About Us
    • Authorized Training Partner
  • Our Services
    • On-Site Training
    • Off-Site Training
    • Coaching
    • Audit Support
    • Consultation Services >
      • Energy Management >
        • Remote Power Management Services
      • Management Systems >
        • ISO 50001 Energy Management System
        • ISO 9001 Quality Management System​
        • ISO 14001 Environmental Management System
        • ISO 45001 Occupational Health and Safety Management System
        • IATF 16949 International Automotive Task Force
        • ISO/IEC 17025 Testing and Calibration Laboratories
        • ISO 13485 Quality Management for Medical Devices
        • AS 9100 Quality Management System for Aerospace Industry
        • ISO 20000 IT Service Management
        • ISO 22301 Business Continuity Management
        • ISO 31000 Risk Management
        • ISO 37001 Anti-Bribery Management System
        • ISO 55000 Asset Management
        • TL 9000 The Telecom Quality Management System
        • Food Safety Management System
        • Integrated Management System (IMS)
      • The Malaysian Standard for Sustainable Palm Oil Production (MSPO) >
        • General Differences between MSPO and RSPO
        • Deadlines for MSPO Certification
        • MSPO Certification Process
        • Photo Gallery
      • Business Continuity Management >
        • How We Can Assist You
      • Halal Certification >
        • Certification Scheme
      • Safety and Health Officer Support
  • Training Courses
    • Soft Skills >
      • Leadership & Supervision Skills
      • Motivation & Teambuilding
      • Communication & Interpersonal Skills
      • Presentation & Public Speaking Skills
      • Clerical & Administrative Skills
      • Customer Relationship Management Skills
      • Negotiation Skills
      • Sales & Marketing
      • Creative Thinking & Problem Solving
      • Human Resource
      • Microsoft Office
    • Business Management >
      • Purchasing & Logistic
      • Supply Chain Management
      • Process Improvement & Core Tools
      • Responsible Business Alliance (RBA) and Sedex Members Ethical Trade Audit (SMETA)
      • Lean & Six Sigma
      • Electrical & Electronics
      • Project Management
      • Industry 4.0
    • Manufacturing Operations >
      • ISO 50001 Energy Management System / Energy System
      • ISO 9001 Quality Management System
      • ISO 14001 Environmental Management System
      • ISO 45001 Occupational Health and Safety Management System
      • ​IATF 16949:2016 International Automotive Task Force
      • ISO/IEC 17025 Testing and Calibration Laboratories
      • ISO 13485 Quality Management System for Medical Devices
      • AS 9100 Quality Management System for Aerospace Industry
      • ISO 22000 IT Service Management
      • ISO 22301 Business Continuity Management
      • ​ISO 31000 Risk Management
      • ​ISO 37001 Anti-Bribery Management System
      • ​ISO 55000 Asset Management
      • Food Safety Management System
      • TL 9000 Telecom Quality Management System
      • Integrated Management System
    • Health & Safety >
      • Occupational Health & Safety
      • First Aid
      • Fire Safety
      • Transportation Safety
    • Malaysian Standard for Sustainable Palm Oil Production (MSPO)
  • Events
    • Remote Online Training
    • Public Training in Johor Bahru
    • Public Training in Kuala Lumpur
    • Online Registration
  • External Info
    • Human Resource
    • Environment
    • Health & Safety
  • Contact Us
    • Career Opportunities