Excel Basics

How to Convert Unix Timestamp to Date in Excel (3 Methods)

This article explains 3 methods to convert unix timestamp to date in Excel. The Unix timestamp format is widely used in different operating and file ...

How to Convert Active Directory Timestamp to Date in Excel (4 Methods)

The timestamp of Active Directory is illegible to humans. Fortunately, Excel provides the opportunity of transforming the timestamp to readable ...

How to Copy and Paste in Excel When Filter Is On (5 Methods)

The Filter feature is a very useful tool for anyone working with MS Excel. But, it causes various problems when we try to copy and paste in Excel ...

How to Disable Auto Convert to Date in Excel (2 Methods)

To make the data entry procedure more convenient, Excel converts some integers or strings to dates. Excel, on the other hand, does so without asking ...

How to Fix Convert to Number Error in Excel (6 Methods)

Sometimes values look like numbers but don’t work like numbers as they can’t add up, multiply, etc. The numbers stored as the text will not work ...

How to Unhide Top Rows in Excel (7 Methods)

To unhide the hidden rows or columns is very common in Excel files. We hide rows or columns intentionally. So, the viewers can not see the ...

How to Convert Scientific Notation to Number in Excel (7 Methods)

In Microsoft Excel, there could be cases where we need to change the Scientific Notation to Text format to show the number in full length. One of the ...

How to Freeze First 3 Columns in Excel (4 Quick Ways)

For the purpose of easy navigation, we may be required to freeze some of the rows or columns of a worksheet. Freezing columns in a worksheet is a ...

How to Protect Excel Sheet from Copy-Paste (4 Effective Ways)

In this article, we will learn how to protect an Excel sheet from copy-paste. Sometimes, we make large datasets in our sheets and perform various ...

How to Convert SAP Timestamp to Date in Excel (4 Ways)

If you are looking for some of the easiest ways to convert SAP Timestamp to date in Excel easily, then you will find this article useful. SAP ...

How to AutoFill Numbers in Excel with Filter (2 Methods)

We often need to work with huge datasets in Excel. Auto Filling numbers with Filter can make our task much easier. So, we should know how to AutoFill ...

Excel Formulas to Fill Down Sequence Numbers Skip Hidden Rows

Sometimes we need to hide some unnecessary rows in Excel to present the information. There we frequently face a problem filling down the sequence ...

How to Calculate Average of Multiple Columns in Excel (6 Methods)

In this tutorial, I will show some methods for calculating the average of multiple columns in Excel. Usually, you can get an average of a range of ...

How to Remove Duplicates in Excel (9 Simple Ways)

Removing duplicates in Excel means keeping unique values and erasing the multiple instances. In this Excel tutorial, you will learn how to remove ...

How to Get Average Time in Excel (3 Examples)

Excel is a useful program that allows us to perform a variety of numerical calculations such as multiplication, division, addition, subtraction, ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo