Data Management and Entry Certificate Course

Learn About Being a Data Entry Clerk
4 Topics | 1 Quiz
Being a Data Entry Clerk – What it Entails?
Average salary
Requirements for data entry personnel
Data Entry Clerk work environment
Learn About Being a Data Entry Clerk – Quiz
Computer types
7 Topics | 1 Quiz
Supercomputer
Mainframe
Workstation
The Personal Computer or PC
Microcontroller
Microprocessor
Server
Computer Types – Quiz
Main Components of the Computer
4 Topics | 1 Quiz
Hardware & software
Firmware
Basic operations
Names for different sizes of Data
Main Components of the Computer – Quiz
Data Management
7 Topics | 1 Quiz
What is data management?
Managing data acquisition
Managing data utilization
Managing data maintenance
Managing data protection
Managing data confidentiality
Managing data integrity
Data Management – Quiz
Getting to know Excel
5 Topics | 1 Quiz
Working with the Excel environment
The Ribbon
Changing the Ribbon Display Options
The Quick Access Toolbar
Views on the Worksheet
Getting to know Excel – Quiz
Workbooks in Excel
3 Topics | 1 Quiz
Creating a new blank workbook
Utilising templates
Saving and Sharing Workbooks
Workbooks in Excel – Quiz
Working with Cells
3 Topics
Understanding cells
Cell Content (Part 1)
Cell Content (Part 2)
Using Find & Replace in Excel
2 Topics | 1 Quiz
Finding Content
Replacing the Cell Content
Using Find and Replace in Excel – Quiz
Formulas and Functions
3 Topics | 1 Quiz
Comprehending Formulas in Excel
Operator Precedence
Inserting Function
Formulas and Functions – Quiz
Most Used Functions
10 Topics | 1 Quiz
COUNT
SUM
IF
AVERAGE
COUNTIF
SUMIF
VLOOKUP
INDEX and MATCH
MIN and MAX
SUMPRODUCT
Most Used Functions – Quiz
How To Create A Database In Excel For Customers
4 Topics | 1 Quiz
How To Create A Database In Excel For Customers With Examples And Templates
How To Create Data Base In Excel: Step By Step Instructions
Database Maintenance In Excel
How To Filter Data
How To Create A Database In Excel For Customers – Quiz
Excel Worksheets – Checking the Integrity of your Worksheets
1 Topic | 1 Quiz
Checking the Integrity of your Excel Worksheets
Excel Worksheets – checking the integrity of your worksheets – Quiz
Filing Systems
3 Topics | 1 Quiz
Why should there be a thorough filing system for organisations?
Setting up a Filing System – Part 1
Setting up a Filing System – Part 2
Filing – Quiz
Knowledge of General Office Procedures
2 Topics | 1 Quiz
General Office Procedures – Part 1
General Office Procedures – Part 2
Knowledge of General Office Procedures – Quiz
What You Need To Know About The Popi Act
1 Topic | 1 Quiz
Basics Of The Popi Act
What You Need To Know About The Popi Act – Quiz
Previous Topic
Next Topic

AVERAGE

Track Your Course Progress
You are currently studying as a guest. Your course progress and quiz results will not be saved unless you login to your EduCourse account. Login to track your progress and qualify for your certificate.
Data Management and Entry Certificate Course Most Used Functions AVERAGE

Use average features (no rocket science here to measure the average of a set of number). The formula below calculates the average in the range A1:A6 of the top 3 numbers.

Explanation: the array constant {20,15,10} is returned by the LARGE function. As an argument for the AVERAGE function, this array constant is used, giving a result of 15.

Previous Topic
Back to Lesson
Next Topic