Certificate in Microsoft Excel

Microsoft Excel provides learners with practical knowledge and skills for creating, organising, analysing and presenting data using Microsoft Excel. The programme covers workbook and worksheet management, data entry and formatting, formulas and functions, tables, sorting and filtering, charts, data validation, conditional formatting and basic data analysis. Learners will also develop skills in using Excel to prepare reports, budgets, schedules, calculations and business documents, with emphasis on accuracy, efficiency and effective data management.

Skills Covered

• Excel interface and workbook navigation
• Workbook and worksheet management
• Data entry and editing
• Cell formatting and styles
• Rows, columns and ranges
• Basic formulas and calculations
• Common Excel functions
• Relative and absolute cell references
• Tables and structured data
• Sorting and filtering
• Conditional formatting
• Data validation
• Charts and visualisation
• Page layout and printing
• Basic data analysis
• Spreadsheet organisation
• Error checking and formula auditing
• Basic reporting
• File management and sharing
• Spreadsheet best practices

Why Join This Programme?

• Develop essential spreadsheet skills for academic and professional environments.
• Learn how to organise, calculate and analyse data efficiently.
• Build confidence in using formulas and common Excel functions.
• Learn to create professional tables, reports and charts.
• Develop practical skills for budgets, schedules, records and business analysis.
• Improve accuracy and efficiency when working with structured data.
• Learn techniques for presenting information clearly and professionally.
• Build a valuable digital productivity skill applicable across a wide range of industries.

Course Objectives

The objectives of this programme are to:

1. Introduce the Microsoft Excel interface and fundamental spreadsheet concepts.
2. Develop skills in creating, organising and managing workbooks and worksheets.
3. Explain effective methods for entering, editing and formatting spreadsheet data.
4. Develop understanding of formulas, functions and cell references.
5. Introduce tables, sorting, filtering and other data-management features.
6. Develop skills in presenting data using charts and visual formatting.
7. Explain the use of data validation and conditional formatting.
8. Introduce basic techniques for analysing and reporting spreadsheet data.
9. Develop good practices for spreadsheet accuracy, organisation and file management.
10. Promote efficient and professional use of Microsoft Excel for workplace and academic tasks.

Learning Outcomes

Upon successful completion of the programme, learners should be able to:

• Navigate the Microsoft Excel interface and workbooks.
• Create, save, organise and manage Excel workbooks.
• Create and format worksheets for different purposes.
• Enter, edit and organise structured data accurately.
• Apply appropriate cell, number and text formatting.
• Create basic formulas for calculations.
• Use common Excel functions for data processing.
• Apply relative and absolute cell references appropriately.
• Create and manage tables for structured datasets.
• Sort and filter data according to specified criteria.
• Apply conditional formatting to highlight relevant information.
• Use data validation to control and improve data entry.
• Create appropriate charts to present numerical information.
• Perform basic calculations and data analysis.
• Prepare spreadsheets for printing and professional presentation.
• Identify and correct basic formula or data-entry errors.
• Organise spreadsheet information for reports, budgets, schedules and records.
• Apply appropriate spreadsheet management and file-handling practices.
• Present data clearly using suitable tables, formulas and visualisations.
• Demonstrate efficient, accurate and professional use of Microsoft Excel.