Latest Blog Posts

How to Split a Sheet into Multiple Sheets Based on Rows in Excel

Observe the GIF. The sample dataset (B4:C10) showcases  employees and their working hours in Sheet1. To split the sheet into multiple ...

How to Use COUNTIF with WEEKDAY in Excel (3 Methods)

Dataset Overview Let’s say we have data from a supermarket that includes the staff’s duty schedule. In this example, we’ll explore how to ...

How to Remove Strikethrough in Excel (3 Ways)

To demonstrate our methods for removing strikethroughs from text in Excel, we'll use the following dataset: Method 1 - Using Keyboard ...

How to Remove Extra Spaces in Excel (5 Easy Ways)

This article describes 5 ways to remove extra spaces in Excel. Here is an animated overview: We'll use the dataset below, and remove ...

How to Remove Parentheses in Excel?

In this article, we will demonstrate 4 easy methods to remove parentheses in Excel. What Are Parentheses in Excel? In general, ...

How to Remove a Circular Reference in Excel – 2 Methods

Circular Reference: An Overview When a cell formula in Excel refers back to its own cell either directly or indirectly, it’s called a Circular ...

How to Check If a String Contains Another String in Excel Using VBA (6 Methods)

Method 1 - Checking for Substrings Open the Visual Basic Editor by pressing Alt + F11 or navigating to the Developer tab and clicking on Visual ...

How to Remove Formulas in Excel – 8 Easy Methods

A sample dataset is shown below. Download Practice Workbook Download and practise. Removing Formulas.xlsm How to Remove ...

How to Remove the Dollar Sign in Excel – 7 Methods

The pre-formatted dataset shows the dollar sign ($) before the Price value. Method 1- Using the Format Cells Feature to Remove the Dollar ...

How to Edit Macros in Excel (2 Ideal Methods)

Here's an overview of using the Macros option to edit macros in a sheet. How to Unhide a Macro in a Personal Workbook Your macros can be ...

How to Find a Circular Reference in Excel (2 Easy Tricks)

Sometimes we input an Excel formula in a worksheet but it’s not working for some reason. It shows a warning prompt instead which mentions Circular ...

How to Insert a Total Row in Excel (4 Easy Methods)

We have a sample dataset below of different items, their prices, quantities purchased, and total prices. We will insert a total row in this dataset ...

How to Find an Exact Match Using VBA in Excel (5 Easy Ways)

Suppose you have the following dataset: Method 1 - Find an Exact Match in a Range of Cells Steps: Press Alt+F11 on your keyboard to ...

How to Remove Space Before Text in Excel (4 Methods)

  How Space Before Text Affects the Dataset? Space(s) before the text can create a lot of trouble to analyze a dataset. It may give you wrong ...

How to Trim Text in Excel

Sometimes we need to trim space or character from an entire text in Excel to make the dataset attractive. We can use different Excel functions like ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo