How to calculate simple moving average in Excel

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. Download Workbook What is Simple Moving...
How to insert a picture into a note in Excel

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

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

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. Download Workbook What is Status Bar? The status bar is the bottom section of the application window (like in some other Windows applications). It displays additional information...
How to manage worksheets in Excel

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

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. Download Workbook What...
How to calculate simple interest in Excel

How to calculate simple interest in Excel

In this guide, we’re going to show you how to calculate simple interest in Excel. Download Workbook What is Simple interest? Simple interest is the most basic approach to calculate the amount earned from an investment or payment of a loan. Simple interest method...
How to calculate compound interest in Excel

How to calculate compound interest in Excel

In this guide, we’re going to show you how to calculate compound interest in Excel. Download Workbook Compound interest Compound interest means "interest on the interest", which defines the interest calculation based on both the initial principal and the accumulated...