Latest Blog Posts

How to Break Links in Excel When Source Is Not Found (4 Ways)

In this article, we discuss how to break links in Excel when the source is not found. What Causes Source Not Found Errors in Excel? When we ...

How to Set Intervals on Excel Charts (2 Suitable Examples)

Let’s consider the Revenue Earnings by Month dataset shown in the B4:D14 cells. We have the Month Numbers, the Month Names, and the Revenue earnings ...

How to Filter by Multiple Colors in Excel (2 Ways)

Consider the following data showing the sales information of some representatives from different regions. Here’s an overview of filtering data by ...

How to Sum Text Values Like Numbers in Excel (3 Methods)

Method 1 - Using SUM, INDEX, MATCH, and IF Functions to SUM Text Values Like Numbers We have a list of names who are assigned to 4 codes ...

Create Chart of Accounts for Construction Company in Excel

Step 1 - Prepare a List of Assets Current Assets include cash, accounts receivable, etc. Long-Term Assets include Land, Buildings, ...

How to Check If a Value Is Between Two Numbers in Excel

Suppose we have the dataset of students’ exam marks below. We want to know whose mark is between 40 and 60. In this article, we will use different ...

How to Make a Graph from a Table in Excel (5 Suitable Ways)

Let’s consider a dataset of Yearly Sales of XYZ Traders. The data table has three columns, B, C, and D, indicating the data of No. of Year, Cost, and ...

How to Paste into Visible Cells Only in Excel (6 Easy Methods)

We have the Delivery Status of Ordered Products as a sample dataset. We will filter this dataset and then try to paste values into only the visible ...

Vlookup with Time Range in Excel (5 Easy Ways)

In this article, we will demonstrate five quick methods to VLOOKUP within a time range in Excel. To demonstrate the methods, we'll use the dataset ...

How to Select All Rows in Excel (6 Methods)

Below, we have used an Excel dataset containing the Names and Marks of some students. In the methods below, we will see how to select all the rows of ...

How to Compare If Date Is Before Another Date in Excel: 6 Quick Methods

Method 1 - Use a Formula to Compare If a Date Is Before Another Date Steps: Select a cell to write a formula. We selected cell (E5). Apply ...

How to Skip Columns in Excel (3 Methods)

Dataset Overview Let’s suppose we have a sample data set containing various Salesmen and their sales per month (January to June). Method 1 ...

How to Average Only Visible Cells in Excel: 3 Quick Methods

Method 1 - Using SUBTOTAL Function to Average Visible Cells 1.1 For Filtered Data Steps: Filter the dataset to hide rows. To enable the ...

How to Convert Milliseconds to Seconds in Excel (2 Quick Ways)

Suppose we have the following dataset containing time values in milliseconds. In this article we'll demonstrate how to convert these values into ...

Excel Filter by Color and Text (with Easy Steps)

Here's an overview of filtering data by color and text. We have the following starting dataset where the colored cells are blank. We want to ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo