Menu
Menu
PREMIUM COURSE

Microsoft Excel 2016 Advance

0

Course Objectives

  • Advance Chart function and PowerPivot Function
  • Analyze data Using Pivot Tables
  • Perform What If Analysis using:
    1. Goal Seek
    2. Solver
    3. Input Table
    4. Scenarios
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function
  • Combining & Consolidating Data
  • Create Hyperlink in a workbook

Target Audience

REQUIRED PREREQUISITES:

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

  • Have attended Microsoft Excel – Foundation and Intermediate Level; OR
    1. Able to use and apply Database function
    2. Able to use and apply Logical function (IF, AND)
    3. Able to use and apply Statistical function (COUNTIF, AVERAGEIF, COUNTIFS, AVERAGEIFS)
    4. Able to use and apply Mathematical function (SUMIF,SUMIFS)
    5. Able to use and apply Lookup function (VLOOKUP)
    6. Able to use Auto and Advanced Filter command
    7. Able to validate data
    8. Able to apply Conditional Formatting
    9. Able to Protect worksheet and workbook
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, discussions and practical exercise.

Course Modules

  • Module 1 – Getting the most from your data
    Topic A: Subtotal and Outlining
  • Module 2 – What If Analysis?
    Topic A: Using Data Analysis Tools
    Topic B: Exploring Scenarios
    Topic C: Using Solver
  • Module 3 – Advanced Excel Task
    Topic A: Using the Advanced Function
    Topic B: Linking, Consolidating, and Combining Data
  • Module 4 – Visualizing Data Charts with Trendline
    Topic A: Create a Trendline
    Topic B: Create Advanced Charts
  • Module 5 – Analyzing Data with PivotTable, Slicer and PivotChart
    Topic A: Create a PivotTable
    Topic B: Filter Data by Using Slicer
    Topic C: Analyze Data with Pivot Chart
  • Module 6 – Enhancing Workbooks
    Topic A: Customizing Workbooks
  • Module 7 – Macros and Form Controls
    Topic A: Macros
    Topic B: Form Controls 

Get To Know The Trainer

Private Profile

 

Chat with us LIVE to get a

FREE QUOTATION!

COURSE INCLUDES

  • 2 Days of training
  • E-Certificate of Completion
  • E-Training manual
  • Trainer logistic to client's place

COURSE BENEFITS

  • 1 or 20 pax, same price
  • Confirmed-to-run even for 1 pax
  • Cheapest available (*we will price match!)
  • Money-Back-Guaranteed Quality
  • HRDF Certified & Claimable

ALL IN FROM ONLY

RM1,100/DAY

RRP RM2,500/DAY   SAVE RM1,400

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

What Other People Bought

LOGIN

Login with your social account

or

Don’t have an account with us?

Edit Profile

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?