Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

Improve your Excel presentations and dashboards with free stock images

A recent addition, it is now possible to access and include stock images into your Excel spreadsheet. This is a useful way to improve your Excel presentations and dashboards.

YouTube Free Stock Images in Excel

Accessing Excel’s free images

Let’s say we are building a financing spreadsheet and need to add some graphics to make it more visually appealing and get our message across.

In Office365, you can go to

  • Insert, then
  • Pictures and
  • you will see an option for Stock Images.

As shown below there are a number of options and using the search feature you are bound to find  an image that will get your story across. Below we have searched for the term ‘finance’ as we are building a financing spreadsheet.

improve your Excel presentations and dashboards

Once you have chosen your image, just click insert. You can then resize it and place it in the correct place.

The most important part of an Excel Dashboard

Conditional formatting without numbers

Excel dashboards and management reporting course