VBA Split Function – How to Use

VBA, just like any other language gives you a set of functions to perform various operations on strings. And VBA Split is one of those string functions. Microsoft introduced the Split function with VBA Version 6 (in Office 2000).As the name suggests, the job of a Split statement is to break, split, or divide a string based on a particular … [Read more...]

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

How to Find External Links or References in Excel

Manually finding external links or references in a spreadsheet is a cumbersome task.  Microsoft does not have any inbuilt function that can find external references or links but still there do exist some workarounds to do this. And this is what I am going to share with you today.Method 1: Finding external References by using the find … [Read more...]

Use an Image as a Background in Excel

Generally, most of us have seen Excel as a plain and monotonous piece of software.But have you ever thought about how you can use your creativity to create amazing and attractive spreadsheets?In this post, I am going to share one such technique, here we are going to learn how to add background images in your Excel worksheets.So grab a … [Read more...]

Extract Filenames from Filepath in Excel

Getting filenames from a Filepath looks like an easy task at first sight. But actually, this is a very cumbersome task when you are dealing with a large number of file paths. Very recently I also wanted to do this task and during the process of extracting filenames, I found few methods that can automate this process.And today I will be sharing … [Read more...]

Excel Function Key Shortcuts

Function Keys in Excel are a handy and faster way of doing certain tasks by using the keyboard instead of a mouse. In this article, we are going to discuss the use of excel function keys (F1 to F12). Function keys provide the same output in all versions of Excel making it easier to recall.Before we head onto our topic, let us first know about … [Read more...]

How To Freeze Rows In Excel

Just assume you are school teacher and have around 90 students in a class which is divided into various sections. Now, you have to collate their marks in every subject in an excel.If you are using a 15-inch laptop to do this, then as soon as you go to the 25th row or later you lose the context of which column is for which subject. All of this … [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...]