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

Check out more MS Excel courses in Malaysia

Comsystem Logo

Microsoft Access 2010/2013/2016/2019/365: Intermediate

The objective of a Microsoft Access intermediate course is to provide participants with a more advanced understanding of the features and functionality of Microsoft Access, a popular database management system.

by Comsystem [Claim Listing ]
AC Interactive Solutions Sdn Bhd (ACIS) Logo

Microsoft Visio (Basic To Advance)

Microsoft Visio (Basic To Advance) training is offered by AC Interactive Solutions Sdn Bhd (ACIS). Our passionate team of expert trainers is qualified and highly experienced in countless training fields.

by AC Interactive Solutions Sdn Bhd (ACIS) [Claim Listing ]
New Asia Academy Sdn Bhd Logo

Business Excel Workshop

The Business Excel Workshop course is offered by New Asia Academy Sdn. Bhd. Upgrade individual’s knowledge & skills to meet industry requirements in line with the latest global developments.

by New Asia Academy Sdn Bhd [Claim Listing ]
Iverson Associates Sdn Bhd Logo

Microsoft PowerPoint (2016 Advance)

This training required some knowledge about Microsoft PowerPoint. In this training you will be gain knowledge about PowerPoint 2016 applications.

by Iverson Associates Sdn Bhd [Claim Listing ]
PSDC (Penang Skills Development Centre) Logo

Interactive Business Presentation With Microsoft Powerpoint (Basic Level)

This is a beginner’s course and aims to give the new user who want to learn the beginning-level PowerPoint skills.

by PSDC (Penang Skills Development Centre) [Claim Listing ]

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