Consolidate Cross-Tab Data in minutes
Cross-tab data is where you have row headings as well as column headings. Consolidating (combining) multiple blocks of such data is a laborious process. Usually the rows and columns do
Cross-tab data is where you have row headings as well as column headings. Consolidating (combining) multiple blocks of such data is a laborious process. Usually the rows and columns do
Here is a fast paced, 8 minute video which will revolutionize Pivot Report Sharing. Using OneDrive or SharePoint, control the visibility and provide full interactivity. Reports render instantly even with
This article is for CFOs, CEOs and other members of Senior Leadership Team. It requires just 10 minutes to read. But it will reduce your personal as well as organizational
Here is the list of articles I have written about Show Values As in Pivot table. This is a very important set of features but are mostly ignored.
Here is a new year gift for the Indian customers. Converting Amount to Words is always a problem. Many application require it and that code is always written manually, within
Table has many benefits. One of them is Table AutoFill Formulas. If you add a formula in any table column, it copies the formula automatically. Further editing of the formula
So far, I have not written an article about the humble IF function. But in the last few months I came across many customers who asked me to explain how
Please read the earlier article about Pct Difference From in order to learn the background. This article shows how to take this one step further.
A simple but very useful method. All of us use AutoFilter in Excel. The dropdown shows unique values in the column. Sometimes we just want to see the rows with
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.
