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!


Excel VBA Training in Johannesburg, South Africa

We are running a 2 day Excel VBA Training in Johannesburg, South Africa.

The course will be held from the 11th- 12th April 2013 (for more dates visit the calendar)

If you are interested please go to VBA Training  for more details. Below is a summary of what the course will cover:

  • Introduction To Vba in Microsoft Excel
  • Record A Macro
  • Understanding Objects
  • Record And Edit An Append Dates Macro
  • Excel Object Model
  • Organising Macros
  • Record A Simple Goal Seek Macro
  • Understanding Input Boxes
  • Understanding Variables
  • Create A Sheet Sorting Macro
  • Decisions / Looping
  • Understanding Message Boxes
  • Debugging Macros
  • Understanding Arrays
  • String Functionality
  • Finalising The Sort-Sheets And Loan Goalseek Code
  • Form Controls (Vs. Activex Controls)
  • Userforms
  • Interfacing With Other Windows Applications
  • User Vba Casework
  • Custom Functions

If you are not sure whether you are skilled enough ask us about our free Excel skills assessment.