BANKING AND FINANCE

BEAUTY AND WELLNESS

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

BUIDLING AND CONSTRUCTION

“I need to sum up and count the numbers of projects in my database frequently. I learned to use subtotal, pivot table which make my task very easy. Recently, I also require to create 2-axis line chart, this course come in time for me to create using pivot chart.”

CONSULTANCY

“Macro and learning about charts that show most recent results. Help to improve efficiency in repetitive tasks and constant manual updates. Definitely time saving, and hopefully I will be able to explore new solutions in future.”

Jascelyn Teo, Prefer not to disclose

CONSUMER AND INDUSTRIAL PRODUCTS

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

HEALTHCARE AND SUPPORT

“The course is definitely useful for my scope of work back in office. Especially in statistical report, management report and annual report. The classroom arrangement and environment is conducive and the location is easy to access”

HOTEL AND ACCOMMODATION

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

Ang Boon Beng , Hamilton Sunstrand Pacific Aerospace P L

INFORMATION TECHNOLOGY

“I now have a much better understanding of what can be done using excel for my business and also know how to do it! As the course has real examples and each case study is a build up, it is easy to understand the context and immediately make reference to my own company and problems I have faced. ”

INSURANCE

“I have learnt and understand a lot more of excel functions and formulas. With this understanding I should be able to use excel more efficiently.”

Shirley Ow, QBE Insurance International Ltd

MANUFACTURING AND MARKETING

“This course is extremely useful for intermediate users of Excel. Through this course, I learnt to use MS Query and Pivot table for consolidating huge amount of crucial data. It will definitely save me a lot of precious time to focus on other job roles, I would recommend to anyone who would like to save time and still be able to be productive when processing and analysing data.”

SOCIAL OR COMMUNITY SERVICES

“1) Use datedif formula to do a simple count of staff ; 2) use countif to find out the number of birthdays in the month- this will help HR to prepare the birthday vouchers for staff; 3) vlookup formula is a powerful tool at work to extract data from a large data pool 4) pivot table is definitely going to help me in my quarterly Income & Expenditure reports I believe that the knowledge I gained in these 2 lessons is going to help me to work smart.”

SPA BEAUTY AND THERAPY

“I deal with a huge amount of raw data and I needed to find efficient ways to generate meaningful trend analysis using pivot tables. Also needed to learn more formula that will me pull together data from different sources to show KPI performance to monitor performance by store, area and overall market.”

BUSINESS PLANNING AND DEVELOPMENT

“The useful features learnt during the course are:Sumif function, pivot table, solver and conditional formatting as they are very relevant in my work that involves budgeting, revenue projections, product tracking dashboard reporting.”

Chia Boong Kheng

BUSINESS SYSTEMS

“I had learned advanced technique on how to extract data in a more efficient way using Pivot table, knew quite a lot of features and functionality of Pivot table. In the past, I just use a few commands like vlookup, Mid, left, right to analysis data. After this course, I had benefited with additional commands date and also learn how to tackle exported raw data from SAP where the date is in text format. Thanks !.”

FINANCE

HUMAN RESOURCE

“Jason went through actual case scenarios and thus allowed us to be able to be able to directly relate to our everyday work, exploring possible alternatives that would be useful in helping to save time and effort. Trainer is very knowledgeable. Thanks for being so willing to share, the prompt responses and working with us to solve the problems that we face in Excel.”

LOGISTICS

MANAGEMENT

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

PLANNING

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

RETAIL AND MERCHANDISING

“Learned a lot of neat tricks in saving time and effort working on an excel sheet.”

Jefre Johari, Ermenegildo Zegna

SALES AND MARKETING

“1) Macros function can help me execute formulas for margin analysis with one keystroke as compared to how I would have manually done previously. 2) Pivot table can help me manipulate tradeshow orders for meaningful analysis. 3) Little tips that help to cut excel processes that I wouldn't have known if I didn't attend this course.”