Now able to consolidate data from difference work sheets to create my quarterly reports and presentation. Able to create the pivot table and chart and lot of function.
ALICE CHUA, TENARIS GLOBAL SERVICES FAR EAST PTE LTD
|
De-duplication of customer names are now made so much easier. We used to highlight them in different colours and manually identifying them and removing it. It took days and with the new Excel formula, it just took seconds to have it done. Pivot Table and Charting is a dynamic way of summarizing data into useful charts and make things very visible for marketers, especially when they don't think in grids.
Amie Choy
|
Some problems that I've been facing in vlookup for years have been cleared in this course. Thanks Jason! Not forgetting the macros together with the tips and tricks learned which will definitely help me to save a lot time.
Andrew Lim, Siemens Pte Ltd
|
Does not know that continuing updating the data base file can direct update the data in pivot table and the ways of showing the pivot charts. This course has open up my view points on how to use data to show different types of readings (with helps of other excel formulas). Steps of streamline data is now faster and the data could be more meaningful and faster to show the analyse data.
Angee Tan, Littelfuse Far East 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
|
Will try to use what I have learned to improve data management of donors and volunteers. (This is not my area of work, but data is power, so it is good to know!)
Catherine Ho, Make-A-Wish Foundation
|
The 1st part is very beneficial as it encompasses scenarios that I have faced before in my work. Examples - pivot table, vlookup. As such, i feel that this course has made me more knowledgeable in excel (provided with regular practice). However, the 2nd part is more complex and I found myself getting lost.
Catherine Seah Geok Choo, N.A.
|
Linking different worksheets and combining them to give different analysis
Chee Miao Fang, National Council of Social Service
|
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, NCS
|
Able to extract information from pivot table and draw chart for easy assessment of the customers using List function.
Clifford Chua, Mitsubishi Electric Asia 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 has taught me how to use the pivot table effectively, and helped me see the benefits of some functions to help me save time in analysing and retrieving useful sales data, and on the use of some functions which I did not know of before.
Dawn Lee, Research Biolabs Pte Ltd
|
I am now able to track forecast changes which each country give without having to remind them to mark changes in a different colour. Pivot chart is also a great eye opener. I've attended some other excel course by other training centres, but everydayExcel is the one which explained and ensure participants understood the text and background. I am able to apply to my work and save time. Thank you Jason.
Diana Ng, Symrise Pte Ltd
|
MS QUERY - CAN USE THIS TO COMBINE A FEW DIFFERENT FILES OR WORKSHEETS WITHOUT HAVING TO COPY AND PASTE. LEARNED MANY SHORTCUTS AND TRICKS.
DOREEN KEE, ERMENEGILDO ZEGNA FAR-EAST PTE LTD
|
This is definitely an eye opener for me. With the lessons on Excel formulas, pivot table and summarized macro training, I believe that it is very useful in the real world application.
Eileen Tan
|
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
|
- a) Managed to save time from formatting the dates and years, which can save me alot of time b) Consolidate all the data together without constant copy and paste function, simply by clicking on the 1 step button
ENEZ SEE TOH, VEECO ASIA PTE LTD
|
In computation of fund raising data esp. in financial year or for a particular sector, the formulas that I learn in this course makes the computation faster.
Eric Hu, National Council of Social Service
|
Pivot table - able to get data & statistic more effectively
Esther Low, World Vision International
|
It would help us in cleaning up the list of registered NPOs in our database with the raw data from the different Ministries.In addition, it allows one to mine the profile of corporate volunteers who have approached the Centre.
Evangeline Goh
|
Learn how to manipulate pivot table and pivot chart. Learn how to use MS query to combine different worksheets together.
Felice Cheong, Siemens Pte Ltd
|
1. Better awareness of useful Excel Functions and Formulas 2. Practical application of Pivot Table and Pivot Chart.
Fiona Wong
|
1. Better awareness of useful Excel Functions and Formulas 2. Practical application of Pivot Table and Pivot Chart.
Fiona Wong
|
Refresh, emphasize and explore in greater depth on the functionalities of Excel. Drill on some of the basic functions but not too sure on how to use it more effectively and productively.
Henry Sim, Littelfuse Far East Pte Ltd
|
Some of the helpful tips learnt include : MS Query for auto-updating of database which is used for pivoting and analysis, text to columns to separate dates, extraction of text from string of characters and lastly learnt some simple formula that could save manual work.
Irene Lim, Siemens Electronics Assembly Systems Pte Ltd
|
Had understand on the download and merging of two different files. This will actually save time for down loading reports for weekly meeting
Irisa Tham, Acushnet Singapore Pte Ltd
|
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
|
Managing duplicates in our mailing list / contact list. Managing data from different source files, learning more functions and formula to work smart.
Jean Huang, Scitific Pte Ltd
|
Previously, I spent a lot of time formatting worksheets, now I can do it at a click of a button and I can have more sleep!!
Jenny Tan
|
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
|
Using Pivot Table to create charts will save a lot of work especially when data is changing. With this, I don't have to create a lot fo charts when data is changing or when I like to look at the data using chart from a different prospective.
Jowyn Ching, Research Biolabs Sdn Bhd
|
With shortcut tips (F4/F5 keys), manipulate data using pivot and ms query assist in the reporting role. Also speeds up the process instead of doing it manually previously.
KARINA MAK
|
The course is very useful and easy to understand. Many manuals steps can now be automated!
Karrie Cheung, Whyze Solutions Pte Ltd
|
Problem I am facing are what is macro and the use & automation of data or report. In this course, I have learnt the using of Pivot table enable me to get and see data easily. The beauty of macro enable work done easily.
Katherine Tan Hui Wen, United Parcel Services Pte Ltd
|
The Tips & Tricks given are very useful especially the double clicking on the paint brush. This course also give me a better understanding on the formula especially the Vlookup formula which is very useful in my daily work.
Koh Lay Chin, Mediacorp TV
|
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
|
This course showed me a few formulas that I didn't know before. I've also heard of other possible solutions to problems that I'll look into further.
Lacey Hanada, Timberland
|
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, NCS
|
I use excel to analyse my customers performance every month. I have forgotten the more advanced functions available in excel since varsity days. These are functions such as vlookup, pivot table. I am now familiariazing myself with these functions in my work - saves me time from getting a colleague who is expert in excel to get the analysis up. Great empowerment on my end!
Lee Ching Yee
|
Time saving by creating new macro
Lim Kam Chung, Canon Singapore Pte Ltd
|
I have learnt the usefulness of pivot table which enable me to consolidate and present pivot chart and data to my management.
Marilyn Tan, NCS Group
|
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
|
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
|
- to learn how to sort and analyze data in a easier and more professional way by using pivot table. - to learn get to know excel f(x)
Mavin Ooi
|
This course is extremely useful for intermediate users of Excel. Through this course, I learnt to use MS Query and Pivot table for consolidating huge amount of crucial data. It will definitely save me a lot of precious time to focus on other job roles, I would recommend to anyone who would like to save time and still be able to be productive when processing and analysing data.
Melanie Low, 3M
|
I now have a much better understanding of what can be done using excel for my business and also know how to do it! As the course has real examples and each case study is a build up, it is easy to understand the context and immediately make reference to my own company and problems I have faced.
Neeraj Sundarajoo, Comwerks Pte Ltd
|
It will help me in managing the data we have collected from participants at our events e.g. streamline marketing materials to publicise to the right audience, collating feedback, tracking trends, etc. Also in planning and presenting of budgeting and tracking of expenditure.
Phenelope Ng, TOUCH Family Services
|
Pivot charts & tables - Now I can present without showing what it is not needed (cuts down on non-crucial info). MS Query - good tool for me to convert my raw database (more than 26 columns across) to select what I need to roll it out without having to see what I don't need. Tricks - Good shortcuts for me to cut down on searching or fumbling them.
Priscilla Tay
|
I considered myself quite an experienced Excel user until I met Jason Khoo. He's the one who showed and taught me many new things and aspects of Excel that allow me to easier and faster manipulate data. Although I have experience in working with pivot tables I was able to pick up quite a number of useful tips and tricks of this Excel Master. Moreover he showed me the power of MS Query in consolidating data from different workbooks. I highly recommend the Sales Performance Analytics with Excel workshop to anyone that has a need to get the maximum out of Excel with the least effort.
Ronald Schepers, N/A
|
Understand the power and benefits of Pivot Table and Ms Query. This would help me save time in generating report for my manager.
Sandre Soon
|
I have been doing alot of data analysis. Working on the raw data can be a pain and time consuming, however after attending this course, I learnt the power of excel in the shortest time and will definitely increase my productivity level.
Sandy Tow
|
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
|
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
|
In the process of creating a new contract that requires data for collation. Lesson on forms showed me how to do this. Also interested in how to use MS Query, but have yet to test it out.
Sherrie Ang, Abacus International
|
I have learnt and understand a lot more of excel functions and formulas. With this understanding I should be able to use excel more efficiently.
Shirley Ow, QBE Insurance International Ltd
|
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
|
using of formulas countif, sumif,.... help in doing the pricing calculation.
Su Su Htwe
|
The short cuts and some formulas taught in the course has been useful. However, I felt the course is a tat too short and more in-depth topics should be introduced without course attendees probing.
Tan Kheng Beng
|
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
|
In the past, I used to have difficult times when it comes to calculation and working on the database. This course has greatly benefited me on how to use the formula efficiently & time saving when applying to my daily works. I find it very resourceful and beneficial to me.
Whelan Lee, Mitsubishi Electric Asia Pte Ltd
|
Analyse sales record of each months and year. By using the Pivot table and formulas like Vlookup and if, it greatly reduce my time.
William Lin, Research Biolabs PTE LTD
|
Find it time consuming to compile data for analysis, basic understanding of pivot tables. With learning's from the course, will do data compilation much faster as well as better understanding of pivot & charts more faster analysis.
Woon Cindy, The Body Shop (S) Pte Ltd
|
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, Creative Technology Ltd
|
I deal with a huge amount of raw data and I needed to find efficient ways to generate meaningful trend analysis using pivot tables. Also needed to learn more formula that will me pull together data from different sources to show KPI performance to monitor performance by store, area and overall market.
Yeeling Chok
|
After attended this course, now I am able to use pivot table and v-look up which definitely will give a lot of benefit to my job.
Yoppy Tan, Oil Spill Response Ltd
|
This course has provided me insights to how I can make use of excel functions to prepare easy to read and manipulate reports. Jason has also provide me a fabulous solution to my time-consuming Order Consolidation Process. Many thanks!
Sharon Huang, The Timberland Company
|
using of sumif and countif instead of pivot table, nestedifs
Carol Chua, Tata Communications International Pte Ltd
|
