Excel Data Entry

Free Video Tutorial: Inputting and Editing Data in Excel

Transcript

In this section, we're gonna take a look at how to efficiently add information into your spreadsheet as well as edit copy/paste and maybe potentially cut information and move it to different places in your spreadsheet. For this first exercise, we have a table of products we don't have all the products so I'm going to add information to the table using data entry techniques. Underneath video games I'm going to add laptops so I'll type laptops I'll press tab and enter 2500. Now I'm going to keep pressing tab until I get to the end of the table. Now what I want you to notice is what happens when I press ENTER. I go directly underneath laptops and I can enter my next row of data. I'm gonna enter smartphone. I'm gonna press tab and enter 900 press tab again and again until I get to the end when I press ENTER. I'm exactly at the place I need to be to enter headphones. I'll do that as well press tab enter 400 so using tab allows you to efficiently add data. 

Arrow Keys

Now someone might say well what if I use the arrow keys won't that do the same thing. I'll use the arrow keys right now to travel over to the end of the table right arrow right arrow right out as soon as I press ENTER I do not get the same type of carriage return effect. some of you are familiar with this. you've used an old-fashioned device and it has a very special name it's called the typewriter. when you get to the end you hear a ding and the character turn brings you right back to the beginning. So now let's take a look at editing some information in this table. I would like to add the word type right after the word product. Now I don't want to necessarily double click with my mouse although I could do that. 

Let's say I don't want to overly exercise my index finger by double-clicking each time I need to edit. what I'm gonna do is on my keyboard I'm gonna use the f2 key pressing f2 once automatically displays the flashing cursor that lets me know I'm in edit mode and if I look down at the bottom of the status bar it actually says edit. Now I'll press the spacebar and then put in the word type and then I've edited that text if I continue with the exercises I'll head over to iPads and I want to change iPads to iPads and tablets so f2 spacebar and I'll type in and tablets. one more edit I'm gonna head over to 950 I'll simply press f2 type in 0. when I press ENTER I've added the amount for TVs from 950 to 9500.

Copy/Pasting

Now let's move down and take a look at copying and pasting. This is something you're probably already familiar with. The keyboard shortcut on the PC to copy is going to be ctrl C and on the Mac, it's gonna be command C. I'll press ctrl C. I'll see a little animation and this animation lets me know that that cell has been selected for copying. I'll head over to the right using the arrow keys and then press ctrl V to paste. that duplicates the text that I originally copied. now press escape to release that particular option from the clipboard and now let's take a look at how you can cut information. I'm moving down the spreadsheet a little bit to bring this into focus. I'm gonna select the text in exercise 5 instead of ctrl C. I will press Ctrl X as an Exacto knife. I'm cutting some information from this cell. I'm gonna head over to the right where I see the words pasted here and I'll press ctrl V. that moves the text from exercise 5 over to the right and II 37. 

Now I want to do the same thing but I'd like to use my mouse. this time I'm gonna click on the cell that contains text right next to exercise 6 I'll move my mouse over the border the green border until I see four arrows as soon as I see four arrows I'm gonna click and drag and move that over to that outline box to the right in a 39 and when I let go I've moved the information over to that cell. In this section, we took a look at basic data entry and ways that you could enter information into your Excel spreadsheet efficiently edit text as well as copy and paste and cut and move information across your spreadsheet.

Learn More in Hands-on Training

Yelp Facebook LinkedIn YouTube Twitter Instagram