Advanced Excel

How to Populate a List Based on Cell Value in Excel (6 Ways)

In MS Excel, sometimes we may need to determine or find values based on some criteria or condition from a list. Assuming we have a task plan with the ...

How to Auto Populate Cells in Excel Based on Another Cell

How good would it be if cells get filled automatically? Most of the time we will love that. Today we are going to show you how to auto-populate cells ...

How to Split One Cell into Two in Excel (5 Useful Methods)

When you import data from a database or any other sources, you have to split cell one into two or more in such situations. In this tutorial, I’m ...

Excel Split Cell by Delimiter Formula

This tutorial will show you how to split cells with the help of a delimiter in Excel. A delimiter is a character that separates chunks of data within ...

Excel Convert Number to Text with Leading Zeros: 10 Effective Ways

Leading zeros aid predominantly to specify the length of a number. In the case of maintaining records such as any special identity number, zip code, ...

How to Convert Numbers to Texts/Words in Excel

Spreadsheets are used by many people in their daily jobs, making them an important element of their office. While the majority of people use ...

Excel Copy Rows from One Sheet to Another Based on Criteria (5 Ways)

In MS-Excel sometimes we need to copy rows from any worksheet to another worksheet based on different criteria. In this article, I will show various ...

How to Remove Commas in Excel (From Text & Numbers)

In this article, I will show you how to remove commas from the names (placed in the middle/in-between/last) and the numbers in Excel. Download Excel ...

Division formula in Excel for multiple cells

Do you want to know how to use the division formula in Excel for multiple cells? You are in the right place. Let’s start… What is the division ...

How to split a single cell in half in Excel (diagonally & horizontally)

Do you want to know how to split a cell in half in Excel (both diagonally and horizontally)? Want to know how to split a single cell diagonally ...

How to divide columns in Excel (Top 8 easy & quick ways)

In this article, I will show how to divide columns in Excel. I will show several ways. Choose one that best suits your job. So, let’s start. ...

How to insert square root symbol in Excel (7 easy ways)

In this article, I will narrate how to insert square root symbol in Excel. The square root is one of the most used symbols in Excel. I will ...

Add The Footer Page 1 To The Current Worksheet

In this article, I will show you how you can add the footer page 1 to the current worksheet you are working on. Excel has many different options for ...

Perform the Commands to Center the Selected Worksheets

In many cases, after working with your Excel worksheets you may want some of the selected worksheets to be aligned in the center position of the ...

Create a report that displays the quarterly sales by territory

In this article, I will create a report that displays the quarterly sales by territory. You can call it also a dynamic and interactive Excel ...

ExcelDemy
Logo