Latest Blog Posts

How to Convert Degrees, Minutes and Seconds to Decimal Degrees in Excel – 2 Methods

This is the sample dataset. Method 1 - Applying  a Formula to Convert Degrees, Minutes and Seconds to Decimal Degrees in Excel Step 1: ...

How to Delete Empty Rows at the Bottom in Excel?

Our dataset contains empty rows, and we'll remove these empty rows in various ways. Method 1 - Manual Approach to Delete Empty Rows in ...

How to Copy Sheet to End in Excel Using VBA (6 Methods)

We have a workbook with two worksheets, NewYork and Boston. The name of the workbook is "Excel VBA Copy Sheet to End". We have another workbook named ...

How to Subtract Minutes from the Time in Excel (7 Methods)

How to Get the Current Time in the Desired Format Steps: Go to cell B5 and enter the NOW function. =NOW() Press the ...

Convert Columns to Rows in Excel Using Power Query

In this tutorial, we will describe how to convert columns to rows in Excel using Power Query. What is Power Query in Microsoft Excel? Power ...

How to Filter and Delete Rows with VBA in Excel – 2 Methods

The sample dataset showcases Salesman, Product, and Net Sales of a company. Method 1 - Filtering the Visible Rows and Deleting them with ...

How to Concatenate Rows in Excel (11 Methods)

Concatenate means to merge or combine two or more cells’ contents into a single cell. Method 1 - Applying Ampersand(&) Operator to ...

How to Disable Copy and Paste in Excel without Macros (With 2 Criteria)

Sometimes we need to share our Excel worksheet with users or clients. Suppose we want them to only be able to view the worksheet but not copy and ...

Excel VBA to Count Duplicates in a Column (A Complete Analysis)

While working with VBA in Excel, we often need to count duplicates in a column in a worksheet. In this article, I’ll show you how you can count ...

How to Create a Formula in Excel That Will Place the Word Yes (7 Ways)

In this article, you will get to know about various ways to create a formula in Excel that will place the word Yes easily. Sometimes we want a result ...

How to Count Non-Blank Cells with Condition in Excel (6 Methods)

The dataset contains information about several students: student names, IDs, and marks secured in Physics and Chemistry. Method 1 – ...

How to Calculate Remaining Days in Excel (5 Methods)

We have an Excel file that contains information on the Start Date and End Date of different projects. We will use this worksheet to calculate the ...

How to Delete Selected Rows with Excel VBA (Step-by-Step Guide)

This article shows how to delete selected rows in Excel with VBA in the simplest possible way. Surely you can add or delete rows or columns manually ...

How to Count Duplicates in Two Columns in Excel (8 Methods)

Column B depicts the List of US Companies by Revenue (List-1) while column D shows the List of US Companies by Profit (List-2). We’ll count the ...

How to Create a Day Countdown in Excel (2 Examples)

Example 1 - Use the TODAY Function to Create a Day Countdown in Excel Here is a common template of the TODAY formula. We’re going to make a ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo