JavaScript seems to be disabled in your browser.
You must have JavaScript enabled in your browser to utilize the functionality of this website.

Home
Basic Excel Training

Basic Excel Training

43 Review(s) | Add Your Review

Immerse yourself in the versatile world of Microsoft Excel, starting with an exploration of its user-friendly interface. Grasp the nuances of managing worksheets, rows, columns, and data for efficient data processing. As you delve deeper, you'll get acquainted with the power of formulas, IF functions for data analysis, and Lookup & Reference functions to extract crucial data swiftly.

The training also empowers participants with hands-on experience in harnessing the potential of aggregate functions such as COUNTIF, AVERAGEIF, and SUMIF. Additionally, charting is made simple with a step-by-step guide to creating various chart types, including specialized ones like Treemap, Sunburst, and Histogram. Learn to format and adapt these charts to present data effectively with our expert-led Basic Excel Training.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant Applications

No funding is available for this course.

For WSQ funding, please checkout the details at WSQ - Data Analytics with Excel

Course Code: C1304

Course Booking

The course fee listed below is before subsidy/grant, if applicable. We will apply for the grant and send you the invoice with nett fee.

$300.00 (GST-exclusive)

$327.00 (GST-inclusive)

Mode of Training *

Physical Classroom Training
Synchronised Teaching using ZOOM
Corporate Training at Company Premise

Course Date * Course Date

Course Time * Course Time: No. of Participants

Sponsorship

Self-Sponsored
Employer-Sponsored

Name(s) on Certificate

Additional Message or Emails for Course Notification

* Required Fields

Post-Course Support

We provide free consultation related to the subject matter after the course. Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts and get back to you asap.

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.

Course Details

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

Course Info

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.

Job Roles

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

Trainers

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.