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
|
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
|
Since i have been using sort function all along every time my supervisor needed a list of expired members, or different types of membership categories, by learning the pivot table and formulas has helped me to save time and be more efficient at work.
SURIANI DAWOOD, YMCA
|
I used to have very limited knowledge of excel and its functions and thus only kept to its basic functions such as trying to organise data (and would panic if there is an error showing). This course allows me to explore other functions that would help me in the organisation and analysis of data. I am more confident in using excel.
Marlina Bte Mohd Isa
|
I was having problem linking my database to my attendance sheet, however after attending this course, I was able to use VLOOKUP to solve the problem. This will save me alot of time to consolidate my attendance sheets and a more accurate report.
Adeline Lee Pei Ying
|
The customised example given by my colleague is beneficial as I now know a simpler formula to categorise payments by Qtr.
Ang Kock Tiong, Defence Science and Technology Agency
|
Many of the formulas learnt here are applicable and truly speed up of data links in a secure & faster way if we are consistent in our data entry.
Angie Ng Siew Lan, Assemblies of God Community Services Society
|
Ability to create a macro which formats cells so I need not waste time repeating the steps over and over again while working with data.
Anita Solomon
|
Have learnt more functions and will be able to apply them to save time. Knowledge on MSQuey, Pivot table / charts, macros, if function will help me to deal with data presentation more efficiently.
Anna Mak, DSTA
|
Macros and all the functions taught will shorten a lot of processing time for analysing data. Organisation and management of data becomes more easy and efficient. It is helpful in exploring more aspects of Excel. The applications will open up more avenues of doing work.
Anson Yoo, Highpoint Community Services Association
|
Now I'm doing my agency's report for the funders. So usually I'll take more a week to do the report. So with this knowledge I think I can do my report more faster with all the formulas and shortcut.
Anu, Society of Moral Charities
|
I have always seen how pivot table works wonder in bringing data together for sales forecast but never actually know how to do it. It helps so much that I can analyse my data more efficiently. I should have attended this earlier.
Betty Juliana Tan, Classique Aromatics Pte Ltd
|
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
|
The course has opened up new possibilities in increasing efficiency at work, especially since I come into contact with quite a bit of statistics and am required to analyse trends.
Cheryl Wu
|
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
|
Am not aware of more functions and what excel can offer. In regards to applying to work, I have not found any time to try but I do think it will definitely be of much benefits.
Chin Lee Foon
|
I like the macro program that was taught. The Excel knowledge acquired on using pivot table and database management is very relevant to my preparation of statistical reports in my organisation. Nonetheless, I am praying very hard that I would be able to apply what was learnt in my actual work delivery. Ha! this will be a challenge! Thanks anyway, to the trainer. Think both he and his assistant have been most helpful and patient to ensure every member of the class follows the lesson flow and are not left behind. It will be great if there can be a beginner's course and if the course can incorporate some hands-on practices in enhancing applications.
CHOO CHOON GEOK SERENE, GRACEHAVEN
|
Converting to between Calendar years to Fiscal year and into quarters.
Chung Kok Wah, NYP
|
It takes while to select a whole list of information, but after learning the (end, shift, arrow down) method, this will save me time to select an entire list of information esp if the list is very long.
Clara Goh, World Vision
|
I have been facing issue and hardship when doing data collation and entry for the Straits Times Pocket Money Fund. Hence the tip and tricks have assisted me in solving many outstanding issues.
Daren Sim, AWWA
|
I have learn the effective method of using Excel and save time in working on it manually using the conventional way of cutting & copying.
Desmond, DSTA
|
Learned several new formula and functions in excel. Possibly able to apply to the spreadsheets currently in use. Else can definitely be a good tool to posses for future use.
Ee Wei-Kang Nicholas
|
learning about pivot table is very effective for data analysis of feedback forms and survey results
Elaine Tan, Special Needs Trust Company
|
I have gained in terms of improved knowledge on more efficient use of excel formulas, pivot table and analysis of data.
Ellyne Setiawan
|
A lot of the formulaes taught in this course is very useful and very applicable in our everyday course of data crunching. The solver application introduced in the course was something new and will be very useful too
Foo Le Ping
|
The vlookup and text to column functions have help me tremendously in my daily work. I managed to save 90% of my time from doing what I used to do before attending this course.
HABIBAH MOHAMED NOOR
|
Not able to translate data to on-demand presentation for analysis. Problem can be tackled with Pivot table.
Heidi Neo Chui Er, CPF Board
|
Thank you for this Excel course. The learning point to streamline data reporting with increased efficiency and accuracy using the functions and formulas to apply in the processing of data for regular reporting. So that I can do away with the different format of manual reporting and analysis that is so time consuming.
Ho Lam Fong
|
discovered the power of pivot tables and charts, thereby allowing me to chart very quickly. having sent 2 of my other staff, I can now know what they can do to extract data and better design forms for feedback survey after each talk or event.
HO SUN YEE, SINGAPORE HEART FOUNDATION
|
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
|
Able to create drop down list for our tracking documents = time savings because we used to key in the data manually.
Janice Weng
|
The formulas taught to us such as substituting, sum product and the use of pivot table will be useful to help my data management colleagues. As for myself, I found the method for calculating age to be most useful as now I am able to get more accurate age of my residents base on the cut off date. Other than the above, there are the extra tips that help us with our daily use of excel.
Jean Goh, Christalite Methodist Home
|
can combine sheets better, can understand vlookup better, can understand more what's possible (even if I don't remember the exact syntax)
Jeff Buck
|
I'd learnt the faster & simpler way to count the subtotal, omitting the duplicate records and making use of pivot tables to churn out statistics and graphs. This allows me to tabulates & submit my reports with less difficulties, which may takes me 1 to 2 days to sort the same databases. I would be able to do more details/complicated analysis using formulas and pivot functions and spend lesser time sorting the records.
Jenny Lai, Children's Cancer Foundation
|
Many new tips that I was not aware of previously. formulas and functions that can help to streamline tedious manual calculation.
Jess Yap, Country Holidays
|
Better knowledge in using Excel (e.g. Pivot Table, sum, count, if etc) which I believe will help me to perform on my job more effectively and efficiently. E.g. some of the current reports - use sort function, after the course - usage of pivot table
Josephine Wee
|
I will try to use pivot and vlookup to track our donors and donation movement.
joyce teo, Community foundation of singapore
|
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
|
I have learnt about Vlookup, macros and PES which are useful to my work
K.V. Surekha
|
The 'Business Analysis with Excel' course has illustrated the use of the various functions of excel in the practical sense, allowing us to comprehend and appreciate the use of this tool in getting our day-to-day tasks done in a more efficient manner.
Katharine Ong, Ministry of Manpower
|
Everything that I've learned here was completely new as I hardly use excel. It's kind of hard to catch up with the pace as the formula get more complicated. I guess I need to practice more on it.
Khalida Abdul Majid, PPIS FAMILY SERVICE CENTRE
|
Productivity at managing large number of information about funding and programme evaluation statistical reports
Lawrence Tng Ping Guan, National Council of Social Service
|
We are still exploring ways to be more efficient. Functions such as sumif and countif are useful tools to count records instead of manually. Datedif is also good to measure the length of stay of the residents.
Leah Tan, New Hope Community Services
|
Able to sort data using subtotal and pivot, knowing how to fill up the fields and analysing it in clean and neat manner.
Lee Hsui Jane, WDA
|
With MS Query, I have managed to compare data from 2 worksheets without using vlookup which is supposed to be more tedious.
Leo Hee Ming, DSTA
|
I attended this course with very basic knowledge on use of excel, I face problem when come to using of formula. Nevertheless, it gave me the feel of the various uses of excel (benefits that I gained), and in order to use excel in a creative way, it is myself that need to put in effort to go through the notes with hands on practice.
Lim Boon Hock, Chinese Heritage Centre (NTU)
|
The formulas and the flexibility of pivot table are especially useful in computing statistic report in my course of work; as well as managing the data of various group of people such as Clients and Volunteers.
Lim Sio Leng, Bethesda Care & Counselling Services Centre
|
The use of vlook-up, MSQuery and Macro will be very useful in my work. Jason's explanation of how to apply these to my current work area gives me the confidence to try them out. He has a newsletter and will help us out in our query outside of these training session as well. Jason is excellent in perceiving our questions, where the error lies and explain it clearly to us. The applications are very useful and can be used in most of my work.
Limm Kiat Heng, Nadathur Fareast Pte Ltd
|
Have learnt more functions and will be able to apply them to save time. Knowledge on MSQuey and Pivot table and charts will help me to deal with large database more effectively now.
Loh Qiaoling, DSTA
|
MS QUERY AUTOMATIC REFRESH NEW DATA AND MACRO HELPS TO ELIMINATE EFFORT, MAKES CONSOLIDATION OF WORKSHEETS EASIER
LOKE YIM PENG, DSTA
|
I am required to perform different computations on a data set to measure the timely completion of activities. The course has taught me new solutions which improves the accuracy of my computations, and reduces the time needed.
Low Wen Ee
|
I'm now able to manage different databases with multiple fields; lessons on vlookup and pivot tables are especially helpful in my area of work. I can now analyse giving patterns and profiles of donors and churn out performance tables and charts easily! Beyond this, the many formulas taught are very helpful and will help reduce alot of manual workings which i used to struggle with. Appreciate the relevance and practical applications in this whole course; glad it's not the academic excel training.
Lynette Lim, World Vision
|
Excel course was able to address some of the issues faced at work and provides time & cost saving solutions.
Mak Jia-Min
|
Learn a lot of new function which I can use it on my existing donor database. The pivot table is especially useful when we need to have a quick trend report of donors. It's definitely more time-saving for me.
Mandy Cheong, SingHealth Foundation
|
The course has provided a shortcut of doing excel in long way. I gain further understanding of the power of pivot/ms query in excel in a methological way. It is only 2 days and still require lots of practices to fully grasped the higher level of pivot data analysis.I like the ideal of informal lunch with trainer/participants that allows networking and knowing each other/networking for small group.
Margaret Chua, EAC Industrial Ingredients (S) Pte Ltd
|
Gives me a better understanding of countif and sumif and MS query in excel. I guess unless i start applying it than I will encounter problems but at the moment no specific problems yet. I would like to practise on MS query in excel starting with basic queries as I can see in the days ahead I may use it to extract profile of demographics.etc.
Mary Phua, St. Hilda's Community Services Centre
|
I am new to Biz Planning. As such, every tool seems useful to me and internalized only upon actual usage in day to day business.
Matthew Leong, DSTA-Biz Planning
|
The course has taught me how to present my training data in a nicer way using Pivot Table. Previously I would create individual table for my training data when I need them. But using Pivot Table I can create all the tables and choose the table I want to present.
Mohamad Raffi Bin Mohamad, Ministry of Home Affairs
|
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
|
We have tons of data back in office and with the new tools learned, hours and hours of long-winded tasks will be eradicated. More importantly, valuable references can be created to increase productivity.
Morhan Karup, Amega Global Pte Ltd
|
Bring me to another level in improving my report submission timing, presentations and analytical summation
Nasser Latiff, Ermenegildo Zegna Far East Pte Ltd
|
Current problem is lack of understanding of the excel program to effectively analyse data. With the new knowledge gained from this course, I can definitely improve on my spreadsheet.
NG JUNJIE
|
Real case examples was given to practise on the formulas that were taught in the course, which make it more comprehensive of how it can be applicable in our work course.
Ng Swee Eng
|
Problem: Filtering a large amount of PES data. Benefits: Time saving, knowing a lot of different shortcuts and solutions to tackle a problem, merging different worksheets into one main worksheet and the pivot table for statistical usage.
Ong Annie
|
Learnt some new features of Excel e.g. MS query, etc and some new formulas, which may come in handy one day. Also a good opportunity to refresh some of the Excel knowledge acquired some time back but had forgotten since. The case studies were useful too.
Patrick Lim, DSTA
|
I have learnt how to create template for easier data analysis, to consolidate data from different files and most importantly understand how macro works.
Poh Qiu Yun, Life Technologies
|
I have always been clueless about the power of Excel, doing many things the manual way like counting amount in cells and doing manual layouts. To me Excel has always been just another program I layout my reports with. But after attending this Excel course, I realised that there is so much more power stored in Excel to help enhance and make efficient daily work reports that I have to do especially with ensuring accurate details in figures in big amounts. I'm sure as I continue to explore what has been taught, I will be able to save alot more time and stop pulling my hair out while I face my reports again.
Rachelle Low, Johnson & Johnson Pte Ltd
|
The MSQuery function would definitely help to reduce time collating data from different sources with different formats that changes constantly. PivotTable has helped me to do graphs more quickly by using the readily available data. Jason's cause delivery is very simple and easy to digest. He never stops sharing useful tips that could make everyone's life easier. Course materials provided are very useful and easy to understand. Much better than the book Excel for Dummies.. Thks Jason
Rosemaniah Jamalludin, Singapore Workforce Development Agency
|
Was facing problem in finding duplicates but the problem is solved now after attending this course. There is a shorter way in finding the duplicates. Thank you.
S Mishaalinii
|
I use a lot of pivot table in my work and knowing functions and shortcuts in Excel would be able to help me save time in doing reports.
Sakinah Ishak, WDA
|
tools in using excel without applying macro.
shannon chong
|
Ease consolidation of databases between outright donations & GIRO donations. Plan to apply pivot table in database compilations.
Sharifah Anuar
|
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
|
I've always encountered VWOs who have problems maintaining a central database when I conduct my checks on them as part of my job. Through the Excel course, I've learnt about linking databases so that the administrator at the VWOs would not encounter too much problems (saves time too!) in collating data from the different workers.Notes provided (with the various print screens) are very helpful for me to catch up when I got a bit 'lost' during the course.
Siti Rohana Hamson
|
The various formulas that can be tapped on. The training on Pivot table and MS Query is very helpful.
Stella Soh, World Vision International
|
Handling lots of student databases with problems facing duplications and formatting of data. This course has helped me know new functions that would help save time and present data in a neater way.
Suguna Nadesan, SINDA (Singapore Indian Development Association)
|
I do creation of monthly management reports with EXcel and many other reports . After attending the 1.5 days course , I could apply what I have learnt to my reports as it will save the time after learning all the functions etc.
Sumarne Sumamaili, Energy Market Authority
|
Example: To filter duplicate donor's name in database.
Benefit of this excel course: Easier and faster way to filter duplicate data by using formula.
Tan Ai See (Ashley)
|
I learn the IF formula and I can use it during my sorting of Credit card Numbers
Tan Joo Hui, NKF
|
I'm more aware of the things that Excel can do. Has not applied the knowledge yet but it helps me to 'design' the master data file in order to facilitate easier generating of reports. The course opens my eyes to see the hidden potential of Excel and not just a spreadsheet to present information
Tan Wee Long, New Hope Community Services
|
Setting Dynamic Range and naming this range for pivot table. Currently I am using fixed range when creating pivot table. After learning this, it helps me to do analysis faster
Tan Yu Min, Ricoh Singapore Pte Ltd
|
Learnt many new things on the use of Excel. Pivot table is really useful and time saving for tabulating client info and their profile. Thank you for coaching so patiently :)
Tang Huey Ming
|
I can separate and find the data I want more efficiently and faster. And I can use more functions to consolidate and shorten my formula.
Too Li Li, NTU
|
better understanding in using excel functions (e.g. pivot table, match, index, etc.) which is very useful on my daily basis reports & analysis, more efficiency & more effective.
Vivion Ho, Timberland
|
The course has allowed me to pick up techniques in creating Pivot tables which I did not have previously. Saves time in creating reports that can be automatically populated without manual intervention.
Wayne Tan, Timberland Singapore
|
I am able to update the age instantly and group the seniors age and sex easily.
Able to extract data from excel and merge with microsoft words.
Wong Kok Foo, PBM, Moral Seniors Activity Centre (Toa Payoh)
|
MS Query, which helps to reduce the excel file size and processing time. This is useful because our data file can be very huge with many columns of data.
Yau Boon Fong, DSTA
|
If I will to learn this course earlier, I should be able to save time when I was told to re-organise a table that was exported from a database. I was asked to divide the list of contact into different group and category.
Yvonne
|
Learning the usage of pivot table and charts for consolidation of raw data for reports. Formulating formulas in Excel for practical usage in reports.
Zahara Ibrahim, Kidney Dialysis Foundation
|
Use of MID & concatenate function to extract & merge text
Yap Kok Phun
|
I have benefitted from the following functions: Managing the mailing list, Merging two lists into one, Removing duplicates in customer database and Consolidate Data from multiple workbooks. Having now understood how these functions work, I will be able to be more effective in managing and handling the mailing of our institution's monthly e-newsletter.
Sue Anne Kuek, Caritas Singapore Community Council
|
1) Tips & Tricks 1: Helps to reduce the time taken to perform certain features 2) Pivot Table & table: Sorting features helps to organize the data without copying the pivot to another worksheet 3) Creating form: Assist me on various features of form creation especially doing transactional lean improvement
Karen Chai Mun Ling
|
