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...
How to create a step chart in Excel

How to create a step chart in Excel

A step chart is a type of line chart that displays the changes over time in data. Unlike a regular line chart, step charts connect data points with vertical and horizontal lines. Although Excel does not have step chart support by default, you can follow our guide to...
How to use Scenario Manager in Excel

How to use Scenario Manager in Excel

The Scenario Manager can keep a set of input values for specific cells, and allows you to switch between them.This can be very helpful if you have a lot of input combinations to test against a model. In this guide, we’re going to show you how to use Scenario Manager...
How to print header row and column in Excel

How to print header row and column in Excel

You can freeze rows or columns to make it easier working on large data tables. However, freezing has no effect on printed documents and you will get the original document with or without the rows and columns. In this guide, we’re going to show you how to print header...
How to insert a spin button in Excel

How to insert a spin button in Excel

A spin button is a control that allows users to select a numeric value from a specific range. These buttons consists of two arrow and look like scroll bars without the scroll. In this guide, we’re going to show you how to insert a spin button in Excel. Download...
How to show a closing message in Excel

How to show a closing message in Excel

In this guide, we’re going to show you how to show a closing message in Excel by using macros. Download Workbook ThisWorkbook object and Workbook_BeforeClose Event If you want to trigger any action at the before closing of your workbook, you must add your code under...