This course is also know as Business Analysis with Excel.
In-House sessions are available upon request.
Upon completion of the course, participants will be able to:
- Apply useful built-in functions in Excel to process data and enhance the usefulness of the data.
- Apply the function learnt to consolidate records.
- Acquire skills to analyse the records for operations and reporting purposes.
- Employ new ways of tabulating and managing data.
Who Should Attend:
Managers and Executives who have to manage, analyse and prepare reports using data downloaded from systems. They must have some basic to intermediate knowledge of Excel i.e. navigate around a worksheet, format cells, auto-filter, sorting, create a simple template and enter simple formulas (e.g. SUM) into the worksheet.
“I have always been clueless about the power of Excel, doing many things the manual way like counting amount in cells and doing manual layouts. To me, Excel has always been just another program i layout my reports with. But after attending this Excel course, i realise that there is so much more power stored in Excel to help enhance and make efficient daily work reports that i have to do especially with ensuring accurate details in figures in big amounts. Im sure as i continue to explore what has been taught, i will be able to save a lot more time and stop pulling my hair out while i face my reports again.” – Rachel Low, Trade Marketing Executive, Johnson and Johnson Vision Care SG
“The lessons and pointers provided can be applied in actual situations at work. This helps to save time and enables us to work smart and more efficiently. E.g. Formulas/functions that were not obvious to me previously now make a lot of sense, and i can easily sift out unrequired information (using pivot table) to make my tables look more cleaned up and presentable.” – Adeline Yap, Citibank Singapore
“Learnt many new formulas which are able to help me re-define those conventional and complicated ones that im currently using.” – Tang Ee Koon Catherine, Defence Science & Technology Agency