Excel Basics

How to Maintain Store Inventory in Excel (Step by Step Guide)

For checking the performance of your business, you might have needed to maintain store inventory. It’s quite difficult to handle such type of report ...

How to Recover File after Crash in Excel (4 Methods)

In this article, I will discuss how you can recover an unsaved excel file after a crash. A crash can happen due to several reasons. For example, your ...

How to Convert Decimal to Minutes and Seconds in Excel (3 Easy Ways)

Excel by default stores time in decimal format. But there are several ways by which we can convert it to hours, minutes, or seconds. Also, Excel has ...

How to Create Leave Tracker in Excel (Download Free Template)

Leave tracker is a widely used task for the human resource department to track every people for their vacation and working days. Almost every ...

How to Keep Track of Customer Orders in Excel (With Easy Steps)

Keeping a track is very essential in any kind of business that involves Customer Orders. The product list, their size, order status, etc. are ...

How to Create a Daily Task Sheet in Excel (3 Useful Methods)

At times, it is very necessary for us to create a daily task sheet.  Using Excel, we can create a daily task sheet very easily because it gives us ...

How to Protect an Excel Sheet Except for Certain Cells (2 Ways)

You may need to secure your data when dealing with confidential analysis. When you wish to protect individual cells in a worksheet, however, it ...

How to Unlock Excel Sheet for Editing (With Quick Steps)

We usually protect Excel sheets for security. When we protect a sheet, some features become disabled like editing, formatting, inserting, etc. If we ...

Protect Excel Cells But Allow Data Entry (2 Quick Methods)

In some cases, you may need to protect your excel sheet but at the same time put data into the sheet. In Microsoft Excel, you can do this work ...

How to Remove Decimals in Excel with Rounding (10 Easy Methods)

We’re going to show you 10 methods of how to remove decimals in Excel with rounding. To demonstrate our methods, we’ve picked a dataset with 3 ...

How to Protect Excel Workbook from Editing (5 Effective Methods)

You may want to protect your Excel worksheet while sending an Excel file to your colleagues. In this article, I’ve discussed 5 effective methods to ...

Converting Time to Decimals in Excel (4 Examples)

When you have to do a further calculation using the time in Excel, you need to convert the time into decimals. Because you may get the time in ...

How to Remove Decimals without Rounding in Excel (4 Suitable Ways)

If you are looking for ways to remove decimals without rounding in Excel, then you will find this article useful. Normally, when we try to remove the ...

How to Copy from Word to Excel into Multiple Cells (3 Ways)

Microsoft Word permits us to generate professional standard documents, reports, letters, and any other dataset. But with Excel, we can edit any data ...

How to Protect Excel Sheet from Deleting (3 Simple Methods)

In Microsoft Excel, you might need to protect your file from deletion. After completing a file you may send it to viewers and you don’t want the ...

ExcelDemy
Logo