Advanced Excel Archives - Page 2 of 8

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

Sep 16, 2021 Advanced Excel 1

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)

Sep 8, 2021 Advanced Excel

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

Sep 8, 2021 Advanced Excel

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)

Oct 19, 2021 Advanced Excel 7

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)

Sep 7, 2021 Advanced Excel 6

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)

Sep 8, 2021 Advanced Excel

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

Sep 27, 2021 Advanced Excel

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

Sep 7, 2021 Advanced Excel 1

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

Sep 7, 2021 Advanced Excel 10

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 ...

Perform a Spelling Check on the Active Worksheet of Excel

Sep 8, 2021 Advanced Excel 2

Spell checking is mandatory sometimes while working in an Excel Worksheet. In this article, we will see how to perform a spelling check on the active ...

Excel Custom Number Format Multiple Conditions

Oct 28, 2021 Advanced Excel 5

In this article, we are going to discuss the Excel custom number format multiple conditions. We will learn about the meaning and uses of different ...

How to Round Numbers in Excel Without Formula (3 smart ways)

Oct 28, 2021 Advanced Excel 2

In this article, you will see how to round numbers in Excel without formula. You will get to see a number of processes to round up, round down and ...

Excel Data Validation Based on Another Cell Value

Sep 15, 2021 Advanced Excel 7

Data Validation is an important feature in Excel. In this article, we will see how Excel data validation based on another cell is created. Data ...

How to change the orientation of a worksheet to Landscape

Jun 9, 2021 Advanced Excel

Sometimes it is convenient to use Landscape page orientation rather than the default Portrait orientation, especially when you have data with a lot ...

How to Remove Leading Zeros in Excel (7 Easy Ways + VBA)

Oct 28, 2021 Advanced Excel 4

In this article, I will show you a good number of techniques on how to remove leading zeros in Excel. We don’t create all our worksheets ourselves. ...