Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 56 of 60 · 540 articles
How to find nth smallest value in a data table
Learn how to find nth smallest value in a data table. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to count values by length
Learn how to count values by length. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to count years between two dates with the DATEDIF
This article show you how to get years between two dates and meets you with a hidden gem in Excel, the DATEDIF function.
How to count months between two dates with the DATEDIF
This article show you how to get months between two dates and meets you with a hidden gem in Excel, the DATEDIF function.
How to SUM 2d ranges with SUMPRODUCT
You can easily sum values by condition(s) with SUMIF and SUMIFS functions; with a limitation. The sum range and criteria ranges should have equal sizes.
How to SUM values across sheets
Learn how to sUM values across sheets. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to count values if date is less than by using COUNTIF function
Learn how to count values if date is less than by using COUNTIF function. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to convert D/M/YYYY date to M/D/YYYY or vice versa
Data formats differ by locations in the world. They all have a standard. Once you understand the syntax of dates you can easily convert them from one locale to the other.
How to count values if date is greater than by using COUNTIF function
Learn how to count values if date is greater than by using COUNTIF function. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.