Excel Basics

How to Remove Value Error in Excel (4 Quick Methods)

The #VALUE! error is a common occurrence in excel. It means that there are problems with the values that are used in the formula. This article ...

How to Convert Exponential Value to Exact Number in Excel (7 Methods)

In this tutorial, I will show you how to convert an exponential value to an exact number in Excel. Usually, when you enter a number that is longer ...

How to Convert Degrees Minutes Seconds to Decimal Degrees in Excel

To denote angular dimensions, degrees, minutes, and seconds are commonly used (DMS). Because one minute equals 60 seconds and one degree equals 60 ...

How to Delete Empty Rows at the Bottom in Excel?

Sometimes, while using Excel we have to deal with different sizes of datasets which may contain blank cells at the bottom or in between rows. Here, ...

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

Sometimes while working on a project we need to share our Excel worksheet with users or clients. Suppose you want the users to only be able to view ...

Excel VBA to Copy and Rename a Worksheet Multiple Times

In Microsoft Excel, using VBA macros can solve a lot of problems with ease. A crucial procedure of VBA macros is to copy worksheets to another ...

How to Calculate Gross Profit Margin Percentage with Formula in Excel

If you need to calculate gross profit margin percentage, you can easily do it in excel. Here, we can use a very easy and simple formula to compute ...

How to Copy Excluding Hidden Rows in Excel (4 Easy Methods)

If you have hidden rows in your dataset and you select the whole dataset using a mouse or CTRL+A shortcut and copy, Excel will select and copy the ...

Copy and Paste Is Not Working in Excel (9 Reasons & Solutions)

The most common operation we perform in Excel datasheets is copy and paste. But sometimes, problems may arise when we try to copy and paste. So, this ...

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 ...

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 ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo