Month: April 2014

LogoImages Folder

Many people ask me – “You teach so many people, but how do you learn?” I will post specific details on learning methodology later. But periodically, I post this type

Read »
Excel: Consolidating crosstab data

This is a continuation of the Data Cleanup series. One common form of bad data is called crosstab. Consolidating crosstab data requires lot of manual effort. Pivot – Multiple Consolidation

Read »