Excel Basics

How to Convert Degrees Decimal Minutes to Decimal Degrees in Excel

Degrees, minutes, and seconds (DMS) are often used to indicate the Angular Measurements. In this article, we will learn how to convert the degrees of ...

How to Delete Hidden Sheets in Excel (2 Effective Methods)

If you try to delete your hidden sheets after unhiding them, then it will consume time. Excel has some amazing features by which you can directly ...

How to Convert Percentage to Decimal in Excel (7 Methods)

In Microsoft Excel, we can represent a piece of data in different forms. The percentage is one of them. A percentage is the presentation of numeric ...

How to Copy and Paste in Excel and Keep Cell Size (7 Examples)

Sometimes we need to copy and paste in Excel and keep cell size. It saves a lot of time during work. Also makes the dataset more attractive. In this ...

How to Copy and Paste in Excel without Formulas (7 Easy Tricks)

In Excel, most of the time we do calculations using formulas. However, when we copy data from one location to another, formulas are copied as well. ...

Drag Number Increase Not Working in Excel (A Solution with Easy Steps)

Sometimes the AutoFill feature in Excel does not work to drag and increase numbers. This article shows how to fix the problem of drag number increase ...

How to Undo Delete Sheet in Excel (3 Methods)

Sometimes, you might accidentally delete the worksheet or even the whole workbook you are working on. This could be a disaster if you are working ...

How to Autofill Days of Week Based on Date in Excel (5 Easy Ways)

Sometimes we need to have days of the week instead of only dates in our Excel datasheet. But, manually typing the days based on date is quite ...

How to Delete Rows in Excel with Specific Text?

We often need to delete rows with specific text in Microsoft Excel. I have explained 3 methods on how to delete rows in Excel with specific text in ...

How to Copy Rows Automatically in Excel to Another Sheet (4 Methods)

In this tutorial, we will demonstrate the methods to automatically copy rows in Excel to another sheet. Microsoft Excel does not provide any feature ...

On Error Resume Next: Handling Error in Excel VBA

In Microsoft Excel VBA, error handling is one of the critical tasks. If you are a coder, you know the importance of error handling to build a perfect ...

Errors in Excel and Their Meaning (15 Different Errors)

Every now and then, we bump into errors in the Excel datasheet. Whenever we input something wrong in the formula or function, Excel lets us know that ...

How to Copy Formula to Another Sheet in Excel (4 Ways)

We usually need to apply the same formulas while dealing with many worksheets. When we copy a cell that does not have a formula but has value and ...

Excel Error: The Number in This Cell is Formatted as Text (6 Fixes)

In this article, we will discuss the ‘The number in this cell is formatted as text or preceded by an apostrophe’ error in Excel. Sometimes, when we ...

[Solved!] Can’t Delete Extra Columns in Excel (3 Reasons and Solutions)

Tired of trying to delete unnecessary columns in your dataset, but you couldn’t? Well, maybe your workbook has some common issues for which deletion ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo