Basic Excel Training

Topic 1 Getting Started with Excel

• Explore Excel user interface
• Manage Worksheets
• Manage Rows and Columns
• Manage Data

Topic 2 Basic Data Analysis using Excel

• Overview of Formulas and Functions
• Use IF functions to analyse data
• Use Lookup and Reference functions to extract data
• Aggregate functions - COUNTIF, AVERAGEIF, SUMIF

Topic 3 Basic Data Visualisation using Excel

• Create chart
• Basic chart types
• Format chart elements
• Other chart types - Treemap, Sunburst, Histogram, Pareto, Box plot, and Waterfall charts

Promo or discount cannot be applied to WSQ courses

Prerequisite

The learner must meet the minimum requirement below :

• At least O levels and above education
• Read, write, speak and understand English

Mode of Training

Instructor Classroom Training

WSQ Funding Validity Period

13 Dec 2021 - 13 Dec 2023

WSQ Course Fee Funding

Self-Sponsored

• Click here for more info on the funding for self-sponsored.
• Eligible Singapore Citizens can use their SkillsFuture Credit and PSEA funds to offset course fee payable after funding.

Employer-Sponsored

• Click here for more info on the funding for employer-sponsored.
• Absentee Payroll claimable by SMEs: Up to 80%of hourly basic salary capped at $7.50/hr
• Absentee Payroll claimable by Non-SMEs: Up to 80% of hourly basic salary capped at $4.50/hr

WSQ Assessment

• Participants will be assessed through individual assessment
• Passing Criteria – Participants are to answer all questions accurately in the individual written assessment.
• Participants may need to attend additional coaching sessions and re-assessments if they do not pass the required competency standards. 

• Data Analyst
• Business Analyst
• Financial Analyst
• Operations Manager
• Marketing Analyst
• HR Metrics Specialist
• Sales Operations Specialist
• Report Developer
• Project Manager
• Management Accountant
• Product Manager
• Supply Chain Analyst
• Performance Metrics Specialist
• Market Researcher
• Business Intelligence Coordinator

Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations.

Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.

Liew Sing Loon: Liew Sing Loon is a ACTA certified trainer. Liew Sing Loon graduated from the National University of Singapore (NUS) in 1992 with a Second Upper Honors Degree in Electrical Engineering. He started his career as an Electronic Product Design Engineer for four years in a Multinational Company which sell the products worldwide. The job provided him practical knowledge in various aspects of manufacturing operations ranges from Design, Quality, Production and Procurement. He then spent fifteen years in Information Technology Sector as a Key Account Manager in selling IT solutions to Banking, Telecommunications and Government clients. The job provided him the opportunities to propose IT solutions, integrating software, hardware and services, to solve customers’ problems to achieve their strategic business objectives. He joint a German Product Test company to develop its business in providing product Safety, Immunity, Electromagnetic Compatibility (EMC) Certification test. While working in the industry, Liew Sing Loon obtained a Master of Science (MSc) in Technology Management from NUS.

In the last decade, Liew Sing Loon has been Adjunct Lecturer in several Institutes of high learning, transferring his knowledge on Quantitative & Statistical Analysis, Operations, Project & Quality Management to learners ranging from Diploma, full time undergraduates and working adults.Liew Sing Loon has a Certificate of Completion in Education Psychology Course and Teaching & Learning in Higher Education Program conducted by National Institute of Education (NIE).

Dwight Nuwan Fonseka: Dwight Nuwan Fonseka is a ACLP certified trainer. He have a degree in Biotechnology from NUS, Advanced diploma in Pharmaceutical management from MDIS and Masters in Education from NTU. He have 8 years experience of teaching biology at O and A levels/ IB level in international schools in Singapore and overseas.