Count Specific Weekday or Weekdays within Data range containing Dates
Often we have to deal with dates as they form integral part of almost every data set. But what if you want to count...
Multi level or Multi column sort in Excel – How To
Before in Excel tips we learnt about Custom Lists feature in Excel and how to use it to sort and have custom autofill series....
How to make a basic Tax calculator in Excel
Business and Taxation go hand in hand. However, taxation calculations are most of the time tedious and if you need to make a small...
Excel Pivot Tables – Grouping Data by Date and Time
Where reporting is about numbers and analysis, the big part of it is also about time. And to best understand the situation you sometime...
Excel Custom Shortcuts – Reaping real benefits of Quick Access Toolbar
Many excel beginners especially those who are using version 2007 and later a small bar which is by default placed above ribbon alongside the...
Highlight Excel errors in the worksheet using Conditional Formatting [Quick Tip]
In my last Excel article I discussed different types of errors we can run into while working in Excel with reasons and solutions to...
Entering data on multiple Excel worksheets in one go
If you have several excel sheets to work on and all the sheets share exactly the same data with exactly the same format. Than...
My Top 10 personal favourite Excel keyboard shortcuts
Everybody has preferences and likeness towards Excel keyboard shortcuts and I am no exception. So here is my personal top 10 list of Excel...
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...
How to convert numbers into words in Excel – VERY QUICK TIP
I have been working on a small piece and I came across one requirement that in letters to customers in addition to amounts reported...