1) More Exposure On The Syntax And Semantics Of Using Macro In Excel. 2) How, When Macro-Recording Used Correctly Will Allow The Faster Development Of Complex Macro Codes.
Aw Chin Loon, NCS
|
Extracting and compiling data from large number of files into a single workbook for easy perusal.
Chiang Mei Yee, Life Technologies
|
Learn to use VLookup, Pivot Table and other essential functions.
Choo Seow Patt
|
The skills and tactics shared help shave off time spent during my pre-sales proposal preparation and also during the data analysis in my job.
Choy Yat Kin
|
Able to organise my data in excel more effectively in Pivot Chart and also gain more understanding in entering formula in excel.
Douglas Hoo Hean Ee, T-est Pte Ltd
|
I was having a hard time adding new rows into budget excel template, as it will has huge impact on the formulas, Jason went through extra miles to explain how to overcome that problem although that was not supposed to be covered in this course.
Felicia Cao, Littelfuse Far East Pte Ltd
|
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
|
This course really enlighten me a lot on various useful formula that i wasn't aware of before this course. Though in my field of work, I don't need to generate very extensive table to present but I do use excel to help sorting my test data to check results of my testing.
Law Poh Geok, NCS
|
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
|
Use of pivot table can help me manipulating data from survey conducted.
Maria Florinda Reyes, NCS Pte Ltd
|
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
|
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
|
Combination of function/feature e.g. remove duplicate, fill up the multiple cells with the same text other than the usual copy & paste. Substitute and many others. Pivot Table - if select the whole spreadsheet will not be able to perform grouping
Soh Wai Chee, Dover Park Hospice
|
Learnt the use of some features in excel in managing database, especially in using pivot table to extract data for presentation
Teo Kheng Hwa, NCs Pte Ltd
|
As a IT Presale which I work on cost sheet during the solution , it would help me to manipulate fast to show different figure when the solution changes.
Victor Sia, NCS PTE LTD
|
Learnt many new ways that Excel can be used in most of the ways that more advanced database systems are used
Goh Lian Teck
|
