MS Excel Basic Training for the Workplace

MS Excel Basic provides employees with the practical foundation they need to work confidently and accurately with spreadsheets in everyday business activities.

This one-day, instructor-led course is designed for beginners, occasional Excel users and self-taught employees who may know parts of Excel but have gaps in their fundamental skills.

The emphasis is on practical workplace capability — entering and organising information, creating formulas, formatting worksheets, working with basic functions, sorting and filtering information, creating charts and preparing spreadsheets for printing.

College Africa Group delivers MS Excel Basic training for corporate teams throughout South Africa through onsite and instructor-led virtual training.

Not sure whether your employees need Basic, Intermediate or Advanced Excel?
Start with the Excel Skills Assessment.

Who Should Attend MS Excel Basic?

MS Excel Basic is suitable for employees who need a structured foundation before progressing to more advanced Excel work.

Typical delegates include:

• Administrative employees
• HR and payroll support staff
• Finance and accounts support staff
• Operations employees
• Project administrators
• Sales support staff
• Personal and executive assistants
• Employees who use spreadsheets occasionally
• Self-taught Excel users with gaps in their knowledge
• Employees preparing to progress to Intermediate Excel

Basic computer literacy is recommended. No previous formal Excel training is required.

Assess Excel Skills Before Choosing a Course

Employees often describe themselves as beginner, intermediate or advanced based on how long they have used Excel. That does not always reflect their actual capability.

Someone may use Excel every day but still struggle with formulas, sorting, filtering, worksheet structure or basic spreadsheet accuracy.

College Africa Group therefore recommends assessing existing capability where an organisation has employees with mixed Excel skill levels.

The Excel Skills Assessment can help indicate whether an employee should strengthen their Basic Excel foundation or may be ready for higher-level training.

Do you have employees with different Excel skill levels?
Tell us about your team and we can help determine the appropriate training pathway.

MS Excel Basic Course Objectives

By the end of the MS Excel Basic course, delegates should be able to:

• Navigate confidently within Excel worksheets and workbooks
• Enter, edit and organise spreadsheet information
• Create and save Excel workbooks correctly
• Use AutoFill and other productivity features
• Create simple formulas and calculations
• Use common Excel functions including SUM
• Format numbers, text, cells, rows and columns
• Apply borders, colours and alignment
• Sort and filter basic business information
• Create simple charts
• Prepare worksheets for printing
• Develop cleaner and more professional spreadsheets

MS Excel Basic Course Content

The course provides a structured introduction to the core Excel skills employees need for everyday workplace spreadsheets.

Download the complete MS Excel Basic course outline:

MS Excel Basic – Table of Contents PDF

1. Introduction to Excel

• Introduction to spreadsheets
• The Excel screen
• Navigating within a worksheet
• Workbook views
• Working with Excel Help
• Creating a new workbook
• Opening and saving workbooks

2. Entering and Editing Data

• Entering information into Excel
• Editing and deleting data
• AutoComplete and AutoFill
• Working with blocks of cells
• Moving and copying information
• Working with the Office Clipboard

3. Rows, Columns and Worksheet Layout

• Adjusting column width
• Adjusting row height
• Inserting and deleting rows and columns
• Formatting cells
• Working with cell styles
• Using Format Painter

4. Basic Excel Formulas and Functions

• Understanding formulas
• Mathematical rules
• Creating a custom formula
• Using the SUM function
• Using AutoSum
• Working with common functions
• Accessing built-in Excel functions

5. Formatting Worksheets

• Changing fonts and font sizes
• Cell borders and colours
• Aligning cell data
• Indenting text
• Rotating text
• Wrapping text within cells
• Formatting numbers
• Applying design and formatting attributes

6. Charts

• Creating a chart
• Understanding chart objects
• Moving and sizing charts
• Editing chart elements
• Formatting chart text and numbers
• Printing charts

7. Printing and Page Setup

• Previewing a workbook before printing
• Changing margins
• Setting the print area
• Page breaks
• Print titles
• Scaling worksheets
• Headers and footers
• Printing worksheets

Are employees struggling with everyday spreadsheets, formulas or basic reporting?
Tell us what they are trying to do in Excel.

Practical Workplace Application of Basic Excel

The purpose of MS Excel Basic training is not simply to learn where Excel buttons are located. Employees need to be able to apply the fundamentals to real workplace activities.

Typical Basic Excel applications include:

• Simple attendance registers
• Employee lists
• Basic expense tracking
• Stock or inventory lists
• Administrative schedules
• Simple reporting worksheets
• Customer and supplier lists
• Basic totals and calculations
• Creating simple charts for reports
• Preparing clean worksheets for printing or distribution

For example, an employee may take a manually maintained attendance list and convert it into a structured Excel register with consistent formatting, automated totals and information ready for management or HR reporting.

MS Excel Basic Training for Corporate Teams

College Africa Group specialises in corporate Excel training rather than mass-market individual courses.

Training can be delivered to departments or groups of employees who need a common Excel foundation before progressing into more advanced spreadsheet work.

Where appropriate, facilitators can discuss examples of the types of spreadsheets employees work with and relate the principles being taught to realistic workplace situations.

This means the training can feel closer to practical workplace support than simply completing a generic Excel course.

Want employees to become more confident with the spreadsheets they already use at work?
Tell us where your team is currently struggling.

One-Day MS Excel Basic Course

Duration: One day

Typical training time: 09:00 to approximately 15:30

Delivery: Onsite or instructor-led virtual training

Level: Beginner / foundation

Requirements: Basic computer literacy and access to Microsoft Excel

Materials: Training manual and practical exercises

Certificate: Electronic attendance certificate

Progress From Basic to Intermediate and Advanced Excel

MS Excel Basic is the foundation of the College Africa Group Excel learning pathway.

Employees who have mastered the Basic level can progress to:

• Excel Intermediate
• Advanced Excel
• Advanced Excel analysis and reporting
• Modern Excel functionality
• Power Query and data transformation
• Excel dashboards and reporting
• Excel consulting and automation where training alone is not the solution

The broader CAG approach is:

Assess capability → train at the appropriate level → apply the skills to workplace Excel → progress into Advanced Excel or consulting where required.

Do employees already have the basics and need to progress further?
View the Excel Intermediate course.

When Excel Training Alone Is Not the Answer

Not every Excel problem is a training problem.

Employees may already understand Excel but still spend excessive time updating repetitive reports, copying information between worksheets, maintaining inefficient spreadsheets or performing recurring manual processes.

In these situations, additional training may not be the most effective intervention.

College Africa Group can separately assess whether the requirement is better addressed through higher-level Excel capability, spreadsheet improvement, consulting or automation.

Is repetitive Excel work the problem rather than employee skills?
Talk to us about Excel consulting and automation.

MS Excel Basic Training Across South Africa

College Africa Group provides corporate Excel training throughout South Africa and Southern Africa.

Training options include:

• Onsite corporate training
• Instructor-led virtual training
• Departmental Excel training
• Training for employees with similar capability levels
• Progressive Basic, Intermediate and Advanced Excel programmes

Training schedules can be discussed according to the organisation’s requirements and operational availability.

Planning Excel training for a corporate team?
Send us your team size, current skill levels and training objectives.

Corporate Excel Pricing

Corporate pricing depends on factors such as delegate numbers, delivery format, training location and the required programme structure.

For current corporate training pricing information and volume options, see our
Corporate Training Offers & Volume Discounts.

Why Choose College Africa Group for MS Excel Basic?

• Corporate training experience since 2003
• Practical workplace-focused Excel training
• Basic, Intermediate and Advanced Excel pathways
• Excel Skills Assessment available before training
• Onsite and instructor-led virtual delivery
• Practical exercises and supporting course material
• Electronic attendance certificates
• Email support relating to material trained
• Advanced Excel, consulting and automation support where required

Frequently Asked Questions – MS Excel Basic

Who is MS Excel Basic suitable for?

The course is designed for beginners, occasional Excel users and self-taught employees who need a stronger and more structured foundation in Excel.

How do we know whether an employee needs Basic or Intermediate Excel?

Employees can complete the Excel Skills Assessment to help indicate whether they should strengthen their Basic Excel foundation or may be ready for higher-level training.

How long is the MS Excel Basic course?

The programme is one full day, typically from approximately 09:00 to 15:30.

What does MS Excel Basic cover?

The course covers workbook navigation, data entry, editing, formatting, basic formulas and functions, AutoSum, charts, worksheet layout, printing and other fundamental Excel skills.

Does the course include practical exercises?

Yes. The training includes practical exercises that delegates can retain for further practice after the course.

Do delegates receive a certificate?

Yes. Delegates receive an electronic attendance certificate after completing the course.

Can MS Excel Basic be delivered onsite?

Yes. College Africa Group provides onsite corporate Excel training as well as instructor-led virtual delivery.

Can employees progress to higher Excel levels?

Yes. The Basic course prepares employees for Excel Intermediate and then Advanced Excel training.

Can you help if training alone will not solve our Excel problem?

Yes. Where the issue relates to inefficient spreadsheets, repetitive reporting or more complex Excel requirements, College Africa Group can separately assess whether Advanced Excel, consulting or automation would be more appropriate.

Enquire About MS Excel Basic Training

Tell us your number of employees, current Excel skill levels, preferred delivery method and training objectives.

Ready to discuss MS Excel Basic training for your employees?
Contact College Africa Group about your training requirements.

Arnold Muscat: 083 778 4903
Email: sales@collegeafricagroup.com

MS Excel Basic prepares delegates to progress to
Excel Intermediate
and higher-level Excel programmes.

Delegates receive training material and an electronic attendance certificate after completing the course.

For corporate pricing, group training and volume requirements, visit our
Corporate Training Offers & Volume Discounts
page.

Useful Excel Resources

College Africa Group Excel Video Tips

ExcelTips

Chandoo