Resources
How to calculate compound interest in Excel
In this guide, we’re going to show you how to calculate compound interest in Excel. Compound...
How to do linear regression in Excel
In this guide, we’re going to show you how to do linear regression in Excel. Linear regression Linear...
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 convert string to number in Excel using VBA
Numeric values are defined by data types like integer or byte. These data types are used for optimizing the processing and memory allocation in Excel. In this guide, we’re going to show you how to convert string into number in Excel VBA. [button...
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
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 Combo Box in Excel
A combo box - also known as a dropdown control - allows selecting an input from a list of options. In this guide, we’re going to show you how to insert a combo box in Excel. [button...
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. [button...
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. ...