Pivot Table – Show Values As – Part 2
We continue to explore Show Values As options in Pivot Tables. We will see the practical application of these options as well. Estimated reading time 10 min
We continue to explore Show Values As options in Pivot Tables. We will see the practical application of these options as well. Estimated reading time 10 min
Why do we add formulas outside Pivot Tables? Because we think Pivot Table cannot do the calculation. Did you ever check if it can? Or did you just ASSUME? Here
Current fashion is about Big Data and Analytics. One related term is very popular – Excel Dashboards. Let us start understand the concept first and then explore the benefits and
Pivot Table is used for data analysis. But did you know that it can also be used for checking data quality? Estimated reading time 7 min.
I created this Paste as Pivot utility (macro) along with Raj Chaudhuri. It helps you in copying cells from Pivot Table and pasting them as GetPivotData functions. You must read
This article shows more details of publishing Excel reports from Excel to SharePoint. Frequently asked questions are also answered. Please read Part 1 and Part 2 of this article series
In this article we will learn the actual steps of delivering Excel reports: Create a report in Excel, Publish it in SharePoint and Share it with others. Please read the
Everyone is creating and delivering Excel reports periodically – usually by mail. If you use SharePoint instead, you get some unbelievable benefits and unparalleled safety. Try this new method. Estimated
Pivot Table is based upon the current block of data.Sooner or later you are going to update the data. Creating a table eliminates the need for refreshing the new range
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.
