Advanced Excel

How to Perform a Spelling Check on the Active Worksheet in Excel

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

How to Apply a Custom Number Format With Multiple Conditions in Excel

The following GIF shows that the custom number format is changing based on multiple conditions. Depending on the values you enter in the cell, the ...

How to Round Numbers in Excel Without Formula (3 Quick Ways)

Method 1 - Round Numbers with Decrease and Increase Decimal Commands in Excel Excel has the built-in feature under the Home tab from which you can ...

Data Validation Based on Another Cell in Excel (4 Examples)

How to Do Data Validation in Excel? Take a dataset that includes student ID, student name, and age. We would like to make a data validation where ...

How to Change Orientation of Worksheet to Landscape in Excel

Method 1 - Applying Landscape Command to Change Orientation of Excel Worksheet Steps: Go to the Page Layout tab. From the Page Setup group, ...

How to Remove Leading Zeros in Excel: 8 Easy Methods

Method 1 - Converting Text to Number to Remove Leading Zeros in Excel Steps: Arrange a dataset like the below image. Select the ...

How to Merge Excel Worksheets Without Copying and Pasting?

In this article, we will demonstrate three ways to merge Excel worksheets without copying and pasting. In the first method, we combine data from ...

How to Make Excel Spreadsheet Bigger When Printing (7 Ways)

You cannot make your Microsoft Excel spreadsheet bigger (unless you want to change the page size). But in this article, we will show some tips and ...

How to Highlight Every Other Row in Excel (3 Easy Methods)

In this article, we will see how to highlight every other row in Excel. Some available techniques are applying conditional formatting, using ...

How to Delete Blank Rows in Excel (6 Ways)

While working with a big spreadsheet you often insert blank rows intentionally to read and understand it properly. Although inserting blank rows are ...

How to Multiply in Excel (8 Methods)

We have a dataset of product Names, unit prices, and Quantities. We will learn to multiply this information from the dataset to calculate the Total ...

How to Reduce Excel File Size (11 Suitable Methods)

Larger file sizes can cause slower performance and trouble when sharing files. There can be multiple reasons behind this larger file size, and ...

How to Lock and Unlock Cells in Excel Using VBA

To demonstrate how to lock and unlock cells in Excel, we’ll use the following dataset containing Salesman, Product, and Net Sales in the range ...

How to Compare Two Columns or Lists in Excel (4 Suitable Ways)

Method 1 - Compare Two Columns Using Equal Operator Steps: Add a new column on the right side to show the matching status. Enter the ...

Intro to Relational Database Management System (RDBMS) Concepts!

Before we dive into creating databases and data-centric applications in Access, it is prudent to go over some basic database and relational database ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo