Countif, relative and absolute cell reference - able now to extract pertinent information on donors and students when the need arises. Time savings estimated to be around 40%.
Jessie Lee, Katong School
|
The problem I am facing is how to use Excel efficiently and effectively. I use a lot of basic functions of Excel in my daily work, for example sorting data,matching. Sometimes I only do it mannually as I don't know all those short cuts and formulas. With the simple formulas I can sort the data and present it in a nicer way than before. I really think it is amazing.
Dong Li Jia, Lithan Genovate Pte Ltd
|
Various excel formulas, such as vlookup as well as the pivot table. Yes, it certainly saves time with good use of the functions and formulas in Excel.
Eunice , NTU
|
I can separate and find the data I want more efficiently and faster. And I can use more functions to consolidate and shorten my formula.
Too Li Li, NTU
|
Converting to between Calendar years to Fiscal year and into quarters.
Chung Kok Wah, NYP
|
Able to use data from different sources. Many short cut available which I am not familiar with or have not use before.
Abdul Rahmat Bin Mordiffi, Prefer not to disclose
|
Gained insights with the function of merging data of two databases. Pivot charts and tables are also useful tools in presenting reports. These definitely will shorten the time in future when I consolidate database and generate reports. Helpful tips are given throughout the classes.
Soh Ee Lian, Prefer not to disclose
|
