Using Excel Power Query to Unpivot Data [Extremely Easy That It Will Shock You]

Most times when data is organized in Excel, it is done in a report format (cross tabulation) since it is easy to understand. Working with this format for further analysis can be an uphill task. It is therefore paramount for [...]

By |2018-09-14T15:33:44+03:00September 13th, 2018|

How to Combine Data from Multiple Worksheets into One Master Worksheet

One of the common headaches I have come across in the course of my career as a Trainer in Excel Dashboards is the question of how to combine data from multiple worksheets into one master worksheet, so that you can [...]

By |2018-11-27T11:44:23+03:00November 6th, 2016|
Grow your career with this FREE ONLINE video course

Zero to Pro with Excel Pivot Tables

  1. Pivot table fundamentals
  2. Save time with advanced hidden concepts
  3. Interactive Pivot-driven dashboard
  4. Intro to Power Pivot & Power Query
  5. Over 10 video lessons