by Ilker | Sep 30, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to extract date from string in Excel by using formulas and VBA. Download Macro-Free Workbook Download Workbook Note that, there isn't a single formula or approach that can handle all scenarios. Extracting dates from strings...
by Ilker | Sep 27, 2021 | Excel Tips & Tricks
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...
by Ilker | Sep 13, 2021 | Excel Tips & Tricks
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. Download Workbook...
by Ilker | Sep 10, 2021 | Excel Tips & Tricks
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...
by Ilker | Sep 9, 2021 | Excel Tips & Tricks
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. Download Workbook What is exponential moving...
by Ilker | Sep 9, 2021 | Excel Tips & Tricks
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. Download Workbook What is weighted moving average (WMA)? Moving average...
by Ilker | Sep 6, 2021 | Excel Tips & Tricks
Moving average calculations is a common way of smoothing data to reduce the effects of random, short-term fluctuations. In this guide, we’re going to show you how to calculate simple moving averages in Excel using three methods. Download Workbook What is Simple Moving...
by Ilker | Sep 2, 2021 | Excel Tips & Tricks
"Traditional comments" were renamed to Notes in Excel 365. The comments feature in 365 refers to a threaded layout that allow users to have discussion in a particular cell. In this guide, we are going to be looking at "legacy comments" and show you how to insert a...
by Ilker | Aug 27, 2021 | Excel Tips & Tricks
A stream graph is a form of stacked area chart in a flowing, organic shape. The graph is displaced around a central axis to visualize the data without expressing positive or negative values. In this guide, we’re going to show you how to create a stream graph in Excel....
