How to Insert Date in Excel? (Shortcut + Formulas)
Inserting dates is a frequently performed task in Excel. Whether you want to create a meeting schedule for the entire week or you want to list down the joining dates …
Steve Scott
How to Filter by Color in Excel?
When working with large data sets in Excel, it is often helpful to filter the data so that only the required rows are visible while the rest remain hidden. While …
ALT + F4 in Excel – What Does it Do?
When working with Microsoft Excel, knowing keyboard shortcuts can save you a lot of time and make your tasks much more efficient. One such keyboard shortcut is the combination of …
How to Open DAT Files in Excel?
A file with the .dat extension is referred to as a DAT file. DAT files commonly contain binary text data and may be used to store large amounts of data …
Control E in Excel – What Does it Do?
The shortcut Control E triggers the Flash Fill feature in Excel. It ranks at the top of the most valuable shortcuts in Excel and can be considered Excel’s superpower. This …
Round Up to the Nearest Whole Number in Excel (Formulas)
When we do calculations in Excel, there is often a need to round up the result. Let’s say you are working on multiple construction projects, and you want to estimate …
COUNTIF Greater Than Zero in Excel
It’s a common task for many Excel users to find out the count of cells that contains a value greater than 0. Doing this manually would be time-consuming and error-prone. …
How To Hide Formulas In Excel Without Protecting the Sheet?
Sometimes we may need to hide formulas in our Excel worksheet without necessarily protecting the sheet or protecting the cells that have the formulas. In this tutorial, I will cover …
How to Convert PDF to Excel without Software?
Documents such as bank statements may be sent to us in PDF format. We may need to convert these documents into Excel. This enables us to use the powerful Excel …
How to Combine Two Columns in Excel (with Space/Comma)
As we work with Excel, we may sometimes need to combine two columns and separate them with characters such as a space or a comma. Below is an example where …
How to Use Greater Than or Equal to Operator in Excel Formula?
Excel’s Greater Than or Equal To (>=) operator is a comparison operator. It compares two values of the same data type. It returns TRUE if the greater than or equal …
How to Select Non-adjacent Cells in Excel?
To perform some operations in Excel requires that we first select cells. Selecting adjacent cells is easy. While selecting non-adjacent cells is not as straightforward, with a bit of practice, you …