Excel Formula

This is about Excel Formula

Send Image of a Range from Excel embedded in Mail [Inline Image in Mail]

Dear Friends, Couple of my friends asked me about this like how can I send screenshot of a particular range area of my excel sheet embedded in my HTML mail with other texts in my email. I also got this question on Microsoft Excel forum where I answered that question by providing a piece of code. Though there were some [...]

[Video Tutorial] How to add controls like command button in excel [For Beginners]

Hello friends, I have created a Youtube channel where I am going to share many more recorded video tutorials for beginners, intermediate and advanced users. Don't want to miss any of the video? Then Subscribe to my Youtube Channel. Subscribe my channel on Youtube Do not forget to share and comment your thoughts about the video tutorials in the comment [...]

Wish you Merry Christmas & happy Holidays

Happy Holidays To wish you and your family a very Happy Holidays and Merry Christmas, I have prepared an Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet with the help of simple bubble graphs, formulas and a simple VBA code to Start and Stop the animation. Wish you a very Happy Holidays and [...]

Spreading data across Columns in Excel Without VBA Code

In my previous article as you learnt how to split data using VBA SPLIT() function. In this Article I am going to explain you how to separate the data across columns of a cell without excel VBA. Microsoft Excel has a built-in function called Text-to-Columns under Data ribbon (refer the Pic 1). Using this option user can split the data [...]

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 [...]

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 Function in Excel

Dear Readers,   User Defined functions (UDF) is also known as Custom Functions (formulas) in Excel. Previously I have created many different User Defined Functions for different purposes but never told you about How to create Custom Functions in Excel. Therefore in this article I am going to tell you stel by step procedure of creating Custom formula in Excel. [...]

Email ID Syntax Validation in Excel

Dear LEM users,   I got quite a few questions regarding How to enforce Email ID syntax validation in Excel. It could be in a particular cell or any textbox etc. So i thought of putting this small excel VBA tip which may help a lot in enforcing this validation. This small validation trick will make your excel intelligent and [...]

Pivot Table Tutorial : Make Pivot Table in 15 Seconds

Hi friends, In the previous article of Pivot Table, I had explained basics about Pivot table and how to make a pivot table in Excel. This is just an extension to that article. Here I have created a Shortest video to show How to create Pivot table in Excel. Watch the below video and you learn how to make Pivot [...]

Excel Formula : MATHEMATICAL Formulas

Want to know about most of the Important Formulas in Excel? Read Excel Formulas Tutorial Page.   Click on the below links for to know about all these Formulas and how to use them ABS | CEILING | COMBIN | COUNTIF | EVEN | FACT | FLOOR | INT | MINVERSE | MMULT | MOD | ODD | PI | [...]

Page 1 of 3123