Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 30 of 60 · 540 articles
How to get a list of file names in Excel
In this article, we are going to show you how to get a list of file names from a specific folder and all its subfolders in Excel.
How to use the "Pick from drop-down list" feature in Excel
In this article, we are going to show you how to use pick from drop-down list feature in Excel, the fastest populated drop-down.
How to import XML files into Excel
In this article, we are going to show you how to import XML files into Excel. We will describe both direct method and Power Query approach.
How to find the last day of a month in Excel
Learn how to find the last day of a month in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to find the position of the minimum value in Excel
In this article, we are going to show you how to find the position of the minimum value in Excel with MATCH and MIN functions.
How to find the position of the maximum value in Excel
In this article, we are going to show you how to find the position of the maximum value in Excel with 2 ways.
How to prevent future dates from being entered in Excel
In this article, we are going to show you how to prevent future dates in Excel by using Data Validations rules.
Box-and-Whisker Charts
In this guide, we’re going to show you how to create a box-and-whisker chart in Excel. These charts can be used for statistical plotting.
How to create a sequence of dates in Excel - Autofill
Learn how to create a sequence of dates in Excel - Autofill. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.