Advanced Excel

Create a Unique List in Excel Based on Criteria (9 Methods)

In Microsoft Excel, several methods are available to create a unique list under multiple criteria. The unique list is generally prepared to remove ...

How to Populate List Based on Cell Value in Excel (8 Methods)

Populating a list based on cell value in Excel means automatically adding information that meets certain criteria. In this Excel tutorial, we will ...

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

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

How to Split Cell by Delimiter Using Excel Formula (8 Ways)

This tutorial will show you how to split a cell by delimiter with the help of a formula in Excel. A delimiter is a character that separates chunks of ...

How to Convert Number to Text with Leading Zeros in Excel

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

How to Convert Number to Words in Excel (4 Suitable Ways)

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

How to Remove Commas in Excel (4 Easy Methods)

This article provides a detailed guide of how to remove commas in Excel. Here, you’ll see the ways of removing commas from numbers through converting ...

Division Formula in Excel for Multiple Cells (5 Suitable Examples)

If you are searching for some special tricks to use division formula in Excel for multiple cells then you have landed in the right place. There are ...

How to Split a Single Cell in Half in Excel

Excel has a lot of features that are meant for performing enormous operations and formatting. You may need to add two different types of headings in ...

How to Insert Square Root Symbol in Excel (8 Easy Ways)

This article will show you how to insert the square root symbol in Excel. Sometimes you may need to store irrational numbers as data in an Excel ...

Perform Commands to Center the Selected Worksheets in Excel

Looking for ways to know how to perform commands to center selected worksheets in Excel? We can select worksheets and perform commands to center them ...

How to Apply Custom Number Format With Multiple Conditions in Excel

Customizing number format involves using one or multiple conditions that enable users to format cells dynamically. For example, you can make positive ...

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

This article will show you how to round numbers in Excel without using formula. You will get to see several processes to round up, round down, and ...

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

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo