2days Training | HRDCorp Claimable Course

Microsoft Excel Advanced Training Course

Learn More

Microsoft Excel Advanced Training Course

COURSE DETAILS & INCLUDED:
  • Physical Class / Remote Online Training
  • 2 Days
  • 9am – 5pm
  • Certificate of Attendance
  • HRDCorp Claimable Course
  • In-House / Public Class 

PROGRAM OVERVIEW:

Microsoft Excel is perhaps the most important computer software program used in the workplace today. That’s why so many workers and prospective employees are required to learn Excel to enter or remain in the workplace.

 

 

From the viewpoint of the employer, particularly those in the field of information systems, the use of Excel as an end-user computing tool is essential. Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.

LEARNING OUTCOME:

Upon completion of this program, participants should be able to:

  • Create Subtotal Using The Subtotal Function
  • Analyze data Using Pivot Tables
  • Perform What If Analysis
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function
  • Combining & Consolidating Data
  • Record and Run a Macro

WHO SUITABLE FOR THIS COURSE:

This course is intended for participants who wish to gain more knowledge from the intermediate level of Excel.  For participants who are working with nested formulas, performs what if analysis, consolidating data and creates Pivot Table to have in depth understanding of how an electronic spreadsheet works.

TRAINING METHODOLOGY:

This program will be conducted with

    • Trainer led hands-on activity
    • Interactive group exercise and discussion
    • Relevant and concise case study
    • Participant led presentations
    • Mentoring – one to one or group

PREREQUISITES:

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

  • Have attended Microsoft Excel – Foundation & Intermediate Level; OR
  • Able to switch between task applications
  • Able to create simple to complex formulas and functions
  • Able to validate data in a Worksheet
  • Able to apply Filter data using Auto & Advanced Filters
  • Able to clean Duplicate Records

KEY MODULES:

  • Module 1: Getting the Most from Your Data
  • Module 2: What If Analysis?
  • Module 3: Advanced Excel Task
  • Module 4: Advanced Chart
  • Module 5: Analyzing Data with PivotTable, Slicer and PivotCharts
  • Module 6: Enhancing Workbooks
  • Module 7: Macros and Form Controls
  • Module 8: Publishing & Protection

Let me know, if you interested this program

Please leave your enquiry here, we will reply as soon as possible.

Scroll to Top