Often the data in your spreadsheets is not according to your needs, so you may need to replace some strings, split some text, merge cells or concatenate data to format the data as per your needs.In this tutorial, we are going to learn different ways to concatenate cells, columns, and ranges in excel. So, without further ado, let’s dive right … [Read more...]
VBA Loops – For, For Each, Do While and Do Until Loops
Last Updated on August 11, 2023 by
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)
Last Updated on March 25, 2024 by
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...]
How to Insert Multiple Rows in Excel
Last Updated on January 24, 2021 by
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...]
VBA Wait and Sleep Functions – Explained
Last Updated on August 11, 2023 by
Wait and Sleep functionality in programs is required to hold or pause the program execution for a specified time. These methods suspend all the activities of Microsoft Excel and sometimes may also prevent you from performing other operations on it until the pause is in effect.However, your computer can simultaneously process other background … [Read more...]
Excel SUMIF and SUMIFS – Explained
Last Updated on November 15, 2020 by
As the name suggests SUMIF and SUMIFS formulae are formed by combining SUM and IF functions. In simple English, this implies that these functions can add items or cells that fulfill a particular criterion. Let’s understand it in detail.Understanding SUMIF and SUMIFS FunctionsYou know SUM function has the capability to add items, and SUMIF … [Read more...]
VBA Substring – How to Substring in Excel Macro
Last Updated on August 11, 2023 by
Substring is one of the most popular functions in any programming language. It eases your tasks while dealing with strings. As the name suggests a substring function divides a string into different parts based on particular criteria.There are multiple VBA Substring functions. In practical situations, these substring functions can be quite … [Read more...]
Counting Unique Values In Excel – 5 Effective Ways
Last Updated on March 12, 2023 by
Let’s consider we have a long list of duplicate values in a range and our objective is to count only the unique occurrences of each value.Though this can be a very common requirement in many scenarios but excel doesn’t have any single formula that can directly help us to count unique values in excel inside a range.In today’s post, we will see 5 … [Read more...]
