How to import XML files into Excel

How to import XML files into Excel

XML is a common file type for storing and transferring data. In this article, we are going to show you how to import XML files into Excel using two methods: First is a more “direct method” and the other is the Power Query approach. Download Workbook Let...
How to find the last day of a month in Excel

How to find the last day of a month in Excel

In this article, we are going to show you how to find the last day of a month in Excel. Download Workbook We will be using two functions to find the last day of a month in Excel: DAY and EOMONTH. =DAY(EOMONTH(<Date>,0)) The EOMONTH returns the date value of the...
How to find the position of the minimum value in Excel

How to find the position of the minimum value in Excel

You can find the minimum value in a range or array using the MIN, MINA and MINIFS functions. If you need to find the position of the minimum value instead, you will need a combination of these functions. In this article, we are going to show you how to find the...
How to find the position of the maximum value in Excel

How to find the position of the maximum value in Excel

Excel has the MAX, MAXA and MAXIFS functions that can find the maximum value in a range or array. If you need to the position of the maximum value, however, you need to combine these formulas with others. In this article, we are going to show you how to find the...
Function: LET

Function: LET

The LET function can define names within the scope of a formula. This essentially offers better readability and help with calculation performance. In this guide, we are going to show you how to use the LET function and go over some tips and error handling methods....
How to prevent future dates from being entered in Excel

How to prevent future dates from being entered in Excel

It can be a challenge to make data entry consistent in concurrent use. A common example is entering a future date into a form. In this article, we are going to show you how to prevent future dates in Excel. Download Workbook To limit the user interaction with the...
Box-and-Whisker Charts

Box-and-Whisker Charts

A box-and-whisker chart is a visualization of groups of numerical data and their quartiles in the data set. Originally named boxplot chart, this visualization gets its name from a box that represents the lower and upper quartiles, and lines extending from the box...
How to create a sequence of dates in Excel - Autofill

How to create a sequence of dates in Excel - Autofill

In this article, we are going to show you how to create a sequence of dates in Excel using the Auto Fill feature. AutoFill is the action of dragging the small square at the bottom-right corner of a cell. The small square is called the fill handle. This feature can be...
How to create a dynamically changing calendar in Excel

How to create a dynamically changing calendar in Excel

In this article, we are going to show you how to create a dynamically changing calendar in Excel. Download Workbook Populate variables First step is creating the variables to be used in the formulas. These variables need to provide the present day information so that...