Enrolled: 698 students
Duration: 1 day
Level: All Level

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed
HRD Corp Claimable Excel Advanced Training

HRD Corp Claimable Excel Advanced Training

The HRD Corp Claimable Excel Intermediate Training is designed for Malaysians who are registered in the HRD Corp scheme and want to increase their Excel competence while taking advantage of the courses that may be claimed.

Who Should to sign up for this HRD Corp Claimable Excel Advanced Training?

Malaysian professionals and businesses in the HRD Corp scheme can take the HRD Corp Claimable Excel Advanced Training to improve their Excel skills. It suits. Users with moderate Excel skills who want to become experts. Data analysts examine and understand data and use advanced Excel techniques to manipulate it. Finance, accounting, and auditing professionals might benefit from advanced Excel abilities for financial modeling and analysis. The HRD Corp plan allows organizations and individuals to recover the cost of this advanced Excel course.

Prerequisites
There aren’t any requirements for taking this course.

Overview of the HRD Corp Claimable Excel Advanced Training

HRD Corp Claimable Excel Advanced Training is an intensive training for Malaysian HRD Corp employers contributors and organizations looking to improve their Excel skills. This program covers advanced Excel capabilities and operations, including complicated data analysis, financial modeling, macro automation, and data visualization. Participants will learn data-driven skills through hands-on experience. HRD Corp claims make the training a cost-effective skills development option. Experienced Excel users, data analysts, finance professionals, and businesses looking to improve Excel should use it.

HRD Corp Claimable Excel Advanced Training Outline

Module 1: Data Transformation Power Query

  • A Power Query primer.
  • Importing, cleaning, structuring data.
  • Multiple-source data integration.

Module 2: Data Modeling Power Pivot

  • Power Pivot overview.
  • Creating data models and linkages.
  • Functions for DAX.

Module 3: Excel Advanced Functions

  • Complex array function use.
  • Finance and engineering.
  • Customizing VBA functions.

Module 4: Excel Dashboard Design

  • Slicers and buttons for interactive dashboards.
  • Powerful charts and formatting.
  • KPI and performance scorecard creation.

Module 5: Advanced PivotTable Techniques

  • Calculated PivotTable fields and items.
  • Advance PivotTable analysis using Power Pivot.
  • Macros for PivotTable automation.

Module 6: Advanced Forecasting and Data Analysis

  • Analysis and forecasting of time series.
  • Problem-solver for optimization.
  • Excel advanced statistical analysis.

Module 7: VBA Excel Automation

  • VBA programming expertise.
  • Validating user input.
  • Developing Excel add-ins.

Module 8: Database Integration

  • Connecting Excel to external databases.
  • Database querying and updating.
  • Data modeling with Excel and databases.

Module 9: Advanced Exporting/Reporting

  • Excel report creation.
  • Data export to PDF, CSV, HTML.
  • Automation report creation with VBA.

Module 10: Excel Security and Compliance

  • Advanced workbook encryption.
  • Data privacy and compliance.
  • Corporate Excel security.

 

 


HRD Corp Course Request

Write down the training course you interested