COURSE INFORMATION

COURSE DESCRIPTION

This programme is designed to equip participants with fundamental Microsoft Excel skills for effective data management, reporting, and visual presentation of information. Participants will learn how to structure and organise data, apply essential formulas, and develop clear charts for workplace communication.

The 2-day format is structured to maximise learning transfer. After Day 1, participants will complete an individual assignment based on practical workplace tasks. During Day 2, participants will review their assignment, receive trainer feedback, and strengthen their understanding through advanced practice and discussion.

This approach supports stronger retention, immediate workplace application, and measurable skill improvement.

TARGET PARTICIPANTS

This programme is suitable for:

·       Administrative staff

·       Executives and officers

·       Supervisors and coordinators

·       HR, finance, sales, and operations staff

·       Employees responsible for reporting or spreadsheet tasks

·       Individuals seeking structured Excel foundation skills

LEARNING OBJECTIVES

Upon completion of this programme, participants will be able to:

·       Understand core principles of data management using Excel

·       Organise and maintain accurate workplace datasets

·       Apply basic formulas and functions confidently

·       Create professional charts and visual reports

·       Complete a practical assignment using learned skills

·       Improve workplace productivity through better spreadsheet practices

ENTRY REQUIREMENTS/ PRE-REQUISITES (IF APPLICABLE)

·       Basic computer literacy

·       Familiarity with keyboard and mouse usage

·       No advanced Excel experience required

EXPECTED BENEFITS TO ORGANISATION

·       Improved quality and consistency of reports

·       Reduced spreadsheet errors and rework

·       Faster completion of data tasks

·       Better visual communication of information

·       Increased staff confidence and digital productivity

·       Stronger learning transfer through assignment-based application

LEARNING OUTCOMES

At the end of the programme, participants will be able to demonstrate:

·       Knowledge

o   Understanding of structured data entry, formulas, and charting fundamentals

·       Skills

o   Ability to manage data, perform calculations, and visualise information effectively

·       Workplace Application

o   Capability to apply Excel skills to real reporting and operational tasks

MODULE BREAKDOWN

Day 1 – Core Foundations

 Module 1: Introduction to Excel and Data Management

·       Excel interface and navigation

·       Workbooks, worksheets, rows, columns, cells

·       File management and best practices

Module 2: Organising and Managing Data

·       Proper data entry methods

·       Formatting cells and tables

·       Sorting and filtering data

·       Basic data cleaning techniques

Module 3: Essential Formulas and Functions

·       Basic formulas and operators

·       SUM, AVERAGE, COUNT

·       MIN, MAX

·       Relative vs absolute references

Module 4: Fundamentals of Data Visualisation

·       Types of charts and their uses

·       Creating bar, column, line, and pie charts

·       Formatting charts professionally

Assignment Briefing (End of Day 1)

Participants will receive an individual assignment to be completed before Day 2.

Individual Assignment (Between Day 1 & Day 2)

Participants will complete a structured task using a sample dataset or their own workplace data (where suitable).

Assignment Scope

Participants are required to:

·       Clean and organise a dataset

·       Apply formulas for calculations

·       Sort and filter information

·       Create at least one chart

·       Prepare a simple summary report

Submission Method

·       Softcopy before Day 2, or

·       Bring completed file during Day 2

Day 2 – Reinforcement & Practical Application

 Module 5: Assignment Review and Discussion

·       Participant sharing session

·       Review of common mistakes

·       Trainer feedback and improvements

Module 6: Enhancing Reports and Presentation

·       Improving worksheet layout

·       Formatting reports professionally

·       Tips for readability and clarity

Module 7: Practical Case Study

·       Realistic workplace scenario

·       Guided completion task

·       Independent practice

Module 8: Consolidation, Assessment & Q&A

·       Knowledge review

·       Final practical assessment

·       Questions and workplace application discussion

TRAINING METHODOLOGY

The programme will be delivered using a combination of:

·       Instructor-led explanation

·       Live demonstrations

·       Guided hands-on practice

·       Individual assignment

·       Case study exercises

·       Feedback and coaching sessions

Learning Mix: 30% Theory / 70% Practical & Applied Learning

ASSESSMENT/ EVALUATION METHOD

Participants will be assessed through:

·       Post training reflection or assessment

·       Day 1 practical exercises

·       Individual assignment completion

·       Day 2 case study task

·       Trainer observation and feedback

·       Final knowledge review / short assessment

PROGRAMME DURATION SUMMARY

Total Training Hours: 14 hours

·       Theory: 30%

·       Practical/ Hands-on: 55%

·       Assignment & Review: 15%