Making Interactive Charts in Excel [How To]
Graphs and charts are amazing tools to understand the information in the blink of an eye. It not only saves you from reading at all levels. That is why charts and Excel is one...
Create Edgy To-Do or Checklists 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...
Create Data Validation lists from Unsorted data with duplicates in Excel [How To]
Today I finally decided to make an Excel dashboard on debtors aging analysis. The main reasons to do this dashboard were that:
I thought now enough knowledge has been delivered to my cult followers that...
Creating and Working with Dynamic Charts in Excel
Title should be "making charts dance to your command in Excel" but lets keep it technical :)
OK let me be very quick at it as I learnt about this almost by chance. I used...
Excel Linked Objects – Making Excel Reports that Spread the Word
Excel is good at so many things and we love it. However, when it comes to reports and presentations we rely on other applications in the office suite like Microsoft Word and Powerpoint. There...
Excel Pivot Table Slicers: Old Filters got Overhauled!
First things first, this post is strictly for those who have Excel 2010 or later installed. But is this a warning not to read this post if you have older versions? NO! The intention...
Making Birthday and Age Calculator in Excel [How To + Dedication + Prayers]
Last year the same day we learnt how to make a birth date heat map in Excel. So lets another Excel trick exactly one year after.
Lets say the date of birth is August 6, 1986....
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...
Changing numbers Sign in Excel – From Negative to Positive and Vice versa
Another question to answer and very interesting one indeed. Again this question came from our vibrant facebook community. The requirement is to change number signs that is change negative numbers to positive and positive...
Transpose Data in Excel: Shift Columns to Rows or Rows to Columns – 5...
In Excel one can easily convert data columns to rows or multiple data rows to columns which is technically named transpose.
https://www.youtube.com/watch?v=sWLAjLbNYkA
In Excel switching or rotating columns to rows or rows to columns is called...