Now: October 2017 Webinar On Doing The Seemingly Impossible With PowerQuery and PowerPivot

, , No Comments

There are many common tasks that I see people spend hours or days on in Excel, and that's if they don't consider impossible them and give up trying to do them.

Some of what I will be covering are:

  1. Automatic update (using refresh) of reports built from numerous files as more files are added (like having year till date report or national sales report automatically update as individual report files from the different months or regions/branches are sent to you regardless of the names they are saved with)
  2. Unpivot data (better seen than explained, so don't miss this segment)
  3. Pivot data
  4. Better and more advanced Text to Columns, can also do Text to Rows (will illustrate)
  5. Extracting data from the web, with daily refresh capability
  6. Analysing your social media activities or digital marketing campaigns (Facebook in particular)
  7. Working with over 1.05 million rows of data (more than you can fit in one Excel sheet)

You shouldn't miss this webinar. Create a reminder; add it to your calendar.

Date: Tuesday, October 31, 2017

Time: 3:00pm to 4:00pm (GMT +1)
Venue: YouTube live (

As usual, I will be using real world type of data and illustrations.

To constantly be in the loop of all our webinar events, especially the monthly webinar on valuable features of Excel and Business Intelligence, subscribe to our Webinar Directory.

See you!


Post a Comment

You can be sure of a response, a very relevant one too!

Click on Subscribe by Email just down below the comment box so you'll be notified of my response.