by Ilker | Aug 21, 2019 | Excel Formulas
The PRICEDISC Excel function is a Financial formula that calculates and returns the price per $100 face value of a discounted security. In this guide, we’re going to show you how to use the PRICEDISC function and also go over some tips and error handling methods....
by Ilker | Aug 20, 2019 | Excel Formulas
The Excel PRICE function is a Financial formula that calculates and returns the price per $100 face value of a security that pays periodic interest. In this guide, we’re going to show you how to use the PRICE function and also go over some tips and error handling...
by Ilker | Aug 19, 2019 | Excel Tips & Tricks
Do the Excel grildine color not match the look-and-feel of your application, or are you just bored of the classic gray colors? Even though you can use border coloring to change those colors, there is an even better way to do this without applying a formatting to all...
by Ilker | Aug 8, 2019 | Excel Formulas
The Excel FALSE function is a Logical formula that essentially returns the logical value FALSE. Microsoft says that the FALSE is kept in Excel for the sake of compatibility with other spreadsheet programs. You do not need to use in most cases, except for when using...
by Ilker | Aug 8, 2019 | Excel Formulas
The Excel TRUE function is a Logical formula that essentially returns the logical value TRUE. Microsoft notes that the TRUE function is included in Excel for compatibility with other spreadsheet programs. You do not need to use in most cases, except for when using...
by Ilker | Aug 8, 2019 | Excel Tips & Tricks
If your worksheet contains multiple pages, you will see header rows or columns only printed in the first page by default. In this article, we are going to show you how to print header row in Excel to repeat on every printed page in Excel 2016, Excel 2013, Excel 2010...
by Ilker | Aug 1, 2019 | Excel Tips & Tricks
The headings in Excel are essentially the screen guides that make working with cells or ranges easier. By default, row and column headings in Excel don’t show in printed documents. If you want to print them anyways, Excel has an option which allows including row...
by Ilker | Jul 30, 2019 | Excel Tips & Tricks
The grid structure is an important feature that helps distinguish between sections, and build an interface easily when using spreadsheets. They are the guide in this structure that makes each cell distinct from other. If you want the gridlines that appear on...
by Ilker | Jul 29, 2019 | Excel Formulas
The Excel ERF.PRECISE (ERF PRECISE) function is an Engineering formula that calculates and returns the error function, integrated between a limit and zero (0). This function has been introduced Excel 2010, and is not available in earlier versions. However, the...
