Latest Blog Posts

Excel Formula to Calculate Average Annual Compound Growth Rate

In financial data, it is very important to know the annual growth rate. Average annual compound and annual growth rate help to distinguish where the ...

How to Calculate Interest Rate on a Loan in Excel (2 Criteria)

In Microsoft Excel, we can do the financial calculations quickly, because excel has some built-in financial functions. For example, suppose you want ...

How to Count Colored Cells In Excel Without Using VBA – 3 Methods

The Excel file contains information about students from different countries in a university. The Country is color-coded. The image below shows the ...

How to Count Blank Colored Cells in Excel (2 Methods)

This article shows 2 ways how to count blank colored cells in excel. Imagine, you have a list of orders from customers of your store. You need to ...

Copy and Paste Is Not Working in Excel (9 Reasons & Solutions)

The following dataset represents the Product, Price, Quantity, and Total of a company. We'll use it to demonstrate the most common reasons for ...

How to Copy Multiple Rows in Excel Using Macro (4 Examples)

In this article, we’ll illustrate how to copy multiple rows in the same or different worksheets and paste them over existing rows or newly inserted ...

How to Calculate Time Difference Between AM and PM in Excel (6 Ways)

We'll calculate the time difference in various units, including hours, minutes, seconds, and also for negative values. Here's the sample dataset ...

Excel VBA: Copy Worksheet to Another Workbook Without Opening

We'll use the following source file "Source", saved in the .xlsm format. We'll use VBA code to copy a worksheet named "Dataset" to another workbook. ...

How to Copy Only Values to Destination with Excel VBA: 9 Step by Step Analysis

Method 1 - Copy Only Values to Destination with the PasteSpecial Method of Excel VBA ⧪ Step 1: Activating the Source Worksheet The 1st step that ...

How to Convert Hours and Minutes to Decimal in Excel (2 Cases)

In this tutorial, we will learn how to convert Hours and Minutes to decimal in Excel. While working with time-related data we don’t need to keep the ...

How to Calculate the Percentage of Time in Excel – 4 Examples

Basic Formula to calculate the Percentage =(Part/Total)*100 Excel automatically multiplies the result of the ‘=Part/Total’ portion with 100 ...

How to Copy Rows in Excel with Filter (6 Fast Methods)

In this article, we will demonstrate 5 ways to copy filtered rows in Excel. We'll use the dataset below (B1:F16 cell range) to illustrate our ...

[Fixed!] Cannot Copy Merged Cells in Excel (4 Solutions)

For illustration, we will use this sample dataset which represents the 5 bestseller books of 2020 at amazon.com. The book names are merged between ...

How to Calculate Average of Multiple Ranges in Excel (3 Methods)

Our sample dataset contains player names and their scores in different games. We'll use this data to practice calculating the average of specific ...

Macro to Copy Specific Columns from One Worksheet to Another in Excel (6 Methods)

Method 1 - Copy selected Columns from One Worksheet to Another Using Macro The sample dataset contains some information about the employees of a ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo