Description

Duration: 2 Days

Course Overview:

The Microsoft Excel Beginner programme is designed to equip participants with essential spreadsheet and data management skills required in today’s digital workplace. As Microsoft Excel remains one of the most widely used productivity tools across industries, this programme provides foundational competencies in data entry, formatting, calculations, reporting, and visualization to improve operational efficiency and workplace productivity.

 

This programme delivers practical, hands-on exposure to Microsoft Excel functions commonly used in administrative, operational, finance, sales, human resource, logistics, education, and business support environments. Participants will learn how to organize and manage data systematically, perform basic calculations using formulas and functions, and generate simple charts and reports for decision-making purposes.

 

Course Objective:

By the end of this course, participants will be able to:

1. Navigate Excel’s interface and understand its basic functionalities.
2. Perform data entry, formatting, and simple calculations.
3. Apply basic formulas and functions for calculations and analysis.
4. Organize data using sorting and filtering techniques.
5. Create and modify basic charts for data visualization.
6. Use keyboard shortcuts and formatting tools to improve efficiency.

 

Methodology:

• Interactive demonstrations
• Hands-on practical exercises
• Group design challenges
• Peer reviews and feedback sessions
• Guided walkthroughs and live design critiques

 

Course Outline:

Module 1: Getting Started with Excel

• Overview of the Excel interface, ribbons, and toolbars.
• Understanding workbooks, worksheets, columns, and rows.
• Data entry and basic editing techniques (copy, cut, paste, undo, redo).
• Formatting cells: font styles, colors, and alignment.

 

Hands-on Practice:

• Create, edit, and format a simple Excel spreadsheet.
• Practice navigating between worksheets and adjusting column/row sizes.

 

Module 2: Basic Data Handling & Formatting

• Introduction to data organization: sorting and filtering basics.
• Using Freeze Panes for easier navigation.
• Setting Print Area and adjusting page layout for reports.
• Applying number formats (currency, percentage, date/time).

 

Hands-on Practice:

• Organize a dataset by sorting and filtering values.
• Adjust page layout settings for proper print formatting.

 

Module 3: Essential Formulas & Functions

• Understanding cell references (absolute vs. relative).
• Basic mathematical formulas: SUM, AVERAGE, COUNT.
• Introduction to logical functions: IF function.
• Using basic text functions (LEFT, RIGHT, CONCATENATE).

  

Hands-on Practice:

• Apply SUM, AVERAGE, and COUNT functions to a dataset.
• Use the IF function for basic conditional calculations.

 

Module 4: Data Visualization & Simple Reporting

• Creating basic charts: bar charts, line charts, and pie charts.
• Modifying chart styles and layouts for better visualization.
• Introduction to basic tables and structured references.
• Recap of essential Excel shortcuts for efficiency.

 

Hands-on Practice:

• Create and modify a simple chart based on sample data.
• Apply basic table formatting for structured data presentation.

 

Final Q&A and Wrap-Up

• Review key takeaways from the course.
• Discuss best practices for using Excel efficiently.
• Provide additional resources for further learning.