10+ ways to SUM Top N values in data range - Ready to be Ben 10 of Excel?
We all love to add things up. Its always good if things add up to the way we want. And no doubt from Excel newbie to pro everyone uses SUM formula. We have recently discussed how to do conditional SUM as well where we learnt to add up only those values that certain criteria. However, […]
Birth Dates Heat Map in Excel - How To
First off whoever has birthday on July the 7th my best wishes to all of them. You people have a very interesting birth date. 7 and 7. Everyone’s birthday is interesting in one or the other. But what if you like to know how the birthdays of employee in an organization are spread over the […]
Conditional SUM in Excel with SUMPRODUCT function
One of our dear member at our Excel facebook page Mr. Zeeshan Sarwar shared a problem in which he wanted to sum only those invoices amounts against which “paid on” date is mentioned. Putting it in simple words it is a conditional sum where you want to sum values on a condition if they are […]
20+ Excel Table tricks to turbo charge your data
Following are the tricks you can do with the features Excel tables offer. Following list is in no particular order. I think all of them are handy that every excel user must know to make his/her work more easy. As there are more than 20 tricks you can perform with tables, the whole article has […]
Introduction to Excel Tables - Data beyond just formatting
Many people think converting data into table is basically a formatting options giving it colours and other eye candies like giving data “zebra lines”. But there is much more to it beside data formatting and face lift that comes in terms of functionality and features that are available if data is maintained in tables. In […]
Using SUMIF with Dates in Excel
I was in the middle of making an accounting project where I had to use SUMIF. This wonderful function that everyone must know especially accountants. In many instances SUMIF can be used as an alternative to VLOOKUP function and it is much easier to use as well. However, using this formula with dates is a […]
