Home // Blog & Excel Tips // MS Excel PowerQuery Training Course in Johannesburg

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!


 

MS Excel PowerQuery Training Course in Johannesburg

Comments Closed
Uncategorised

In several of our recent public courses we have mentioned and shown a bit of what MS Excel’s PowerQuery can do. Due to the amount of people that are interested we are going to run a 1 day PowerQuery in MS Excel course on the 14th June 2018 in Johannesburg. To get more information email mashooda@AuditExcel.co.za.

If you don’t know about PowerQuery, it is a new free tool in Microsoft Excel that does all the data clean up you can think of.

It allows you to automate the process so that you can:

  • Pull information off a CSV file for example
  • Merge it with another CSV file
  • Remove the blank rows
  • Create a Pivot Table out of it.

Most important, these steps are recorded (like the MS Excel macro recorder) which means next month you can just replay them!

Some other highlights include the ability to merge all spreadsheets in a folder, unpivot reports, append months to each other etc.