How to convert European date to US date in Excel with formula

How to convert European date to US date in Excel with formula

You might have already seen that Excel's date-related functions return errors or incorrect values with external data. The most common reason is the difference between date formats, such as reverse day and month figures. Usual scenario between US and European...
How to convert European date to US date in Excel

How to convert European date to US date in Excel

Date formats vary between countries. If you need to work with external source reports from a different country, you may see that Excel doesn't recognize the dates or recognize them wrongly. The most common case happens between US and European countries because of the...
How to swap two cells in Excel

How to swap two cells in Excel

Although swapping two cells sounds easy, it may become complicated what you want to be swapped or not. In this article, we are going to show how to swap two cells in Excel for several scenarios. Download Workbook Swapping two adjoining cells Let's start with the...
How to generate Descriptive Statistics in Excel

How to generate Descriptive Statistics in Excel

Descriptive statistics are summarizations of your dataset. This summary includes mean, median, mode, standard deviation, variance, minimum and maximum variables, kurtosis, and skewness. Excel can generate all these measures for a selected range in a proper table. In...
How to use subtotal feature in Excel

How to use subtotal feature in Excel

A subtotal is the aggregation of a data set, typically showing the totals of a certain section in that data set. Excel gives you tools to calculate subtotals in different ways. In this article, we are going to show how to use the subtotal feature in Excel. Download...
How to display negative numbers as zero in Excel

How to display negative numbers as zero in Excel

In this guide, we’re going to show you How to display negative numbers as zero in Excel in two ways. Download-Workbook Formula approach to display negative numbers as zero The first method in our list is the formula way. An obvious way is to use the IF function which...
How to Create Charts with Formula in Excel

How to Create Charts with Formula in Excel

Excel keeps growing its visualization tools with each version. And the charts are the flagship of those. Although they present lots of customization options, they may become overwhelming when you just need to create a simple bar or column chart. In this guide, we’re...