Advanced Excel Archives

7 Ways to Alternate Row Color Based on Group in Excel

February 5, 2023 Advanced Excel

This article will delve into various techniques to apply color formatting in Microsoft Excel to distinguish between groups of rows. With this ...

5 Ways to Add Alternate Row Colors Without Table in Excel

March 21, 2023 Advanced Excel

Color Banding or alternate coloring rows makes the data in the worksheet easier to scan. A preset table format can quickly add the color format to ...

3 Examples to Use INDEX-MATCH Instead of VLOOKUP in Excel

March 28, 2023 Advanced Excel

The majority of Excel users concur that INDEX-MATCH is significantly superior to VLOOKUP when it comes to matching data in a vertically arranged ...

[Fixed!] Advanced Filter Not Working in Excel

January 10, 2023 Advanced Excel

In excel, we can use the Filter option in several ways. Accordingly, the advanced filter is also an excellent tool for filtering data for complex ...

How to Fix Automatic Update of Links Has Been Disabled in Excel

March 30, 2023 Advanced Excel

In this article, I'll show you three excellent methods on how to fix Excel automatic update of links has Been disabled in Excel. Furthermore, these ...

What Is Circular Reference in Excel?

January 3, 2023 Advanced Excel

Often people use formulas associated with functions to make dynamic worksheets. Sometimes it might happen that reference cells depend on the result. ...

3 Easy Ways to Find and Replace in Multiple Excel Files

January 3, 2023 Advanced Excel

Every now and then we have to deal with a very large-scale dataset in our practical life. Data sets can be in different datasheets of the same ...

6 Ways to Extract Data from Excel Based on Criteria

February 16, 2023 Advanced Excel

There may be times when you need to know how to extract data from Excel based on criteria. For example, you may need to use an Excel formula or VBA ...

3 Ways to Find Weighted Average from Pivot Table in Excel

December 29, 2022 Advanced Excel

Making a Pivot Table and measuring the weighted average in Excel is not everyone’s cup of tea. You can not simply modify or insert any formula in a ...

4 Ways to Remove Blanks from Data Validation List in Excel

December 29, 2022 Advanced Excel

Organizing data using various techniques is quite common in Microsoft Excel. Records are arranged in a tabular form here. You can create a drop-down ...

4 Ways to Remove Duplicates from Drop-Down List in Excel

December 29, 2022 Advanced Excel

Duplicate Values appear often in our workbook. If we want to make drop-down list based on a column that contains duplicates, all the values will ...

3 Ways to Use Advanced Filter to Exclude Blank Cells in Excel

February 16, 2023 Advanced Excel

Blank cells cause problems when we want to do different operations in a dataset. We will use an Advanced Filter to exclude blank cells in Excel with ...