Name Box in Excel

Name Box in Excel

Among the many awesome features in Excel, Name Box doesn’t get talked about enough. While it looks like a simple name box (just like its name says), there are some cool things you can do with it. In this article, I will cover everything you need to know about Name Box in Excel and some … Read more

Prevent Duplicate Entries in Excel

Prevent Duplicate Entries in Excel

When doing data entry work in Excel, you may want to prevent entering duplicate entries in a column or a range of cells. Thankfully, there is a feature in Excel that allows you to do precisely this – and it’s called Data Validation. In this article, I will show you how to prevent duplicate entries … Read more

Conditional Formatting Not Working in Excel

Conditional Formatting Not Working in Excel

Conditional Formatting allows you to add a visual layer to your dataset and make it easier to understand. You can use it to quickly highlight cells that satisfy the specified conditions (such as highlighting cells with the top 3 values or highlighting all cells that contain the word ‘Excel’, etc.) But sometimes Conditional Formatting may … Read more

Remove Last Character in Excel

Remove Last Character in Excel

Most of my work involves getting data from various sources, such as databases, webpages, or other people. In most cases, the first step is to clean the data and make it usable for my analysis. Sometimes, I get datasets that have an additional character in the end that I want to remove. Thanks to some … Read more

How to Square a Number in Excel

How to Square a Number in Excel

There are multiple ways to calculate the square of a number in Excel. You can use the in-built POWER function or the Caret operator (^). Let me show you how to quickly calculate the square of a number in Excel. How to Square a Number in Excel? Toggle Using the POWER Function POWER function allows … Read more

Excel Showing Formula Instead of Result

Excel Showing Formula Instead of Result

Sometimes, it happens that instead of showing the result of a formula in Excel, you see the formula itself. Below, I have an example where I have a formula in column C, and instead of showing the result of the formula, Excel shows the formula itself. This is a pretty common occurrence with Excel users, … Read more

Extract URL from Hyperlinks in Excel

Extract URL from Hyperlinks in Excel

Many of my projects involve working with data from the web, where I get hyperlinks in cells in Excel when I copy the data from other sources. Something as shown below (source): One of the first things I often have to do is extract the URLs from these hyperlinks so that I can do my … Read more

How to Add Parentheses Around Text in Excel

How to Add Parentheses Around Text in Excel

Sometimes, when working with text data in Excel, you may want to add parentheses around the text in a cell or range of cells. For example, below, I have a data set with the region name in column A, and I want to put these names in parentheses or brackets. As always, Excel offers multiple … Read more