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.


Powermap Introduction

Powermap Introduction

If you make use of Excel 2013 then you should seriously look at getting the free PowerMap add in that allows you to visualise information using a map as the background.

As a quick example we used the Currie Cup log to show the various cities and the log points of the teams. By simply highlighting the table and including the town name (that’s all you need to do- include a town name e.g. Johannesburg, Pretoria etc) and Excel will (correctly) place it on the map.

You can even create a video clip to show the results as shown below. Very useful when you want to emphasize geographically important information. The image below took about 5 minutes to create.

This is the type of thing you can learn on the Excel Dashboards course.