Excel OFFSET Function – How to Use

The OFFSET function is one of the most enigmatic Excel functions that may take a while to wrap your head around. But I will ensure that by the end of this tutorial, you would not just be able to understand what the Excel OFFSET function does, but also learn how you can use it in your own worksheets.OFFSET is an in-built worksheet function … [Read more...]

Excel Flash Fill – How To Use

What is Excel Flash Fill, and more importantly, what is so special about it?Flash Fill is a special tool in Excel that can automatically fill in values for you once it recognizes a pattern in the data.Have you ever wondered if Machine Learning exists in Excel? And if it does, where does it exist? Flash Fill is one of those tools that use … [Read more...]

Excel FIND Function – How to Use

The FIND function is a built-in Worksheet Function (WS) in Microsoft Excel, which you can use to locate a sub-string or a specific character's position within a text string. It is categorized as a TEXT function in Excel.If the FIND function fails to find the text, it will return a #VALUE error. Note that the Excel FIND function will perform a … [Read more...]

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 an essential part of any programming language, and VBA is no exception. There are five different types of loops that can be used in VBA. These are as follows: For Loop For Each Loop Do While Loop Do Until Loop Wend Loop (obsolete)In this … [Read more...]

How to Insert a Checkbox in Excel (In 5 Easy Steps)

Inserting a checkbox in Excel is an easy task. The checkbox control is available in the Excel developer tools option. Checkbox and other controls like dropdowns can be quite helpful while designing forms in Excel.These controls prevent users from entering some unwanted data in your forms, and hence they are preferred.In this post, we will … [Read more...]

Excel IF Function – How to Use

IF function is undoubtedly one of the most important functions in excel. In general, IF statements give the desired intelligence to a program so that it can make decisions based on given criteria and, most importantly, decide the program flow.In Microsoft Excel terminology, IF statements are also called "Excel IF-Then statements". IF function … [Read more...]

Round Function In Excel – The Complete Guide

Microsoft Excel provides multiple formulas to round numbers. We have formulas like - ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD, and they all can be used to round numbers in excel.Rounding is the process of removing the least significant digits from a number so that we are left with a simpler value that is … [Read more...]

How to Insert Multiple Rows in Excel

In the last few decades, Microsoft has grown by leaps and bounds and so are its fabulous products. Microsoft Excel is one such product that has grown immensely. It has wonderful features and options to make your tasks easier. But one feature that it lacks is the ability to insert multiple rows. The default insert option that Excel has allows you to … [Read more...]