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 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
|
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
|
Time saving by creating new macro
Lim Kam Chung
|
saves time on our daily repeated actions thru the use of macro
Sim Kim Kiat, CANON S'pore Pte Ltd
|
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
|
Learned a lot of neat tricks in saving time and effort working on an excel sheet.
Jefre Johari
|
Bring me to another level in improving my report submission timing, presentations and analytical summation
Nasser Latiff, Ermenegildo Zegna Far East 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
|
Using VLOOKUP, MONTH, MID, merging data in 2 cells, saved me at least 5 hrs last week when I had to verify accuracy of data between several files where names are not consistently entered.
LOH LEAN SAN, INGERSOLL RAND
|
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,Vlookup, etc, not to forget the macro programming introduction which have been clearly explained and demonstrated by Jason.
Linda Chew, ISK (Singapore) Pte Ltd
|
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
|
Extracting and compiling data from large number of files into a single workbook for easy perusal.
Chiang Mei Yee
|
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
|
For software requirements and test cases traceability, test & defect reporting and test data analysis on life science software application testing. To improve test productivity and test efficiency
Neo Soon Hoe
|
THE KNOWLEDGE ON PIVOT TABLE & SOLVER CREATE NEW OPPORTUNITIES FOR ANALYZING DATA WHICH WAS NOT POSSIBLE PRIOR TO ATTENDING THIS COURSE.
CHAN CHOON SENG
|
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
|
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
|
I am able to generate weekly reports quicker with the solutions provided. Time savings - approx 20% of what I used to spend.
KAREN ONG, Littelfuse Far East Pte Ltd
|
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
|
I was having a hard time adding new rows into budget excel template, as it will has huge impact on the formulas, Jason went through extra miles to explain how to overcome that problem although that was not supposed to be covered in this course.
Felicia Cao, Littelfuse Far East 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
|
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
|
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
|
Able to extract information from pivot table and draw chart for easy assessment of the customers using List function.
Clifford Chua
|
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
|
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
|
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, Prefer not to disclose
|
- 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, Prefer not to disclose
|
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
|
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, Prefer not to disclose
|
This course provide the relevant knowledge to enable to compile and compare data thru' pivot table, macro and formulas.
Wei Wei, Prefer not to disclose
|
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, Prefer not to disclose
|
Organising data using pivot table and using macro recording to write macros to reduce repetitive work.
Celine Cheok
|
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, Prefer not to disclose
|
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, Prefer not to disclose
|
I have a clearer idea on how macros are created and it will help to minimize human error and effort.
Tew Beng Yong
|
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, Prefer not to disclose
|
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, Prefer not to disclose
|
Eg. Camera Tool. It is useful to be use in presenting all charts and tables onto 1 A3 size Due to job scope, other learnings are unlikely to be applied
Eileen Ang, Prefer not to disclose
|
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, Prefer not to disclose
|
I have learnt the following functions which have helped me to save a lot of time in doing my work: PROPER, SUB-TOTAL, COUNT ETC.
Tan Peng Chiok, Prefer not to disclose
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
I would often need to verify my warehouse's WMS records with my office's records. The ability to actually combine the 2 records together for this purpose has significantly reduced the time needed for the task. The WMS records can be exported into a CSV file while my office's records are already in Excel format. And with Vlookup, I could merge the 2 files.
Frederick Looi, Taytonn Pte Ltd
|
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
|
Able to organise my data in excel more effectively in Pivot Chart and also gain more understanding in entering formula in excel.
Douglas Hoo Hean Ee, T-est Pte 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
|
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)
|
