Microsoft Excel 2021365 - Beginner to Advanced - Applying Date and Time Formats

This video tutorial covers the basics of number formatting in Excel, focusing on date and time formatting. It explains how dates are stored as numbers in Excel, starting from January 1, 1900, and how to apply short and long date formats. The tutorial also discusses the importance of locale settings for date formats, especially when working with international clients. Additionally, it covers time formatting options, including 24-hour and 12-hour clocks, and how to apply formatting to empty cells.

What steps should you take to change the locale settings for date formats in Excel?

Describe how you can format time in Excel to display a 12-hour clock.

What is the advantage of applying formatting to empty cells in Excel?