Grouping in Pivot table is one method of spelling mistakes correction. Here is another option for correcting mistakes using VLOOKUP. Estimated reading time 10 min Estimated Time Saving many hours!
We take accuracy of Excel data for granted. Often the raw data as well as results of formulas can be wrong, outdated or misleading. Here is a collection of 13
Converting data from multiple columns to one column is a common requirement and we struggle to get this done. Very often we would have to resort to manual cut and paste.
The query keeps cropping up very often while I work with customers. There are many ways to handle it. Here are three ways to do it. Simple Copy Paste, using
This is a common activity. Go to a browser page, find some tabular data or report and copy-paste it into Excel. Now you waste a lot of time cleaning up
Experts tell us the best practices. But we do lot of mistakes before we can find the best way. Documenting the mistakes – which is what I call “Worst Practices”
This is a continuation of a series on how to convert badly formatted data into an easy to analyze – tabular format. In this article, we are talking about data
Read the the article Consolidating crosstab data before reading this article. In this article we understand how we can use Multi-column, Row Heading Cross Tab data consolidation using Power Query.
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
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.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
