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. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'



AE Newslettter: What is Advanced Excel, Unhide rows not working, Excel not recognizing duplicates

What is Advanced Excel, Unhide rows not working, Excel not recognizing duplicates

In this issue:


Cleaning up Data in Excel

We have recently 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

Next Excel Courses

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

Unhide rows not working in Excel

Have you tried to unhide rows in Excel and it refuses? This could be as a result of a number of reasons.  Read more

What is an Advanced Excel user?

In Excel it is very difficult to identify the abilities of an Advanced User. Do you need to know VBA and array formulas? Read more on our understanding of an Advanced Excel user  Read more

Excel not recognizing duplicates

Excel is seldom wrong. So if it says there are no duplicates, then there are no duplicates. But the reasons for this may be difficult for a human to see.   Read more

Pro and Cons of Public, ON Site and Online Excel Training

The pros and cons of learning Excel in a public course, onsite course or online course 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