Latest Blog Posts

Isometric Drawing in Excel – 3 Steps

STEP 1 - Drawing Different Shapes Steps: Go to the Insert tab. Click Shapes. Select a shape. Here, Rectangular: top corner rounded. ...

How to Use a Data Model in Excel – 3 Examples

The sample dataset includes sales price, seller name, product name, and date. There's another dataset that contains the seller's name and gender. ...

How to Summarize Text Data in Excel – 3 Steps

The dataset showcases Products and their Groups. To summarize all products: Step 1 - Create a Pivot Table Select the whole dataset ...

How to Sum Only Numbers and Ignore Text in the Same Cell in Excel (6 Easy Methods)

Dataset Overview Let’s consider a dataset where we’ve entered the names of 10 employees and their salaries inside the same cell. Our dataset spans ...

Skip to the Next Result with VLOOKUP If a Blank Cell Is Present – 3 Methods

This is the sample dataset. Method 1- Combining the VLOOKUP and the IFNA Functions Steps: Enter “Ben” in B13. Enter the following ...

How to Move a Row to the Bottom If a Cell Contains a specific Value in Excel – 2 Methods

The sample dataset contains customer name, product brand name, sales amount, and target status. Some cells of the target column display “ Passed” . ...

How to Create a GST Rental Invoice Format in Excel – 5 Steps

This is the sample dataset.   Step 1 - Enter the Invoice Details    Step 2 - Calculate the Subtotal Go to ...

How to Solve Colebrook Equation in Excel (3 Simple Ways)

  What Is a Colebrook Equation? The Colebrook equation shows the relationship between the Reynolds number, Pipe Roughness, and Diameter based ...

How to Create a Non-GST Invoice Format in Excel (5 Steps)

Step 1 - Make Outline of Non-GST Invoice Format in Excel Set up the basic inputs. You’ll need a Product List in one sheet and a Customer List in ...

How to Move a Row to Another Sheet Based on the Cell Value in Excel (2 Methods)

Dataset Overview Often, we need to move or copy rows based on cell values to different worksheets for various purposes. The cell value can be in any ...

How to Solve a First-Order Differential Equation in Excel (Easy Steps)

Understanding Differential Equations A differential equation relates one or more functions to their derivatives with respect to an independent ...

How to Calculate Final Grade in Excel (in 3 Steps)

In the dataset "Student Marksheet", we have columns showing student names and various courses. Next to each student's name, we have a grade for each ...

How to Save a Copy as XLSX Using Excel VBA (5 Suitable Ways)

We have taken a simple and concise dataset that has 3 columns and 6 records of students' marks to show how to save it as an XLSX file. ...

The Quick Access Toolbar is Missing in Excel – 6 Solutions

This is an overview. Why is the Quick Access Toolbar Missing? Possible Reasons: It was Accidentally Removed. The Customized Quick ...

How to Filter Missing Data in Excel (4 Easy Methods)

This article will provide you with 4 easy methods to filter missing data in Excel. We'll use the dataset below representing some salesperson’s ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo