Latest Blog Posts

How to Remove Unknown Links in Excel (4 Suitable Examples)

Sometimes we use the information of one Excel file for other. This way, we link Excel files one to another. Sometimes we see that, there are unknown ...

How to Trace Dependents Across Sheets in Excel (2 Easy Ways)

To illustrate how to trace dependencies, we will use the following data set. Here in columns B and C, we have some order ids and their corresponding ...

How to Create Multi Level Hierarchy in Excel (2 Easy Ways)

In this article, we will demonstrate 2 simple methods to create a multi level hierarchy in Excel. Watch Video – Create Multilevel Hierarchy ...

What to Do If CTRL C Is Not Working in Excel (8 Solutions)

4 Major Reasons Why CTRL C Might Not Be Working in Excel Hardware problem can create the issue. The keyboard can malfunction so that CTRL C ...

How to Use Excel Formulas to Compare Two Dates

We have a dataset of some Students who have to submit their assignments, the Date of Submission & the Deadline, and the Remarks (if the ...

How to Remove Excel Links from Word Document

Links in Microsoft Word can take you to that certain Excel file from where you created the link in Microsoft Word. After going to that Excel file, if ...

How to Apply Conditional Formatting for Dates That Are Older Than a Certain Date in Excel (5 Methods)

Dataset Overview To illustrate these methods, let's use a dataset containing the joining dates of 10 employees in a new startup company. Our dataset ...

How to Return the Expected Value If the Date Is Greater Than Today in Excel – 2 Examples

Example 1 - Set the Cell Value If the Date Is Greater Than Today The dataset showcases products and their delivery date. Consider the delivery ...

How to Solve System of Equations in Excel (2 Easy Methods)

Are you finding ways to solve the system of linear equations in Excel and searching for the easiest guide? Then I think you have come to the right ...

How to Select Specific Rows in Excel Formula (4 Easy Ways)

Looking for ways to know how to select specific rows in the Excel formula? Sometimes, we want to select specific rows in Excel that contain formulas ...

Excel Formula If Date Is Less Than Today (4 Examples)

Let’s say we have a Student-wise Submission Dates list of a certain institution. This dataset contains the First Names, Last Names, and Submission ...

How to Add 30 Minutes to Time in Excel: 3 Easy Methods

Method 1 - Use TIME Function to Add 30 Minutes to Time Steps: Select cell D5 for the convenience of our work. After selecting cell D5, ...

How to Check If a Value Lies Between Two Numbers and Return a Result in Excel

Understanding the IF-THEN Formula In a nutshell, Excel’s IF-THEN formula allows you to create conditional logic within a worksheet. It checks ...

How to Merge Tables from Different Sheets in Excel (5 Easy Ways)

The two sample sheets contain data of student names and marks obtained for Physics and Math. Method 1 - Apply the VLOOKUP Function to Merge ...

How to Update Excel Links (Manually/Automatically)

We'll use the following datasets to demonstrate how you can update links inside and between sheets. ⏷Update Links Automatically ⏷Update ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo