How to find the first non-blank cell in a range in Excel

How to find the first non-blank cell in a range in Excel

by | Sep 22, 2020

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...
Function: CELL

Function: CELL

by | Sep 21, 2020

The CELL is an Information function that returns information about various properties of a cell. You can learn things like file name with full folder path, location of a cell or formatting properties. In this guide, we’re going to show you how to use the CELL function...
How to create a pizza chart in Excel

How to create a pizza chart in Excel

by | Sep 17, 2020

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

How to create a worksheet selection popup in Excel

by | Sep 16, 2020

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...
How to calculate the percent of completed month

How to calculate the percent of completed month

by | Sep 11, 2020

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...
Function: YEARFRAC

Function: YEARFRAC

by | Sep 10, 2020

The YEARFRAC is a Date & Time function that calculates and returns the fraction of the year between two days. The function calculates the fraction by the number of whole days in given day count basis. In this guide, we’re going to show you how to use the YEARFRAC...
How to calculate the percent of completed year

How to calculate the percent of completed year

by | Sep 9, 2020

A percentage value is a great way to express a proportion’s size in whole. You may want to calculate and see what percent of the year is completed. In this article, we are going to show you how to calculate the percent of completed year in Excel. Download Workbook...