Was using primitive way to do my excel sorting. Especially in privot table - Grouping is a new insight as well as many ideas.I like the setup, it's not too many students and can have better focus to attention and questions
Celine Koh, Cytec Industries Pte Ltd
|
I can use the new solution to summit my monthly report and some engineering data analysis. Very Useful!
Eric Tan Kay Chuen, Denka Advantech Pte Ltd
|
I would often need to verify my warehouse's WMS records with my office's records. The ability to actually combine the 2 records together for this purpose has significantly reduced the time needed for the task. The WMS records can be exported into a CSV file while my office's records are already in Excel format. And with Vlookup, I could merge the 2 files.
Frederick Looi, Taytonn Pte Ltd
|
Some of the useful tip and function, like Goto, it helps to save time. Thinking process in the course make you apply the technique and excel knowledge that are taught.
Lai Wan Ning, 3M Asia Pacific
|
its gives me a better view of understanding excel formula easier. and identifying other colleagues problem which could be applied to my work.
LEE ANDREW
|
Helped me to generate pivot table to analyse data more concisely, calculated averages & percentages faster. Quick tips like the end button helped me to navigate data faster.
Lim Yee Ling
|
Analysis of price data over different years. Price data are usually disorganized and difficult to analyse the trend. Now with knowledge of pivot tables, it is easier to present and organize the data to see trends.
Low Yuan Sheng, DSTA
|
learnt and think that MSQuery Pivot table can help me to compile list of past offers anytime, without modifying the source table. Trainer is most willing to share tips and always try his best to answer our questions.
NEO CHZE YUN, DCNS FE PTE LTD
|
I gain better understanding in excel now. With the foundation, I achieved during the workshop, now I will not be ignorant on the formulas used in the worksheet. I also have better knowledge in macro and pivot table too. Keep up the good job! Thumbs up.. Hopefully in future should there be any workshop on excel/macro/pivot table, please do inform me. Thank you.
Nurhafizah Binti Adi Ahmad Safarudin, Lufthansa Technik Logistic GmbH
|
Pivot table and chart creation, which could be used concurrent or replace vlookup method.
Roy Leng, Credit Counselling Singapore
|
The different formulas learnt will be able to assist me in my work. save time and decrease chances of human errors. Pivot table is useful and will be able to assist me in churning out log sheets and registers
sandy, touch home care
|
Before this Excel course, I only had a basic knowledge of Microsoft Excel. After this Excel course, I had a more advanced knowledge of Microsoft Excel. This resulted in time savings for me in my course of work.
SEAH AI PING, KAH MOTOR COMPANY SDN BHD
|
Problems faced : Not able to do a quick delete of blank rows in between tables / colour code cells based on range. Course taught me new formulas and quick keys(F4/F5..etc) that allows me to complete my task in a much time.
Shawna Lee
|
This course has equipped me the skills to compare and retrieve info from huge data files. Vlookup and pivot tables / charts are very useful in my course of work. Time saving and better presentation of data for analysis purposes are two of the main benefits.
Tan Hui Choo, Jesslyn , Kah Motor Co Sdn Bhd
|
Pivot table. From this course, I have learnt additional pivot table functions which I do not know in the past. I can make use of the knowledge acquired on this immediately in my course of work.
Wendy Voo How Kheng, Ricoh (Singapore) Pte Ltd
|
Formulaes and Formats which can speed up the cleaning and sorting of data.
Ye Jinling, Ariel
|
