Excel is a powerful software whereby numerous data can be captured in the worksheet. I learn some of the short cuts such as copy & paste functions. I hope to improve and shorten the process in due time whenever I do my work.
Annie Choy
|
THE KNOWLEDGE ON PIVOT TABLE & SOLVER CREATE NEW OPPORTUNITIES FOR ANALYZING DATA WHICH WAS NOT POSSIBLE PRIOR TO ATTENDING THIS COURSE.
CHAN CHOON SENG, LIGHT IMAGE HOLDINGS PTE LTD
|
I face challenges when managing massive raw data. This course allows me to better manage these data with much ease and convenience. One of the most useful tool I've learnt is pivot table.
Dawn Chen Wenshan, National Council of Social Service
|
No specific problems, but being exposed to the many formulas certainly helped! I have not tried using pivot tables before so I'm sure this skill will come in handy.
Glenn Yeo
|
- currently my database has thousands of client data. human error is unavoidable. As I have learnt how to extract duplicates, it will assist me to minimise errors and improve my efficiency. Through learning pivot table, it will also assist me in to have a better management of data, as well as generate report easily
Hafizah, Centre for Enabled Living Limited
|
To find the trends (age, gender, edu levels, barriers, etc) for the Long Term Unemployed (LTU) data. Using a pivot table to do a detailed report to find out what are some of the trends or barriers etc.
Ho Sok Yee, WDA
|
1. Using tracking in the shared files to check the amendments done by other colleagues. 2. Using the various formulas, pivot table and MSquery to process excel is definitely useful in shortening the hours of work.
Jonathan Chang, NCSS
|
A few days ago, I had trouble removing duplicates in a name list so the part on removing duplicates was helpful. Time savings tips, pivot table analysis, vlookup.
Li Ting
|
Previously, when doing the headcount report, we need to print in the hard copy, count and key in the figures in the spreadsheet. After this course, just extract the figures from the system and use the pivot table to consolidate the figures.
Lim Huey Pin
|
Using VLOOKUP, MONTH, MID, merging data in 2 cells, saved me at least 5 hrs last week when I had to verify accuracy of data between several files where names are not consistently entered.
LOH LEAN SAN, INGERSOLL RAND
|
The training on the use of pivot table course has been most useful. With this knowledge, I can now proceed with the re-arrangement of data in my current worksheets knowing very well that I will be able to extract useful information with less hassle.
Minna Foo, WDA
|
I have a better understanding of V-Lookup and Pivot Table which I was not very confident of using it previously. As I often need to extract data which is normally incomplete, I am able to use V-Lookup to compare 2 separate worksheet. I have picked up a handful of formulas which will certainly helps in my data computation.
Peh Mei Qi, National Kidney Foundation
|
I need to enter repetitive data when generating monthly report and it's very time consuming. In this course, I learn to use VLookup to auto complete hence reduce time in entering repetitive data.
Tan Hwee Huan
|
I have learnt the following functions which have helped me to save a lot of time in doing my work: PROPER, SUB-TOTAL, COUNT ETC.
Tan Peng Chiok
|
Learnt on how to extract duplicate record, filter off duplicate records that's not required.
Tracy Huang
|
This course introduced data management techniques are very useful in my work, which involves management reporting of industry adoption.
Tan Yan Wei
|
