Monthly Archives: May 2014

Excel VBA – What is SPLIT Function?

Split is the hardest shot to hit in Bowling. But unlike bowling SPLIT is very simple function to use in excel VBA. Splitting data or string in VBA, sometimes becomes necessary to organize it and to put it in more readable format. SPLIT-function Here in this article, you will learn about splitting the data/string which is joined [...]

Excel OFFSET Function – Excel Tutorial

Dear Friends, What is OFFSET () Function? OFFSET() is a built-in function in excel which returns a range reference which is offset a number of Rows and Columns from a specific Cell or range. Most importantly this is a function which returns Range Address and not the Value. Did you get it what it is used for? No? Don't worry [...]

Excel Trick – Sheet Protection – Protect it and Stay Free

Dear Readers, I am back with another Excel Trick which is very much common while managing your sheet with certain security (protection). To protect the whole Worksheet can be easily done by using the Protect Sheet option available in Microsoft Excel. But in this article I am going to explain you, How to protect your whole sheet except a cell [...]

Excel Trick – SMART Method to make White Background

Dear Readers,   If you are a Microsoft Excel user then you must have come to a situation where you want to show you data in a particular area and rest all the area you want to make it plane white (without lines or grid). Something like depicted in below image: How do we do this formatting GENERALLY? [...]

Custom Formula to Reverse a String in Excel

Dear Friends,   This is a very small but useful Custom Function which can be used to reverse a string in excel. In VBA (Excel Macro) there is an Inbuilt function to reverse a string but in Excel Formula there is no formula as such to reverse a string. Using that built-in function you can create your own custom formula [...]

How to create User Defined Functions in Excel

U ser Defined functions (UDF) is also known as Custom Functions (formulas) in Excel. So far, I have created many different User Defined Functions for different purposes but never told you about How to create Custom Functions in Excel in a systematic way.. Therefore in this article I am going to teach you Step by step procedure to create your [...]