Pivot Table would definitely be useful in my scope of work for sales/finance data analysis
Chang Mei Choo,
|
at present - I maintain separate worksheets/books of clients profiles, clients by presenting problems, clients by languages/dialects spoken. Now I know that they can be combined into 1.
Doreen Goh, SAGE Counseling Centre
|
Able to use data from different sources. Many short cut available which I am not familiar with or have not use before.
Abdul Rahmat Bin Mordiffi
|
Problem I faced is performing the same manual formatting on the weekly open order report that we need to submit our customers on every week. With the knowledge of macro, I'm able to let the macro execute the task with just one click on the icon that I had set on the menu bar. So, it helps to save some time.
Alicia Tan, Littelfuse Far East Pte Ltd
|
The creation of a database to store donors records. Now I am able to create a database that will enable me to sort for the info required.
Angel Loy
|
Link files data and creating of pivot tables, charts is beneficial in data, statistical reports
Angela Tan Yam Choo
|
This course has taught me how: 1) to merging columns 1,2 & 3 together 2. Filtering 3. Selecting of records 4. Consolidating data 5. Pivot Table. It saves me a lot of time and definitely been useful in my area of work.
Antoinette Wang Lee Lee, Life Community Services Society
|
1. using all the formulas taught - I used to do manual calculation. 2. creating pivot table - better representation of reports
Anusiah.T, Disabled People's Association
|
I think the methods taught during this course is practical and useful for the work I do. I'm able to better understand which formula I can use to get the results that I need. And this would definitely save my time.
Cecillia Teo, Beyond Social Services
|
My training records are more manageable with the knowledge of how to use excel in a more efficient way.
Celine Low, DSTA
|
The formula to pull out the months and to calculate the financial months are very useful as it saves a lot of manual work of typing one by one. Pivot table and MS Query will also be useful in updating information.
Chew Hwee Shan, National Council of Social Service
|
To improve my Excel knowledge, and found that not only to the donation management, it also help the Nursing side. But I think I need more practice, and look for more course to study.
Chia Siang Luan
|
For the donor management, I know how to use the Pivot Tables how to sort the monthly report & I had save a lot of time from finding the answer.
Choo Ban Seng, Sunshine Welfare Action Mission
|
Will be able to create a central database to process all volunteers, donors and even clients information as they some switch their roles or may having two roles at any one time.
Choo Jin Kiat
|
Learning Pivot table and pivot charts enable me to use excel to help my organisation analysis trends in Fundraising patterns
Christopher, Man Fut Tong Nursing Home
|
Instead of doing manual glance to compare and spot the difference/error, I can use the formula to do the checking and exacting info out for me in much shorter time. Knowing how to apply the formulas with a better knowledge has help me to save a lot of time and help me do generate out reports easily!
Chua Khim Noi Judy, Rainbow Centre - Yishun Park School
|
I have benefited quite a lot from this course, like the feature subtotal, vlookup, pivot table and more, it's very helpful in my area of work
cindy cheng, Ren Ci Hospital & Medicare Centre
|
The F5 function is good as it helps to solve the problem of extracting some data from a column to another column.
Cindy Ng, DSTA
|
I need to sum up and count the numbers of projects in my database frequently. I learned to use subtotal, pivot table which make my task very easy. Recently, I also require to create 2-axis line chart, this course come in time for me to create using pivot chart.
Connie Look, BCA
|
This course benefit by saving my time to transfer 3 files to 1 database and I can will try to do pivot table for all the Giro donors. I have been using Excel a lot this past years but don't know that I could much with it.
Diana Nekmat, Muslimin Trust Fund Association
|
i have learnt many things thru this course especially usage of formulas but unfortunately am really blurr about excel. sorry mr jason but anyway thanks!
diyana abu samah
|
Eg. Camera Tool. It is useful to be use in presenting all charts and tables onto 1 A3 size Due to job scope, other learning's are unlikely to be applied
Eileen Ang
|
to work more effective and efficiency, how to create a pivot table, mail merge, database sort, better verse how to use excel, time savings, new solution.
Emily Wong, Care Corner Family Service Centre (Queenstown)
|
Various excel formulas, such as vlookup as well as the pivot table. Yes, it certainly saves time with good use of the functions and formulas in Excel.
Eunice , NTU
|
Duplications in database. Will work it out with the knowledge learnt.
FADZILAH, Muslimin Trust Fund Association
|
Be able to widen my knowledge on Excel and learn new function eg Pivot Table, Formula and Consolidate Data from Different Workbooks.
Faridah bte Salleh, ITE
|
Pivot Table - which I can use this to generate my monthly report - trend of donations received & it can be updated automatically at regular interval, so I do not need to generate the same report all over again
Goh Chiew Mon, Children's Cancer Foundation
|
I was thinking about building a catalogue, even a library management system, and at least now, I am assured excel can be a good starting point.
Goh Yee Ling, Singapore Council of Women's Organisations
|
The use of Query to refresh pivot tables is useful in my course of work, with about 70% in terms of time saving.
Ho Cheeng Hwi, DSTA
|
Pivot table is particularly helpful because I can use it to consolidate data from multiple workbooks to analyze data for my training program. Presently I'm working on different workbooks to generate the data.
Huang Limei Rachael, Cornerstone Community Church
|
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, NCSS
|
I learnt that Excel has many more functions that I'm not aware of. It opens my mind in exploring more and thinking of how I can make it of it to collect data. I'm not familiar with Access (which we use for data collection and many members don't have this software). So I'm hoping the knowledge gained here will help me do data query and improve my productivity. I want to cut down the time needed to collate data and present it in good visual presentation too. I think I should be able to do that now. I would like to know how to import data from Access and use Excel to collate info.
Ivy Low
|
I use Excel routinely in my work. However, analysis tools are used only as and when required for reporting. The database for managing HR training, volunteer management, donor database are still very much in formulation and transition. This course would help me realise the potential of the software for me to consider better ways of gathering and analysing data.
Jeannie Lee Siew Chin
|
- The tips and tricks are helpful and save me time and effort to click on mouse
- When making changes to charts created from pivot tables is much easier and require lesser effort than the traditional way of creating it from excel. Just drag and drop.
- The option to update pivot table automatically have helped me do my monthly report for my boss in a shorter time.
Jeannie Siew Po Yeng, DSTA
|
Use the pivot table more efficiently... shifting around the fields for different presentation of reports.
Jenny Su, Trinity Christian Centre
|
It is beneficial to my current scope of work. my current scope of work requires me to manage and provide reports on volunteer management.
Jimmy Lim, NKF
|
The different fomulas that I have learnt have helped me speed up in extracting data. I find the pivot table is extremely helpful.
Joanne Yap , TOUCH Community Services Ltd
|
V-Lookup: I have a better understanding of how vlookup works. It can help to look up values in multiple worksheets and present them in one worksheet. Macro recording - eliminate the need to repeated formatting of weekly report.
Joy Ang, Littelfuse Far East Pte Ltd
|
Pivot table to extract information from raw data for weekly report on new cases. Also, tips on some fx formulas that I make use in my course of work.
Judy Lee, WDA
|
Ideas for new solutions to work situation (however not covered in-depth enough during the course to implement).
Karen
|
Problem Faced: Not sure how to analyze raw data and use Pivot Tables. In this course learn about how to use MS Query in Pivot Tables.
Khoo Hai Yong, DSTA
|
Gain more knowledge on applying the different functions and formulas in Excel to my daily works. (eg. Donor Management Mailing List, Financial Asst Master List)
Khoo Mui Kiang, Beyond Social Services
|
The delimited and sumif function is informative. However, I am interested in extracting data from PDF file to excel.
Koh Bee Leng
|
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
|
Were facing preparing of the report for internal use and external use problem.
Every report will have indicate different data. After attend this especially for Pivot table & Macro method, it do helping me on sorting out lots of report. Formula wise are also do helps a lots on shorten my time to rearrange the data.
Lemon Low, Ricoh (S) Pte Ltd
|
Alot to learn....good experience and hands-on training. Have to keep on exploring the system and alot of trial and error...
Lena Yow, Care Corner Family Service Centre (Admiralty)
|
Use of Pivot tables and Vlookup. Know these techniques will make work more efficient.I like the case study approach that the trainer adopted. This makes understanding & application of the techniques more user friendly
Liew Yok Yin, NKF
|
If familiar with formulas, its a wonder what it can be done. But the formulas are very brain straining. Confused about which one to be use.
Lily Tham
|
Have been doing summation manually, or by using simple formalae. Knowing how pivot table works can help save at least 50% of my time spent on providing information to the auditors.
Lim Shuxian
|
Learning the pivot table has helped me to understand and learn how to consolidate information and statistics and present it in so many different options.
Linda Sy, FaithActs
|
my knowledge on excel is very elementary. This course is beneficial to me because it aids in my work alot as I use Excel for payroll, donors and volunteers management. I learn how to use pivot tables and many formulas. I also learnt useful 'tricks' which I never knew they exist before. Thanks!!
loh lona, pave
|
I have managed to equip some excel tips which helped me in saving quite alot of time when collating information in excel and formatting the data. Definitely have a better understanding in MSquery which I could do some self-exploring into the feature and try to apply it for my reporting assignments.
Lyndy Zhang, National Council of Social Service
|
I think the course is very interesting. As, it not only refreshes my memory in excel. At the same time it also provide me an opportunity to explore further in excel. Such as, it help me to complete my task in a faster ways and able for me to meet my dateline.
Macy
|
Pivot tables, and some other functions would enable me to analyse and make use of my database more effectively.
Mansura Sajahan, Transient Workers Count Too
|
Reporting and revision of data now can be done more efficiently. Merging of data from different people into a single report is also now possible when I didn't know it before.
Maureen Lee , SCWO
|
Very eye opening for me, their are plenty of things to learn.
Mavis Koh, CARE Singapore
|
Gives me understanding on the usage of concept and formula. The course has definitely empower me to work more efficiently with Excel. The reporting and analysis will definitely be much faster in the future.
MEI LING, CHARITY
|
I need to use Excel frequently for my company system tracking of daily project/tasks. We have people writing programs and this course helps me to understand excel spreadsheet whenever I sees a complicated formulas.
Melissa Yeo, IFF (Asia Pacific) Pte Ltd
|
1. mastering the use of dates, calculating the age... merging 2 lists into one, analysing donation, pivot table etc... 2..I will more confident to use in my office. Excellent and well present and good work and helpful too, breakfast and snack good too.
Mrs Florence Yee, Ang Mo Kio Methodist Church, Management Committee
|
learn some new thing with shortcut way. And found out the solution in grouping data in pivot table report.
New Shiow Yee, Ricoh (S) P/L
|
Simple things like the copy function which helps save time. It's practical in doing financial reports with the pivot table/chart.
Ng Soo Bin
|
vlookup and and pivot table has definitely give me more ways in writing my report. I used to manually count the various but similar data required and that would have taken almost half of my day. However I believe I can save a lot more time by using the pivot table.
Nur Ain Mustafa, Singapore Council of Women's Organisations
|
I've learnt a new way of keeping my database neat and a shorter way of getting the data well organised by using pivot table.
Nurhidayah, WDA
|
It definitely applicable and useful for me to apply the lessons learned to manage the store records back in MFT Nursing Home.
Ong Hock Chye, MFT Nursing Home
|
I learnt how to use vlookup to exact details from one spreadsheet to the other. And to use MS query as my client database is keyed into Access. I will need to exact data from Access to Excel and analyse them for my Centre Manager. Learning these functions will allow me to save time in exacting the data and more them to analyse the data.
Pamela Goh, Care Corner Family Service Centre (Queenstown)
|
The course is definitely useful for my scope of work back in office. Especially in statistical report, management report and annual report. The classroom arrangement and environment is conducive and the location is easy to access
Pamela Hwee, Academy of Medicine, Singapore
|
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
|
Have learnt about pivot table and form creation which will help me to upkeep donor data neater and faster.
Patricia Fong, SingHealth Foundation
|
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
|
To combine report that was given to me by different area managers
Pauline Wong, Guardian Health & Beauty
|
Like postal code when exported to excel, always missing the first 0 digit. Problem solved after attending the course. Using concatenate formula. The amount of time is saved.
Peggy Chong
|
The pivot table is very useful in cross referencing of data which is important in my area of work.. The dynamic feature ensures that the reports that I generated will be the most updated.
Phua Kian Chye, Institute of Education
|
The course greatly improve the time spent in trying to remove duplicate names for mailing list, totalling donors based on dates. Pivot table also help to make the tabulating of report & donor listing much easier.
Poh Hwee Keng, Make-A-Wish Foundation
|
I have learn very little form this course some useful formula which is relevant to my work. I wish this course be given more time to learn.
RAMIDAH BINTI ALI, PPIS-JURONG FAMILY SERVICE CENTRE
|
Should be able to provide statistics quickly. a) Client database is larger and larger. b) Hard to find groups of client by age group/income/debt volume, etc.
Raye Haw, Credit Counselling Singapore
|
My present use of excel is quite limited but I will most likely be able to use some of the formulae & functions that were taught in the course
Rebecca Lim, Musical Theatre Limited
|
I have learn that the vlookup and pivot table can save me lots of time instead of manually counting the numbers from the file in doing my statistic of our staff performance. Have also learn new features which will enable me to set new targets
Romy Faizal, WDA
|
I had helped my colleague to create formular for Statistic report. Previously they are doing manual sorting. In this way, saving our time.
Samantha Sam, Gracehaven - The Salvation Army
|
problem that I faced was sorting of information in the excel file. After this course, I could sort data better. E.g. Sorting out the different categories of subsidies granted to students in bccsc's student care centre It was great that Mr Khoo brought a helper a long to assist us in our learning. Without one more trainer, we would not be able to learn more and ask more questions
Sandy Chua
|
Definitely this course has helped me to save some of my time in doing my office work. As an administrator I do not really use excel as often as my other staffs. But after this course I have learn some basic formula and keys. I will try to apply what I have learn on our membership listing and donors data-based.
Sarah Ang Hui Beng, Riding for the Disabled Association of Singapore
|
This course has been helpful as I use Excel in my daily work. For example, I can now use the subtotal formula to do counting from a list. I can also create more professional looking forms from today's lessons.
Seet Lay Peng, Focus on the Family Singapore Ltd
|
Know the functions of MS query, pivot tables and formatting etc. This is help to speed up administrative work.
Seng Liping
|
Basically the tricks and tips for general use of excel sheets. And the formulas were very useful. I've had problem consolidating and organising raw data from counsellors with their different headings and such. I've learnt the easier and less tedious way of consolidating the data to a master copy.
Shazryyana, Singapore After-Care Association
|
Short Cut, Vlookout, pivot table, chart. All these has benefited me and would save me numerous of hours. Even though have not, done it yet.
Shirley Lee
|
Gained insights with the function of merging data of two databases. Pivot charts and tables are also useful tools in presenting reports. These definitely will shorten the time in future when I consolidate database and generate reports. Helpful tips are given throughout the classes.
Soh Ee Lian
|
Updating my database records with more usable and relevant functions in EXCEL. Able to present data analysis in easier than before. Good interaction and trainer is patient with the problems posed.
Soh Wai Leng, Cornerstone Community Church
|
Have been using xls for my statistics compilation for a while, but in a very basic way. After the learning thru this xls course, it would certainly allow me to explore a more efficient way to do the statistics now.
TAY SWEE HWA, DSTA
|
Consolidate data in 2 different worksheet. Something that I will try out at my workplace.
Teo Lizhen, NCSS
|
Experienced for myself the power of excel which overwhelms! Sadly I do not use excel so extensively in my workplace so likely I will forget what I have painstakingly tried to understand at the course.. :(
Valerie Er, DSTA
|
Some of the formulas such as subtotal, roundup .... also learn more about pivot tables & ms query. Think can further explore on how to utilise the new knowledge into my existing workflow & reports. Didnt know so much more can be done.
Veronica Wong
|
The subtotal function is so useful. I used to filter the data, cut and copy the cells to a new workbook and look at the serial number to count the total no. of cells. It was too time-consuming. Now, I can do the count in a matter of seconds. Also, complicated data can be made so meaningful with the pivot table. And the small tricks, such as combining the F5 function, a formula and CTRL enter can help me save time in populating blank cells with the header information. This will save me lots of time!
Wang Siliang, National Council of Social Service
|
Recently, we had our annual walkathon and 20,000 donation pledge cards were issued and we had to capture certain information about the collectors. The course has helped us to quickly sort data from the returned cards and saved us a lot of time (certain amount of donations qualified the collector for a free token of appreciation).
Warren de Souza, New Hope Community Services
|
I have learned short cut and A LOTTT of format in excel. good course to attend and to shorten the time to crack our head on how to do this do that. eg printing certain session, envelope export printing, upper lower capitals changes etc..
Wendy Loh
|
The various functions such as IF, filter and sort; and use of pivot table and ms query.
William Oh, NCSS
|
Jason has given a good insight into the usefulness of using pivot table to present data. He has also value-added to the course by demonstrating how Excel can be used to present the BSC Dashboard information.
Winnie Lim
|
Learning MSQuery allows me to save lots of report processing time. And there are new things to learn, even in areas that I thought I am familiar in, e.g. pivot tables.
Wong Ley Kun
|
Hope to use excel as a database. However, I will need to practise frequently to apply the techniques that was taught especially with the searchif function, pivot table and MS Query.
Wu Moy Li
|
The pivot table and the MS Query are very useful tools which I can use to manage my elderly database, volunteers database and tracking income/receipts, expenses and budgets.
Yong Yin Hoong, TOUCH Community Services
|
I have learnt to use pivot chart instead of manually filtering the data, this will save 20% of the time in my Excel tasks.
Yvonne Teo, National Council of Social Service
|
To convert text to date, as I also download file from MAR, and unable to convert the date to value. Have been manually removing the space in between as function trim unable to apply in this case too.
Zann Sim Bee Cheng , DSTA
|
The training is more suitable for the applicants who are often use the programme in getting specific information such as worksheet. Many technical terms such as & F4 F5 and formulae for analyse purpose.
Theresa Yeo, Bo Tien Welfare Services Society
|
