Mode of Training
E-Learning and Classroom
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.
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
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
Excel Conditional Formatting Using Formulae
Business Plans with Excel
Personal Budgeting with Excel
Compiling customer orders and data
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.
Johannesburg, Cape Town, Durban, Lagos & Accra
Booking and Registration
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