Counting on 2 conditions using SumIF function . I can use this function to solve my monthly customer demand report.
Ang Boon Beng , Hamilton Sunstrand Pacific Aerospace P L
|
Learned some new shortcuts when using Pivot table, ie. format of cell, layout of the columns and rows. Also learned new skills ie. Pivot Chart, which can actually be easily generated from a click.
Catherine Chng, DSTA
|
I can use the Vlookup function. And as I missed the 2nd lesson because of medical leave, I did not have the opportunity to go through all the case studies.
Lee Cheng Tiong
|
On how to use the MS Query in Pivot Tables. I can use this technique to import data from MS Access directly into excel. This is especially useful if the number of rows of data in Access exceeds the maximum number of rows in excel.
Lian Si Chin
|
Learning of sorting function in a pivot table. Previously, the pivot table are copied to another sheet to perform the sorting. Now, with the tips learnt during the course, it is definitely more efficient and time-saving to use Excel in daily data management. This course really provide me with the insight of functions and pivot table in Excel.
Tay Yew Hion
|
For software requirements and test cases traceability, test & defect reporting and test data analysis on life science software application testing. To improve test productivity and test efficiency
Neo Soon Hoe, Life Technologies
|
Learned the uses and features of the pivot table and the pivot charts that would be useful for future presentations in my course of work
Malar Parndian
|
