What you will learn ?
Data Collection, Data Entry, Data Management, MS Excel (Formulas, Functions, Pivot Tables, Charts), Basic Database Concepts, Data Cleaning, Data Analysis Techniques, and Professional Data Reporting & Presentation.
Get certificate of completion
Jobs that require this skill:
Data Entry Operator
Office Assistant
MIS Executive
Computer Operator
Business Data Assistant
Course content
Requirements
Course description
Course Content / Syllabus
Module 1: Basics of Data Management
What is Data & Information
Types of Data (Structured / Unstructured)
Data Collection Methods
Data Accuracy & Validation
Module 2: MS Excel (Core Tool)
Excel Interface & Functions
Data Entry & Formatting
Formulas & Functions
(SUM, AVERAGE, IF, VLOOKUP, COUNT, etc.)
Sorting, Filtering & Data Validation
Charts & Graphs
Pivot Table & Pivot Chart
Module 3: Database Management (Basic)
Introduction to Database
Tables, Records & Fields
Primary Key & Data Integrity
Basic MS Access / DB Concepts
Module 4: Data Analysis Techniques
Data Cleaning
Data Classification
Trend & Comparison Analysis
Basic Statistical Concepts (Mean, Median, Mode)
Module 5: Data Presentation & Reporting
Reports Preparation
Dashboard Basics
Professional Data Presentation
Exporting Reports (PDF, Excel, Print)
0 Video
Lessons
Get instant & lifetime access
This course contains pre-recorded videos that can be watched anytime
How to buy this course:
STEP 1: Click on BUY NOW button
STEP 2: Register yourself by filling basic details
STEP 3: Make payment via credit card, debit card, UPI Pay TM or other payment wallets
STEP 4: Get instant access and unlock the course
How to access the course:
STEP 1: Login to your account
STEP 2: Click MY COURSES section and view your course
STEP 3: Click videos to begin
