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 Lesson
Next Lesson

Working with Cells

Data Management and Entry Certificate Course Working with Cells
Lesson Content
0% Complete 0/3 Steps
Previous Lesson
Back to Course
Next Lesson