VLOOKUP based text grouping in Microsoft Excel
You must read this article first: Grouping Text in Pivot Tables. This article explains how to combine multiple text items into a single group. This is used for classifying or
You must read this article first: Grouping Text in Pivot Tables. This article explains how to combine multiple text items into a single group. This is used for classifying or
Power BI and Power Map support mapping your own data using Latitude and Longitudes. Lat-longs are available in various formats. Power BI supports only decimal format. Unfortunately lot of data
Although Power View and Power BI reports are similar, Microsoft is focusing on the later. Power BI platform is being separated out from Excel for many reasons. One of the
I work with many customers on Power BI. It is a new topic for many users and decision makers (not techies). The benefits of using Power BI are obvious and
FormulaText function in Excel was introduced in version 2013. It requires just one parameter – the cell from which you want to display the formula. Even if you select a
This is a picture blog. Self-explanatory! Learn how to Sum visible cells only using the Aggregate function. Works only in vertical direction (not horizontal). It is best to use it
This is the continuation of the earlier article about Validations. Data Validation using Formula is not very well understood. Hence this article. Try it out and you will immediately know
This is a very old feature. But it is still very useful. Spend 10 minutes to learn where you should use and not use Range Names in Excel.
Le The more I work with customers, the more I realize that data quality is still a very big problem. Data Validation in Excel is an effective solution to this