by Ilker | Dec 22, 2020 | Excel Tips & Tricks
Tracking and managing data across multiple files can be challenging. With Power Query, you can get the file names from a specific folder and all its sub-folders. In this article, we are going to show you how to get a list of file names in Excel. Download Workbook We...
by Ilker | Dec 21, 2020 | Excel Tips & Tricks
Dropdown lists are a common example of data validation used in organizing data input. In this article, we are going to show you how to use pick from drop-down list feature in Excel. Download Workbook The “Pick from drop-down list” feature generates a...
by Ilker | Dec 21, 2020 | Excel Tips & Tricks
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...
by Ilker | Dec 18, 2020 | Excel Tips & Tricks
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...
by Ilker | Dec 18, 2020 | Excel Tips & Tricks
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...
by Ilker | Dec 16, 2020 | Excel Tips & Tricks
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...
by Ilker | Dec 10, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to allow users to enter date values only for the current week in Excel. Download Workbook To limit the user interaction with input cells, you can define validations. You might be familiar with data validation from dropdown...
by Ilker | Dec 8, 2020 | Excel Tips & Tricks
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...
by Ilker | Nov 27, 2020 | Excel Tips & Tricks
Formula intersections can help simplify your formulas. There are 2 types of intersections in Excel: implicit and explicit. In this guide, we’re going to show you implicit vs explicit intersections in Excel. Download Workbook Implicit Intersections If you are using...
