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|

How to Consolidate Data from Multiple Worksheets in Excel

Do you have data in multiple worksheets that you wish to aggregate into a single sheet? Then this article is primarily written to address just that -how to consolidate data from multiple worksheets to a summary worksheets in Excel. [...]

By |2018-11-27T11:15:55+03:00November 6th, 2016|

Using Excel Macros to Combine Multiple Sheets

Using Excel macros to combine multiple sheets is one of the ways to greatly enhance productivity by automating and speeding up the process, especially where the number of worksheets are many. This article is part of the 3 approaches we’re exploring. If [...]

By |2018-11-27T12:12:38+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