Latest Blog Posts

How to Use Excel VBA to Paste Range into Email Body (3 Methods)

Let’s assume a scenario where we have an Excel file that contains information about the employees of a company, including the Name, Age, Gender, Date ...

How to Solve Text Won’t Convert to Date in Excel (4 Problems & Solutions)

Dataset Overview Let’s consider a dataset containing employee information, including their joining dates. Unfortunately, these dates are not in the ...

How to Count Number of Cells with Dates in Excel (7 Ways)

Let's use a sample dataset containing Name, Gender, and Date of Birth to showcase how you can count how many cells contain dates in Excel. ...

How to Copy a Formula in Excel Without Dragging – 10 Methods

Use the following dataset to calculate the profit of this company.   Method 1- Double-Clicking to Copy Formula in Excel without Dragging ...

How to Calculate Accrued Interest on a Bond in Excel (5 Methods)

We will show how to calculate this accrued interest on a bond using different formulas in Excel. We will calculate the accrued interest based of the ...

How to Calculate Production per Hour in Excel (4 Methods)

Method 1 - Using Target Efficiency and Working Period Start with a productive facility that has 6 working units. Each unit has its own machine ...

VBA to Transpose Multiple Columns into Rows in Excel (2 Methods)

Sometimes we need to re-organize columns into rows when working on a large dataset in Excel for better readability. Implementing VBA is the most ...

How to Bold Text in a Concatenate Formula using VBA in Excel – 2 Methods

This is the sample dataset. Method 1 - Bold Text in the Output of the Concatenate Formula. Press ALT+F11 to open VBA. In the VBA window, ...

How to Autofilter and Copy Visible Rows with Excel VBA

The dataset below has 5 columns displaying a Site's name, Category, Date, Platform, and Number of Visits for each site. Method 1 – AutoFilter ...

How to Add a Percentage to a Price with an Excel Formula – 2 Methods

Importance of Cell Number Formatting in Percentage Calculation To enter a percentage you have to use Number format. Steps: Enter a decimal ...

How to Copy Unique Values to Another Worksheet in Excel – 5 Methods

The dataset showcases a list of colors with duplicates in Sheet1. To copy the unique colors to another worksheet in the same workbook. ...

Concatenate Multiple Cells but Ignore Blanks in Excel (5 Ways)

  Method 1 - Combine CONCATENATE, IF, and ISBLANK Functions to Concatenate Multiple Cells Consider the following dataset. In column B, we have ...

Carriage Return in Excel Formula to Concatenate (6 Examples)

Method 1 - Using Ampersand Operator and CHAR Functions Insert Carriage Return in Excel Formula to Concatenate Step 1: Insert the following formula ...

How to Calculate Average Turnaround Time in Excel (4 Methods)

  Method 1 - Compute the Average Turnaround Time in Excel Look at the following picture. We have the Start Time and the End Time of some ...

How to Concatenate Date That Doesn’t Become Number in Excel (5 Ways)

Method 1 - Concatenate a Date with Text and Keep the Date Format in Excel If you concatenate Text with Dates, then the Dates will be converted to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo