Watch this five minute video to understand what we “really” mean by Remove Duplicate Rows in Excel. The default option removes the duplicate rows automatically. Most of us want to
I received a query from a customer about dynamic data labels for charts. Instead of replying directly, I thought of writing this article. This will help all of you in
Estimated reading time 3 min. Works with ALL versions of Excel. The data is a list of sales transactions, two columns – amount and date. We have 5000 transactions over
This is a frequent frustration. You copy some data which contains hidden rows and columns. You blindly assume only the visible cells will be pasted. But when you paste it,
Power Pivot Data Model adds database like features to Excel. Power Pivot allows you to handle millions of rows of data, from multiple data sources and lightening fast analysis. It
This is a common requirement. We have started some time consuming operation like adding a field to a large pivot table, or fetching data from a database, or refreshing some
Here is another short but power packed video which explains how analytics can drive growth. Read the related articles here. [youtube https://youtu.be/W2sP3n7LYMo]
Redundant or unwanted columns can confuse the users of Pivot Table. Here is how you can hide unwanted columns from appearing in the Pivot Table field list. This setting is
Let us say I want to create sample data for my analytics class for a customer. I dont have access to the actual customer data. But I want the data
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.
