Advanced Excel Essential Training

One Day, 30/11/2024

Venue

Tertiary Courses Malaysia G-3A-02, Corporate Office Suite, KL Gateway, No 2, Jalan kerinchi, Gerbang kernichi Lestari, 59200

Entrance Fee

RM 1,000.00

Category

Science & Technology

Event Type

Class, Course, Training or Workshop

Share

Schedule

DateTime
30/11/20249:30 AM - 5:30 PM
Advanced Excel Essential Training

Dive deep into the advanced functionalities of Excel with our Advanced Excel Essential Training. This course covers pivotal tools such as PowerPivot and PowerChart, enabling participants to harness the full potential of Excel for superior data management and analysis.

Grasp the intricacies of What-If Analysis and Power Query, pivotal for dynamic forecasting and streamlined data extraction. With hands-on learning and expert guidance, you'll be poised to transform raw data into meaningful insights, ensuring you stand out in any data-driven environment.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant

HRD Corp Claimable Course for Employers Registered with HRD Corp

HRDF claimable

Course Code: M299

Topic 1 PivotTable and PivotChart

  • Get Started with PivotTable

  • Data Management with PivotTable

  • Format PivotTable

  • Create PivotChart

Topic 2 What-If Analysis and Optimization

  • Activate What-If Analysis and Solver

  • Scenario Analysis

  • One Variable and Two Variable Data Table

  • Goal Seek

  • Optimization Using Solver

Topic 3 Introduction to Excel Power Query

  • What is Power Query

  • Import Data

  • Clean Data

  • Transform Data