Latest Blog Posts

How to Select All Cells with Data in Excel (5 Methods)

Method 1 - Select All Cells with Values Using the ‘Go To Special’ Command The dataset below has data on several areas of fruit sales date-wise. ...

Creating a Drop-Down Filter to Extract Data Based on a Selection in Excel – 4 Methods

This is the sample dataset: Method 1 - Create a Drop-Down Filter to Extract Data Based on Selection with Helper Columns in Excel Insert 3 ...

How to SUMIF between Two Dates and with Another Criteria (7 Ways)

The following dataset contains sales records of some products, their estimated delivery dates, and company selling regions. Using this dataset, we ...

How to Reference Text in Another Cell in Excel (14 Ways)

Method 1 - Reference Text from One Cell to Another Cell in the Same Worksheet in Excel Consider the following example. We will take cell B7 and ...

How to Remove Blanks from a Data Validation List in Excel (5 Methods)

Method 1 – Using the OFFSET Function Steps: Enter the following formula in cell C5: =FILTER(B5:B14,B5:B14<>"") Here, the ...

How to AutoFill Formula When Inserting Rows in Excel (4 Methods)

We have some salespersons along with their Sales amount and Sales Commission. The Commission is 10%. We'll use it to demonstrate how to AutoFill ...

How to Create a Drop-Down List with Unique Values in Excel – 4 Methods

The sample dataset showcases Product name, Category, and Country to which the product is exported. Method 1 - Insert a Pivot Table to ...

How to Calculate Average If Within Date Range in Excel (3 Ways)

To demonstrate our methods, we'll use a sample dataset containing Date, Region, and Sales. and calculate the average Sales within a certain date ...

How to Convert a Number to Text with the Green Triangle in Excel (6 Methods)

What Does the Green Triangle Indicator Mean? In case Excel detects an error in its calculation it indicates the error by displaying a triangle on ...

How to Calculate the First Day of the Month Using Excel VBA (3 Methods)

Dataset Overview Suppose we have an Excel worksheet containing information about a sales representative named Emma from the Armani group. Her ...

Problem and Solution of Data Validation Not Working Copy Paste in Excel

Method 1 - Reason for Data Validation Not Working Copy Paste in Excel Steps:  We selected Column B which contains the Employee Name. From ...

How to Compare Two Cells and Change Color in Excel (2 Ways)

We have two different Product lists. The Product lists have products that are ordered on certain days. We want to compare these products on the same ...

How to Get the Last Day of Month Using VBA in Excel (3 Methods)

This article illustrates 3 different methods to get the last day of the current, past, or future month from a specific starting date using VBA code ...

How to Combine Rows from Multiple Sheets in Excel (4 Methods)

Method 1 - Use Consolidate Option to Combine Rows from Multiple Excel Sheets The Consolidate feature is the quickest way to combine rows. But we can ...

How to Change Date Format in Pivot Table in Excel

Let’s introduce today’s dataset where Sales of some Product Categories is provided along with an Order Date and corresponding States. Creating ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo