SYLLABUS

The syllabus covers the following skills:

1. Apply custom formats and layouts
2. Create advanced formulas
3. Use of Scenario
4. Pivot tables and charts
5. Manage and share workbooks

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 METHOD

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

INTRODUCTION TO DATA ANAYLSIS

• 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 VISUALISATION 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 WORK

• 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 ADVANCE 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 AND 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.