Curriculum
- 6 Sections
- 18 Lessons
- 50 Hours
- Module 1 - Data Entry BasicsData entry roles improve your computer skills, which can ultimately,help you expand into a new career path. This is a hands-on, non-intimidating tutorial where learners work through various examples to get to grips with the nuances of data entry essentials. In this module, you'll learn how to customize currency, date/time, numeric and text entries useful for further skills in computations in Excel.9
- 1.1Overview of Data Entry Techniques5 Minutes
- 1.2Why Data Entry2 Hours
- 1.3Data Entry with Leading Zeros4 Hours
- 1.4Customizing Currency Entries2 Hours
- 1.5Managing Date Entries2 Hours
- 1.6Customizing Date Entries2 Hours
- 1.7Creating an Excel Table2 Hours
- 1.8ISCS 262 2nd Semester Exams45 Minutes21 Questions
- 1.9ISCS 26215 Minutes15 Questions
- Module 2 - Data Entry with Data FormIt’s a great new tool from Microsoft that allows you to quickly and easily create questionnaires, surveys, quizzes and polls that you can share both internally or externally from your work. There is a wide variety of potential uses for these. You could use them to get customer feedback, collect reviews and testimonials or even use them as data entry forms. In this module, you'll find that with near endless cells of a spreadsheet, using a data form provides a convenient means to enter or display data on the screen, particularly, when you have to move from column to column with near endless cells and more columns of data to view.4
- Module 3 - Managing Duplicate DataData duplicates in Excel table can cause a lot of inconveniences to you. Whether you import data from a database, get it from a colleague, or collate it yourself, data duplicate can always creep in. And if the data you are working with is huge, then it can become really difficult to locate and remove these duplicates. The focus of this tutorial is walk you through how to locate and remove duplicates from you data file.3
- Module 4 - Computation and Charts3
- Quizzes0
- Reference1
Requirements
- Access to a personal computer or similar devices with internet connectivity.
- Light skills in using Excel to create a workbook.
- Strong desire to acquire professional skills in data entry
Features
- Adding data form to Quick Access Toolbar
- Creating an Excel table
- Using data forms for data entry
- Navigating through data records
- Validating data records
- Managing data duplicattes
- Sorting and filtering data records
Target audiences
- All category of learners who want to use Excel for data entry
Leave A Reply
You must be logged in to post a comment.
13 Comments