by Ilker | Sep 3, 2019 | Excel Tips & Tricks
Excel’s merge cells feature provides an easy way to group multiple cells together. You can create multi-level headers by merging cells on the previous row or column. Merged cells looks like a higher category that contain the information in the following cells....
by Ilker | Sep 2, 2019 | Excel Tips & Tricks
You can easily increase the column width to fit more contents into a smaller area. However, increasing the column width means that you’re going to be able to use fewer columns. Changing the alignment of the text can help overcome these limitations and allow you...
by Ilker | Aug 29, 2019 | Excel Tips & Tricks
Hiding zero (0) values in Excel can be especially helpful for de-cluttering your workbooks and in most cases, make them easier to read. In this guide, we’re going to show you how to hide zeros in Excel worksheets, following three different methods. How to Hide Zeros...
by Ilker | Aug 29, 2019 | Excel Formulas
The ERROR.TYPE function is an Information formula that returns an index number corresponding to a specific error value in Microsoft Excel. If there are no errors in the target cell(s), the function returns another error value, #N/A. This function can be especially...
by Ilker | Aug 29, 2019 | Excel Formulas
The Excel NOMINAL function is a Financial formula that calculates and returns the nominal annual interest rate, for a given effective annual interest rate and number of compounding periods per year. The nominal annual interest rate is used for calculating financial...
by Ilker | Aug 28, 2019 | Excel Tips & Tricks
In this guide, we are going to show you how you can open all files in a folder on startup. Excel allows selecting a specific folder to open the files in it automatically when Excel starts. This can be a project or template folder, or just a folder on the network used...
by Ilker | Aug 27, 2019 | Excel Formulas
The Excel EFFECT function is a Financial formula that calculates and returns the effective annual interest rate, for a given nominal annual interest rate and number of compounding periods per year. The effective annual interest rate is used to compare financial loans...
by Ilker | Aug 27, 2019 | Excel Formulas
The DURATION Excel function is a Financial formula that calculates and returns the annual duration of a security based on the Macauley duration formula. In this guide, we’re going to show you how to use the DURATION function and also go over some tips and error...
by Ilker | Aug 26, 2019 | Excel Formulas
The Excel YIELD function is a Financial formula that calculates and returns the yield on a security that pays a periodic interest. A common use case for the YIELD function is calculating bond yields. In this guide, we’re going to show you how to use the Excel YIELD...