What course participants say about us

MANUFACTURING AND MARKETING

“This course is unique from other Excel courses. Contents are very focus driven/relevant to our work function areas which enable us to gain better mileage from the training. It provides immediate solutions to real-life work issues.”

Esther Leong,

“This course will definitely save a lot of time when extracting data for manpower reports, etc. Pivot table is an amazing tool to use when compiling statistics reports.”

Tan Siew Leng,

“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,

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

MICHELLE LEE, ROHDE & SCHWARZ

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

Amy Lau,

“I learned the shortcut in the first speed test which will help me to fill up the records in an instant. ”

Joanne Li, Rohde&Schwarz

“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,

“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,

“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.”

Diana Ng, Symrise Pte Ltd

“I could have used the data consolidation by MS Query last year, when my company conducted a global survey and different geographies compiled the information together in different order. I could have saved so much time using MS Query instead of manually copying and pasting everything into the correct order”

Jieming Sun,

“The part whereby we were taught on how to consolidate the data from different excel sheets into one (last lesson). The refresher on pivot tables, more so on how to manipulate it based on whether you put it into rows/columns etc.”

Geraldine Cheang, Trafigura

“This course is unique from other Excel courses. Contents are very focus driven/relevant to our work function areas which enable us to gain better mileage from the training. It provides immediate solutions to real-life work issues.”

Esther Leong,

“This course will definitely save a lot of time when extracting data for manpower reports, etc. Pivot table is an amazing tool to use when compiling statistics reports.”

Tan Siew Leng,

“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,

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

MICHELLE LEE, ROHDE & SCHWARZ

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

Amy Lau,

“I learned the shortcut in the first speed test which will help me to fill up the records in an instant. ”

Joanne Li, Rohde&Schwarz

“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,

“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,

“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.”

Diana Ng, Symrise Pte Ltd

“I could have used the data consolidation by MS Query last year, when my company conducted a global survey and different geographies compiled the information together in different order. I could have saved so much time using MS Query instead of manually copying and pasting everything into the correct order”

Jieming Sun,

“The part whereby we were taught on how to consolidate the data from different excel sheets into one (last lesson). The refresher on pivot tables, more so on how to manipulate it based on whether you put it into rows/columns etc.”

Geraldine Cheang, Trafigura

“The "creating of form" can be applied on some of my existing forms like External Training App Form and Employee Updates Form that was previously in MS word version which was difficult to input. With excel, input of data is much easier and neater and furthermore I am able to link the data to a master file for easy consolidation. Also the Vlookup function was very useful in a sense that searching of required filed is just at the click of a button. The pivot table is also proven useful in some of my reporting, eg payroll and bonus reporting for the whole organisation. The MS query help to reduce time spend on reporting of my salary reporting to the various HOD. Last but not least, the F5 special function improve my productivity to 100% by deleting the pictures/objects in the MOM WP Form. Previously I have to delete one by one for 10 over times for just one single row.”

Karen Sim, Asiatic Agricultural Industries Pte Ltd

“I have always seen how pivot table works wonder in bringing data together for sales forecast but never actually know how to do it. It helps so much that I can analyse my data more efficiently. I should have attended this earlier. ”

Betty Juliana Tan, Classique Aromatics Pte Ltd

“Was using primitive way to do my excel sorting. Especially in privot table - Grouping is a new insight as well as many ideas”

Celine Koh, Cytec Industries Pte Ltd

“Before attending this course, I used Excel on a daily basis but did not know many of the formula. I used to do a lot of cut & paste which now I can use formula to help me work more effectively, eg. vlookup, sumif, countif, etc. ”

Grace Choo, 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, Denka Advantech Pte Ltd

“Short Cut, Vlookout, pilvot table, chart. All these has benefited me and would save me numerous of hours. Even though have not, done it yet.”

Shirley Lee,

“Although i'd know some of the formulars, i'd learned how to make better use of the formulars. I'd learn Pivot Table to salve lots of times to have the report/results.”

Lim Yit Yeat, Faci Asia Pacific Pte Ltd

“Especially on Pivot Table which I've learnt more than 10 years ago which I did not use it plus most of the formulas that I've learnt are somethings new to me.”

ONG CHIN GUAN, FACI ASIA PACIFIC PTE LTD

“Pivot Table & Micro. It minimise my time spending in preparing monthly report/slide for presentation. ”

KAMISAH SAMAD, GOODYEAR ORIENT CO PTE LTD

“Counting on 2 conditions unisng SumIF function . I can use this function to solve my monthly customer demand report. ”

Ang Boon Beng , Hamilton Sunstrand Pacific Aerospace P L

“The creation of a database to store donors records. Now I am able to create a database that will enable me to sort for the info required.”

Angel Loy,

“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

“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

“Learning of macro save times on formating and using formula facilitate financial reporting.”

Edmas Tan, Mektec Corp (S) Pte Ltd

“MS Query for consolidating data from multiple sources and auto data refresh Simple shortcuts such as ctrl+enter and Go-To Special functions that can help save time in everyday work ”

Alyna Chen, Merck Pte Ltd

“I have a need to reflect sales performance as % of target in a easy to view format. Previously I have always used bar chart, but now I am able to represent this in a beautiful speedometer that is easily understood at a glance. The camera feature is also very handy, as it saves me the hassle of copy and pasting from the pivot table every time there is a data refresh.”

Chen Lihui Alyna, Merck Pte Ltd

“This course is unique from other Excel courses. Contents are very focus driven/relevant to our work function areas which enable us to gain better mileage from the training. It provides immediate solutions to real-life work issues.”

Esther Leong,

“This course will definitely save a lot of time when extracting data for manpower reports, etc. Pivot table is an amazing tool to use when compiling statistics reports.”

Tan Siew Leng,

“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,

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

MICHELLE LEE, ROHDE & SCHWARZ

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

Amy Lau,

“I learned the shortcut in the first speed test which will help me to fill up the records in an instant. ”

Joanne Li, Rohde&Schwarz

“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,

“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,

“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.”

Diana Ng, Symrise Pte Ltd

“I could have used the data consolidation by MS Query last year, when my company conducted a global survey and different geographies compiled the information together in different order. I could have saved so much time using MS Query instead of manually copying and pasting everything into the correct order”

Jieming Sun,

“The part whereby we were taught on how to consolidate the data from different excel sheets into one (last lesson). The refresher on pivot tables, more so on how to manipulate it based on whether you put it into rows/columns etc.”

Geraldine Cheang, Trafigura

No testimonies were found.