by Ilker | Oct 8, 2020 | Excel Tips & Tricks
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...
by Ilker | Sep 22, 2020 | Excel Tips & Tricks
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...
by Ilker | Sep 22, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to count the number of cells greater than the average in Excel. Download Workbook Formula =COUNTIFS(<numbers range>,”>“&AVERAGE(<numbers range>)) <numbers range>: The reference from the range of...
by Ilker | Sep 22, 2020 | Excel Tips & Tricks
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. Download Workbook Formula =COUNTIFS(<numbers range>,”<“&AVERAGE(<numbers range>)) <numbers range>: The...
by Ilker | Sep 21, 2020 | Excel Tips & Tricks
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...
by Ilker | Sep 17, 2020 | Excel Tips & Tricks
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...
by Ilker | Sep 16, 2020 | Excel Tips & Tricks
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...
by Ilker | Sep 11, 2020 | Excel Tips & Tricks
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...
