I have learn how to insert conditional formatting to my current spreadsheet to help me to highlight those cell that is I wanted. Besides that, the pivot table can help me to work more efficiently.
Cecilia Chin
|
Organising data using pivot table and using macro recording to write macros to reduce repetitive work.
Celine Cheok
|
The Go To function is GREAT, especially the visible cells selection. I have been highlighting each subtotal row to do formatting, which can be time consuming when the data is huge. With this function, it really save a lot of time.
Chew Leng Khim
|
Learn how to create macro. Currently the way of doing reports are too manual. After learning how to create macro. I can save time in doing reporting.
CHIOU CHEE LING, ESPN STAR SPORTS
|
MS Query in Pivot Tables and Pivot Charts are very useful and benefited to me. Last time I used to do the data base query in MS Access, but now with this powerful ad-hoc query tool, it save up 30% time savings.
chong mee nyuk
|
Pivot Table and the use of Pivot Chart to present data. Time saving, and definitely easier to modify how data can be presented according to needs
Dalilah
|
The problem I am facing is how to use Excel efficiently and effectively. I use a lot of basic functions of Excel in my daily work, for example sorting data,matching. Sometimes I only do it manually as I don't know all those short cuts and formulas. With the simple formulas I can sort the data and present it in a nicer way than before. I really think it is amazing.
Dong Li Jia, Lithan Genovate Pte Ltd
|
Learning of macro save times on formatting and using formula facilitate financial reporting.
Edmas Tan, Mektec Corp (S) Pte Ltd
|
The short cuts that I have learnt in the course actually help me save some time. For e.g. I do not have to drag the mouse all the way down to the end with the help of shift+end.
Edna Wong, DSTA
|
Pivot table - I had known more uses for the pivot table and how it can assist me to gather my data and summarise in the simplest manner
Eng Woei Lin, DSTA
|
The course is very beneficial, especially MSQuery, Pivot Table and the other functions of Excel. I gained valuable knowledge on the usage of the more advanced tools of Excel and has applied them to various areas of my work. Many thanks for a very well organised course.
Esther Tan, The Bible Society of Singapore
|
I think learning of pivot table has really helped me a lot. I will be able to organize and analyze any data, donation, or even financial information. A lot of shortcut methods were taught which will help me to save time
Faridah Begum, Singapore Indian Development Association
|
- merging two workbooks together (i.e. 2 donations database from various years) and using Vlookup, pivot table as well in management functions.
Florence Lang
|
From the course, I learn how to present the raw data on the most present format. At the same time, save times to change the presentation form.
Grace Loo, Harrier Technology Pte Ltd
|
I am tasked to come up with some activity based costing report. The use of pivot tables and other skills picked up at the course will come in handy.
Harrison Tan, National Volunteer & Philanthropy Centre
|
Has helped to resolve problem on displaying info that spread across 2 or more rows into 1. Used to resolve this via manual cut & paste means which is time-consuming and tedious. Now, with the proposed, could save lots of time & effort (depending on data size).
HOO LEE SAN, DSTA
|
Import External & DataPivot Table, Pivot Table with MS Query have solved my problems. It safe a lot of times, I just need to spend the times for the first setting then I may able to view the report anytime.
Irynn Ng Gaik Pei
|
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 , TRONIC INTERNATIONAL PTE LTD
|
I have learnt to create pivort tables and use functions like vlookup to develop quick solutions in presenting data in the format I need by drawing data from various databases. In addition, I have learnt shortcut keys when working on EXCEL.
Jean Gwee
|
I have learned to use MS query to perform and present data summary, and more functions of Pivot table that I have not used.
Jerene Law
|
Countif, relative and absolute cell reference - able now to extract pertinent information on donors and students when the need arises. Time savings estimated to be around 40%.
Jessie Lee, Katong School
|
Learn to create a pivot table, it's very powerful and i will be able to save a lot of times of doing manual work in order to extract data
Joanne Lim, Tzu Chi Foundation
|
With the Offset & Match formula it will help save time in terms of looking up of data, consolidation, etc.
Joyce Chng, Timberland
|
I have to prepared lots of financial information and reports to the CEO and BOD, the function, formular, and pivot table will help me to plan and organized the report in a faster and better style.
June Lee, Ling Kwang Home for Snr Citizens
|
- Problem - format data to suit the needs of bosses. Benefit - able to use various formula/ applications in excel to help with that. saves time and minimises error due to transferring of data.
Katherine Khoo, DP Architects Pte Ltd
|
1) Now, I'm able to do formulas in the pivot table. I don't need to rely on copy & paste - saves time and space. 2) Able to do drop down list & conditional formatting that will help me with creating dashboard. 3) Match formula is useful for my current work too.
Law Su Yin, Timberland
|
Constant chart update as my line of work requires ad-hoc, monthly and quarterly reporting to higher management and timeliness of reporting is crucial.
Lee Jew Jeow, MINDEF
|
This course has enable me to manage and retrieve information from multiple data files and create meaningful tables and charts
Lee Ker Peng, PUB
|
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
|
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
|
Vlookup function and pivot table help me to save times when doing my work. Everyday i have to export 2-3 sets of different data from SAP system. Each data have some different fields and same fields. By using VLookup, I could combined/matched all three sets of data easily and fast.
Lim Soon Wah, Janis
|
The sumif and sub-total formula are extremely helpful and can really save a lot of time. Pivot table is also strong tools which I hope that it can be used in my next job
Lim Suet Ni,
|
I now know how to use Pivot table feature to create meaningful analysis reports from ERP database and will disseminate this useful feature to my fellow colleagues. Of course I have become more familiar with many formulae such as count, if, subtotal, lookup, etc, not to forget the macro programming introduction which have been clearly explained and demonstrated by Jason.
Linda Chew, ISK (Singapore) Pte Ltd
|
Learnt quite bit of 'shortcuts' and formulas so that I can effectively use excel in my work. able to consolidate few worksheets and workbooks to work together.
Mansha Vasnani, Chen Su Lan Methodist Children's Home
|
It saves time when ever we encounter difficulties in matching of Donor credit card number, profiles, and do reporting of our income and supplier pivot table.
Michelle A-de Ramos, World Vision International
|
1) Pivot table. Can search particular key information required, such as one P/O# with many invoices & sum up for each P/O when matching the payment from customers.2) End Key 3) Remove duplicate in the list
Ong Bee Kew (Chloe), Littelfuse Far East Pte Ltd
|
This course has taught me that the classifying of data is important as it will affect how we are able to create table/charts from there. It has also tell me about how to create pivot tables and pivot charts. This has enabled me to create tables/charts easily and also quickly.
Ong Hui Zhen
|
In my organisation, we need to analyse & present data at a regional level. However, our data is only available in separate tables by country . I learn how to merge data from these files & present them at a consolidated level. The pivot charts are also very useful in presenting our KPIs on a regular basis.
Patrina Kuek, Acushnet Singapore
|
We use Pivot tables often. This course has help me to use the pivot tables extensively and make charts from the pivot tables as well. Quite often, charts are well understood and convey the essence of presentation. Moreover, charts are also interactive and each time they get updated when base data change.
Pradip Muchhala, NXP Semiconductors Singapore Pte Ltd
|
Formulations, PES reporting, removals of duplicates, Pivot table usage saves time so much and able to generate reports and work more effectively and efficiently.
Puveines, SINDA
|
Understand more formula, knowledge of Pivot table, access, etc. eg. able to use the access table to extract data rather than to maintain a few excel worksheet for different requirements.
Rebecca Goh Lay Yian, DSTA
|
summarising of data using Pivot Table and MS Query. It is very useful for users who requires to process reports with massive data from various workbook.
Regina Lim, National Council of Social Service
|
It gave me hints on shortcut that I can perform. eg F5.
The logical steps explained on the formula is very helpful
Rozali Affandi, MYLA
|
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
|
Believe this course will greatly help me to reduce my working time on Excel with the learning of pivot table & macro. Freddy & Jason have simulated real work situations and helped me to understand better on how to apply the formulas & tables.
Sam Siew, The Timberland Company (Asia-Pac)
|
Learn about new formulas that I might be able to use to cut down on the size of my excel spreadsheet and the time taken to run the spreadsheets.
Sim Ying Tze, The Bodyshop Singapore
|
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
|
using pivot table, hopefully I can reduce my time to do a summary report and presentation in the future.
tan guo hao,allan
|
What is being taught was totally new to me. Never used these formulas before; first session was struggling but second session your approach of waiting for every one to be on same page before moving on to next step was very good. So far I had used only the excel functions for spreadsheets in budgets & monthly financial reporting's. Vlookup & Pivot Table/ Charts are especially helpful for more informative presentations.
Tan Ng Hee, Life Community Services Society
|
Visible cells under the GO TO function had helped to reduce time in copying and shading of cells. Very good. Implemented straight away. Trim functions and number that represents adding, subtraction, multiplication etc in a formula, better understand the meaning of the numbers
tan poh sung
|
,Analysis of outlets SPM (Sales Point Materials) consumption analysed by month,amt ,campaign,event etc can be done swiftly using pivot tables is using the traditional sort methodology
Tan Soi Meng, Chanel Pte Limited
|
I am having problem removing duplicates for mailing addresses as well as summing up donation from donors who have donated for a few years. Now I have learnt to use pivot tables to solve this problem and use other formulas to go about doing my work faster.
Valliappan, SINDA
|
Through the advanced formula that I have learned from this 2-day course, I'll be able to save a lot of time in producing related reports. I am amazed to find out that there are a lot of commands especially formula in excel that I have to utilize in order to be more effective and efficient.
Villamin Arnel Abas, HCA Hospice Care
|
Subtotal value to be extracted using F5. In the past used to copy & paste special (values) all subtotal value. Time saved on the extra work.
Vivian Choy
|
This course provide the relevant knowledge to enable to compile and compare data thru' pivot table, macro and formulas.
Wei Wei
|
I find the whole course very interesting and it is indeed a powerful tool to lighten my workload. I have yet to explore the learning in my work, but I find the pivot table & ms query most helpful and relevant. I believe the donors profiling will also help me retrieve specific data more efficiently. Many thanks to the trainer, Jason Khoo and his assistant. They are both very patient and helpful, which helps to make the learning process less stressful and a very positive one
WINNIE WONG , GRACEHAVEN
|
Has better helped me to deal with excel worksheet that has thousands of lines. Provide more insight on pviot table.
WONG LIZ, SIEMENS PTE LTD
|
With no formal Excel training, I'm not aware of shortcuts and more efficient methods of accomplishing the required analysis and data extraction. The course is an eye opener to the capabilities of Excel and unleashed new ways and methods I can use to achieve more.
Ma Fook Loong
|
1) Use datedif formula to do a simple count of staff ; 2) use countif to find out the number of birthdays in the month- this will help HR to prepare the birthday vouchers for staff; 3) vlookup formula is a powerful tool at work to extract data from a large data pool 4) pivot table is definitely going to help me in my quarterly Income & Expenditure reports I believe that the knowledge I gained in these 2 lessons is going to help me to work smart.
Anne Phan, All Saints Home
|
