Data Entry and Office Administration Certificate Course

1. 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
2. Computer types
7 Topics | 1 Quiz
Supercomputer
Mainframe
Workstation
The Personal Computer or PC
Microcontroller
Microprocessor
Server
Computer Types – Quiz
3. 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
4. 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
5. 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
6. Workbooks in Excel
3 Topics | 1 Quiz
Creating a new blank workbook
Utilising templates
Saving and Sharing Workbooks
Workbooks in Excel – Quiz
7. Working with Cells
3 Topics
Understanding cells
Cell Content (Part 1)
Cell Content (Part 2)
8. Using Find & Replace in Excel
2 Topics | 1 Quiz
Finding Content
Replacing the Cell Content
Using Find and Replace in Excel – Quiz
9. Formulas and Functions
3 Topics | 1 Quiz
Comprehending Formulas in Excel
Operator Precedence
Inserting Function
Formulas and Functions – Quiz
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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 Lesson
Next Topic

COUNT

Login to save your progress and get your certificate. Your course progress is only saved when you are logged in.
Data Entry and Office Administration Certificate Course 10. Most Used Functions COUNT

Microsoft Excel has something to do with formulas and functions. A summary of the 10 most used Excel functions can be found (+ extra tricks when creating formulas in Excel).

1. COUNT

Use the COUNT function to count the number of cells that contain numbers.

Note: use COUNTBLANK and COUNTA to count the blank/nonblank cells in Excel. COUNTA stands for count all.

Want to save your place in this course? Login or register to save progress and work toward your certificate.
Previous Lesson
Back to Lesson
Next Topic