Latest Blog Posts

How to Freeze First 3 Columns in Excel (4 Quick Ways)

Method 1 - Freeze First 3 Columns Using Freeze Panes The Freeze Panes option of Excel is available in the View tab. We can use the Freeze Panes ...

How to Protect an Excel Sheet from Copy-Paste (4 Methods)

Method 1 – Using the Info Option   We will use a dataset containing sellers' sales amounts for the first five months. 1.1 Secure a Workbook ...

Excel VBA to Convert Date and Time to Date Only

It often becomes necessary to convert a range of dates and times to dates only. We can use Excel VBA to convert date and time to date only. This ...

How to Use an Excel Formula to Calculate Overtime and Double Time (3 Methods)

Dataset Overview Let’s say we have a dataset containing an employee’s Entering and Existing Time on certain Dates. We want to calculate the Overtime ...

How to Convert SAP Timestamp to Date in Excel (4 Ways)

The following table containing the sales records of a company. It has some SAP Timestamps in the Order Time column. We will convert them into dates. ...

How to AutoFill Numbers in Excel with Filter (2 Methods)

We have the Names of some students along with their Department. In the Serial column, we are going to list the students serially with Filter ...

How to use Excel Formulas to Fill Sequence Numbers Skipping Hidden Rows – 3 Methods

The dataset showcases Serial No, Month, Employee ID, and Salary. Rows 10, 11 and 12 are missing. To fill the sequence in column B skipping hidden ...

How to Convert String to Number in Excel VBA (3 Methods)

Method 1 - Convert String to Number Using Type Conversion Functions Excel provides several built-in type conversion functions. We can use them in ...

How to Calculate Average of Multiple Columns in Excel: 6 Methods

Method 1 - Calculate Average of Multiple Columns Using AVERAGE Function Steps: Type the below formula in cell B13 to calculate the average of ...

How to Calculate the Duration of Time in Excel (7 Methods)

We have a dataset with starting times and ending times. We'll measure time durations from the starting times to the ending times. Method 1 ...

How to Convert String to Long Using VBA in Excel (3 Ways)

You'll learn how to convert Strings to Long in this VBA tutorial. This VBA tutorial comes with an Excel worksheet that contains all of the macros, ...

Macro to Concatenate Multiple Columns in Excel (with UDF and UserForm)

While working with VBA in Excel, we often have to develop Macro (s) to concatenate multiple columns in a worksheet. Concatenating columns is widely ...

How to Remove Duplicates in Excel (9 Simple Ways)

Removing duplicates in Excel means keeping the first instance of a value in a range and removing all the other instances. In this Excel tutorial, we ...

Concatenate Multiple Cells Based on Criteria in Excel (4 Methods)

Here's an overview of concatenating cells if they meet certain criteria. How to Concatenate Multiple Cells Based on Criteria in Excel: 4 ...

How to Get Average Time in Excel (3 Examples)

We'll show you three examples of how to calculate the average time from a data collection of specific times in the sections below. Here is an example ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo