Excel Basics

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 Copy Rows in Excel with Filter (6 Fast Methods)

Often you may need to copy filtered rows in Excel. And this task can be accomplished using Excel as well as the VBA code. In this article, I’ll show ...

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

You must face some unwanted problems when you are going to copy and paste merged cells in Excel. Because there are some conditions of merged cells. ...

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

The average is calculated by summing the specified numbers and dividing them by the total values selected. We use averages because it’s beneficial to ...

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

We often need to work with different types of huge datasets in Excel. The data can be of various types such as Number, Text, Date, etc. So often ...

How to Copy Formula in Excel Without Dragging (10 Ways)

You may be used to copying formulas in Excel by dragging them over to all the cells, but if you have a humongous dataset to copy the formula then it ...

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 Add Percentage to Price with Excel Formula (2 Ways)

In this tutorial, I will show you how to add a percentage to a product’s price using an Excel formula. Luckily, adding percentages to a price is very ...

How to Copy Unique Values to Another Worksheet in Excel (5 Methods)

This article illustrates 5 different methods to copy unique values to another worksheet in the same workbook in Excel. Working with a dataset with ...

How to Convert Text Date and Time to Date Format in Excel (7 Easy Ways)

Very often we find time and date in text format in a worksheet. This may be a result of the wrong input format. This may also occur when we copy data ...

How to Copy Merged and Filtered Cells in Excel (4 Methods)

Copying merged and filtered cells in Excel can be a frustrating process. Merged and filtered cells are notorious in spreadsheets for producing ...

Formula to Copy and Paste Values in Excel (5 Examples)

There are a lot of ways to copy and paste values in Excel. But if you think of a way to copy and paste values using formula. The answer is yes, Excel ...

How to Calculate Average Rating in Excel (7 Methods)

The average rating means the review of any product. We can calculate this average rating using the formulas in Excel. What Is Average Rating? ...

How to Paste Link and Transpose in Excel (8 Quick Ways)

By noticing the fact that when you click on the Transpose option then the Paste Link option is automatically disabled, a question may arise that can ...

How to Copy and Paste in Excel with Merged Cells (2 Methods)

Copy and paste with merged cells in excel is a bit tricky. It often either results in an error or excel doesn’t allow it. But fortunately, there are ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo