Certificate in Microsoft Excel – Beginner Level

Microsoft Excel – Beginner Level provides learners with foundational knowledge and practical skills for creating, organising and working with spreadsheets using Microsoft Excel. The programme introduces the Excel interface, workbooks and worksheets, data entry, cell formatting, basic formulas and functions, rows and columns, simple tables, sorting and filtering, basic charts and worksheet management. Learners develop the ability to perform common spreadsheet tasks, organise information clearly and carry out basic calculations for personal, educational and workplace purposes.

Skills Covered

• Microsoft Excel interface and navigation
• Creating and managing workbooks
• Creating and organising worksheets
• Data entry and editing
• Cells, rows and columns
• Selecting and managing ranges
• Basic cell formatting
• Number, date and text formatting
• Basic formulas and calculations
• Common beginner-level functions
• Relative cell references
• Copying and filling formulas
• Creating basic tables
• Sorting and filtering data
• Basic charts and data visualisation
• Adjusting rows and columns
• Worksheet organisation
• Page layout and printing
• Basic error checking
• File saving and management

Why Join This Programme?

• Build a strong foundation in Microsoft Excel.
• Learn how to create and manage basic spreadsheets confidently.
• Develop practical skills in entering, organising and formatting data.
• Understand basic formulas and functions for everyday calculations.
• Learn how to sort, filter and present spreadsheet information.
• Develop introductory skills in creating charts and visual summaries.
• Improve efficiency when working with numerical and structured information.
• Establish a foundation for progression to intermediate and advanced Excel skills.

Course Objectives

The objectives of this programme are to:

1. Introduce the Microsoft Excel interface and basic spreadsheet concepts.
2. Develop practical skills in creating and managing workbooks and worksheets.
3. Familiarise learners with entering, editing and organising spreadsheet data.
4. Develop knowledge of basic cell, row, column and range management.
5. Introduce essential formatting techniques for clear spreadsheet presentation.
6. Develop an understanding of basic formulas, calculations and commonly used functions.
7. Introduce simple data-management features such as sorting and filtering.
8. Develop basic skills in creating charts and presenting spreadsheet information.
9. Introduce appropriate worksheet, file-management and printing practices.
10. Prepare learners to use Microsoft Excel confidently for routine personal, educational and workplace tasks.

Learning Outcomes

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

• Navigate the Microsoft Excel interface and identify commonly used tools.
• Create, save, open and manage Excel workbooks.
• Create, rename, organise and manage worksheets.
• Enter, edit and delete text, numbers and other basic data.
• Select and manage individual cells and ranges.
• Adjust row heights and column widths to improve worksheet presentation.
• Apply basic font, alignment, border and cell-formatting options.
• Apply appropriate number, date, currency and percentage formats.
• Create basic formulas using arithmetic operators.
• Use common beginner-level Excel functions for simple calculations.
• Understand and apply basic relative cell references.
• Copy and fill formulas across cells where appropriate.
• Create and format simple tables for organising information.
• Sort spreadsheet data using basic sorting options.
• Apply basic filters to display relevant information.
• Create simple charts to present spreadsheet data visually.
• Apply basic page-layout and printing settings.
• Identify and correct common data-entry or formula errors.
• Save and organise spreadsheet files using appropriate file-management practices.
• Use Excel to create clear and accurate spreadsheets for routine personal, educational or workplace requirements.