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

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 nowWe 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 nowTo 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