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

IC Training & Consultancy ICTC Logo

MS Access Essential Training

MS Access Essential course is offered by IC Training & Consultancy ICTC. Our experts have years of experience working with Microsoft Office and Google Suite, and we’re passionate about helping others make the most of their Microsoft Office and Google Suite software.

by IC Training & Consultancy ICTC [Claim Listing ]
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 ]
Master Trainers Logo

Certified Microsoft Excel & PowerPoint

The Certified Virtual Trainer is a high-impact virtual course that prepares professional trainers to run virtual classes online. This certification itself is conducted fully online and learners are assessed by their ability to run a virtual class independently.

by Master Trainers [Claim Listing ]
KTS College Logo

Microsoft Office Application

This course is a popular one among school leavers and job seekers everywhere. This is a short course and fully delivered in one to one approach. Learners with no prior knowledge in handling this office software can become confident users after completion of this course.

by KTS College [Claim Listing ]
Sarawak Skills Logo

Microsoft Excel (Basic & Intermediate)

Microsoft Excel course is offered by Sarawak Skills. Sarawak Skills is the preferred provider of Technical and Vocational Education and Training (TVET) for industrial workers and school leavers. 

by Sarawak Skills [Claim Listing ]

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