Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

10000+ Copies Already Downloaded

Category Archives for Formulas

How use DATEDIF Function in Excel

DatedIF function is the best tool to calculate your age from date of birth. Ahead In this post, I will show you how to use the DatedIF function in excel, why it is a useful & worth to learn. Use of DatedIF DATEDIF Function In Excel will be your buddy if you want to calculate the […]

Check it out now

How To Convert Incorrect Date Formats Into Correct Dates

We have already learned in Basic Date Functions that dates are the base of all the data & trend analysis. But, sometimes it is very nasty when we got some dates in a non-standard format. In these conditions, we have to correct date format by using some formulas and functions. Using formulas doesn’t mean that […]

Check it out now

How To Convert Normal Text To Sentence Case In Excel [Trick]

To convert a normal text into a Sentence Case In Excel using a single formula is not possible unless you write a UDF. We have text formulas to convert a normal text into upper case, lower case & proper case. But not a particular function for Sentence Case. But, good news is that we can use these formulas for converting a normal text string […]

Check it out now
1 5 6 7