Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a free 3 hour Excel 2019 course from Simon Sez IT ️ https://www.simonsezit.com/four-free-courses

Whether it's words or numbers, learn how to enter and edit data in Excel 2013. There are two ways of doing this--either by using a mouse and keyboard, or by using a touch screen. Find out how to fill in data vertically or horizontally, how to make a column wider, how to apply a command to multiple cells, how to use the formula bar, how to specify the kind of data you have put in, and more! Watch a more detailed discussion in this video.

Get the full course on Excel 2013 course here: https://www.simonsezit.com/course-category/excel/

Stay in touch:
Facebook: http://on.fb.me/14m8Rwl
StreamSkill.com: https://StreamSkill.com/
SimonSezIT.com: https://www.SimonSezIT.com/
The Simon Sez IT email newsletter: http://bit.ly/18bMwY0
YouTube Channel: http://bit.ly/foiItB
Twitter: http://bit.ly/177EU5J
Google+: http://bit.ly/11JbHdb

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)

Hello again and welcome back to our course on Excel 2013. In this section, I’m going to start to look at entering and editing data. Now I’m going to concentrate on getting the data in, whether it’s words or numbers, on changing data, selecting data, filling rows and columns, and so on rather than the actual formatting. We’re not concentrating so much here on making it look good. We’re concentrating on getting the data in. In subsequent sections we’ll look at the formatting side.

Now in order to follow through this section, you’re going to need to have a way of entering numbers and letters. If you’re using a mouse and keyboard that’s absolutely fine. If you’re using a touch screen, you probably need now to use your on-screen keyboard. This is a touch devise. I have got an on-screen keyboard and I’ll just quickly enable it to take a quick look at it. Now you can see it there sort of super size. You should know how to enter letters, switch to upper case with the Shift key and back again, and then obviously entering numbers and some special characters. We’ll be using things like finance symbols, dollar signs. We’ll be using at signs, exclamation marks, and various other punctuations characters.

So make sure you know how to enter those in order to be able to carry on with this section of the course.
So let’s start with some really straightforward data entry. I’m going to create a new workbook. I’m just going to start with a blank workbook and by default the selected cell, we talked about selected cells before, is Cell A1. And I’m going to type in A1 the word Hello. Now if at the end of typing the word Hello and before I do anything else, I press the Enter key what happens is this, two things. First of all, what I’ve typed in A1 stays there. So the word Hello is in A1. And the selected cell moves down to A2. So if I now type World, press Enter again, World stays in A2 and the selected cell is now A3.

Now this is the default behavior with Excel when after typing into a cell you press the Enter key. And as you go forward, you’re basically filling in a column of data.
Now to start entering data anywhere else on the sheet, all I have to do is to click or tap in the cell. So let me click in that cell, start typing 1-2-3, press Enter, 2-3-4, press Enter, 3-4-5. You notice that the same pattern continues, although in this case when we put numbers in the numbers are pushed to the right of the cell and the words to the left. I’ll come back to that in a while. If you’re using a touch screen pretty much the same. Tap somewhere, type what you want to type, and then other than that the behavior is exactly the same.

If you wanted to fill in things in a row, horizontally, then you would really need to click into successive cells to do it in a very straightforward way. So click or tap to go across the row. So that’s the basics of filling in cells on a sheet and, of course, they don’t have to be adjacent cells. You can click anywhere you like, put data in anywhere you like on the sheet.

So let’s now look at a straightforward case of setting up some data just by entering it straight into a worksheet. And what I’m going to do is to start to enter a list of somebody’s expenses. These are expenses related to work but they could be domestic expenses as well. So let’s close the current worksheet and we’ll start a nice new empty one.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.