VBA Loops – For, For Each, Do While and Do Until Loops

Loops are used in VBA for repeating a set of statements multiple times. Loops form a very important part of any programming language and VBA is no exception. There are different types of loops that can be used in VBA. These are as follows:1. VBA For Loop2. VBA For Each Loop3. VBA Do While Loop4. VBA Do Until LoopIn this post, I will … [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...]

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

Excel Function Keys and Shortcuts

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

Named Range in Excel

In this article we are going to learn about Named Range in Excel. Named Range gives the Excel users a privilege to provide names to a specific cell, cells (defined range of cells), formula or constant value. Named Range is supported in all versions of Excel. This article will brief you about why and how to use named range.When and Why to Use … [Read more...]

How to Use Excel Sparklines

Excel Sparklines were introduced in Excel 2010 version. It is small line chart that could be easily embedded with the text and gives a great presentable output for easier depiction when aligned next to the tabular data. They are supported in Excel 2010 and above version only. Although sparkline’s design is not limited to lines they can also be … [Read more...]

Privacy Policy | Disclaimer | About