Some of the useful tip and function, like Goto, it helps to save time. Thinking process in the course make you apply the technique and excel knowledge that are taught.
Lai Wan Ning
|
Was using primitive way to do my excel sorting. Especially in privot table - Grouping is a new insight as well as many ideas.I like the setup, it's not too many students and can have better focus to attention and questions
Celine Koh, Cytec Industries Pte Ltd
|
I can use the new solution to summit my monthly report and some engineering data analysis. Very Useful!
Eric Tan Kay Chuen
|
I need to use Excel frequently for my company system tracking of daily project/tasks. We have people writing programs and this course helps me to understand excel spreadsheet whenever I sees a complicated formulas.
Melissa Yeo, IFF (Asia Pacific) Pte Ltd
|
I gain better understanding in excel now. With the foundation, I achieved during the workshop, now I will not be ignorant on the formulas used in the worksheet. I also have better knowledge in macro and pivot table too. Keep up the good job! Thumbs up.. Hopefully in future should there be any workshop on excel/macro/pivot table, please do inform me. Thank you.
Nurhafizah Binti Adi Ahmad Safarudin, Lufthansa Technik Logistik GmbH
|
Learning of macro save times on formatting and using formula facilitate financial reporting.
Edmas Tan, Mektec Corp (S) Pte Ltd
|
I need to enter repetitive data when generating monthly report and it's very time consuming. In this course, I learn to use VLookup to auto complete hence reduce time in entering repetitive data.
Tan Hwee Huan, Prefer not to disclose
|
1) Tips & Tricks 1: Helps to reduce the time taken to perform certain features 2) Pivot Table & table: Sorting features helps to organize the data without copying the pivot to another worksheet 3) Creating form: Assist me on various features of form creation especially doing transactional lean improvement
Karen Chai Mun Ling
|
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, Prefer not to disclose
|
Allows me to explore alternative ways to process databases. Will consider more of using Excel in day-to-day operation instead of other software as it is easier to learn and apply. Will be able to shorten the learning curve of new employees.
Felicia Lim
|
Previously, when doing the headcount report, we need to print in the hard copy, count and key in the figures in the spreadsheet. After this course, just extract the figures from the system and use the pivot table to consolidate the figures.
Lim Huey Pin, Prefer not to disclose
|
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, Prefer not to disclose
|
Problems faced : Not able to do a quick delete of blank rows in between tables / colour code cells based on range. Course taught me new formulas and quick keys(F4/F5..etc) that allows me to complete my task in a much time.
Shawna Lee, Prefer not to disclose
|
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
|
learn some new thing with shortcut way. And found out the solution in grouping data in pivot table report.
New Shiow Yee, Ricoh (S) P/L
|
Were facing preparing of the report for internal use and external use problem.
Every report will have indicate different data. After attend this especially for Pivot table & Macro method, it do helping me on sorting out lots of report. Formula wise are also do helps a lots on shorten my time to rearrange the data.
Lemon Low, Ricoh (S) Pte Ltd
|
Attendance List report has been modified easier to read and saves time with the solution of Pivot Table, and formula
Catherene Quek, Ricoh (Singapore) Pte Ltd
|
Pivot table. From this course, I have learnt additional pivot table functions which I do not know in the past. I can make use of the knowledge acquired on this immediately in my course of work.
Wendy Voo How Kheng
|
Setting Dynamic Range and naming this range for pivot table. Currently i am using fixed range when creating pivot table. After learning this, it helps me to do analysis faster
Tan Yu Min, Ricoh Singapore Pte Ltd
|
- 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
|
