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
  • Petaling Jaya Branch

    G-03 (Mezzanine floor), Amcorp Tower Persiaran Barat Jalan Timur, 46050 , Petaling Jaya

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