Track
Back Office
Duration
60 hours
Skill Level
Beginner
Language
English
About this Course
Understand basic data entry, formatting, and organization for accurate digital records.
Learning Mode: Learn at ALC or at Home
Detailed Course Curriculum
Hands-on module breakdown aligned with MKCL production standards and industry requirements.
- Basics of Computer Typing
- Basics of Data Entry and various formats
- Different Avenues of Computer Typing & Data Entry
- Career opportunities in the world of Data Entry
- Let’s Type Something
- Please type displayed paragraph
- Few Questions related to typing
- Why Learn Typing?
- What is Keyboarding?
- Need for Typing
- Typewriters To Computers
- Types of keyboards
- Ergonomic Keyboards
- PDA Keyboards
- Keyboard Layout
- QWERTY Keyboard
- Data Entry
- What is Touch Typing?
- What is Muscle Memory?
- Names of Fingers
- Finger Placements
- Practice Makes Perfect
- Minimise Hand Movements
- How to Measure Progress?
- Correct Posture
- The Space Bar
- The Enter Key
- Learning the G and H Keys
- Learning the Apostrophe Key
- Using Keys
- Learning the E and I Keys
- Learning the W and O Keys
- Learning the Q and Y Keys
- Learning the P and T Keys
- Using Keys
- Learning the C and Comma Keys
- Learning the X and Period Keys
- Learning the Z and Slash Keys
- Learning the B and N Keys
- Learning the Tab Key
- Using Keys
- Typing Tips
- Typing Tips
- Using Number Keys – 1 to 5
- Using Number Keys – 6 to 9 and zero
- Learning the Square Brackets and Back Slash Keys
- Typing Tips
- Learning the Minus, Equals and Grave Accent Keys
- Touch Typing on the Number Pad
- Num Pad Home Row Positions
- Index Finger Keys
- Typing Tips
- Middle Finger Keys
- Ring Finger Keys
- Little Finger Keys
- Google Docs
- Adobe PageMaker
- CorelDRAW
- Adobe InDesign
- Microsoft Word
- Microsoft Excel
- Open Office Calc
- Open Office Writer
- Undoing and Redoing
- Editing Modes
- Need for Data Conversion
- Skills Required for Data Entry
- Types of Data Entry Jobs
- Data Entry Jobs in Industrial Sector
- Data Entry Jobs in Medical Sector
- Related Jobs
- Types of Data
- Data Validation
- Data Categories
- Data Correctness
- Compiling Data
- Data Entry Tools
- Scanning
- OCR
- Data Conversion for the Web
- Other Conversions
- Data Entry Pay Scales
- Factors affecting Pay Scale
- Legal Documents
- Other Documents
- Medical Transcription
- Stamp Papers
- Bank Documents
- KYC Details
- Loan Applications
- Form Entries
- Publications
- Types of Typists
- Google Docs - Voice Typing
- Introduction to Functions, Common Types of Arguments, Parts of Functions
- Advanced Aspects of Functions, Searching for a Function
- Using the Functions
- Using the SUM and AVERAGE Functions
- Using the IF Function
- Analysing the IF Function
- Using the OR Function
- Using the AND Function
- Using the OR Operator Function
- Nesting the IF Statement
- Analysing the Nested IF Function
- Using the NOT Function
- Using the SUMIF Function
- Using the SUMIFS Function
- Using the AVERAGE and MEAN Functions
- Using the MODE Function
- Using the MEDIAN Function
- Area and Volume Calculations
- Rounding Decimal Places
- MOD and INT Functions and Uses
- Using the Random Function
- Using the RANDBETWEEN Function
- EMI Calculations
- Calculating Monthly Instalment and Interest
- Calculating Principal Amount
- Calculating Balance Amount
- Using PV Function
- Using FV Function
- The CHOOSE Function
- Using the MATCH Function
- Using the INDEX Function
- Using the MATCH and INDEX Functions Working Together
- The CELL Function and Determining File or Sheet Names
- Using the ISBLANK Function
- Error Checking Using the ISERROR Function
- Error Checking Using the IFERROR Function
- OFFSET Function: Display the Value in Cell
- OFFSET Function: Calculating a SUM
- OFFSET Function: Creating a Dynamic Named Range
- Using the INDIRECT Function
- INDIRECT Function to Build Dynamic Formulas
- Using the LOOKUP Function
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- VLOOKUP in Live Action
- Lookups Nested Within Lookups
- Working with Date and Time in Excel
- Using the YEAR, MONTH, DAY, HOUR, MINUTE AND SECOND Functions
- Calculation Between Two Dates
- Calculating Person’s Age Using Excel
- Using Functions to Serialize Date
- Using the TIMEVALUE Function
- LEFT: Text Manipulation
- RIGHT: Text Manipulation
- LEN: String Extractions
- TRIM: String Extractions
- Changing Case Function
- CONCATENATE: Building Strings From Multiple Cells
- REPLACE and SUBSTITUTE: Two More String Manipulation Function
- Using the FIND and MID Text Functions
- FIND and MID: Text Functions Working Together
- Formatting Numeric and Date Values Using TEXT
- IF ARRAY Formulas
- Transpose-Shift
- What-If Analysis Tools
- Using Goal Seek
- What are Scenarios?
- Possible Scenarios
- Naming Cells
- Creating a Scenario
- Second Scenario
- Third Scenario
- Viewing a Scenario
- Quick Access to Scenarios
- Merging Scenarios
- Other Scenarios
- Merging Process
- The Merge Scenarios Window
- Types of Scenario Summaries
- Creating Scenario Summary
- Understanding Scenario Summary
- Creating Scenario PivotTable Report
- Modifying Scenario PivotTable Report
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 Mastery Basics?
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