Skip to content

Category Archives: Excel

In this article, we explain two different ways to break links in excel.  When we move a sheet from different workbooks.  There are chances of… Read More
A dynamic named range expands automatically when you add values to the range. To better understand this concept let’s take a look at the below… Read More
We have two options to refer a cell in excel VBA Absolute references and Relative references.  Default Excel records macro in Absolute mode. In this… Read More
Most often we need to split cells for text processing [Eg.  Split Last Name and First Name from Customer name field].   We explore two… Read More
We have two options to refer a cell in excel VBA Absolute references and Relative references.  Default Excel records macro in Absolute mode. In this… Read More
You can record a macro in excel or write from scratch in VB Editor.  Excel provides different options to run a macro.  In this article,… Read More
We often need to report Unique customers/products/items from a given data for data analysis. In this article, we explore two different approaches in excel to… Read More
Descriptive statistics is all about describing the given data. To describe about the data, we use Measures of central tendency and measures of dispersion. Measures… Read More
Most often we receive “ID fields” as alphanumeric strings.  We have to extract only text from “ID fields” for further process.   In this article… Read More
In Power Query, we have an option to Combine two tables using “Merge queries”.   Merge Queries: Merge with current query with another query Merge… Read More
Infographics are the best option to capture user attention and effectively convey the information. We explain step by step how to create a simple infographic… Read More
Excel is one of the best tools for data analysis. It is a place where you can organize your data in the best way. Excel… Read More
When you open the excel sheet, you see a cross-section of rows and columns with grey colored lines. Those gray colored lines are known as… Read More
Excel is the world where you can organise your data. Organising data is a very big task especially when you are doing it on a… Read More
Have you ever wondered you keep searching data on Excel but it is not returning any values and many times you are trying to add… Read More

Start Your Coding Journey Now!