How to Sum visible cells only in Excel
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 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
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
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.
