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
|
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
|
The use of vlook-up, MSQuery and Macro will be very useful in my work. Jason's explanation of how to apply these to my current work area gives me the confidence to try them out. He has a newsletter and will help us out in our query outside of these training session as well. Jason is excellent in perceiving our questions, where the error lies and explain it clearly to us. The applications are very useful and can be used in most of my work.
Lim Kiat Heng
|
Very down to earth solution & productive approach. A paradigm shift experience.
Alex, Prefer not to disclose
|
I have gained in terms of improved knowledge on more efficient use of excel formulas, pivot table and analysis of data.
Ellyne Setiawan, Prefer not to disclose
|
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, Prefer not to disclose
|
Ideas for new solutions to work situation (however not covered in-depth enough during the course to implement).
Karen, Prefer not to disclose
|
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, Prefer not to disclose
|
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, Prefer not to disclose
|
Pivot Table would definitely be useful in my scope of work for sales/finance data analysis
Chang Mei Choo, Prefer not to disclose
|
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, Prefer not to disclose
|
