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 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!


 

Finding Advanced Excel users

Watch our presentation on ‘Advanced’ Excel users in the business world and how to (correctly) identify them.

Our conclusion are:

  • ‘Advanced’ Excel is still undefined, but it is difficult to get away from the wording.
  • Skill levels can be assessed via MCQ type questionnaire BUT
  • Use a consistent quiz for benchmark purposes.
  • Intermediate may actually be OK (and better than the people you already have).
  • Careful thought should be given to each question (like a personality quiz).
  • Newest is not always best, end result more important than method used
  • Specific jobs require different Excel skills

Test your (or others) Excel skill level- no more awkward Excel interviews