Course Content

Course Content

Data Entry in MS Excel

How to perform data entry of date-time


Now we will see that how we can perform data entry of date and time in MS Excel.


Date and time are very important feature to complete any data entry.


Firstly we will use '/' to enter date, that is when we want to enter any date we can write it as '16/10/2016'. Or else also '16/10/16', it will get directly changed to '16/10/2016'.


We can also use '-' to enter date, like '16-10-2016'.


If by mistake we have added any wrong date then it will be left aligned in MS Excel.


To manipulate date we have many functions in FORMULAS tab inside Date & Time option.


Similarly if we want to enter time we will use ':' symbol. Like - '2.30' , and if we want to show our time in 24 hour format then also we can write it as '14.30'. It is also correct.


If we are working in any Excel sheet which requires previous year data, then we have to enter the date manually because MS Excel has restricted the date at particular time period.


Overall date and time can be entered in Microsoft Excel by using '/' and ':' symbols.


Excel allows you to simplify data entry by utilising a form, which is a dialogue box with fields for a single record. Data entry, a search tool for previous entries, and the ability to amend or delete data are all available on the form.

Text, values, dates, and formulae are the four categories of data included in Excel worksheets.

The secret data entry form in Excel can be accessed by adding the command to the Quick Access Toolbar. The form command should be added to the Quick Access Toolbar. Right-click anywhere on the quick quick access toolbar to bring up the context menu. From the menu options, choose Customize Quick Access Toolbar.

The most basic data entry method entails manually entering data into a spreadsheet. This is typically required the first time data is entered into a computer. If the data is already stored in a computer file, there may be a simple way to import it into a Gnumeric worksheet.

Transcribing, updating client information, and entering financial records are all examples of data entry job duties.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere