Resources
How to set different colors to positive and negative numbers in a column chart in Excel
Color differences are probably the first thing that human eye can catch. Because a visualization should be easy to understand, different colors may be your best option to express opposite data like positive and negative values. In this guide, we’re going to show you...
How to protect a worksheet except for individual cells in Excel
The more people work on an Excel file, higher the risk of corrupting it. Let's say that you have created a layout that clearly indicates where the input cells and output cells are. It's almost impossible that your file will maintain its initial state when it has been...
How to split worksheet in Excel
As data grows in a worksheet, it gets harder to manage it. Even a large monitor doesn't help while dealing with thousand rows and hundreds of columns. Fortunately, Excel allows you to split the window up to 4 panes which you can focus on different parts of the...
How to extract date from string in Excel
In this guide, we’re going to show you how to extract date from string in Excel by using formulas and VBA. Download...
How to create five-star rating chart in Excel
Star rating charts are a type of visualization that can display data like a bar chart, but with stars instead. A common use case for this chart type is for displaying customer satisfaction in product reviews. In this guide, we’re going to show you how to create...
How to spell check using VBA in Excel
Excel can spell check, but it's not as capable as the spell check in Word, nor is it automatic. Using VBA, you can automate the spell-checking process in your workbooks. In this guide, we’re going to show you how to spell check using VBA in Excel. [button...
How to spell check in Excel
Neither Excel is a word processing software, nor most of Excel users do care about spell checking in their workbooks. However, Excel does have a spell check feature even though it is not as powerful as Word or PowerPoint offers. In this guide, we’re going to show you...
How to calculate exponential moving average in Excel
Exponential moving average option is a data smoothing approach which gives exponentially decreasing weights to values over time. In this guide, we’re going to show you how to calculate exponential moving average in Excel. [button...
How to calculate weighted moving average in Excel
Weighted moving average is a data smoothing approach that gives more weight to more recent time periods. In this guide, we’re going to show you how to calculate weighted moving average in Excel. [button...