Track
Back Office
Duration
60 hours
Skill Level
Beginner
Language
English
About this Course
Improve speed and accuracy in data entry using spreadsheets and data validation tools.
Learning Mode: Learn at ALC or at Home
Detailed Course Curriculum
Hands-on module breakdown aligned with MKCL production standards and industry requirements.
- Overview of Data Entry
- Brief History and Evolution of Data Entry
- Manual and Automated modes of Data Entry
- Online and Offline Data Entry
- Common Data Entry Software
- Introduction to Basic Data Entry Tools
- Fundamentals of Data Entry
- Data Organization and Management
- Practical Skills in Data Entry
- Introduction to Data Formatting and Error Checking Techniques
- What is data entry?
- Skills required to become a data entry operator
- Mindset for a successful Data Entry Operator
- 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 typin
- Opportunities Various job opportunities available for data entry professionals
- Types of Data entry Jobs like Remote Data entry, in-house data entry
- Different Types of Data Entry Job Options
- Expected salary range for data entry professionals
- Data Entry Operators Work in a Variety of Industries
- Data Entry Operators Essential Roles in Other Fields
- Certifications for Data Entry Jobs
- Finding freelancing data entry jobs on Fiverr and Upwork
- Finding freelancing data entry jobs peopleperhour.com, guru.com
- How can freshers look up freelancing
- Precautions to be taken when looking at Data Entry Jobs i.e. Job Scams, legitimate employers etc.
- What are the common tools
- A brief introduction to stenography and its career opportunities can be added
- Right postures and Keyboard introduction
- Right postures and Keyboard introduction
- Various Keyboard Layout and Typing speed
- Introduction to Keyboard
- Introduction to Keyboard
- Typing Techniques
- Use of Home Row, Top Row and Bottom Row
- Use of Home Row, Top Row and Bottom Row
- Top Row
- Top Row
- Bottom Row
- Bottom Row
- Shift key
- Shift key
- Caps lock key
- Caps lock key
- Numeric keys
- Numeric keys
- Special Character Keys
- Special Character Keys
- Use TAB key
- Use TAB key
- Finger motions
- Finger motions
- Tips for increasing Typing Speed
- Tips for increasing Typing Speed
- Introduction
- 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
- Touch Typing: Finger Symphony
- Posture Perfection for Keyboard Warriors
- App Arsenal: Your Typing Toolkit
- Dial In: Customizing Your Typing Terrain
- Typing Tenets: The Path to Prowess
- Home Row Harmony: Fingers’ First Frontier
- Middle Maneuvers: E & O’s Journey
- Index Adventure: T & I’s Trail
- Index Expedition: Navigating N & R
- Home Base Expansion: H & C Challenge
- Shift Key Saga: Capitalization Quest
- Ring Recon: Mastering W, Period, and Comma
- Index Ingenuity: Unlocking G, B, U
- Index Insight: Y & M Mastery
- Finger Flex: V & P Velocity
- Middle Mystique: The Quest for X and?
- Pinky Power: Z, Brackets, and Dash
- Thumb Thrive: Numpad Numerics
- Numpad Navigator: Numeric Expeditions
- Lexicon Lift: Words at Warp Speed
- Shortcut Strategy: Swift Selection Secrets
- Editing Efficiency: Shortcut to Success
- Navigating Mobile Typing Mastery
- Triple Threat: Top Mobile Typing Techniques
- Keyboards Elite: Speed Typing on Mobile
- Optimal Holds: Mastering Mobile Typing Posture
- Mastering Mobile Typing: Strategies for Efficient Text Entry
- Toolkit 25: Elevating Your Mobile Typing Game
- Predictive Power: Boosting Efficiency by 30%
- Clipboard QuickDraw: Phrases in a Flash
- Shortcut Savvy: Fewer Taps, More Text
- Acceleration Arsenal: Tips 1-5 for Rapid Typing
- Speed Surge: Tips 6-10 for Typing Boost
- Typing Turbocharge: Tips 11-18 Unleashed
- Voice Velocity: Speech Recognition for Typing
- Efficiency in Password Management
- Password Fortification Check
- Decoding Dictionary Attacks
- Brute Force Attacks Unveiled
- Mastering Password Managers
- Choosing Between Passwords and Algorithms
- The Stub Technique: A Primer
- Elevated Security Measures for Critical Accounts
- Navigating Forced Password Updates
- Comprehensive Keyboard Shortcuts for Data Entry
- Start Menu Mastery with Windows Key
- Quick App Access: Windows Key + Taskbar Tricks
- Instant Desktop Display Techniques
- Efficient Window Management for Optimal Workflow
- Seamless App Switching for Enhanced Productivity
- Quick Close Strategies for Streamlined Operations
- Mid-Process Evaluation for Continuous Improvement
- Browser Zoom Mastery for Efficient Data Review
- Tab Navigation Techniques for Swift Data Entry
- Address Bar Mastery for Speedy Navigation
- Advanced Paste Special for Data Precision
- Cut Function Quick Keys: Efficiency Boost
- Start Menu Access: Instant Shortcut
- Tiles Rearrangement: Windows Layout Wizardry
- Applications Search Shortcut: Find Fast
- Run Command Quick Access: Instant Execution
- Search Functions: Shortcut Mastery
- Files Search Shortcut: Swift Discovery
- Taskbar Apps: Quick Launch Techniques
- Taskbar Customization: Personalize with Ease
- File Explorer Instant Open: Navigate Swiftly
- Desktop Reveal Shortcut: Clear & Access Quickly
- Minimize Windows: Quick Clear Workspace
- Selective Window Minimize: Focus Enhancer
- Desktop Peek: Quick Glance Shortcut
- Language Input Switch: Multilingual Shortcut
- Active Window Positioning: Efficient Layout
- Window Snapping: Productive Arrangement
- Display Mode Switch: Visual Optimization
- Monitor Window Shift: Workspace Expansion
- Instant Screen Lock: Secure with a Shortcut
- Zoom & Minimize: Quick View Adjustment
- Quick Screenshot Save: Capture & Store
- Charms App Launch: Quick Access Magic
- Settings Charms: Quick Tweak Shortcut
- Quick Link Menu Access: Instant Navigation
- Application Cycling: Swift Swap
- Tabs Cycling: Efficient Browsing
- Programs Cycling: Seamless Switching
- Task Manager Launch: Control at Your Fingertips
- Activate Task Manager: Immediate Access
- Application Exit Shortcut: Quick Close
- Active Window Close: Swift Shutdown
- File Explorer Navigation: Speed Through Files
- File Properties Tab: Instant Information
- File Menu Access: Direct Dropdown
- Ribbon Menus Quick Access: Efficiency Key
- Address Bar Jump: Navigate with Ease
- Enable Preview: Quick Content Glance
- Macros Preparation: Automation Shortcut
- Help Dialogue Box: Instant Assistance
- Instant Rename: Quick File & Folder Update
- Font Case Change: Quick Text Adjustment
- Find Next Feature: Swift Search Continuation
- Browser Window Refresh: Quick Update
- Window Elements Cycling: Efficient Navigation
- Spell-Check Launch: Instant Correction
- Key Mastery: Unlocking Functionality
- F9 Key Versatility: Exploring Possibilities
- F10 Key Utility: Enhancing Productivity
- F11 Key Advantage: Full-Screen Mode & More
- Quick Save As: Efficient File Management
- Undo and Redo: Instant Corrections
- Quick Trash Move: Efficient Deletion
- Next Field Jump: Swift Data Entry
- Ribbon Access: Instant Toolbar Navigation
- Customize Quick Access Toolbar: Personal Efficiency
- Placeholder Text Generation: Quick Setup
- Text Alignment Shortcut: Quick Format
- Text Selection: Quick Highlight
- Page Navigation: Swift Movement
- Block Text Selection: Group Highlight
- Vertical Text Selection: Up & Down Highlight
- Toggle Windows Ribbon: Show/Hide Shortcut
- Print Preview Activation: Instant View
- Microsoft Office Zoom: Quick Magnification
- Words and Sentences Selection: Precision Highlight
- Find in File: Quick Item Search
- Replace in File: Quick Item Update
- Go-to Feature: Swift Navigation Shortcut
- New Windows and Tabs: Quick Creation
- Desired Tab Jump: Instant Access
- Recently Closed Tabs: Quick Reopen
- Browser Page Refresh: Quick Update
- Browser Zoom: Quick Magnification
- Paste Special: Advanced Clipboard Management
- Copy and Paste Formatting: Quick Style Transfer
- Google Forms Essentials: Pro Hacks and Tips
- Google Forms Q&A: Your Concerns Addressed
- Intro to Google Forms: Data Entry Simplified
- Setting Up Your Google Form: A Step-by-Step Guide
- Crafting Compelling Titles and Descriptions
- Adding and Refining Questions for Maximum Clarity
- Exploring Various Question Types for Diverse Data
- Enhancing Forms with Images and Videos
- Guiding Responses: Description and Validation
- Efficiency Boost: Importing Questions into Forms
- Organizing Forms into Sections for Easy Navigation
- Customizing Forms: Themes, Backgrounds, and Fonts
- Designing Custom Headers for Brand Consistency
- Mastering Form Settings for Optimal Performance
- Pre-Launch Testing: Ensuring Form Perfection
- Distributing Your Google Form: Reach and Engagement
- Analyzing Responses: Insights and Trends
- Seamless Data Flow: Connecting Forms to Sheets
- Managing Notifications and Form Availability
- Optimizing Quiz Creation in Google Forms
- Crafting Detailed Paragraph Questions
- Designing Multiple Choice Questions for Impact
- Generating Concise Short Response Queries
- Incorporating Checkboxes for Diverse Answers
- Mastering Quiz Settings for Enhanced Control
- Final Touches: Perfecting Your Google Form
- Leveraging Feedback to Refine Your Google Forms
- Intro to Microsoft Forms: Streamlined Data Collection
- Getting Started: Navigating Microsoft Forms Interface
- Preparation Tips for Effective Form Creation
- Building Your First Form: A Step-by-Step Guide
- form Enhancement: Adding Sophistication and Clarity
- Form Modification: Tailoring for Precision
- Incorporating Branching Logic for Dynamic Forms
- Form Aesthetics: Themes and Media Integration
- Configuring Forms: Settings and Language Options
- Form Testing: Ensuring Accuracy and Functionality
- Quiz Crafting: Leveraging Microsoft Forms for Assessment
- Quiz Finalization: Settings and Adjustments
- Collaborative Editing and Template Sharing
- Distributing Forms: Engagement and Reach
- Mastering Job Portals: Naukri.com Deep Dive
- Creating Your Naukri Account: A Starter Guide
- Crafting an Impactful Resume on Naukri
- Uploading Your Resume: Getting Noticed on Naukri
- Skill Set Update: Enhancing Your Naukri Profile
- Job Alerts Creation: Stay Ahead with Naukri
- Keyword Optimization: Strategic Job Searching
- Applying Filters: Pinpointing Your Ideal Job
- Application Process: Making Your Move on Naukri
- Inbox Management: Tracking Employer Responses
- Microsoft Excel
- Basics of Spreadsheet and Formatting: Features of Spreadsheets
- Features of MS excel, Starting Excel, Excel Worksheet
- Data Types, Navigation the worksheet, Entering & editing Data, Modifying worksheet, Paged Breaks, Page Setup, Print Preview
- Home tab & Formatting Tools, Formatting cells using dialog box, Formatting Column & Rows, Formatting Worksheet using cells style & applying style, Auto format.
- Entering Text, Numbers and Dates
- Creating Text, Number and Date Series
- Formula, Functions and Chart: Introduction & Objective of formula, Using
- formulas, Functions, Charts, types of charts, to use more function.
- Inserting and Deleting Rows, Column
- Changing Cell Height and Width
- Editing Worksheet Data
- Sort and Filter - Advanced filter
- Adding comments
- Worksheet Protection
- Capturing data through images (Get data from image) in Excel using OCR
- Get data from various sources in Excel (From website, from text files, from folders, from pdf etc.)
- Fill options and other functions in Excel
- Solver Add-In
- Excel Shortcuts
- Creating Excel Tables
- Styling and Customizing Tables
- Using Total Rows in Tables
- Removing Duplicate Data
- Resizing and Renaming Tables
- Sorting and Filtering Data in Tables
- Advanced Filtering in Tables
- Slicers in Tables
- Converting Tables to Ranges
- Working with Custom Lists
- Cleaning Data
- Find and Replace
- Using the Go To Feature
- Selection Pane
- Select Objects
- Flash Fill for Text
- Flash Fill for Dates
- Flash Fill for Numbers
- Flash Fill for Splitting Text
- Default Fill Series
- Text Fill Series
- Number Series
- Date Series
- Justify
- Fill Options
- Basic Data Sorting
- Sorting with Multiple Criteria
- Sorting by Color
- Customized Data Sorting
- Basic Data Filtering
- Filtering by Color
- Advanced Data Filtering
- Finding Unique values using Filter
- Advanced Filtering with AND & OR Conditions
- Find Quarter and Year From Dates
- Adding and Subtracting Days
- Adding and Subtracting Years and Months
- WEEKDAY and WEEKNUM Functions
- NETWORKDAYS Function in Excel
- NETWORKDAYS.INTL Function in Excel
- Calculating Exact Age
- Conditional Formatting using Dates
- Creating Dropdown Lists
- Creating Date ‘Data Validation’
- Creating Number Data Validation
- Creating Text Data Validation
- Input Messages and Error Alerts
- Dependent Dropdown Lists
- Go to and Clear Data Validation
- Using Named Ranges
- Prevent Duplicate Entries
- Getting Characters by ASCII Code
- Fetching Unicode Characters
- Formatting Numbers as Text
- Converting Text to Numbers
- Converting Values to Text Strings
- Joining Array Elements into Text
- Extracting Text from Cells
- Comparing Text for Exact Match
- Generating Cell Addresses
- Retrieving Column Numbers
- Counting Columns in a Range
- Horizontal Data Lookup
- Creating Clickable Links
- Inserting Images via Formula
- Retrieving Row Numbers
- Counting Rows in a Range
- Cut, Copy, and Paste the text
- Word Processing and Formatting Documents: Main features of word processing
- Text Formatting
- Features of word; starting MS word Program, Word screen layout, Rulers, Managing Document, find document, Printing Documents, Exit word Program
- Working weigh text, front dialog box, Formatting paragraphs, Bulleted &
- numbered lists, working with table, adding graphics, moving text, Page
- formatting, header & footer.
- Mail Merge: Types of documents in mail merge, mail merge wizard, merging Document, creating mailing labels by merging an address list, Creating envelops
- 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
- Introduction to PowerPoint presentation
- PowerPoint Slides
- Creating Presentation
- PowerPoint Transitions
- PowerPoint Animations
- Setup Slideshow
- Start Slide Show
- Online conversion from Word to PowerPoint using Office 365
- In case of content is falling short in this credit, Open office writer, open office calc and open office impress can also be considered.
- Google Docs
- Creating a Document
- Outcome
- Working with Google Sheets
- 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
- Document Conversions
- 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
Eligibility Criteria
• Basic knowledge of computers and keen desire to build skills in this field.
• Open to students, job seekers, and working professionals.
• Open to students, job seekers, and working professionals.
Official Certification
• Official MKCL KLiC Certificate upon successful completion of the course and evaluations.
Work-Centric Learning Approach
• Step 1: Learners are given an overview of the course and its connection to life and work
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
Ready to start Data Entry Pro?
Join our upcoming batch at ZICA Kalyani center with certified instructors.
Other MKCL Courses
-
Data Entry and Data Management
120 hours -
Office Assistance
120 hours -
Google Workspace Expert
120 hours -
Advanced Data Entry Techniques
60 hours