24hrs – ICDL Perform Advanced Spreadsheet Functions (Excel Advanced)
24hrs – ICDL Perform Advanced Spreadsheet Functions (Excel Advanced) is a highly funded WSQ SkillsFuture approved course. It is highly recommended for those who want to leverage on the Advanced functions and features to improve productivity in your daily work activities.
During the course, you will get to how to use advanced functions such as complex formula writing, inserting and editing functions, defining names, tracing formulas, and diagnosing errors.
You will be able to:
- Use advanced formatting, formulae and charts features to enhance a spreadsheet
- Analyse, validate and audit data in a spreadsheet
- Use advanced spreadsheet functions to enhance productivity
- Manage collaborative editing to a spreadsheet
In completion of this course, participants may think of learn more on Macros and programming in Excel by attending 3 days of Visual Basic for Applications in Microsoft Excel – Fundamentals.