Data Entry and Data Management

Role of a Data Entry Operator

What is data entry?

How to acquire the basic skills to become a good data entry operator?

Tips to improve upon basic data entry skills

Online and free applications that help data entry operators to practice typing

Various job opportunities available for data entry professionals

Expected salary range for data entry professionals

Finding freelancing data entry jobs on Fiverr and Upwork

How can freshers look up freelancing

What are the common tools ?

Various Keyboard Layout and Typing speed

Typing Techniques

Right postures and Keyboard introduction

Introduction to Keyboard

Use of Home Row, Top Row and Bottom Row

Top Row

Bottom Row

Shift key

Caps lock key

Numeric keys

Special Character Keys

Use TAB key

Finger motions

Tips for increasing Typing Speed

Google Doc Voice Typing

Outcome

Font

Kruti Dev/Devlys to Unicode

Shree Lipi to Unicode

ISM font introduction and installation

Calligraphic fonts

Applying Font Settings

Data Entry Tools

Winautomation

Different data entry methods, Zoho Forms & Survey Monkey

Objective

Define Zoho Forms

What Are Some Of The Features Of Zoho Forms?

How can Zoho Forms help in data entry?

How to create a free account and form on Zoho Forms website?

What is Survey Monkey?

What are some of the features of Survey Monkey and how does it help in data entry?

How can you create a free account and survey on the Survey Monkey Website?

Summary

Outcome

Kamisha Soft

MoreApp Forms

ElectroNeek Studio IDE

Teamscope

Grammarly

About Grammarly Tool

Using Grammarly Tool

Summary

Outcome

Komprehand

Mathtype

Chemdraw

Excel Forms

Google Forms

Customizing google form

Filling google form

Key data entry skills

What is image assisted data entry

Scanning Image (De-pixelation)

Resizing images

Data Validation in Excel

Compression of documents

Applying page size settings and print settings

Merging and splitting documents Intro

Merge Documents

Split Documents

Report Creation

Reporting and presentation of data

Adding Digital Signature

Manage and Share Workbooks-Connect to external data

Formatting Email

Proofreading your document

Proofreading your document with auto-correct

Password Protection

Encrypted PDFs

Intro

Doc to PDF

PDF to Google Doc

PDF to Excel

Excel to PDF

Excel to CSV

PDF to ePUB

PDF to JPG and PNG

PDF to RTF

PDF to Word using OCR

PDF to Word using online tool

Data Entry Tasks

Quickly convert hard copy to soft copy

Changing the layout of data from columns to rows quickly

Adding forms to the Quick Access Toolbar

Entering numbers, dates, days or months serially into cells

Entering text to specify quantity before or after a numeric value

Using the summation formula to calculate the total amount in a spreadsheet

Changing the format of the date entered into selected cells

Calculating the balance amount and displaying negative numbers properly

Deleting blank or redundant cells from the middle of the spreadsheet

Entering same data into various cells of the spreadsheet

Deleting duplicate data from the spreadsheet

Data Validation: Introducing a dropdown list for entering a fixed or limited range of data into the cells

Using the data validation feature to quickly introduce more than two kinds of data into the dropdown list for cells

See the fixed list of values for a column cell

Conditional Formatting

Sort & Filter

File conversion from PDF to word

Efficient written and verbal communication skills

Self-motivation

Accuracy and attention to detail

Time Management

Multi-tasking

What is Data Management and how it differs from Data Entry?

Typical Data Management Jobs in the market

Basic Introduction to Data Management

Define Data

Where do we use data?

What is data management?

How does data management help businesses to achieve their goals?

What are the various steps involved in data management?

What skills do data management professionals require?

What is data entry?

What are the skills required to become a data entry operator?

What are some tips to improve upon basic data entry skills?

What are some online and free applications that help data entry operators to practice typing?

What are the various job opportunities available for data entry professionals?

What is the expected salary range for data entry professionals?

How can one find freelancing data entry jobs on Fiverr and Upwork?

How do professionals organize their data?

What is a database?

What mediums do professionals use for storing data?

How do professionals organize and store official data?

What are some good practices for organizing and storing data?

Meta Data and Big Data

What is Metadata?

What are the types of metadata?

What is Big Data?

Define Data Analytics

What course of study can you persue to become an expert in Data Analytics?

Data Collection Techniques

Data Cleaning Techniques: Downloading, Saving, and Cleaning data

Data Cleaning Techniques: Freezing and Cleaning data

Microsoft Excel

Entering Text, Numbers and Dates

Creating Text, Number and Date Series

Inserting and Deleting Rows, Column

Changing Cell Height and Width

Editing Worksheet Data

Sort and Filter - Advanced filter

Adding comments

Worksheet Protection

Fill options and other functions in Excel

Solver Add-In

Solver Add-In

Excel Shortcuts

Microsoft Word

Cut, Copy, and Paste the text

Text Formatting

Paragraph Alignment, Spacing, and Formatting Marks

Bullets and Numbering

Increase and decrease Indent

Text and Paragraph Shading

Text sorting, Paragraph indenting, and spacing

Macros

Inserting Table

Designing Table

Aligning Table

Table of Contents

Mail Merge

Add multiple footers in word

Microsoft PowerPoint

Introduction to PowerPoint presentation

PowerPoint Slides

Creating Presentation

PowerPoint Transitions

PowerPoint Animations

Setup SlideShow

Start Slide Show

Data Analysis

Google Data Studio - An Introduction

Data Sources

Data Blending

Data Blending inside

Google Data Studio-Creating Reports and Chart Types

Report canvas interface

Creating chart types- Table, Pivot table

Bar Chart

Line Chart

Time series chart

Scorecard Pie Maps charts

Google Data Studio - Action controls for Reports and Managing Reports

Community visualization

Embed URL in reports

Creating Groups

Page and report level

Creating multi page report with navigation

Using parameters to get user input

Copying chart formatting

Managing data segments

Regular expressions

Google Data Studio -Sharing Reports, Collaborating on Reports and Tips to create an effective report

Google Docs

Creating a Spreadsheet

Outcome

Google Slides

Creating a Google Slide File

Inserting Images

Slide Transitions

Google Slides Other Options

Outcome

Google Keep

Google Keep: Creating a Note

New Note with Drawing

New Note with Image

Google Keep View and Settings

Outcome

Canva Introduction

Objective

Introduction

What is Canva?

What are the features of Canva?

How can you create free account in Canva?

How can you use Canva to make a checklist for data collection?

Summary

Outcome

How to create a project in ProofHub?

How to use Canva for Branding?

How to create digital notes using Evernote?

How to book tickets on MakeMyTrip?

How to maintain the digital record in Khatabook?

How to automate the note-taking process using Otter?

How to schedule emails using Boomerang?

How to create a to-do list and note reminders using Sticky Notes?

How to download copyright-free images?

How to manage projects using Trello?

How to communicate with people using Slack?

How to create a private YouTube channel?

How to manage tasks using Asana?

How to convert files using Format Factory?

How to search files quickly using Search Everything?

How to communicate with colleagues using LAN Messenger?

How to share your free time slots with colleagues using Doodle?

How to use templates to create documents using Smart Business Box?

How to share files with your clients using Dropbox?

How to digitally store visiting cards using Card Scanner?

How to calculate scientific expressions using the Scientific Calculator?

How to assign tasks and processes using Smartsheet?

How to track user statistics of social media handles using Social Blade?

How to create a communication site using Microsoft SharePoint?

How to scan printed documents using Microsoft Lens?

How to create a to-do list using Todoist?

How to save passwords using LastPass?

How to share heavy files using Wormhole?

How to start accepting payments using Razorpay?

How to manage and analyze your social media handles using Buffer?