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 19 hours of Excel 2013 training here course here: http://streamskill.com/course/ultimate-microsoft-excel-2013-training-course/

Stay in touch:
Facebook: http://on.fb.me/14m8Rwl
StreamSKill.com: http://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 the last two sections, we’ve been looking at entering data and particularly at different formats of data. I’d like to begin this third section on entering and editing data by looking at some of the other formats and then we’re going to look at editing and finally deleting data.

So let’s begin by looking at some of the other numeric data formats. If I put, for instance, the number 0.5 into Cell B11, tick. I’ve still got Cell B11 selected. Now let me bring up the Format Cells dialog. And when I type in a number like that, what generally happens is that Excel 2013 assigns a format of General. And you see the little note there General format cells have no specific number format.

Now if I typed a dollar sign in beforehand, it would’ve assumed one of the finance related formats, probably Currency. But that would depend on a couple of other things as well. But generally speaking when you’re typing in it’s quite common for the format that’s assigned to be General. If I clicked on Number, then one of the things that happen is if I assign Number Format it says how many decimal places would you like? And by default there will be two.

Note that this isn’t in Number Format yet. It still thinks it’s General. Until I click on OK on this dialog it will still thinks it’s General Format. But if I wanted to make it into a number and I wanted it to have two decimal places, I have two here. Let’s go for three decimal places. I can also say whether I want a thousand separator or not. Now whichever format you are assigning to the contents to one or more cells there will almost always be a set of other things that you can choose from and it will normally also show you the different ways that that number could appear.

So for example, here it says for negative numbers you can have a minus sign, you can have the number in red, you can have the number in braces/brackets which is really an accounting standard to show negative numbers in brackets, or you can have red in brackets. So you can choose which format you’d like for negative numbers. So that’s the option here with a straightforward number. If I click on OK, I have got a three decimal place regular number.

So let’s now try some of the other available number formats. We’ve already seen Currency. Note with Currency you can also specify the number of decimal places. I’m going to change it back to two. And you can also specify the Currency symbol. It defaults to the U.S. dollar here as I have the U.S. locale set. But you have virtually every available currency in the world is available for you there. Obviously, if you’re working in any locale you may be dealing with currency in a different locale. So you need to be able to access other options.

Accounting format is actually very, very similar to Currency. A couple of differences, one of them it deals with negative numbers in the standard accounting way. But secondly, the Currency symbol appears on the left of the cell. So if I turn 0.5 into Accounting format, it would look like this with a dollar at the left hand edge of the cell that the amount of money is in. Now, of course, when I entered this number I didn’t actually say to Excel this is an amount of money. I’ve told it that subsequently. So I could tell Excel that it actually is a Percentage. Click on OK and, of course, it’s 50.00%. Here’s another one. What about putting it as a fraction? It’s a half. And another one. What about putting it in scientific notation? That’s 5 times 10 to the minus 1.

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