Excel VLOOKUP – Massive Guide with 8 Examples

VLOOKUP is one of the most useful and important functions in Microsoft Excel. It is generally used to look up a particular value in huge data sheets where manual intervention can be cumbersome. The alphabet ‘V’ in VLOOKUP stands for “Vertical” so this function is sometimes also called vertical lookup.The term “Vertical” signifies that it can be … [Read more...]

VBA Replace Function – How to Use in Excel

VBA Replace is a quite useful string function in Excel VBA. Functions like replace ease your tasks while dealing with strings.As the name suggests the job of the Replace function is to substitute a set of characters in a string with a new set of characters.In Excel VBA there are two functions that can be used for performing string replace … [Read more...]

Adding Current Date and Time Stamp in Excel

Sometimes it happens that you might want to enter the current date and time stamp in your excel spreadsheets automatically. This need usually arrives because of various reasons, in my case I was urged to find a solution to it as I need to do some team management wherein I required the time my associates are spending on work daily. So, in this case … [Read more...]

NETWORKDAYS Function In Excel

The best thing about Excel is that it gives us a wide variety of options to choose from its functions based on our needs. And today, we are going to have a look at a similar function, i.e. NETWORKDAYS. Using this function in excel you can easily calculate the number of weekdays between two dates.As the name suggests, NETWORKDAYS Function in Excel … [Read more...]

Excel DATEDIF Function – Calculate Difference Between Two Dates

DATEDIF is a hidden function in Excel. As the name suggests the job of this function is to calculate the difference between two given dates.I have referred to this function as hidden because for some reason Microsoft has decided not to document this function. And because of this, you won’t find this function in the Formula Tab.To verify this, … [Read more...]

VBA IF Statement – Explained With Examples

IF is one of the most popular and frequently used statements in VBA. IF statement in VBA is sometimes also called as IF THEN ELSE Statement. The task of the IF Statement is to check if a particular condition is met or not.If you have followed my earlier posts, then you would remember that we discussed If Function in Excel. The IF Function in … [Read more...]

Excel Text Function – How to Use

Excel Text function falls under the category of String Formulas. As the name suggest the task of Text Function is to convert a numeric value to a string.This function comes quite handy when you want to display numbers in a more readable format or in such a format that makes more sense. Another situation where Text Formula can be used is : while … [Read more...]

FileSystemObject in VBA – Explained

FileSystemObject also called FSO, provides an easy object-based model to access a computer’s file system. You simply have to create an instance of FileSystemObject in VBA and then you can generate files, read files, delete files, iterate through folders, and do many other operations on your computer’s file system.The FileSystemObject is present … [Read more...]