Latest Blog Posts

How to Add Data Points to an Existing Graph in Excel – 3 Methods

  The dataset showcases the Population Growth in The USA. Using the above dataset, you’ll get the following graph. To add data ...

How to Create a Lookup Table in Excel (5 Easy Ways)

  Suppose we have a dataset containing some Product ID, Delivery Status and Price of those products. We will show the way to find specific ...

VLOOKUP Not Picking up Table Array in Another Spreadsheet

Solution 1 - Close One if Separate Instances are Open A worksheet being open in multiple instances is one of the main reasons why the VLOOKUP ...

How to Create a Subtraction Formula in Excel – 7 Methods

The sample dataset showcases Employees' Salaries and Expenses.   Method 1 - Subtraction Between Two Cells Using Generic Formula ...

How to Translate an Excel File from Japanese to English

Method 1 - Using Excel Translate Feature for Translating Japanese to English Steps: Open the Excel file containing the Japanese language data. ...

How to Create a Table from Another Table with Criteria in Excel (3 Methods)

Method 1 - Using the INDEX and ROW Functions We'll use a table named Source_table with three columns named Employee ID, Employee Name, and Gender. ...

Paste Comma Separated Values into Excel (in Different Orders)

Method 1 - Paste Comma Separated Values into Excel from a CSV File Directly Steps: We have data in a CSV file like the image below: ...

How to Copy VLOOKUP Formula in Excel (7 Easy Methods)

  We will consider the following dataset. Here, we applied a VLOOKUP formula on Cell G5. Then, we'll copy the formula. Method 1 - ...

How to Create Activity Relationship Chart in Excel

Introduction to Activity Relationship Chart The foundation for creating any form of plant layout is an Activity Relationship Chart. For this chart ...

How to Skip Data Points in an Excel Graph – 4 Steps

This is the sample dataset. Step 1 - Use a Formula to Calculate the Output Insert a new column to show the profit. Enter the ...

How to Create a Conditional Formula in Excel (5 Easy Ways)

Let's use a Score List of Math scores of some students. This dataset contains the ID, Student Name, and their corresponding Marks in columns B, C, ...

How to Move or Copy a Sheet Not Working in Excel

The below dataset contains employee Information: Employee ID, Name, and Designation. Reason 1: Having an Excel Table in Grouped Worksheets ...

How to Use SUMIF, COUNTIF and AVERAGEIF Functions in Excel: 3 Methods

Method 1 - Application of SUMIF Function in Excel ⏩ Overview of SUMIF Function The SUMIF function is used for summing numerical values based on ...

[Fixed!] Excel Hyperlink Is Not Redirecting Properly

Sometimes, we use different hyperlinks to express our thoughts in short or to add attachments. Rather than discussing it in detail, we mention other ...

Unlocking Potential of Google Sheets QUERY Function in Excel: 6 Examples

Method 1 - Excel Equivalent of QUERY Function: Copy Whole Range We have some sales information in the range B4:E12 and want to copy the whole range ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo