Data Analysis and Dashboard Reporting in Excel

by Malaysian Export Academy Sdn Bhd Claim Listing

This course will help the participant create a customized dashboard in Excel. A business or digital dashboard, in the simplest terms, is a display of metrics in numeric or graphical form.

RM2120

Contact the Institutes

Fill this form

Advertisement

Malaysian Export Academy Sdn Bhd Logo

img Duration

Please Enquire

Course Details

This course will help the participant create a customized dashboard in Excel. A business or digital dashboard, in the simplest terms, is a display of metrics in numeric or graphical form.

These metrics, or what is commonly referred to as measures, range widely depending on the customer and type of organization. Towards the end of the program, participants will create a working dashboard.

 

Objective

Participants will discover advanced EXCEL dashboard creation techniques and strategies to improve their EXCEL competency level.

 

Outcomes

Participants will demonstrate advanced Excel skills to create and display their own custom dashboards with minimum error.

 

Training Methodology

  • Remote Learning, Lecture style, with hands-on exercises

 

Pre-requisites

  • Familiarity with using a personal computer, mouse, and keyboard

  • Comfortable in using Windows environment

  • Ability to launch and close programs

  • Navigate to information stored in the computer

  • Manage files and folders

  • Have basic Microsoft Excel skills

 

Outlines

  • Module 1: Importing & Cleaning Data

  • Module 2: Working With Multiple Worksheets

  • Module 3: Basic Data Analysis

  • Module 4: Introduction to PivotTable

  • Module 5: Introduction to Dashboarding

  • Module 6: Data Visualization Best Practices

  • Shah Alam Branch

    No 47-B, Jln BP 7/2, Bandar Bukit Puchong, Shah Alam
  • Kuala Lumpur Branch

    No. 86, Jalan BP 7/8, Bandar Bukit Puchong 47120 Puchong, Kuala Lumpur

Check out more Data Science courses in Malaysia

Bridgit Sdn Bhd Logo

Analyzing Data With Power BI

This two-day instructor-led course provides students with the knowledge and skills to analyze data with Power BI. Specialize in Microsoft Power BI. Model, shape, and combine data using Power BI.

by Bridgit Sdn Bhd [Claim Listing ]
Centre For Advanced & Professional Education (CAPE) Logo

Introduction To Machine Learning

Machine learning has been around for decades, but its usage was limited to specialized applications such as Optical Character Recognition (OCR) due to constraints in computing resources.

by Centre For Advanced & Professional Education (CAPE) [Claim Listing ]
Symphony Digest Logo

AI & Big Data Analytics In FinTech Credit And Digital Banking

AI & Big Data Analytics In FinTech Credit and Digital Banking course is offered by Symphony Digest. Whether you are looking for public courses or HR looking for in-house courses, Symphony has over 200 courses to suit your needs.

by Symphony Digest [Claim Listing ]
International College of Management and Sports - ICMS Logo

Advanced Big Data Analytics (HCIA)

The Advanced Big Data Analytics (HCIA) Program is offered by the International College of Management and Sports (ICMS).

by International College of Management and Sports - ICMS [Claim Listing ]
GemRain Consulting Sdn Bhd (GRC) Logo

Artificial Intelligence For Business Professionals (CertNexus AIBIZ)

CertNexus AIBIZ training is designed to help business leaders and stakeholders, product and project managers, and anyone interested in leveraging the power of AI to stay competitive in the rapidly changing business landscape.

by GemRain Consulting Sdn Bhd (GRC)

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy