Resources
Retirement Savings Calculator
This is an Excel based retirement savings calculator. Download the Excel template from the link below and start using it. It requires entering your current age, retirement age, investments up to now, expected annual return, annual payments and number of remaining...
Mortgage Calculator
This is an easy to use Excel mortgage calculator template. Simply download from the link below and start using it. It requires home value, loan amount, interest rate, loan term and property tax rate inputs. It calculates your monthly payments. It also calculates the...
How to find the first blank cell in a range in Excel
Finding the first blank cell in your workbook can become a fairly repetitive task, especially in situations like adding new rows into a large data set. In this article, we are going to show you how to find the first blank cell in a range in Excel, and also show you...
How to find the first non-blank cell in a range in Excel
If you frequently analyze data in Excel, you may come across empty cells before the actual values. Instead of removing these cells, you can get the position or even the value of the first non-blank cell with formulas. In this article, we are going to show you how to...
How to count the number of cells greater than the average in Excel
In this article, we are going to show you how to count the number of cells greater than the average in Excel. [button link="https://spreadsheetweb.com/wp-content/uploads/2020/09/How-to-count-the-number-of-cells-greater-than-the-average-in-Excel.xlsx" type="big"...
How to count the number of cells less than the average in Excel
In this article, we are going to show you how to count the number of cells that is less than the average of that data set in Excel. [button...
How to create a pizza chart in Excel
Of course, there isn’t a chart type called a pizza chart in Excel. On the other hand, Excel has a support for inserting images into chart elements. With help of this cool feature, you can give your charts a fancy look. In this article, we are going to show you how to...
How to create a worksheet selection popup in Excel
If your work requires navigating between worksheets a lot, activating those sheets can quickly become a hassle. Some VBA tips we're going to cover here can help you to create a popup list of worksheets where you want them, and save yourself from the default worksheets...
How to calculate the percent of completed month
Have you ever wanted to track what percent of the month is completed? In this article, we are going to show you how to calculate the percent of completed month in Excel. If you want to calculate the percent of completed year instead, follow the link: How to calculate...