Get 20-hours of Excel 2016 training here ► https://www.simonsezit.com/course-category/excel/

During this Microsoft Excel 2016 advanced training tutorial video, we will take a look at the important aspects using of date and time function, particularly the date and time processing. We will show you an example of how to develop a company invoice in Excel.

Check out some of our other training on YouTube:

Excel 2016 advanced training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3h5ZVxzp_a4UHRQBtXXgnxf

Excel 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hFUdlWMkTLZL-Fr3oRGN35

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Project 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g_ABHdUU7RoGJJm-YFr4_Y

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

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 Advanced.

In this section we’re going to start to look in some detail at dates and times and at Date and Time Functions in Excel 2016.
Now of course the use of dates and times is absolutely fundamental in Excel and yet for many people there are aspects of the use of dates and times that are completely baffling and cause them all sorts of problems. So what I’m going to do starting in this section is to explain in some detail how dates and times work and then to look at some of the main functions that you’re going to need to be able to be pretty familiar with in order to handle any kind of Excel application that requires the use of dates and times.

Now before we begin let’s start with one of the things that I think is at the root of many people’s problems with dates and times and that is that ideally you will have the Date and Time settings on your device set correctly before you even start to use dates and times in Excel.

Now I don’t mean by that that you’ve got the right date and time set but I meant that you’ve got the format set. And although there are some relatively minor differences in how these default settings are handled in the versions of Windows on which Excel 2016 will run, fundamentally the approach is the same. You need to start by going to Control Panel and you need to look at Region. Click on Region and you get this little dialog. As I pointed out to you earlier in the course my default language is set to English United States. And in this dropdown here my selection Match Windows Display Language means that my regional settings generally will match English United States. Or the dropdown here where I could choose a different language to determine these settings.

So for example, if I went for English United Kingdom my short date format would be day, month, year. Whereas if I say match Windows Display Language it is of course month, day, year. Now you’re probably familiar with what the little D’s and big M’s and so on mean but I’ll come back to those in just a moment.

But the important thing to realize is that these are my default settings. And whilst I’m working on Excel if I don’t change anything else, if I just insert dates and so on these determine how they will appear, same is true of time as well. Now it may be that in a particular workbook I need some different settings. It may be that even in individual cells I need different settings and that’s fine. I’m sure you know how to change the date or time format in a cell. But if you find that you always have to change the short date format and you think, “Why can’t it be the way I want it to be?” You almost certainly need to change it in your default settings here. Changing the short date format, for example, is really easy.

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