Related Data Validation Lists
A very cool use of data validation is making related data validation lists. If your worksheets includes multi level data entry, this is a very...
Beat Excel! Get to next level in Excel!
Hyperlink
Hyperlinks lets yo link your content to other contents within or outside of your workbook. Be it another sheet or another workbook, even a web...
Excel Data Validation
There is a way to restrict user input in excel. This can be achieved by Data Validation.
HLOOKUP Function
Do you need to fetch certain values from a list searching horizontally? Than HLOOKUP function is for you.
Excel Scenario Manager
Would you like to know results of several scenarios for your calculations with one click? Or lets say you are about to buy a car...
Excel Text Functions
There are a total of 24 functions that are categorized as excel text functions. Though we are all sure that all of them are...
