Get a FREE 2.4 hour Excel 2019 Beginners course here ►https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/
During this Microsoft Excel 2016 training tutorial video, we will show you the basics of entering and editing data in a workbook. We will also demonstrate how to use autofit column width to make data fit within a cell, as well as how to format numbers into currency.
Checkout some of our other training on YouTube:
VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ
Excel 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh
Access 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gbtcZ9Z3kbhk-2v65bfGeX
Project 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i1QJ6-Z91KRjFg5dzacD1O
Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF
SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge
PowerPoint 2013 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gX0kiJc3k8d31y0zTLcECq
Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/
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 2016.
In this section we’re going to start to look in more detail at how to enter and edit data in Excel 2016 and then I’m going to set you your first actual exercise on the course.
Now before I start I am once again going to be basically working with mouse and keyboard. I will refer to touch once or twice. If you are using a touch device you’ll either need an onscreen keyboard, so you’ll get the equivalent of this, or if you have an external keyboard for your touch device you need to have that setup because we’re going to be entering quite a bit of text and numbers during this and subsequent sections.
Now the other thing to bear in mind is that in this and the next few sections I’m really going to concentrating on getting the numbers in and formatting them in the sense of making sure that dates look like dates and so on. The actual cosmetics, how pretty what we’re doing looks, is something we’re going to come back to later on in the course.
Now the first thing that we’re going to do is to start work on a new workbook and to make a new workbook, you’ve already seen how to do that. You can also use a Keyboard Shortcut. The keyboard shortcut is Control-N. So there is my new workbook and what we’re going to put in this workbook is we’re going to do a very simple monthly electricity account.
So the first thing I’m going to do is to save the book with the name Monthly Electricity. There we are. And now what I’m going to do is to enter the months of the year. Now you’ve already seen that we can actually use a Series Fill feature here. I’ll come to that again in just a moment. The first thing I’m going to do is just select a cell, it doesn’t really matter which one at this stage, and I’m going to type in the first month of the year which of course is January. Now when I’ve finished typing January if I press the Enter key two things happen. First of all I leave that cell and that cell has its value January in it. But also notice that the selection, the cell selection goes to the next cell below and that lines me up well for typing in February. Now if after you’ve typed you press the Enter key by default the cell that’s selected next is the cell below the one you’ve just typed in. But if instead of hitting the Enter key I’d used the Enter, the tick mark on the Formula Bar, and if I used that now after typing February watch what happens. February is entered but I’ve now still got the same cell selected. So although I’ve got the same content my next selection is different depending on how I terminate entry of data into a cell. If I now want to go to K10 I can of course click in K10, enter March and of course now I’ve got the same options but also I can terminate entry in a cell by just clicking anywhere else on the sheet.
So it’s important to recognize that when you’re entering data what happens after you’ve entered that data depends on essentially what you do at the end of the data entry.
Now the next thing I want to do is to use the feature that we saw before to get all of the months of the year in quickly without having to type them all. So I’ve selected January. I’m going to use the little symbol at the bottom right hand corner of the border there, drag down the requisite number of months, release, and I have all of the months of the year.
Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.