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

HRD Corp Claimable Course for Employers Registered with HRD Corp

Course Code: M1305

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