EXCEL COURSE : Lesson 3 - Data Formatting in Excel

This 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 the 'Home' tab in the Font category.