Excel Tips and Tricks
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...
How to calculate the percent of completed year
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. [button...
How to create a thermometer chart in Excel
A thermometer chart is an effective way of comparing two values. Although Excel doesn’t support this specific chart type, there is a way to create a thermometer chart. In this article, we are going to show you how to create a thermometer chart in Excel. [button...
How to modify a Comment Box in Excel
The default comment box style in Excel is, unfortunately, fairly outdated. You can't really change much other than fonts and colors. In this article, we are going to show you how to modify a Comment Box in Excel. [button...
How to show workbook location in Quick Access Toolbar
Finding your active file’s location can be a bit tricky at times. However, you can see the file location and even copy its location as a text from the Quick Access Toolbar. In this article, we are going to show you how to show workbook location in Quick Access...
How to use Clipboard in Excel
Copy and Paste is essential in daily computer use. If you copy and paste a lot, like most people, you can find yourself pasting the same information again and again. Excel’s Clipboard feature lists the items you've copied before and allow you to paste them whenever...
How to select a random item by distribution in Excel
Let’s say you need to populate items randomly. You can use Excel’s RANDBETWEEN function to select a random item from a list. What if the distribution of the items is not uniform? In this article, we are going to show you how to select a random item by distribution in...