Four ways to improve your data presentation in Excel

Excel 365 2013
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 Word 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.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.