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.
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
Pre-requisite
Certification
LOPTERRA means Leveraging On Professional World. We aim to continuously partner with businesses by rendering professional services that gives your business the needed boost for growth through the provision of professional & skills development training, Occupational health and medical surveillance services and Human Resources services across Sub Saharan Africa.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy