Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 53 of 60 · 540 articles
How to replace characters in Excel
In this article we're going to show you how to replace a character in Excel using the SUBSTITUTE function.
Grouping Dates in Pivot Table
Learn about grouping Dates in Pivot Table in Excel, including the relevant formula or feature, setup steps, and practical usage.
How to sum by date in Excel without time
Excel has functions like the SUMIFS can't work if you have date-time values combined. This article shows How to sum by date in Excel without time.
How to calculate running totals in Excel Tables
Learn how to calculate running totals in Excel Tables. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to create a Quarter formula in Excel
Learn how to create a Quarter formula in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to generate Excel month names
Learn how to generate Excel month names. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to create a dynamic drop down list in Excel
Creating a dynamic Excel drop down list is useful If you have a list that is updated frequently. This article shows you how to create a dynamic drop down lists with the help of OFFSET and COUNTA functions.
How to get Excel cell address of a lookup result
Learn how to get Excel cell address of a lookup result. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to change number format in Excel chart
Learn how to change number format in Excel chart. This practical guide covers the required setup, step-by-step process, and useful Excel options.