Bad Data to Good Data: Fill gaps using Power Query
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
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
Immediate action required. Control Panel – Windows Update – Check for Updates. Adobe also released important patches. Also update Power Query – the Excel add-in which helps you get and
In an earlier article, we discussed how to analyze FaceBook posts using Excel. Now let us see how Twitter data can be analyzed. This article explains how to analyze your own
This is the third article in this series. Please read these articles as well: Auditors, Risk Managers: Excel spreadsheet analysis using the new Inquire tool Spreadsheet Analysis using Inquire –
Please read this article first: Auditors, Risk Managers: Excel spreadsheet analysis using the new Inquire tool In this article, we discuss how to use the Relationship Diagrams using Inquire tool.
These two roles require extensive work with complex workbooks. Auditors need to understand and validate large, complex workbooks in a time bound manner. Risk managers work with complex models with
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
This is a post for developers or those who know PowerShell Script. To understand the context, please read these two posts… This article and the code is contributed by Raj Chaudhuri –
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.
