Excel Tips and Tricks
How to use symbols on charts in Excel
Adding symbols or icons into charts can enhance the visual representation, and make it easier to understand the data. In this article, we are going to show you how to use symbols on charts in Excel. [button...
How to find nth closest match in Excel
In this article, we are going to show you how to find nth closest match in Excel. [box...
How to create a Waterfall Chart in Excel
A waterfall chart is a data visualization tool that shows how positive or negative values in a data series change in a sequential manner. A common scenario is to display the cumulative effect of income and expenses on net income. The values can be distributed either...
How to cut and paste transpose in Excel
A common problem when transposing data in Excel is that data is populated in their relative cells. This means that you may occasionally see messed up references when using the Paste function with transpose. In this article, we are going to show you how to cut and...
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://www.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 hyperlink to the current workbook folder in Excel
A hyperlink is not only for navigation between internet pages! Just like with websites, hyperlinks can be very useful in Excel too. You can even create hyperlinks to sheets or references in an Excel workbook as well. For example, you can generate a hyperlink to the...