Basics of data management

• Introduction to Data Management
• How do professionals organize their data?
• Meta Data and Big Data
• Freelance Data Entry Jobs

Introduction to computer typing and data entry

• Introduction to Typing
• Keyboarding
• Ergonomic Typing

Introduction to various typing methods

Using different types of keys and symbols in typing Google Docs – Voice Typing Lipikaar App

Introduction to data analysis

• Using different types of keys and symbols in typing
• Google Docs – Voice Typing
• Lipikaar App
• Text Formulas
• Text Manipulation Functions

Apply custom formats and layouts

• Apply Custom Data Formats
• Use Advanced Fill Options
• Apply Advanced Conditional Formatting and Filtering
• Apply Custom Styles and Templates
• Use Form Controls
• Prepare Workbooks for Internationalization
• Use Outlines
• Use Custom Views

Create advanced charts

• Basic Excel Charts
• Use Area, Scatter & Stock Charts
• Use Surface, Radar & Combination Charts
• Create Custom Chart Templates
• Work with Sparkline’s

Pivot tables and charts

• Pivot Tables
• Use Pivot Charts
• Create Dashboard using Pivot Table
• Using Power Query

Data visualization and data analysis

• Use of Macros
• Using Data Tables
• Create Dashboard using Pivot Table
• Using Power Query

Use scenarios

• Use What-If Analysis Tools
• Create Scenarios
• Merge Scenarios
• Create Scenario Summaries
• Use Data Tables

Manage and share workbooks

• Manage Workbook Versions
• Copy Styles between Workbooks
• Copy Macros between Workbooks
• Use Track Changes and Comments
• Merge Workbooks
• Protect Workbooks for Sharing
• Connect To External Data

Typical data entry projects

• File Conversion from PDF to Word

Create advanced formulas

• Functions
• Apply functions in formulas
• Mathematical Functions
• Financial functions
• Useful Data Functions
• Some Other Useful Functions
• Look up data by using functions
• Apply advanced date and time functions
• Functions for Manipulating Text
• Arrays

Free & open-source tools for data management

• Working with Google Sheets
• Working with Google Forms
• Working with Google Keep
• Using OpenOffice.org Writer
• Using OpenOffice.org Calc
• Using Komprehend
• Using Google Data Studio

Different data entry methods and data cleaning

• Using Komprehend
• Excel Shortcuts
• Mail Merge in MS Word
• Compare Docs using MS Word

Introduction to DBMS

• What is a DBMS and its purpose?
• Types of DBMS
• Examples of DBMS – MySQL, Oracle, etc.