Excel Functions

This category holds all the posts which are related to Functions which are very useful while writing Macros.

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

What is Pivot Table ?

As you know Excel has so many excellent features in it. Pivot Table is one of them. If you use Microsoft Excel and not used Pivot Table, It means you have missed a really great feature of Excel. Pivot table is the best tool available in Excel to Sort, Filter, Count, Sum and summarizing the data in a worksheet. A [...]

Download Free File Manager – New Version

Hi Friends, I had created one file manager in Excel using excel macro. Basically it lists all the Files in a folder and sub-folders of any given drive in your PC. It fetches File Name, File Path, File Size, File Type, Last Modified Date of each file and list it in the Excel. Based on some valuable inputs and queries, [...]

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

Excel Formula : DATE and TIME Formula

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 DATE | DATEDIF | DATEVALUE | DAY | DAYS360 | HOUR | MINUTE | MONTH | NOW | SECOND | TIME | TIMEVALUE | TODAY | [...]

How to get Excel Range in Array

Many a times while doing coding in excel, we need all the values stored in a Cell Range in an Array format. So that during any point of time we can access the value from the array, rather going in Excel Cell and reading from there. Thinking that in mind, I just created a Function (UDF - User Defined Function) [...]

Assigning Macro : How to assign macro to Hyperlink ?

So far we have always seen running any Macro or Function using a Command Button. Sometimes, instead of putting a Command Button, you want to do the same operations but by using a Hyperlink in Excel. In this article you are going to learn how to run a macro by using Hyperlink in Excel.   Follow the below Simple Steps [...]

User Defined Function in Excel to Convert Currency to Words

Many a times we require to change the Numbers in Words. For Example: 6734862=Sixty Seven Lakhs Thirty Four Thousand Eight Hundred Sixty Two. In Excel, there is no Formula as such to Convert Numbers in Words. I have written one UDF : User Defined Function. After using this Function, you will be able to change any numbers in Words. Now [...]

How to Import Delimited Text File in Excel

In this article, I am going to show, how can we export Delimited Text Files in Excel. For Example, you have a file which is Comma delimited Text file or Pipe Delimited Text File etc. This file you want to export in to Excel in such a way that Delimiter is treated as a Column. It mean wherever it finds [...]

How to get Word Count and Letter Count in Excel Formula

Dear Readers, Getting a word Count of a String kept in a Cell, is not so difficult but sometimes you just don't get it how to do it. So keeping that in mind, I wrote all possible ways to get Word Count of a String. You can get it by Excel Formula as well as UDF (User Defined Function). We [...]

Page 3 of 512345