How to Calculate Age in Excel using Date of Birth

Let’s say you are preparing a data where user’s age is one of the important things to capture. The thing is, if you ask every user to enter his/her age, chances are they can give you an approx number.

Simple Steps to Recover Unsaved Files in Excel [Without Any Pain]

How to Recover Unsaved Files in Excel [Step by Step] There are few things which I hate from my soul and a crashed Microsoft Excel is one of those things.Just think like this, you are working on an important report and suddenly application crashed and you get a message “Excel is not responding” or “Excel […]

How to use INDEX and MATCH in Excel – The Everything Guide

INDEX MATCH, when combined, can change the approach you use to lookup values in Excel.Yes, you get it right.The combination of these two functions can match the gap of all other functions which we use for lookup.Let me tell you how.If you love to use VLOOKUP then I’m sure you have this secret pain inside: […]

How to Insert Delta Symbol in a Cell in Excel

How to Insert Delta Symbol in a Cell in Excel [5 Ways] Sometimes while working with reports and charts we need to use some sort of symbols to present a specific type of values.Take an example of Delta (Δ) Symbol which we can use to present the difference between two values over a time of […]

How to Sum Values Between Two Dates using SUMIFS

SUMIFS is the easiest method to sum values between two dates (range of dates).Let’s say, you are working in a trading company and your boss asks you to get the total sales amount for last 15 days.In this case, you need to sum sales amount from the current date to 15 days prior i.e. between […]

1 2 3 28