Four ways to improve your data presentation in Excel

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 date in a more appealing and convenient way.

    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 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 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.

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.