Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 32 of 60 · 540 articles
How to count the number of cells greater than the average in Excel
Learn how to count the number of cells greater than the average in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to count the number of cells less than the average in Excel
Learn how to count the number of cells less than the average in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to create a pizza chart in Excel
In this article, we are going to show you how to create a pizza chart in Excel. You can give your charts a fancy look.
How to create a worksheet selection popup in Excel
In this article, we are going to show you how to create a worksheet selection popup in Excel by using VBA.
How to calculate the percent of completed month
In this article, we are going to show you how to calculate the percent of completed month in Excel. The article uses DAY and EOMONTH.
How to calculate the percent of completed year
In this article, you'll learn how to calculate the percent of completed year in Excel. Formula is using YEARFRAC, DATE and YEAR functions.
How to create a thermometer chart in Excel
A thermometer chart is a way of comparing two values. In this article, we are going to show you how to create a thermometer chart in Excel.
How to modify a Comment Box in Excel
The default comment box style in Excel is fairly outdated. In this article, we are going to show you how to modify a Comment Box in Excel.
How to use Clipboard in Excel
Clipboard feature lists the items you copied and allow you to paste. In this article, we are going to show you how to use Clipboard in Excel.