by Ilker | Aug 9, 2021 | Excel Tips & Tricks
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...
by Ilker | Aug 9, 2021 | Excel Tips & Tricks
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...
by Ilker | Aug 5, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to do linear regression in Excel. Download Workbook Linear regression Linear regression is a statistical analysis tool t find the correlation between two factors. It is calculated using the following formula, which shows how...
by Ilker | Aug 5, 2021 | Excel Tips & Tricks
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...
by Ilker | Aug 4, 2021 | Uncategorized
Excel doesn’t have a predefined chart category for slopegraphs, but you can modify a line chart to create one. In this guide, we’re going to show you how to create slopegraphs in Excel. Download Workbook What is a slopegraph? Slopegraphs are good for displaying...
by Ilker | Jul 30, 2021 | Excel Tips & Tricks
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. Download Workbook Data types...
by Ilker | Jul 29, 2021 | Excel Tips & Tricks
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...
by Ilker | Jul 29, 2021 | Excel Tips & Tricks
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...
by Ilker | Jul 28, 2021 | Excel Tips & Tricks
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. Download Workbook Please note that this is a guide to insert a form control combo box which is...
