Create Edgy To-Do or Check Lists with Check boxes in Excel + Shortfall calculator
The ones who like to plan adores to-do lists as well. And if you are also the one who likes to strike a line or tick or dash or mark then this tutorial is for you. As I teach ACCA and other professional qualification students and at the same time teaching several subjects it is […]
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 […]
