Latest Blog Posts

How to Add Leading Zeros in Excel by CONCATENATE Operation

In Excel, if you insert a number with leading zeros, the zeros will disappear. Excel does that because normally zeros in front of a number don’t ...

How to Link Files in Excel (5 Different Approaches)

Method 1 - Link to a New File in Excel Our sample dataset contains some product names in column B and their prices in column C, and we want to ...

How to Copy Visible Cells Only without Header Using VBA

After filtering data using the auto filter in Excel, we need to copy visible cells only without a header. We can do this very easily using the VBA ...

How to Convert Unix Timestamp to Date in Excel (3 Methods)

The Unix timestamp is a system of tracking time as a running total of seconds. The time count started at the Unix Epoch on January 1st 1970 UTC. So a ...

How to Calculate Interest Rate in Excel (3 Ways)

Consider the following dataset that we'll use to calculate interest rates. We'll calculate the Monthly and Yearly Interest Rates, as well as the ...

How to Concatenate Strings and Variables in Excel VBA (3 Examples)

Example 1: Developing a Macro to Concatenate string (s) and variable (s) in Excel VBA Here’s a dataset with book names, authors, and prices from a ...

How to Convert Active Directory Timestamp to Date in Excel (4 Methods)

Consider a dataset, there are 6 AD timestamps which need to be converted to readable dates. To do that, the example will use Sequential Serial ...

How to Concatenate and Keep Currency Format in Excel (3 Methods)

While concatenating two or more pieces of text in Excel, different number formats like currency, decimal format, and percentage format are removed ...

How to Calculate the Gold Loan Interest in Excel – 2 Methods

Method 1 - Using the Excel PMT Function to Calculate the Gold Loan Interest This is the syntax of the PMT function: PMT(rate, nper, pv, , ) ...

How to Copy and Paste in Excel When Filter Is On (5 Methods)

We're going to use a sample dataset as an example. The following dataset represents the Salesman, Product, and Net Sales of a company. There are two ...

PasteSpecial Method of Worksheet Class Failed

While working with Excel VBA, you will face a lot of runtime errors. It is very usual to get these problems. Over time, you will get more promising ...

How to Disable Auto Convert to Date in Excel (2 Methods)

To make the data entry procedure more convenient, Excel converts some integers or strings to dates. Excel, on the other hand, does so without asking ...

How to Fix Convert to Number Error in Excel (6 Methods)

The sample dataset represents some bestseller books at amazon.com. The triangle-shaped green sign at the top-left corner of every cell in the ...

How to Unhide Top Rows in Excel: 7 Methods

Method 1 - Using Format Command in Excel to Unhide Top Rows Use the Ribbon shortcut to unhide the top 3 rows of our dataset. Step 1: Go ...

How to Convert Scientific Notation to Number in Excel (7 Methods)

Method 1 - Apply the TRIM Function to Convert Scientific Notation to Numbers in Excel Step 1: Select cell C5 to convert scientific notation to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo