by Ilker | Aug 19, 2021 | Excel Tips & Tricks
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...
by Ilker | Aug 17, 2021 | Excel Tips & Tricks
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...
by Adam | Aug 16, 2021 | Excel Tips & Tricks
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....
by Ilker | Aug 11, 2021 | Excel Tips & Tricks
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...
by Ilker | Aug 10, 2021 | Excel Tips & Tricks
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...
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...