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

​

​