The pivot table has helped to reduce the time spend in in collating, updating and presenting the financial data and reports as required by my boss.
Sam Bee Yong, Ang Mo Kio - Thye Hua Kwan Hospital
|
To combine report that was given to me by different area managers
Pauline Wong
|
This course is very useful for me as it showed me the most efficient and productive way to slice and dice data to prepare management report. This course is also very interesting especially when it used real life case studies to illustrate how excel can help me in business analysis.
Jaslyn Tan, John Wiley & Sons
|
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, Prefer not to disclose
|
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), Prefer not to disclose
|
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, Prefer not to disclose
|
Time savings in some short cut formula learnt, eg. copy + key, arrow down key, camera function, formatting within pivot table which shortens the database fine-tuning and housekeeping for my sales reports.
Teo Mui Ling
|
Converting revenue worksheets from various medical centres into Pivot Table for easier analysis. Better understanding of using vlookup formula to extract information across different worksheets.
Leonard Lim Lin Gee, Prefer not to disclose
|
The useful features learnt during the course are:Sumif function, pivot table, solver and conditional formatting as they are very relevant in my work that involves budgetting, revenue projections, product tracking dashboard reporting.
Chia Boong Kheng, Prefer not to disclose
|
Better overview for pivot table and pivot chart relating to monthly receivable reporting. Equip in better formulas for quarterly gst reporting. Better solution towards monthly ageing analysis dada extraction.
Leonard Lim Lin Gee, SATA COMMHEALTH
|
i am doing my monthly report for my department, I need to get the clinic and companies revenues every month , I actually use it since then but there are more functions that u haven't discover.....by this training I learned more about the necessity and uses of Vlookup and pivot table it gives me more details the uses of it.
emmarie, SATA COMMHEALTH
|
Every month, a revenue report from the medical centre are presented for me to review my sales from the medical centre. Analysing the data is tedious as the data are presented in a very raw manner. After taking this course, I will be able to come up with a good summary report using the pivot table.
Shenny Ng, SATA CommHealth
|
I used to spend more time and efforts compiling the volunteers' contribution. With the use of the pivot table / chart function, meaningly reports can now be ready in less than a minute.
Agnes Tan
|
I have some experience with Pivot table. I am not aware of Pivot Chart so this course is an eye-opener.
Tan Bee Huey, Singapore National Eye Centre
|
Have learnt about pivot table and form creation which will help me to upkeep donor data neater and faster.
Patricia Fong, SingHealth Foundation
|
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
|
