# Tag: BI

###### Ageing analysis in seconds (Number Grouping in Pivot Table)

Bin or Bucket Analysis is a common requirement. We will see how easy this is using Grouping feature of Pivot Table. Estimated reading time 10 min

###### How to correct spelling mistakes while analyzing data?

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!

###### Microsoft Excel: Grouping Text in Pivot Tables

Grouping is very powerful. It allows you to combine multiple related items into fewer (or one) item. The most primitive form of grouping is with Text. However, it is extremely

###### How to add calculations inside Excel pivot tables

Before you perform manual calculation, learn this option. This can save you hours of manual work. Estimated reading time 10 min

###### Pivot : Show Values As – Part 3

This article shows how to find difference from a specific value to other values in a Pivot Table. % Difference From is a very powerful way to understand your data more

###### 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

###### Add formulas OUTSIDE Pivot Tables = Inefficiency

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

###### Understanding Excel Dashboards – the practical way.

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

###### New use of Pivot Table – Data Quality Audit

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.

## 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.

## Excel to Power BI Course

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

##### Subscribe to Blog

Join 1,712 other subscribers