How to Separate Date and Time in Excel?
There may be times when you import datasets and find that date and time columns have been combined. In this tutorial, we are going to look at seven simple methods …
Steve Scott
How to Turn OFF Scroll Lock In Excel?
If the Scroll Lock is turned on in Excel, the active cell remains unchanged as you scroll through the worksheet using the arrow keys. This is convenient if you want …
How to Filter Multiple Columns in Excel?
In Microsoft Excel, when we apply a filter to a specific column it only filters all the columns based on that specific column. But we often came across situations where …
How to Change Commas to Decimal Points in Excel?
Countries such as the USA and the UK use a comma to separate groups of thousands and a decimal point to separate decimals. Many other countries such as Spain and …
Excel Not Responding – How To Fix It!
Sometimes when you launch Excel or are in the process of working with Excel, Excel freezes and returns a message box indicating that Microsoft Excel is not responding. This tutorial …
VLOOKUP Not Working – 7 Possible Reasons + Fix!
The VLOOKUP Function allows you to retrieve information from a vertically arranged table or dataset. It’s an extremely popular Excel function that automates looking up information from large datasets. However, …
How to Edit Document Properties in Excel?
Document Properties in Excel are a set of data that describe the document. This information includes the author, title, company name, and other information about the document (such as the …
How to Link Cells in Excel (Same Worksheet, Between Worksheets/Workbooks)
Linked cells in Excel refer to the contents of other cells. The other cells may be in the same worksheet, other worksheets in the same workbook, or worksheets in other …
How to Add Zero In Front of Number in Excel?
If you try to add a leading zero in front of a number in Excel, Excel removes it immediately after you press Enter. This is because a zero before a …
How to Calculate the Interquartile Range in Excel?
The Interquartile Range is commonly used in statistics as it helps us identify the natural seasonality and monthly trends in a dataset. It gives you insight into the spread of …
How To Combine Date and Time in Excel?
Sometimes you may have a dataset in Excel that has date and time values in separate columns. You may want to combine those values in one column. In this tutorial, …
How to Get the First Day Of The Month In Excel?
Sometimes, you may want to get the first day of the month when you already have a date. For example, if you have 15 Jan 2023, you can use a …