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.


Excel PowerPivot

Excel PowerPivot

A new tool that will be making a big impact on business people is the Excel PowerPivot add in which is available for Excel 2010 and later versions. It has been described as the best thing to happen to Excel in years.

Effectively it addresses all the shortfalls of traditional Pivot Tables and adds extra functionality. In terms of Business Intelligence it is now possible to do sophisticated analysis with the tool that is already on your computer.

The added benefit is that it is based on Excel and is so similar that there is very little new to learn. We have shown the differences between Excel and PowerPivot here .

If you need to work with datasets that have more than 100 000 rows (and up to 100 million rows) and/ or you need to combine various data sets to create new business intelligence then you must start to learn about this tool.