Excel Pivot Table – Introduction: What, Why and How for Absolute Beginners [1 of...
Excel is surely a cavalry of features. And if we count the ways in which each feature can be useful just makes the whole think almost countless. However, for every feature one must know...
Excel Find based on cell formatting – When appearance matters
Most probably you might have not found this little find option in Excel i.e. find by cell formatting. Basically it let you include additional condition to find only such results that hold specific format...
10+ ways to SUM Top N values in Excel data range – Ready to...
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...
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...