Four ways to improve your data presentation in Excel

Excel 365
Using simple tricks, you can convert your Excel spreadsheet from a table with rows and columns to an interactive application that will help you to represent the data more appealingly and conveniently.

   1.   Add a watermark text or a picture to the workbook with your company branding

Watermark in Excel 2016

See Adding watermarks to workbook for more details.

   2.   Add a background picture by choosing a graphics file to serve as a wallpaper for a spreadsheet like the wallpaper that you usually see on your Windows desktop:

background in Excel 2016 spreadsheet

See Adding a background image to the spreadsheet for more details.

   3.   Use conditional formatting to highlight cells in the worksheet:

Example of Conditional Formatting Rule in Excel 2016

See Applying Conditional Formatting for more details.

   4.   Use the drop-down list to simplify entering a value from the predefined set like countries, states, types, etc.

Drop-down list in Excel 2016

See Creating a Drop-Down List in a Cell for more details.

See also this tip in French: Quatre façons d'améliorer votre présentation de données dans Excel.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.