How to Change Date Format in Excel (The Easy Way) Dates and times are two of the most common data types that users work with when using Microsoft Excel. 📅 However, it may be confusing for users to work with dates as Excel has default date formats and has a variety of ways [...]
How to Find Duplicates in Excel Using a Formula It’s normal to find duplicate data in your Excel files. When you’re dealing with a small group of data, finding duplicates should be easy-peasy. But when your Excel sheet is filled with rows and columns of data, it could be stressful. 😫 Duplicate data [...]
Excel Date Formula Explained (Change Date Format) Using dates in Excel can get frustrating sometimes if you do not understand the science that runs behind a date stored in Excel. There are just so many ways how a date can be presented in Excel. From a short date format to a long date [...]
How to Combine Two Columns in Excel (Without Losing Data) In Microsoft Excel, you can use the Merge Cells feature to combine two or more cells, columns, or rows. This feature is best when you combine cells with no data in them. If these cells contain data, using the merge cells feature will [...]
How to Highlight Duplicates in Excel (Step-by-Step) There are several ways you can identify duplicates in Excel, you can do them by using Excel tools and even formulas. However, one of the most persuasive ways to highlight duplicates is to highlight them (it's catchy, and there's no chance it will skip your sight [...]
How to Change Negative Numbers to Positive in Excel Got your data cluttered with negative numbers? It is quite common if you're importing data in Excel from an external source (web, a CSV file, etc.) or even if you merged data from some sources. Unwanted negative numbers in your Excel sheet can be [...]
How to Use an Array Formula in Excel (+Examples) Array formula in Excel is an exceptional feature that allows you to manipulate and organize large sets of data easily into a single cell. For instance, you would need multiple nested IFS of SUMIFS functions to find the sum of values in your sheet [...]
How to Calculate Discount Percentages in Excel (Easy) Who doesn’t like discounts? Getting a thing for only a certain percentage of its actual price is always a win-win situation. While we see sign boards all around 20%, 30%, 50%, and other discounts. Applying a discount percentage to a price to find out the [...]
How to Average a Range in Excel and Ignore Zero (0) Averaging a range of numbers in Excel is all about using the AVERAGE function. Simple enough. However, if your range of numbers contains undesired zeros that you do not want to be included in the average – this is not as simple [...]
How to Calculate Your Expected Return in Excel (Easy) The expected return on an investment is a very crucial measure for the people of finances. If you're about to make up a portfolio of investments for yourself, make sure you've critically evaluated the expected return it shall yield to you will all the [...]