Resources
How to calculate simple moving average in Excel
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. [button...
How to insert a picture into a note in Excel
"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...
How to create a stream graph in Excel
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....
How to show a message on Status Bar in Excel
In this guide, we’re going to show you how to show a message on Status Bar in Excel. What is...
How to generate numbers without dragging the mouse in Excel
It is almost impossible to think of Excel without autofill feature. It allows you to generate numbers or dates and copy formulas with a single mouse movement. However, this single action can be a burden when you need to generate numbers in a large range. In this...
How to get division remainders in Excel using the MOD function
In this guide, we’re going to show you how to get division remainders in Excel using the MOD function. This function is frequently used in mathematical and logical calculations. You can create distributions, create a switch mechanism, and more with the MOD function....
How to manage worksheets in Excel
Higher the number of worksheets in an Excel file, higher the time spent trying to find a specific sheet. In this guide, we’re going to show you how to manage worksheets in Excel with some simple tips and shortcuts. See all sheets and navigate To see the list of all...
How to use Data Table in Excel
A data table can show the results for all possible outcomes at once and saves you from testing against variables individually in your Excel models. In this guide, we’re going to show you how to use Data Table in Excel with one and two variables. [button...
How to calculate simple interest in Excel
In this guide, we’re going to show you how to calculate simple interest in Excel. What is Simple...