PRDV007: Spreadsheets III: Presenting Data

When presenting information, it helps to add shapes to highlight your main points. Excel has ready-made shapes that can be inserted into your spreadsheets and charts.

The figure below displays the graphical elements you can include to emphasize or enhance the visual appeal of your data.

Figure 3: Shape Options

When sharing your spreadsheet or chart, you may want to add a hyperlink to another worksheet, workbook, or external site on the web. For example, if your spreadsheet is for a business, you may want to link to the website so your spreadsheet’s audience can easily access it.

We often need to add symbols, such as letters from other languages, to your Excel graphics. You may also use WordArt to emphasize a title or add important information to your spreadsheet or chart, and SmartArt can be used to create diagrams and graphics to illustrate concepts.

Conditional formatting can be applied to cells to visually highlight and analyze data based on specific criteria or conditions. You can automatically format cells based on their values, making identifying patterns and trends easier.

The figure below shows how you can use conditional formatting to emphasize important data points and trends.

Figure 4: Conditional Formatting Options

You can add headers and footers to your spreadsheet to reference the title, author, or date it was created. This is helpful for record-keeping if you print your spreadsheet or share it with others.