Advanced Excel

How to Use Advanced Filter to Exclude Blank Cells in Excel (3 Easy Tricks)

Sometimes, in Excel, large datasets contain blank cells randomly located, which may be required to be deleted later. However, it might seem ...

Excel VBA: Advanced Filter with Multiple Criteria in a Range

When working with big amounts of data and required to set multiple filters at once, Advanced Filtering in Excel comes in handy. It may also be ...

How to Combine Two Bar Graphs in Excel (5 Ways)

If you are trying to combine two bar graphs in Excel, then you will find this article useful. A combination of two bar graphs is requisite when you ...

VBA to Copy Data to Another Sheet with Advanced Filter in Excel

When we are dealing with multiple Excel sheets, sometimes we have to copy data from one spreadsheet to another with certain conditions for better ...

How to Combine Graphs with Different X Axis in Excel

In Microsoft Excel, plotting graphs in worksheets is one of the crucial tasks. Graphs make a worksheet visually attractive to the user. Mainly, ...

How to Combine Two Line Graphs in Excel (3 Methods)

In this article, we will learn how to combine two line graphs in Excel. Generally, we need to combine two graphs in one graph paper to show our ...

How to Use Advanced Filter for Unique Records Only in Excel

Daily, Excel users have to deal with duplicate entries in datasets. In that case, the Excel feature of Advanced Filter for unique records only is a ...

How to Use Advanced Filter to Copy Data to Another Sheet in Excel

Usually, the advanced filter option allows us to extract data from a data range with respect to multiple conditions. We can use the advanced filter ...

How to Combine Two Graphs in Excel (2 Methods)

Quite frequently we insert graphs for a certain dataset in our Excel worksheet. Graphs help us to analyze our progress or productivity. It can also ...

Excel Advanced Filter: Apply “Does Not Contain” (2 Methods)

You can use the Does Not Contain feature of Advance Filter to filter out the rows that do not contain a specific text or multiple texts. In this ...

How to Use Advanced Filter If Criteria Range Contains Text in Excel

Advanced Filter in Excel is one of the coolest options in Excel. Advanced Filter can do many complex filtering that AutoFilter can not do. In this ...

Excel Date Picker for Entire Column

Date Picker is one of the interesting tools of Microsoft Excel. It relieves us from the monotonous work of inserting data for each cell manually. ...

Creating a Mailing List in Excel (2 Methods)

In businesses, we have thousands of customers and have to inform them of any updates or changes in our services. Creating a mailing list in Excel ...

How to Make a Numbered List in Excel (8 Methods)

Bullets and numbering in Excel are mostly used to organize data in a worksheet. If you have a big list of entries, numbered lists can help you keep ...

How to Make a List within a Cell in Excel (3 Quick Methods)

Want to make a list of your data within a cell in Excel? You are in the right place! Here in this tutorial, we will show you 3 unique methods to make ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo