my knowledge on excel function have increased, such as the mid function, subtotal. I believe that all these function will increase my productivity of my daily job.
Stella Goo Siang Tey, Creative Technology Limited
|
my knowledge of the formulaes are limited before the course. this course has given me a better insight on the formulaes to be used, pivot charts, macros, subtotal and consolidation of multiple workbooks together.
Ye_Luyan
|
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
|
Use of $ symbol to fix formulas. Saves time and effort. Use of MS query to consolidate data so that pivot table info is more accurate. This helps with the reports and analysis I have to do on a regular basis.
Colleen Ang, Juniper Networks
|
This course really enlighten me a lot on various useful formula that i wasn't aware of before this course. Though in my field of work, i don't need to generate very extensive table to present but i do use excel to help sorting my test data to check results of my testing.
Law Poh Geok, NCS
|
1) MORE EXPOSURE ON THE SYNTAX AND SEMANTICS OF USING MACRO IN EXCEL. 2) HOW, WHEN MACRO-RECORDING USED CORRECTLY WILL ALLOW THE FASTER DEVELOPMENT OF COMPLEX MACRO CODES.
AW CHIN LOON
|
Jason has helped to shorted my quotation with his vast knowledge of functions in Excel. I especially enjoyed the last day of the class when Jason used a real-life example to share with the class. Thank you very much for your patience Jason! I enjoyed the class very much!
Chew Ngian
|
The course has helped me to work with Pivot Table in massaging the data that I have. And to learn to work with formulas and shortcuts which I never realised Excel can do.
Lau Kuan Chiat
|
I am given a worksheet of data to work on that does not come in the format I need to work on. I spend many nights, manually cleaning up. Now I know after attending this course, how easy it is to get what I needed in a very short time.
Mark Lee, NCS
|
Facing long time looking for data from one worksheet and paste on another worksheet. After attending the course I can save time on the process.
Lee Siew Yan Jeannie, NCS Communications Engineering Pte Ltd
|
I have learnt the powerful of using formulas to prepare a detailed price contract in much a shorter time frame by saving about 20% of the time and with much less mistake.
Sharon Long, NCS Group
|
I have learnt the usefulness of pivot table which enable me to consolidate and present pivot chart and data to my management.
Marilyn Tan
|
Learnt the use of some features in excel in managing database, especially in using pivot table to extract data for presentation
Teo Kheng Hwa, NCs Pte Ltd
|
Use of pivot table can help me manipulating data from survey conducted.
Maria Florinda Reyes
|
As a IT Presale which I work on cost sheet during the solution , it would help me to manipulate fast to show different figure when the solution changes.
Victor Sia, NCS PTE LTD
|
Problem: (Long List of Cost Sheet, Price List, Supplier List, Equipment List) Solution: Using Formulas and examples in the training to analyse data. Very informative and helpful training examples and materials
Calvin Chin, NCS-CE
|
After attended the course, have an basic understand on how to use formula to save time and what formula to use for each problem faced at work. Short cut that I can use in my work which I previously unaware.
Irene Toh
|
Consolidate data in 2 different worksheet. Something that I will try out at my workplace.
Teo Lizhen, NCSS
|
The various functions such as IF, filter and sort; and use of pivot table and ms query.
William Oh, NCSS
|
Excel is a powerful tool for designing my questionnaire for manpower survey as I can save money on temp staff to do data entry! It helps me greatly in my analysis of data too as I can customize what information to retrieve and how to present my results.
Ng Hwee Choon, NCSS
|
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
|
Usage of pivot table and MS Query as they are helpful in pulling out data from workbooks with a lot of fields and analyse the data
Cheryl Phua, NCSS
|
I used to compare worksheets by arranging them side by side on the screen, and then screen out the differences. Now I know I can use vlookup. It would really save a lot of time.
Chiam Mei Si, NCSS
|
It has taught me how to better manage the data so that I can make useful analysis (i.e. using the pivot table to save a lot more time than re-organising the data manually from scratch). It has also taught me more options on how to analyse and manage data, which I wouldn't have known before.
Huang Moli, NCSS
|
Ranking method is very useful in my course of work and save me a lot of time & stress and I have learn new things in pivot table and it is very interesting.
Irene Toh, NCSS
|
Though i have been using excel for many years but some of the simple function that was not known to me eg like the 'end' function. And also pivot table, i also have been using it but din know that within the pivot function, it can group things like the qtr, year, month etc, and before i knew this i have to manually type in the data.
Mary kwok, Prefer not to disclose
|
using of formulas countif, sumif,.... help in doing the pricing calculation.
Su Su Htwe, Prefer not to disclose
|
Clearer about how to use formulas and pivot tables. Need to use actual data to practise what was taught. With formulas, there will be instances where one will not know that the formula is wrong.
Kwek Jim See, Prefer not to disclose
|
Almost 70% of the things I've learnt in this course are totally new to me. A specific problem which I have was unable to extract part of the information from a cell. Didn't know this was possible until I went through this course. It saves me a lot of time by using the formulas, instead of having to cut and paste one by one.
Patricia , Prefer not to disclose
|
The skills and tactics shared help shave off time spent during my pre-sales proposal preparation and also during the data analysis in my job.
Choy Yat Kin, Prefer not to disclose
|
Know the functions of MS query, pivot tables and formatting etc. This is help to speed up administrative work.
Seng Liping, Prefer not to disclose
|
was interested to see if I could consolidate all my information that gets reported in my dept. The templates are not the same. I still would need to format the data on the individual reports. But I think using what I have learnt here I could save time using the formulas and all. So perhaps once I have tried, I shall let you know. Need practise first.
Patricia Reincastle
|
Pivot Tables and MS Query really helped in my need to consolidate and draw out different permutations of raw data in a quick and efficient way. I also appreciated the other tips.
Joann Chen, Prefer not to disclose
|
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, Prefer not to disclose
|
Able to create drop down list for our tracking documents = time savings because we used to key in the data manually.
Janice Weng, Prefer not to disclose
|
Currently we have a long list of scholars under different schemes and we need to extract the information manually for reports. The most useful part would be the pivot table and chart as well as MS Query to generate information as part of scholarships & schemes administration and management. By using these tools I would be able to generate different type of tables that show different trends under the scholarship & scheme that we are managing.
Juliana Johari
|
Pivot table is very useful to collate and compare data sets. Having a greater understanding of how formulas are formed also would help me to understand excel files that come with formulas.
Sherlyn Ang, Prefer not to disclose
|
Would be useful in my future work. Since it has just been a week since we learned the advanced features, have not put it to use yet. But I think I definitely will from next month onwards! It will help me to plan my visits when I do checks on Childcare Centres as I can extract the necessary information as and when needed. Good set of notes- think t\hat it is great that Jason tailors the material to meet the needs of the class- we appreciate the effort taken to do this!
Monica Lim
|
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, Prefer not to disclose
|
problem - interpreting data into an analytical format. down know how to create forms. lack of knowledge on formulas thus spend time on manual logic. course helped to understand formulas to save time.
Josephine Ho, Prefer not to disclose
|
using of sumif and countif instead of pivot table, nestedifs
Carol Chua
|
Current Situation before this course - Sales analysis by country,business activities,amount,customer name - using manual sorting and sub-total. After the course, can use vlookup to fill up data, pivot table for sorting more efficiently. Learn new things from this course like vlookup, pivot table, new fx formulas, simple macro, as well as some good tips & tricks which will make work more efficiently.
JACELYN CHONG
|
