Microsoft Excel Advanced 2019

All versions available. Outline version below is Microsoft PowerPoint 2019. If you need assistance just chat with us LIVE.

4.2

Course Objectives

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 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

Target Audience

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.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

Course Modules

  • 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

Get To Know The Trainer

Trainer Slyvia

 

Sylvia has been in the IT Training Industry for the past 20 years She began her career as a Corporate Trainer and her personal areas of expertise are wide; encompassing Microsoft and Adobe applications. In addition to that; she also specializes in corporate coaching for government, multi-national companies to local SMEs

Chat with us LIVE to get a

FREE QUOTATION!

COURSE DETAILS

COURSE INCLUDE

ALL IN FROM ONLY

RM0/DAY

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.2

  • 33%
  • 50%
  • 17%
  • 0%
  • 0%
  • MJ
    MOHD NAZRUL B CHE JAMALUDIN
    Junior Executive, Manufacturing / Production

    5

  • ZS
    ZAILANID BIN SIMAN
    Manager / Supervisor, Operations

    5

  • NH
    Nur Azzhari Bin Hassan
    Junior Executive, Others

    4

  • MI
    MUHAMAD ZUBIR BIN ISMAIL
    Manager / Supervisor, Manufacturing / Production

    4

    Good and recommended
  • MJ
    Mohd Fadzil Bin Abd Jalil
    Junior Executive, Manufacturing / Production

    4

  • MM
    Mohd Nazri bin Abd Majid
    Junior Executive, Marketing / Design

    3

Courses you may like

MEMBERS ONLY FEATURE

Kindly sign-up or log-in to get access.

LOGIN

Login with your social account

or

Don’t have an account with us?

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?