by Ilker | Dec 22, 2021 | Excel Formulas
DB The DB function is a Finance function that calculates the depreciation of an asset on the fixed-declining balance basis for a specified period. In this guide, we’re going to show you how to use the DB function and go over some tips and error handling methods....
by Ilker | Dec 22, 2021 | Excel Formulas
The SYD function is a Finance function that calculates the depreciation of an asset on the sum-of-years' digits basis for a specified period. In this guide, we’re going to show you how to use the SYD function and go over some tips and error handling methods. Supported...
by Ilker | Dec 21, 2021 | Excel Formulas
The SLN function is a Finance function that calculates the depreciation of an asset on a straight-line basis for one period. In this guide, we’re going to show you how to use the SLN function and go over some tips and error handling methods. Supported versions All...
by Ilker | Dec 20, 2021 | Excel Tips & Tricks
A pill chart is a fancier way of drawing bar or column charts. Rounded corners and space after axis are enough to make your dashboards catchier. In this guide, we’re going to show you How to create pill charts in Excel. Download Workbook[/button Raw data The following...
by Ilker | Dec 13, 2021 | Excel Tips & Tricks
In this article will show you How to insert chess symbols in Excel. Download Workbook[/button Copy & Paste You can simply copy & paste the character from here: ♔♕♖♗♘♙♚♛♜♝♞♟ Enjoy. 🙂 Symbols Excel (Word too) has a feature named Symbol which is a dialog box that...
by Ilker | Dec 13, 2021 | Excel Tips & Tricks
The importance and use cases of randomized data is increasing as the information technologies grows. You can lower the margin of error in analyzing methods and testing algorithms or eliminate the bias between subjects in the datasets. In this article will show you How...
by Ilker | Dec 9, 2021 | Excel Tips & Tricks
Greek letters are commonly used in various areas, like mathematics and science as symbols for constants or variables, or even in the game industry to define phases of a product. They are also commonly used nowadays with naming new COVID-19 variants. If you need them...
by Ilker | Nov 29, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to create a progress chart in Excel. Download Workbook Steps to create a progress chart 1. Calculate remaining process Start by calculating the remaining process. If you are using a percentage value, the formula will...
by Ilker | Nov 29, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to calculate area under curve in Excel. Download Workbook Unfortunately, there isn't a single function or feature that can calculate area under curve in Excel. You can still rely on integrals to calculate area. On the other...
