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 ]
New Horizons Logo

Microsoft Word Foundation

Microsoft Word-Foundation Course is offered by New Horizons. New Horizons is a Microsoft Gold Certified Partner for learning Solutions, ensuring clients receive high quality training from a Microsoft accredited and endorsed provider.

by New Horizons [Claim Listing ]
Modoku Tech Sdn Bhd Logo

Microsoft PowerPoint 2019 Advanced

This Advanced Microsoft PowerPoint 2019 training class is for PowerPoint 2019 users who want to build upon their basic skills. Students will use advanced techniques such as working with Masters and Special Effects within their presentations.

by Modoku Tech Sdn Bhd [Claim Listing ]
Diya Training And Development Consultancy Logo

Budgeting, Forecasting & Modelling With Excel

Budgeting, Forecasting & Modelling With Excel training is offered by Diya Training and Development Consultancy. We are first and foremost, extremely passionate in what we do!

by Diya Training And Development Consultancy [Claim Listing ]
Pentawise Sdn Bhd Logo

PowerQuery: Transforming Your Work Processes in Microsoft Excel

Power Query allows you to search for data sources, make connections, shape the data, and perform further analysis. It’s a powerful tool for data extraction, cleaning, and transformation.

by Pentawise Sdn Bhd

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