Intensive F7F Wix.JPG

Data Analysis with Excel

Happening on 25-26 Nov 2021
Duration: 2 days
Selling Price: RM700/pax

What will you learn in this program?

Upon the completion of this course, participants will:

1) Customize formulas by ....

  • Using functions as below:

    • Use sum function by specifying criteria(s) like SUMIFS & DSUM.....

  • Lookup Functions:

    • Lookup for data using VLOOKUP with exact match mode.....

  • Managing data using Excel Table...

  • Pivoting Tables-Generate summary report from a large data set...Summarize data using Pivot Table using different function like SUM, COUNT, AVERAGE, MAX and MIN