Day: April 22, 2014

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 »

Popular Articles

Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Subscribe to Blog

Join 1,750 other subscribers