Latest Blog Posts

How to Draw an AON Network Diagram in Excel (3 Examples)

Below is a template to draw an AON network diagram. The acronym ST stands for Start Time, RT for Run Time and ET for End Time. Method 1 - ...

How to Show Grand Total with Secondary Axis in Pivot Chart

While creating a Pivot Chart in Excel, showing the Grand Total can help understand the chart and increase clarity. If you are curious to know how you ...

How to Create Reference with Another Workbook in Excel (5 Ways)

We use Excel basically to ease our workload and save work time. For this, sometimes we refer to another cell in an Excel sheet or another sheet of an ...

How to Trace Errors in Excel – Quick Steps

To trace errors in Excel: Click the error cell >> go to Formulas >> Formula Auditing >>  Error Checking >> Trace Error. ...

[Fixed!] Cut and Paste Not Working in Excel

Need to learn how to solve if Cut and Paste not working in Excel? If you are looking for such unique tricks, you’ve come to the right place. The most ...

Find String in Column and Return Row Number in Excel (7 Ways)

We have a sample dataset that contains Sales Person and Sales information. We will find a name from the column named Sales Person and return the row ...

How to Merge Two Excel Sheets Based on One Column (3 Ways)

We have the salary and departmental information of some people on two different sheets. Here, we will show 3 ways to merge two sheets based on one ...

How to Return Value in Excel If Cell Contains Date: 5 Practical Examples

Consider the Interview Schedule dataset in the B4:C13 cells below, with Names of the employees and their scheduled Interview Dates. To determine ...

How to Break Links in Excel and Keep Values (3 Easy Ways)

We have a dataset of 10 employees and their salaries for the first two months in a file titled Employee Salary Details.xlsx. The sum of those ...

[Fixed!] Excel Update Links Manually Greyed Out

In our everyday usage of Excel, it is very common to use multiple ones at a time. It is also very common to link them together and update them on a ...

How to Edit Bank Statements in Excel (with Easy Steps)

  Step 1: Convert the PDF File to Excel to Edit the Bank Statement We will first try to convert the PDF file below. Go to the website ...

How to Fix Broken Hyperlinks in Excel (5 Ways)

Generally, clicking on a hyperlink should take us to another cell, workbook, or website. But if that isn’t happening then the hyperlinks can be ...

How to Use Trace Precedents and Dependents in Excel (with Quick Steps)

  What Are Trace Precedents and Trace Dependents Features in Excel? In Excel, we use formulas with cell references, and thus, the formula cell ...

How to Skip to Next Cell If a Cell Is Blank in Excel (5 Easy Ways)

Consider the following dataset containing a list of Ids, Products, and their corresponding Sales values. In the Product ID column and Product column, ...

How to Sum If Cell Contains Text in Another Cell in Excel

Here's a dataset that contains the Order No., Item Names, Quantity and Sales of some products. We'll use it to create sums depending on certain ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo