Latest Blog Posts

How to Create a Proforma Invoice Format in Excel with GST (Free Template)

What Is Proforma Invoice? A Proforma Invoice is a preliminary document that outlines the payable amount for a customer. It includes details related ...

How to Select Random Cells in Excel (5 Ways)

Consider a dataset of Salesmen of an organization and their respective Sales over a certain period of time. We want to select some random cells from ...

How to Calculate Root Mean Square Error in Excel

Introduction to the Root Mean Square Error (RMSE) The Root Mean Square Error (RMSE) calculates the amount of error between 2 datasets. It compares a ...

How to Update Links Without Opening File in Excel: 4 Methods

Method 1 - Using Edit Links Command to Update Links Without Opening File in Excel Steps: Go to the Data tab. Select the Edit Links option. ...

Open Workbook with Variable Name Using VBA in Excel: 4 Easy Ways

Method 1 - Using Workbook.Open Property 1.1 Open Workbook Mentioning File Path Steps We have a file stored in the documents folder to open. ...

How to Merge Two Pivot Tables in Excel (with Quick Steps)

We have two Pivot Tables: Income and Cost. Our merged Pivot Table will look like the image shown below: Step 1 - Create Two ...

How to Create a Data Model in Excel – 3 Methods

This is the sample dataset. Method 1- Using the Relationships Tool to Create a Data Model in Excel Steps: Select a value in ...

How to Flip Data Vertically in Excel (4 Quick Methods)

Suppose you have the following dataset: Method 1 - Combining INDEX and ROWS Functions to Flip Data Vertically in Excel Steps: Make ...

How to Use VLOOKUP to Merge Two Sheets in Excel

The following dataset has the Student ID and Name columns. The Student IDs are in irregular order. The second dataset has the Student ID and ...

Troubleshooting the “There Is a Problem with Clipboard” Error in Excel (3 Solutions)

Introduction to Clipboard Issues Before we delve into the solutions, let’s first understand the problem. The clipboard feature is available in all ...

If Cell Color Is Red Then Execute Different Functions in Excel: 5 Operations

Method 1 - Counting Red Color Cells Define Name Applying the COUNTIFS Function Steps: Go to Formulas. Select the Define Name ...

How to Reverse Data in Excel Chart: 4 Useful Methods

Method 1: Reverse Data in Excel Chart by Formatting Axis Select cell range B4:C10. Go to the Insert tab and click on Bar Chart under ...

How to Calculate the Car Payment in Excel – 6 Steps

The dataset below details the Cost of Car, the Down Payment, the Interest rate and the period to pay the loan.   Step 1 - Compute ...

How to Create List of Unique Values from Multiple Sheets in Excel

To demonstrate the different methods to obtain unique values from columns in multiple sheets, we will use 3 Excel sheets as a dataset. Each of them ...

How to Create a Summary Sheet in Excel (4 Easy Ways)

Consider an Excel workbook that contains 4 worksheets named Level-1, Level-2, Level-3 and Level-4, respectively. Each worksheet contains a dataset ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo