Course Description // Excel is essential skill set required by many companies, from small organisation to large co operations. It is of utmost importance that users are able to manage data – statistics, planning, reporting efficiently. In this 1 day course – you will be learning the basic fundamentals to more advanced features of Microsoft Excel

Course Duration // 1 day

Prerequisite // Have basic knowledge of Microsoft Excel (not for beginners)

Target Audience // This course is ideal for anyone who needs to maintain data within spreadsheet, be it accounts, customer information, Sales and Marketing, Administration, Procurement, Human Resource, Business Development and Engineering

Learning Objectives // Upon Completion of this course, students will be able to
•Easily organise data in multiple worksheets
•Understand the fundamentals of Microsoft Excel formulas.
•Output final report on paper and PDF.
•Personalise Excel to suit your preferred working approach.
•Create complex formula to handle challenging tasks.
•Articulate the fundamental types of data and ways in handling them.
•Set a control to keep invalid data at bay.
•Automate cell styles whenever the data changes.

Methodology // 70% practical hands-on sessions and 30% theory. Students will have mastered with confidence on subject matter, to be able to independently pursue subject matter by the end of class