Microsoft Excel Training

Mode of Training

E-Learning and Classroom

Course Overview

This course is intended for people who need to create and edit spreadsheets using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency.

Course Agenda

  • Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets

  • Demonstrate an understanding of the principles of spreadsheet

  • Definition of a spreadsheet

  • Function of a spreadsheet

  • Spreadsheet features

  • Types of spreadsheet

  • Microsoft Excel Window, Features and Use

  • Properties of a spreadsheet

  • Creating, Opening and saving spreadsheets

  • Cells, Values, Calculations, Real time updates

  • Data Cells, Formula cells and label cells

  • Producing spreadsheets from given specifications

  • Formulae

  • Excel Conditional Formatting Using Formulae

  • Business Plans with Excel

  • Personal Budgeting with Excel

  • Compiling customer orders and data

  • Editing Spreadsheets

  • Formating Spreadsheets

  • Checking Spelling and Grammer in Excel

  • Printing a spreadsheet using features specific to spreadsheets.

  • Excel hacks and shortcuts


The user should understand the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and start menu.


Delegates who successfully complete this course will recieve a certificate of completion.


2 days


Johannesburg, Cape Town, Durban, Lagos & Accra

Booking and Registration

Please email for a registration form and booking details or book now.

Do you wish to book up to or more than 4 delegates, consider an in-company course (Lopterra will deliver this course at your premises at an affordable rate). Please call us on +27 11 083 6811, +27 (0) 72 390 4560, +234 806 659 7728

See other courses below