Microsoft Excel 2019 (Advance)

by Info Trek Claim Listing

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Info Trek Logo

img Duration

2 Days

Course Details

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

 

Objectives:

  • Create Subtotal Using the Subtotal Function
  • Analyze data Using Pivot Tables
  • Perform What If Analysis using:
    • Goal Seek
    • Solver
    • Input Table
    • Scenarios
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function
  • Combining & Consolidating Data
  • Summarizing & Analyzing with Pivot Table and Pivot Charts
  • Record and Run a Macro

 

Outline:

  • Module 1: Organize Summary And Details On Your Data
  • Module 2: Planning, Forecasting & Projection Of Your Data
  • Module 3: Retrieve, Compare Or Compiling Data With Functions
  • Module 4: Present Data With Visual Report
  • Module 5: Summarizing And Analyzing Data With Pivottable, Slicer And Pivotcharts
  • Module 6: Navigating Large Workbooks
  • Module 7: Automate Task With Macros
  • Module 8: Prevent User Changes With Protection
  • Kuala Lumpur Branch

    G-03 (Mezzanine floor), Amcorp Tower Persiaran Barat Jalan Timur,, Kuala Lumpur
  • George Town Branch

    Ground & Mezzanine Floor, 2, Beach St, George Town

Check out more MS Excel courses in Malaysia

Corporate Frontier Logo

Be Innovative With Microsoft Excel

Microsoft Excel is one of the most widely used spreadsheet and data management programs in organisations today. An understanding of Excel can be a critical factor in being able to carry out a variety of responsibilities.

by Corporate Frontier [Claim Listing ]
SIRIM Academy Logo

MS Word (Beginner)

MS Word course is offered by SIRIM Academy. SIRIM Academy - which focuses on technology training, personnel certification, talent, and vendor development, ESG and people skills.

by SIRIM Academy [Claim Listing ]
Global Infoskills Sdn Bhd (GISB) Logo

Microsoft Visio (2016 Foundation)

Microsoft Visio course is offered by Global Infoskills Sdn Bhd (GISB). Global Infoskills Sdn Bhd (GISB) is a diversified training and consultant company, specialising in corporate training, as well as personal development training, and is focused on improving people’s skills through training.

by Global Infoskills Sdn Bhd (GISB) [Claim Listing ]
Knowledge Hub Logo

Power Ponit

This course is designed for people who have a basic knowledge of Microsoft® PowerPoint, and who wants to increase their knowledge and know the practical uses of PowerPoint.

by Knowledge Hub [Claim Listing ]
Sabah Skills & Technology Centre Logo

Microsoft PowerPoint (Basic to Intermediate)

Microsoft PowerPoint course is offered by Sabah Skills & Technology Centre. SSTC aspires to actively provide the best of skills training available to meet current needs and strengthen the knowledge and skills level of the State’s workforce.

by Sabah Skills & Technology Centre [Claim Listing ]

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