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.

 

AE Newsletter: New Online Data Cleanup Course, Repair Corrupt Files, tables slowing Excel down, Excel and BI

New Online Data Cleanup Course, Repair Corrupt Files, tables slowing Excel down, Excel and BI

In this issue:

New Online Course

We have just launched our new online course covering cleaning up data in Excel. Taking material out of the live 3 day course we have specifically targeted this course at people who regularly receive spreadsheets from different systems and need to rework it.

Areas covered in the course include

So if your data looks like this, you need this course. For the next week, while we are ironing out the glitches it is available for half price

excel-data-cleaning-fundamentals Next Excel Courses

Email us if you need more details or visit the calendar page

Repairing Corrupt Files

If you have lost data because of a corrupt Excel file, have a look at some of the things you can do about it.  Read more

Data Table Slowing Excel

If you use Data Tables and your Excel seems slow, or takes long to save you should…  Read more

Future of Excel and BI

“What is the most used feature in any business intelligence solution?”- It is the Export to Excel button..  Read more

How to use the new online courses

Instructions on how to use the new online Excel training course. We will be launching modules of the live courses over the next few months. Read More

Excel Skills Assessment

Did you know that our Excel Skills Assessment is now being used by overseas companies to assess their entire workforce? Read More