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.

Worth $20, Absolutely Free

Category Archives for Formulas

DATEDIF Function

Try to type “DATEDIF” in a cell in your worksheet, you won’t find anything listed with this name.Even if you check help system, there is nothing listed with this name.But, if you step back to the help system of the Excel 2000, you will find DATEDIF Function documented there.Well, it’s a mystery that why Microsoft […]

Check it out now

Convert Text To Date

Dates play an important role when we need to analyze trends. And, this is one of the most important things which we need to capture in a right way.In Excel, the right format to insert a date is mm/dd/yyyy. That’s the basic date format which is used by Excel to store dates. Apart for this, […]

Check it out now

Sentence Case

In Excel, we have three specific functions to convert text from one case to another. Whereas there is another case for which we don’t have any function or any other option.That’s ==> Sentence CaseYou might be wondering: What sentence case actually is?Well, in sentence case, for an entire sentence, the first letter of the first […]

Check it out now
1 6 7 8