Become the office Excel wizard by using this secret data entry tool - Excel Tips and Tricks - video Dailymotion

ExcelTips247

Become the office Excel wizard by using this secret data entry tool. You will learn how to do data entry with Excel, and will know which tool is used for data entry,   Here are the steps outlined in my video.   Data Entry Tool - From Ribbon  1) Right-click any icon on ribbon  2) Customize the Ribbon...  3) Quick Access Toolbar  4) All Commands  5) Form...  6) New Group  7) Add...  8) OK  9) Place cursor in dataset  10) New Group ~ Form    Data Entry Tool - Hotkey  What is the shortcut key for data entry form in Excel?  Here it   Alt + D + O + O    Become the office Excel wizard by using this secret data entry tool,How to do data entry with Excel?,Which tool is used for data entry?,   Check out my complete suite of Microsoft Excel Tips and Tricks.  https://www.youtube.com/@RabiGurungXybernetics/shorts  https://www.tiktok.com/@xybernetics247  https://www.instagram.com/rabi.gurung247/  https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/  https://twitter.com/XyberneticsInc/media  https://www.reddit.com/r/Excel247/  https://www.facebook.com/XyberneticsInc/reels/   #microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Transcript

00:00Entering data in cells can be a very time-consuming process especially if

00:03you're dealing with large amount of data with various numbers of columns.

00:07Fortunately there's a quick way to do it using something called forms. There's two

00:11ways to access form. This is the first way using ribbon. Right-click any of this

00:15icon here and then click on customize the ribbon on this context menu here.

00:20Once that's done you'll come up with this Excel options here. From this choose

00:24command. You're going to use all commands. Choose a feature called form. This one

00:30here and then over here you're going to put this form over here but you can't

00:34just click on add and it'll work. No. You're gonna have to add a new group in

00:38here. Once this new group is created, form is selected. Click on add and the form

00:43will be added to a new group here. You can rename it to whichever you want. I'm

00:46gonna leave the group name as new group customized like this. Once that's done

00:50click OK and you'll notice that on your ribbon you have access called form here

00:56under the new group. It's in the home section or home tab here. Now place your

01:01cursor anywhere in your data set table itself like this and then if you click

01:06on form, a form will be accessible for you to enter details. Now if you want to

01:10enter a new entry here you click on new and let's say you add the title of the

01:16book. Publisher is XYZ and then the price is 123.44 and then if you close it you can

01:23see that the new record has been added on row 22. Likewise if you click on form

01:28here again you can also make changes to the existing data set table like this.

01:33Let's say you want to get rid of the word of Wavelet like this and then we're

01:38gonna change the publisher to LTD and maybe make changes to the price like this and

01:43then close it. You can see that it changed existing data as well. That's one

01:48way to get access to the forms you are using ribbons. The next way of course is

01:52to use a hotkey. Place a cursor on your data set table here and press alternate

01:57and press DOO and the form will be available for you as well.

Become the office Excel wizard by using this secret data entry tool - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended