Advance Excel , lesson 3 - Data Formatting in Excel

This video covers the basics of data formatting in Excel.

You can format data in Excel to make it look better and to highlight some data points. For example, if you have data-set and you want to highlight the negative numbers, you can simply highlight it in red color to it.

Here are some of the common formatting I use to make my data look better and more readable

Applying borders to all cells
Making headers bold
Giving a background cell color to headers.
Center align the headers
You can find these options in Home tab in the Font category.