SynergyWorks Logo
Our Purpose Our Profile Our Approach Our Services Our Contact Singapore
Travel Industry
Download
 
 
 

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 estimates that she is likely to save about 50% of her time working on those excel related task as compared to before."

Patrina Kuek has 12 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 4 and 11 May 2007
Organisation : Acushnet Singapore Pte Ltd
Designation : Financial Analyst


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 estimates that she is likely to save about 50% of her time working on those excel related task as compared to before."

Rachelle Low has 4 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 4 and 11 May 2007
Organisation : Johnson and Johnson Vision Care Singapore
Designation : Events Support Executive


In my day-to-day planning function, I have to manage a lot of data, to translate these data into meaning reports for analysis and planning purpose. This course has enabled me to use some useful formulas & functions to get the report I want in a reduced time.

Lynn estimates that she is likely to save about 50% of her time working on those excel related task as compared to before."

Lynn Soon has 7 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 4 and 11 May 2007
Organisation : Acushnet Singapore Pte Ltd
Designation : Demand and Supply Planning Analyst


Excel is a powerful tool for designing my questionaire for manpower survey as I can save money on temp staff to do data entry! It helps me greatly in my analysis of data too as I can customise what information to retrieve and how to present my results.

Hwee Choon estimates that she is likely to save about 50% of her time working on those excel related task as compared to before."

Ng Hwee Choon has 10 years of experience using Excel. She uses excel 3 times a week. She attended our Excel course on 8 and 15 March 2007
Organisation : National Council of Social Service
Designation : Senior Executive (Corporate Development and Manpower Division)


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 estimates that she is likely to save about 50% of her time working on those excel related task as compared to before."

Sherrie Ang has 5 years of experience using Excel. She uses excel 4 times a week. She attended our Excel course on 8 and 15 March 2007
Organisation : Abacus International
Designation : Associate Director (Sales and Marketing)


Conditional formating and creation of a survey form using the functions in excel are very useful for me to do my work more quickly. Conditional formating because it is very useful in performance tracking.

Alicia estimates that she is likely to save about 30% of her time working on those excel related task as compared to before."

Alicia Chay has 2 years of experience using Excel. She uses excel every day. She attended our Excel course on 8 and 15 March 2007
Organisation : National Council of Social Service
Designation : Senior Executive (Corporate Development)


Ranking method is very useful in my course of work and save me a lot of time & stress and I have learn new things in pivot table and it is very interesting.

Irene estimates that she is likely to save about 70% of her time working on those excel related task as compared to before."

Irene Toh has 10 years of experience using Excel. She uses excel 10 times a week. She attended our Excel course on 8 and 15 March 2007
Organisation : National Council of Social Service
Designation : Executive (Partner Relation)


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 estimates that she is likely to save about 35% of her time working on those excel related task as compared to before."

Karen Chai has 5 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 8 and 15 March 2007
Organisation : Choose not to disclose
Designation : Lean Six Sigma Business Leader (Process Improvement)


The functionality of Excel that can assist to track business performance and achieve growth.

Examples practise and relate to "actual" business siutation enhance understanding in application.

Leng Leng estimates that he is likely to save about 50% of his time working on those excel related task as compared to before."

Soh Leng Leng has 8 years of experience using Excel. He uses excel 1 times a week. He attended our Excel course on 8 and 15 March 2007
Organisation : Cummins Filtration Singapore
Designation : Director (Management)


Learned the uses and features of the pivot table and the pivot charts that would be useful for future presentations in my course of work

Malar estimates that she is likely to save about 40% of her time working on those excel related task as compared to before."

Malar has 10 years of experience using Excel. She uses excel 4 times a week. She attended our Excel course on 8 and 15 March 2007
Organisation : Choose not to disclose
Designation : Senior Executive (Strategy and Specialisation)


Would be useful in my future work. Since it has just been a week since we learned the advanced features, have not put it to use yet. But I think I definitely will from next month onwards! It will help me to plan my visits when I do checks on Childcare Centres as I can extract the necessary information as and when needed

Good set of notes- think that it is great that Jason tailors the material to meet the needs of the class- we appreciate the effort taken to do this!

Monica estimates that she is likely to save about 55% of her time working on those excel related task as compared to before."

Monica Lim has 15 years of experience using Excel. She uses excel 2 times a week. She attended our Excel course on 8 and 15 March 2007
Organisation : Choose not to disclose
Designation : Principal Executive


Very well presented. Very useful that participants individual requirements were uncovered and subsequently included in the material.

Anne estimates that she is likely to save about 35% of her time working on those excel related task as compared to before."

Anne has 7 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 8 and 15 March 2007
Organisation : Choose not to disclose
Designation : Manager (Content Development)


Benefits - learnt some useful tips and is able to speed up processing time. Pivot table is also useful.

Michelle estimates that she is likely to save about 40% of her time working on those excel related task as compared to before."

Michelle Lee has 12 years of experience using Excel. She uses excel 5 times per week. She attended our Excel course on 8 and 15 March 2007
Organisation : ROHDE & SCHWARZ
Designation : Team Assistant (Logistics)


I now understand how Pivot Table works and am able to convey the data into a report that consists of figures & charts.

Amy estimates that she is likely to save about 40% of her time working on those excel related task as compared to before."

Amy Lau has 7 years of experience using Excel. She uses excel 10 times per week. She attended our Excel course on 8 and 15 March 2007
Organisation : Choose not to disclose
Designation : Project Support Exec (Logistics)


Formula taught were usesful, such as the Countif and Sumif, so were conditional formatting, and Macros.

Willy estimates that he is likely to save about 35% of his time working on those excel related task as compared to before."

Willy Ong has 5 years of experience using Excel. He uses excel 5 times a week. He attended our Excel course on 8 and 15 March 2007


Time Savings - Using Goal Seek to find out breakeven

Irish estimates that she is likely to save about 15% of her time working on those excel related task as compared to before."

Irish Ng has 2 years of experience using Excel. She uses excel every day. She attended our Excel course on 15 and 27 Feb 2007
Organisation : Adam Khoo Learning Technolgies Group Pte Ltd


The conditional formatting. I want to auto-highlight those rows that are urgent/blank. Time saving was beneficial.

Kim Yan estimates that she is likely to save about 50% of her time working on those excel related task as compared to before."

Chan Kim Yan uses excel every day. She attended our Excel course on 15 and 27 Feb 2007


Wendy estimates that she is likely to save about 80% of her time working on those excel related task as compared to before.

Wendy Tong has 6 years of experience using Excel. She uses excel every day. She attended our Excel course on 4 and 11 Dec 2006
Organisation : Microsoft Regional Sales Corporation


I benefitted from time save in using formula, data validation, macro for my monthly reporting.

Karen estimates that she is likely to save about 20% of her time working on those excel related task as compared to before."

Karen Koh has 5 years of experience using Excel. She uses excel every day. She attended our Excel course on 4 and 11 Dec 2006
Organisation : Microsoft Regional Sales Corporation


With the course, I should now be able to create customized forms that will help my team in our daily operations.

Tom Tang has 9 years of experience using Excel. He uses excel 5 times a week. He attended our Excel course on 4 and 11 Dec 2006
Organisation : Microsoft Regional Sales Corporation


How to handle complicated formula and creating simple macro were useul tips.

Izumi estimates that she is likely to save about 10% of her time working on those excel related task as compared to before."

Izumi Takeda has 10 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 4 and 11 Dec 2006
Organisation : Microsoft Regional Sales Corporation


I learnt how to use macro to record the report formatting procedure.

Jack estimates that he is likely to save about 10% of his time working on those excel related task as compared to before."

Jack Li has 1 years of experience using Excel. He uses excel every day. He attended our Excel course on 4 and 11 Dec 2006
Organisation : Microsoft Regional Sales Corporation


Time saving, understand formulas and functions. Being less 'manual' when setting up databases. Very useful course. Excellent Trainer. Seldom have I understood so much of a computing course.

Marceline estimates that she only needs to spend about 50% of her time working on those excel related task as compared to before."

Marceline Chin has 8 years of experience using Excel. She uses excel 2 time a month. She attended our Excel course on 2 and 9 Nov 2006
Organisation : National Council of Social Service


I learnt how to use the Special Paste fnction for copying big spreadsheet and using the shortcut to set print area.

Eileen Lim estimates that she only needs to spend about 50% of his time working on those excel related task as compared to before."

Eileen has 6 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 2 and 9 Nov 2006
Organisation : National Council of Social Service


The tips are extremely useful. It does help me to save time in performing / managing databases. The conditioning format is useful as I need to track profile of clients.

Annie estimates that she only needs to spend about 20% of her time working on those excel related task as compared to before."

Annie Won has 6 years of experience using Excel. She uses excel 3 times a week. She attended our Excel course on 2 and 9 Nov 2006
Organisation : National Council of Social Service


Helps to create charts and pivot tables for our R&D projects.

Pradip estimates that he only needs to spend about 50% of his time working on those excel related task as compared to before."

Pradip has 7 years of experience using Excel. He uses excel 3 times a week. He attended our Excel course on 2 and 9 Nov 2006
Organisation : Philips Semiconductors S'pore Pte Ltd


Lots of clarity obtained in all the functions covered in the the course besides many advanced level functions. Very good and advantageous course.

Satbir has 10 years of experience using Excel. He uses excel everyday. He attended our Excel course on 2 and 9 Nov 2006
Organisation : Raffles Solutions Pte Ltd


The charts has been useful. I learnt how to input interesting formulas into the chart

Joyce Chia has 4 years of experience using Excel. She uses excel 4 times a week. He attended our Excel course on 2 and 9 Nov 2006
Organisation : V-Kool International Pte Ltd


All the shortcuts given e.g. paintbrush, counta, goto save a lot lot of time.

Yu Wei estimates that she only needs to spend about 70% of her time working on those excel related task as compared to before."

Yu Wei has 2 years of experience using Excel. She uses excel 1 time a week. She attended our Excel course on 2 and 9 Nov 2006
Organisation : National Council of Social Service


Learning about the formulas, the project management and all the short cut keys.

Janice has 8 years of experience using Excel. She uses excel 5 times a week. He attended our Excel course on 2 and 9 Nov 2006


I used to sieve duplicate records manually but now I can use advanced filter to do that.

Herman estimates that he only needs to spend about 20% of his time working on those excel related task as compared to before."

Herman has 4 years of experience using Excel. He uses excel 3 times a week. He attended our Excel course on 22 and 29 Sep 2006
Organisation : Mondial Assistance Singapore


IF Formula and VLOOKUP formula are very useful for my reports. They reduce compiling time by almost 40%. Though I have been using excel for many years, the course teaches me a couple of tips that I did not know.

Hazel has 10 years of experience using Excel. She uses excel every working day. She attended our Excel course on 22 and 29 Sep 2006
Organisation : W L Gore & Associates


I learnt quite a number of shortcuts and functions e.g. SUBTOTAL formula, goto function, search funtion, etc. THANKS!

Hwee Miang has 10 years of experience using Excel. She attended our Excel course on 22 and 29 Sep 2006


I have learnt how to use formula like VLOOKUP, COUNTIF etc. which I never know excel is so powerful to do so many stuff.

Sandy estimates that she only needs to spend about 60% of her time working on those excel related task as compared to before."

Sandy has 6 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 22 and 29 Sep 2006
Organisation : W L Gore & Associates


Better understanding on how to use formulas. Tips on shortcuts really useful.

Herbert Ho estimates that he only needs to spend about 50% of his time working on those excel related task as compared to before."

Herbert has 2 years of experience using Excel. He uses excel 1 time a week. He attended our Excel course on 22 and 29 Sep 2006
Organisation : Mondial Assistance Singapore


I learn how to use macro recording to shorten the time taken to do certain task.

Vincent estimates that he only needs to spend about 80% of his time working on those excel related task as compared to before."

Vincent has 2 years of experience using Excel. He uses excel 5 times a week. He attended our Excel course on 22 and 29 Sep 2006
Organisation : Persimmon Ridge Investment Pte Ltd


Whole course is indeed a beneficial one. Although I use Microsoft® Excel almost everyday at work, little do I know excel can make wonders with the little icons you can see on the screen.

Philo has 10 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 22 and 29 Sep 2006
Organisation : Eltra Aeronautics (S) Pte Ltd


1) Used to slowly scroll from top to bottom or vice versa. Now I know how to use the shortcuts.
2) Learnt how to create "forms" in Excel.
3) Learnt how to update data in both Access and Excel.

Jasmine estimates that she only needs to spend about 50% of her time working on those excel related task as compared to before."

Jasmine has 6 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 1 and 8 Sep 2006
Organisation : National Council of Social Service


I used to delete selected fields row by row in a database of 50,000 rows.

Winnie estimates that she only needs to spend about 20% of her time working on those excel related task as compared to before."

Winnie has 8 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 1 and 8 Sep 2006
Organisation : National Council of Social Service


I used to sort data manually. After this training, pivot table has benefitted me in time savings.

Susan estimates that she only needs to spend about 10% of her time working on those excel related task as compared to before."

Susan has 2 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 1 and 8 Sep 2006
Organisation : Philips Electronics Singapore


I used to either scroll down the worksheet or press "Page Down" to get to the end of the data. But no, I can simply use "End, Shift(hold), Down" keys.

Wendy estimates that she only needs to spend about 70% of her time working on those excel related task as compared to before."

Wendy has 10 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 1 and 8 Sep 2006
Organisation : Prefer not to disclose


a) Apply formula to the whole column without using copy and drag.
b) Use to count manually by rows - now I use countif
c) Using macro to carry out repeat functions.

Alice estimates that she only needs to spend about 70% of her time working on those excel related task as compared to before."

Alice has 5 years of experience using Excel. She uses excel 3 times a week. She attended our Excel course on 1 and 8 Sep 2006
Organisation : Temasek Polytechnic


I have learnt to analyse the data in a more efficient manner using the countif, subtotal formulae.

Dawn estimates that she only needs to spend about 30% of her time working on those excel related task as compared to before."

Dawn has 5 years of experience using Excel. She uses excel almost every workday. She attended our Excel course on 1 and 8 Sep 2006
Organisation : Prefer not to disclose


Before this course, I only know the basic of Excel. Did not know that actually, there are so many formats we can use to cut short the time to obtain the results. One specific example is the pivot table which I get to learn is useful for my presentation

Sock Moon estimates that she only needs to spend about 50% of her time working on those excel related task as compared to before."

Sock Moon has 8 years of experience using Excel. She uses excel 5 times a week. She attended our Excel course on 1 and 8 Sep 2006
Organisation : Philips Electronics Singapore


"Vlookup helps me to reconcile stock reports from my external warehouse. It is very productive as the reconciliation takes less time when you have a LONG list of inventory."

Pivot Table gives me the basics of creating our shipment planning forecast. A very benefiting tool for segregating data you require.

Vivien estimates that she only needs to spend about 70% of her time working on those excel related task as compared to before."

Vivien has 6 years of experience using Excel. She uses excel 5 times a week.
Organisation : Taytonn Pte Ltd.


"Before, I had to manually merge data. Now with Vlookup, merging data and manipulating them is a breeze!"

Adrian estimates that he only needs to spend about 20% of his time working on those excel related task as compared to before."

Adrian has 10 years of experience using Excel. He uses excel 4 times a week.
Organisation : IIR Exhibitions Pte Ltd.


"I have a big workbook and I keep increasing the worksheets depending on demand and requirement. Now I would just have to try to use pivot table."

JoAngie estimates that she only needs to spend about 80% of her time working on those excel related task as compared to before."

JoAngie has 10 years of experience using Excel. She uses excel all day long for reporting / daily records / schedules.
Organisation : Heineken Far East Pte Ltd.


"Lots of shortcuts such as visible cells selection, Ctrl + End + 'arrow key'. Pivot table and chart will be very useful in doing my reporting."

Chantel estimates that she only needs to spend about 80% of her time working on those excel related task as compared to before."

Chantel has 6 years of experience using Excel. She uses excel 5 times a week.
Organisation : Choose not to disclose.


"I used to manually calculate subtotal at the end of each section. Now I can use the subtotal function to do it."
Note from SynergyWorks: Subtotal function is different from subtotal formula.

Anna estimates that she only needs to spend about 60% of her time working on those excel related task as compared to before."

Anna has 10 years of experience using Excel. She uses excel 3 times a week.
Organisation : Danfoss Industries Pte Ltd.


"Before this course, I would manually edit spreadsheet. Now, I learnt to use Auto-Filter to help me filter data and do formatting using "Visible Cells Only"

Shirley estimates that she only needs to spend about 50% of her time working on those excel related task as compared to before."

Shirley has 10 years of experience using Excel. She uses excel 2 times a week.
Organisation : East West Executive Travellers Pte Ltd.


"I learnt how to use the F4 function key to rotate between absolute references and relative references, the subtotal key, copy key by double clicking the mouse button. I can use the pivot table feature in excel to try on our ACCPAC system to extract the info we need.

Rosalind estimates that she only needs to spend about 50% of her time working on those excel related task as compared to before."

Rosalind has 5 years of experience using Excel. She uses excel 2 times a week.
Organisation : Igus Singapore Pte Ltd.


"I used to use different tabs to segregate data for different customers. I realised that just by keying in the same worksheet, I can manipulate (organised) the data using pivot table.

Extremely useful for start-up/organisation that doesn't run on SAP/MRP etc. Excel can be a comprehensive tool to evaluate/analyse data with basic data entry.

Cindy estimates that she only needs to spend about 30% of her time working on those excel related task as compared to before."

Cindy has 5 years of experience using Excel. She uses excel 2 times a week.
Organisation : Taytonn Pte Ltd.


"The Excel Pivot Table combined with MS Query are fantastic tools! I managed to use them to extract the required data from Accpac and submit it to my Organisation's HQ in Germany. I actually recommend your course to one of my business associates who claims to work a lot with Excel and databases. When I showed him how quickly I could sort out databases for e.g. with VLookup of the Industry Class, he was SOLD! Thanks to your Excel course plus your guidance!"

Bilal has 10 years of experience using Excel. He uses excel 3 times a week.
Organisation : Igus Singapore Pte Ltd.


"I learnt many shortcuts and functions that I didn't know of. This course is most beneficial to people who handle huge data and want to manage it well.

Companies should have a customized excel course conducted by this trainer that matches their needs - will certainly result in time/cost savings and efficiency."

Maggie has 6 years of experience using Excel. She uses excel 3 times a week.
Organisation : Sumitomo Corporation (S) Pte Ltd


"I am able to use pivot table to monitor the product and total purchase. I know how to make use of formulas for different type of requirement. I have a better understanding on macros."

Wendy has 5 years of experience using Excel. She uses excel 5 times a week.
Organisation : Sumitomo Corporation (S) Pte Ltd


"I learn how to use pivot table, leverage and discover useful shortcuts (e.g. double click cross at the bottom right, end bottom and make use of the FindAll function"

Gwyneth has 8 years of experience using Excel. She uses excel 4 times a week.


"I used to just sorting data using "sort". Now, can apply the filter function to better arrange data info."

Val has 4 years of experience using Excel. She uses excel 2 times a week.
Organisation : National Council of Social Service


"The course has helped to save time and headaches. Now able to split comments into multiple cells. Not more MANUAL re-entry"

Glenn has 10 years of experience using Excel. He uses excel 8 times a month.
Organisation : National Council of Social Service


"I used to input data manually. Now I can create a dropdown list for a list of similar data"

Karen has 2 years of experience using Excel. She uses excel everyday.
Organisation : National Council of Social Service


"I used to take a long time to churn out data, but with the help of pivot table/charts, I am able to churn out useful dat/information within a shorter time period."

Alenzia has 5 years of experience using Excel. She uses excel everyday.
Organisation : National Council of Social Service


"I didn't even know there's such a thing as "Pivot Table" previously. Now I know hoe to use it effectively."

Sheena has 3 years of experience using Excel. She uses excel 5 times a week.
Organisation : National Council of Social Service


"I have gained a greater understanding for pivot table. Get to know how to scroll to the end of the file."

Yen Yen has 3 years of experience using Excel. She uses excel everyday.
Organisation : Marketing Institute of Singapore


"Very good and valuable excel course that provides continual learning with the help of website learning."

Julie has 6 years of experience using Excel. She uses excel 1 time a month.
Organisation : National Council of Social Service


"From the school list. Very good - save a lot of money."


School list was a request made by Shirley to convert data copied from the website into a mailing list.

Shirley has 10 years of experience using Excel. She uses excel everyday.
Organisation : National Council of Social Service


"Setting up formula to search for data."

May has 4 years of experience using Excel. She uses excel 4 times a week.
Organisation : National Council of Social Service


"'Text to Column' was especially beneficial since I download the data from the system. I used to change the data manually."

Leo Murshige has 6 years of experience using Excel. He uses excel 4 times a week.
Organisation : Danfoss Industries Pte Ltd


"The interactive style of the course is very useful. The course improves my work efficiency"

Jil has more than 12 years of experience using Excel. She uses excel everyday.


Copyright SynergyWorks 2002-