Скачать или смотреть Master number formatting: use Excel presets and create custom number formats

In this video, we’ll deep dive on number formatting.

Every time we work with Excel we’re dealing with numbers. Most of the time we need just a handful of formatting options, depending on what we normally work on, like comma style or percentage style. However, it is not unusual to deal with dates, phone numbers, and other special kinds of numbers that need a specific formatting to be applied. Knowing how to properly manage these kinds of numbers will save you quite some time and headaches.

In the first part of this video, we’ll see all the standard options Excel offers you to format numbers.
In the second part, we’ll see how to create our own custom formatting styles. I’ll explain how to read special number formatting rules and how to create basically any formatting style we want.

Finally, a couple of links to deep dive the topics mentioned in the video:
Number scientific notation: https://www.mathsisfun.com/numbers/sc...
Full guidelines to customize number formats by Microsoft: https://support.microsoft.com/en-us/o...

Timestamps:
00:00 Introduction to number formatting
00:58 Overview of standard formatting options
04:26 How to create custom formatting styles
09:44 Deep dive on date formatting styles

Download the workbook and practice at your own pace: https://bit.ly/3I3AswI
The link opens a google docs page. Once there, click on File, then Download, and finally Microsoft Excel.