GOVERNMENT ORGANISATION
|
Not able to translate data to on-demand presentation for analysis. Problem can be tackled with Pivot table.
Heidi Neo Chui Er, CPF Board
more testimonies from participants in the Government Organisation industry |
Learnt many new formula which is able to help me re-define those conventional and complicated ones that I'm currently using.
TANG EE KOON, CATHERINE, DEFENCE SCIENCE & TECHNOLOGY AGENCY
|
The customised example given by my colleague is beneficial as I now know a simpler formula to categorise payments by Qtr.
Ang Kock Tiong
|
Problem Faced: Not sure how to analyze raw data and use Pivot Tables. In this course learn about how to use MS Query in Pivot Tables.
Khoo Hai Yong, DSTA
|
Have been using xls for my statistics compilation for a while, but in a very basic way. After the learning thru this xls course, it would certainly allow me to explore a more efficient way to do the statistics now.
TAY SWEE HWA
|
The F5 function is good as it helps to solve the problem of extracting some data from a column to another column.
Cindy Ng, DSTA
|
To convert text to date, as I also download file from MAR, and unable to convert the date to value. Have been manually removing the space in between as function trim unable to apply in this case too.
Zann Sim Bee Cheng
|
The use of Query to refresh pivot tables is useful in my course of work, with about 70% in terms of time saving.
Ho Cheeng Hwi, DSTA
|
My training records are more manageable with the knowledge of how to use excel in a more efficient way.
Celine Low
|
- The tips and tricks are helpful and save me time and effort to click on mouse
- When making changes to charts created from pivot tables is much easier and require lesser effort than the traditional way of creating it from excel. Just drag and drop.
- The option to update pivot table automatically have helped me do my monthly report for my boss in a shorter time.
Jeannie Siew Po Yeng, DSTA
|
Experienced for myself the power of excel which overwhelms! Sadly I do not use excel so extensively in my workplace so likely I will forget what I have painstakingly tried to understand at the course.. :(
Valerie Er
|
Able to use Left, MID and Right functions to extract date. This helps me to sort the date of the data set and to sort the data in ascending order. I am happy to learn about MS Query in Excel and to extract data from Excel/Access and let it auto-update by the criteria set. I can apply this in the monthly reports and keep them updated as and when needed.
Eve Tay
|
The excel functions and tips I learned from this course will definitely help me to do my work more efficiently. Eg. use Pivot chart to plot chart straight from pivot table, use shortcut keys to highlight whole spreadsheet, use Macro to record repetitive tasks etc.
Low Bee Hua, DSTA
|
More tips n tricks. More confident in previously trial-n-error ways. Revision of what was previously learnt. Time-savers are useful.
Zoe Lim, DSTA
|
Learn have to cut and paste formula into existing formulas so that there are not so many columns in the worksheet containing different formulas. Gain more knowledge on pivot table on how to manipulate the fields so as to show selected data that are needed for different purpose. Found the query created using the excel spreadsheet a useful way to show data and refresh it as needed.
Ong Lay Yen
|
The shortcuts to doing many of the functions, for e.g. how to change months from dates, subtotals, features of the pivot table, etc..Course is certainly made more interesting with relevant case studies which are applicable to the participants.
Karen Lee Heng Keow, DSTA
|
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 !
Yap Seow Kian
|
Has helped to resolve problem on displaying info that spread across 2 or more rows into 1. Used to resolve this via manual cut & paste means which is time-consuming and tedious. Now, with the proposed, could save lots of time & effort (depending on data size).
HOO LEE SAN
|
Understand more formula, knowledge of Pivot table, access, etc. eg. able to use the access table to extract data rather than to maintain a few excel worksheet for different requirements.
Rebecca Goh Lay Yian
|
Pivot table - i had known more uses for the pivot table and how it can assist me to gather my data and summarise in the simplest manner
Eng Woei Lin
|
The short cuts that I have learnt in the course actually help me save some time. For e.g. I do not have to drag the mouse all the way down to the end with the help of shift+end.
Edna Wong
|
Analysis of price data over different years. Price data are usually disorganized and difficult to analyse the trend. Now with knowledge of pivot tables, it is easier to present and organize the data to see trends.
Low Yuan Sheng, DSTA
|
Have learnt more functions and will be able to apply them to save time. Knowledge on MSQuey and Pivot table and charts will help me to deal with large database more effectively now.
Loh Qiaoling, DSTA
|
Have learnt more functions and will be able to apply them to save time. Knowledge on MSQuey, Pivot table / charts, macros, if function will help me to deal with data presentation more efficiently.
Anna Mak, DSTA
|
With MS Query, I have managed to compare data from 2 worksheets without using vlookup which is supposed to be more tedious.
Leo Hee Ming, DSTA
|
Learnt some new features of Excel e.g. MS query, etc and some new formulas, which may come in handy one day. Also a good opportunity to refresh some of the Excel knowledge acquired some time back but had forgotten since. The case studies were useful too.
Patrick Lim
|
MS Query, which helps to reduce the excel file size and processing time. This is useful because our data file can be very huge with many columns of data.
Yau Boon Fong, DSTA
|
I have learn the effective method of using Excel and save time in working on it manually using the conventional way of cutting & copying.
Desmond, DSTA
|
MS QUERY AUTOMATIC REFRESH NEW DATA AND MACRO HELPS TO ELIMINATE EFFORT, MAKES CONSOLIDATION OF WORKSHEETS EASIER
LOKE YIM PENG, DSTA
|
Learned some new shortcuts when using Pivot table, ie. format of cell, layout of the columns and rows. Also learned new skills ie. Pivot Chart, which can actually be easily generated from a click.
Catherine Chng
|
There may be a new solution for me to consolidate data from multiple excel files using the MS query. I am currently using macro to automate the consolidation and any new addition/amendment to the new fields will required me to maintain the macro. From the course, MS query may be able to meet the same requirement, if not better, and it should be much easier to add/amend data field into the consolidated data.
oon boon eng, DSTA/CPD/BSIC
|
I am new to Biz Planning. As such, every tool seems useful to me and internalized only upon actual usage in day to day business.
Matthew Leong
|
I do creation of monthly management reports with EXcel and many other reports . After attending the 1.5 days course , I could apply what I have learnt to my reports as it will save the time after learning all the functions etc.
Sumarne Sumamaili
|
The pivot table is very useful in cross referencing of data which is important in my area of work.. The dynamic feature ensures that the reports that I generated will be the most updated.
Phua Kian Chye, Institute of Education
|
Constant chart update as my line of work requires ad-hoc, monthly and quarterly reporting to higher management and timeliness of reporting is crucial.
Lee Jew Jeow
|
The course has taught me how to present my training data in a nicer way using Pivot Table. Previously I would create individual table for my training data when i need them. But using Pivot Table I can create all the tables and choose the table I want to present.
Mohamad Raffi Bin Mohamad, Ministry of Home Affairs
|
The 'Business Analysis with Excel' course has illustrated the use of the various functions of excel in the practical sense, allowing us to comprehend and appreciate the use of this tool in getting our day-to-day tasks done in a more efficient manner.
Katharine Ong, Ministry of Manpower
|
Real case examples was given to practise on the formulas that were taught in the course, which make it more comprehensive of how it can be applicable in our work course.
Ng Swee Eng, Prefer not to disclose
|
A lot of the formulaes taught in this course is very useful and very applicable in our everyday course of data crunching. The solver application introduced in the course was something new and will be very useful too
Foo Le Ping
|
Use of MID & concatenate function to extract & merge text
Yap Kok Phun, Prefer not to disclose
|
Short Cut, Vlookout, pivot table, chart. All these has benefited me and would save me numerous of hours. Even though have not, done it yet.
Shirley Lee, Prefer not to disclose
|
Better knowledge on Pivot Table/Chart and shortcuts keys. For e.g, instead of pressing the End and arrow key, normally I'll scroll to the end of the data. After learning the shortcut, it has cut down the time. As for the pivot table, instead of sorting or summing the data in the pivot table, normally I'll paste special the pivot data into another worksheet and begin the sorting and summing.
Lim Pei Ching, Prefer not to disclose
|
Learned new functions like using MS query to present reports, how to go to end of data. Gained better insight on vlookup usage.
Maliga Murosamy, Prefer not to disclose
|
Instead of manually checking which half of the month the payment falls into during Qtr 4 of the FY, I have learnt how to use a combination of DAY, DATE, MONTH and YEAR formula to achieve various information required.
Lee Suet Mui, Prefer not to disclose
|
Subtotal value to be extracted using F5. In the past used to copy & paste special (values) all subtotal value. Time saved on the extra work.
Vivian Choy, Prefer not to disclose
|
The Go To function is GREAT, especially the visible cells selection. I have been highlighting each subtotal row to do formatting, which can be time consuming when the data is huge. With this function, it really save a lot of time.
Chew Leng Khim
|
Visible cells under the GO TO function had helped to reduce time in copying and shading of cells. Very good. Implemented straight away. Trim functions and number that represents adding, subtraction, multiplication etc in a formula, better understand the meaning of the numbers
tan poh sung, Prefer not to disclose
|
MS Query in Pivot Tables and Pivot Charts are very useful and benefited to me. Last time i used to do the data base query in MS Access, but now with this powerful ad-hoc query tool, it save up 30% time savings.
chong mee nyuk, Prefer not to disclose
|
With no formal Excel training, I'm not aware of shortcuts and more efficient methods of accomplishing the req'd analysis and data extraction. The course is an eye opener to the capabilities of Excel and unleashed new ways and methods I can use to achieve more.
Ma Fook Loong, Prefer not to disclose
|
Learnt on how to extract duplicate record, filter off duplicate records that's not required.
Tracy Huang, Prefer not to disclose
|
The course has helped to solve the categorisation / grouping of the data so as to generate the report to meet specific requirement, eg. by FY that starts from 1 Apr of the year. The benefit is time saving and error reduction.
Loo Peng Kwun, Prefer not to disclose
|
Learning how to make use of F5, Ctrl-Enter really speeds up the processing time of using spreadsheets (in addition to the formulas, pivot table, MS query). Previously, manual methods were used and precious time was taken up manipulating the info when I could have made use to do other stuff.
Ooi Leng Leng, Prefer not to disclose
|
its gives me a better view of understanding excel formula easier. and identifying other colleagues problem which could be applied to my work.
LEE ANDREW, Prefer not to disclose
|
I am required to perform different computations on a data set to measure the timely completion of activities. The course has taught me new solutions which improves the accuracy of my computations, and reduces the time needed.
Low Wen Ee, Prefer not to disclose
|
Learned several new formula and functions in excel. Possibly able to apply to the spreadsheets currently in use. Else can definitely be a good tool to posses for future use.
Ee Wei-Kang Nicholas
|
I can use the Vlookup function. And as I missed the 2nd lesson because of medical leave, I did not have the opportunity to go through all the case studies.
Lee Cheng Tiong, Prefer not to disclose
|
Learning of sorting function in a pivot table. Previously, the pivot table are copied to another sheet to perform the sorting. Now, with the tips learnt during the course, it is definitely more efficient and time-saving to use Excel in daily data management. This course really provide me with the insight of functions and pivot table in Excel.
Tay Yew Hion
|
On how to use the MS Query in Pivot Tables. I can use this technique to import data from MS Access directly into excel. This is especially useful if the number of rows of data in Access exceeds the maximum number of rows in excel.
Lian Si Chin, Prefer not to disclose
|
This course introduced data management techniques are very useful in my work, which involves management reporting of industry adoption.
Tan Yan Wei, Prefer not to disclose
|
Jason has given a good insight into the usefulness of using pivot table to present data. He has also value-added to the course by demonstrating how Excel can be used to present the BSC Dashboard information.
Winnie Lim
|
The delimited and sumif function is informative. However, I am interested in extracting data from PDF file to excel.
Koh Bee Leng, Prefer not to disclose
|
using pivot table, hopefully i can reduce my time to do a summary report and presentation in the future.
tan guo hao,allan, Prefer not to disclose
|
I have learnt to create pivort tables and use functions like vlookup to develop quick solutions in presenting data in the format I need by drawing data from various databases. In addition, I have learnt shortcut keys when working on EXCEL.
Jean Gwee
|
Excel is a powerful software whereby numerous data can be captured in the worksheet. I learn some of the short cuts such as copy & paste functions. I hope to improve and shorten the process in due time whenever I do my work.
Annie Choy, Prefer not to disclose
|
No specific problems, but being exposed to the many formulas certainly helped! I have not tried using pivot tables before so I'm sure this skill will come in handy.
Glenn Yeo
|
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.
Annabelle
|
Problem: Filtering a large amount of PES data. Benefits: Time saving, knowing a lot of different shortcuts and solutions to tackle a problem, merging different worksheets into one main worksheet and the pivot table for statistical usage.
Ong Annie, Prefer not to disclose
|
Ability to create a macro which formats cells so I need not waste time repeating the steps over and over again while working with data.
Anita Solomon, Prefer not to disclose
|
This course has enable me to manage and retrieve information from multiple data files and create meaningful tables and charts
Lee Ker Peng
|
discovered the power of pivot tables and charts, thereby allowing me to chart very quickly. having sent 2 of my other staff, i can now know what they can do to extract data and better design forms for feedback survey after each talk or event.
HO SUN YEE, SINGAPORE HEART FOUNDATION
|
The MSQuery function would definitely help to reduce time collating data from different sources with different formats that changes constantly. PivotTable has helped me to do graphs more quickly by using the readily available data. Jason's cause delivery is very simple and easy to digest. He never stops sharing useful tips that could make everyone's life easier. Course materials provided are very useful and easy to understand. Much better than the book Excel for Dummies.. Thks Jason
Rosemaniah Jamalludin
|
Ive learnt a new way of keeping my database neat and a shorter way of getting the data well organised by using pivot table.
Nurhidayah, WDA
|
Pivot table to extract information from raw data for weekly report on new cases. Also, tips on some fx formulas that I make use in my course of work.
Judy Lee, WDA
|
I have learn that the vlookup and pivot table can save me lots of time instead of manually counting the numbers from the file in doing my statistic of our staff performance. Have also learn new features which will enable me to set new targets
Romy Faizal, WDA
|
To find the trends (age, gender, edu levels, barriers, etc) for the Long Term Unemployed (LTU) data. Using a pivot table to do a detailed report to find out what are some of the trends or barriers etc.
Ho Sok Yee, WDA
|
The training on the use of pivot table course has been most useful. With this knowledge, I can now proceed with the re-arrangement of data in my current worksheets knowing very well that I will be able to extract useful information with less hassle.
Minna Foo
|
Able to sort data using subtotal and pivot, knowing how to fill up the fields and analysing it in clean and neat manner.
Lee Hsui Jane, WDA
|
I use a lot of pivot table in my work and knowing functions and shortcuts in Excel would be able to help me save time in doing reports.
Sakinah Ishak, WDA
|
