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 [...]
How to convert dates formatted as text in Excel
One of the key processes as an analyst while creating reports is to cleanse data from inconsistencies. Sometimes it [...]
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 [...]
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 [...]
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 [...]
From 4 hours to 1 minute filling in blanks in Excel
Save 99% of Time Spent Filling in Blanks in Excel Every time I’m training staff from various corporates [...]