Microsoft Excel Advance

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

4.7

Course 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

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, discussions and practical exercise.

Course Modules

  • Module 1: Organize Summary and Details on Your Data

    Topic A: Outlining and Grouping Data

  • Module 2: Planning, Forecasting & Projection of Your Data

    Topic A: Using Data Analysis Tools

    Topic B: Exploring Scenarios

    Topic C: Using Solver

    Topic D: Linking, Consolidating, and Combining Data

  • Module 4: Present Data with Visual Report

    Topic A: Create Combo Chart

  • Module 5: Summarizing and Analyzing Data with PivotTable, Slicer and PivotCharts

    Topic A: Create a PivotTable

    Topic B: Filter Data by Using Slicer

    Topic C: Analyzing Data with PivotChart

  • Module 6: Navigating Large Workbooks

    Topic A: Customizing Workbooks

  • Module 7: Automate Task with Macros

    Topic A: Macros

  • Module 8: Prevent User Changes with Protection

    Topic A: Protecting Worksheet and Workbook

Get To Know The Trainer

Trainer Jarina

 4.5

Managing and maintaining a Microsoft Windows Server 2003 Environment - educate the IT professionals who implement, manage, and troubleshoot existing network and system environments based on the Windows Server 2003 platform. Implementation responsibilities include installing and configuring parts of systems. Management responsibilities include administering and supporting systems

Trainer Shalina

 4.5

Shalina has   20   years   of experience in IT related fields including 11 years in conducting public courses. She specializes  in  Corporate  IT  infrastructure  planning  (networking,  troubleshooting and  system  integration),  conducts  applications  training  programs  such  as Microsoft,  Adobe,  Lotus  and  COMPtia  products  as  well  as  organizes  and conducts exhibitions and seminars.

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

Trainer Izham

 4.5

Izham has 14 years of teaching background with 4 years in the academic department of a public university followed by corporate clienteles in the later years. Since becoming a corporate trainer, Izham has been helping office workers all over cope with data and document volumes in digital form to become efficient and come out being smart office workers.

Trainer Beatrice

 4.5

Beatrice has been in the training industry for the past 27 years being one of the pioneer trainers of Microsoft Office training programs. She has vast experience having trained many people from various corporate sectors. She is a certified Microsoft Office training consultant and is accredited by Pembangunan Sumber Manusia Berhad (PSMB/HRDF).

  View more trainers

Chat with us LIVE to get a

FREE QUOTATION!

COURSE DETAILS

COURSE INCLUDE

ALL IN FROM ONLY

RM949/DAY

RRP RM2,500/DAY   SAVE RM1,551

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.7

  • 69%
  • 28%
  • 3%
  • 0%
  • 0%
  • IM
    Ismail Bin Muda
    Manager / Supervisor, Operations

    5

    Very good and knowledgeable Trainer
    The training help me to understand excel much better and the training show me the correct and easy way to do the task
  • TA
    Thiruchelvi Arumugam
    Senior Executive, Operations

    5

    Awesome
  • HM
    Harrish V Muniandy
    Manager / Supervisor, Operations

    5

    Great session!
  • SD
    Sharmila Devi
    Junior Executive, Others

    5

  • AA
    Azrul Ahmad
    Senior Executive, Quality Assurance

    5

  • SA
    Shasikumar A/L
    Manager / Supervisor, Operations

    5

  • AF
    Albert Joe Fernandez
    Assistant Manager, Customer Service / Hospitality

    5

  • VL
    Vui Ket Lai
    Manager / Supervisor, Customer Service / Hospitality

    5

    Great training
  • TW
    Teh Kim Wooi
    Manager / Supervisor, Operations

    5

  • JC
    Jacinta Malashree A/P Chandrasekaran
    Manager / Supervisor, Others

    5

    Good
    Good
  • Sr
    Sugunan a/l rajan
    Executive, Quality Assurance

    5

  • J
    Jeyarani
    Senior Manager, Corporate Communications

    5

  • BT
    Bavani Tommy
    Executive, Others

    5

  • MM
    MUNIR IQBAL BIN AHMAD MUNIR

    5

  • NN
    Norazni Bin Nooruddin

    5

    Excellent
  • NS
    Nurul Husna binti Sani

    5

  • SZ
    Syaiful Anuar bin Zakaria

    5

    Good course for enhance career
    Excellent
  • MT
    Mohd Fahami Khairi Bin Mat Tahir

    5

  • NK
    Nur Khairin Adleena binti Khairudin

    5

  • NK
    Noorshima Hj Nokman Kushairi

    5

    Very knowledgeable
  • MY
    Muhamad Firdaus bin Yusoff

    5

    Excellent
    Marvellous
  • SH
    SITI NUR DAYANA BINTI HANDAN

    5

    Excellent
    Would recommend others to join
  • MH
    Madihah Hashim

    5

  • NA
    Nur Fazlinda Binti Azmi

    5

  • ZF
    Zahidah bt Mohd Fadzillah

    5

  • SA
    SAMUEL ANDREW
    Executive, Operations

    4

  • SO
    SURIANI BINTI OTHMAN
    Manager / Supervisor, Customer Service / Hospitality

    4

    Awesome
    Good for the presenter!
  • KI
    Khalehla Ismail
    Executive, Quality Assurance

    4

  • KK
    Kareena Kow
    Manager / Supervisor, Customer Service / Hospitality

    4

  • GS
    Goh Bing Shiuan
    Executive, HR / Learning and Development

    4

  • WY
    Wong Wei Yin

    4

  • Nh
    Nur liyana hanani bt hassan

    4

    Good experience
  • MS
    Megat Muhamad Shafiq Bin Megat Samsudin

    4

    Great
    Good exposure
  • NI
    Nizam Bin Mohamed Isa

    4

  • LM
    LIM KIAN MIN

    4

  • AC
    Aaron Chan
    Manager / Supervisor, Operations

    3

OF 4Next

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?