
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