by Ilker | Oct 25, 2019 | Excel Formulas, Excel Tips & Tricks
Rounding numbers is a crucial element of creating legible and easy-to-use spreadsheet tools. Excel offers a few methods to do this, including a formula approach and the number formatting feature. In this guide, we're going to show you how to round numbers in Excel...
by Ilker | Oct 24, 2019 | Excel Tips & Tricks
Converting units can be time consuming when you rely on a separate tool or website to do it. In this guide, we are going to show you how to convert feet to inches and inches to feet in Excel. Download Workbook Manual approach The first approach we are going to show...
by Ilker | Oct 24, 2019 | Excel Tips & Tricks
Converting units can be time consuming when you rely on a separate tool or website to do it. In this guide, we are going to show you how to convert pounds to kg and kg to pounds. Download Workbook Manual approach The first approach we are going to show you is doing...
by Ilker | Oct 22, 2019 | Excel Tips & Tricks
Converting units can be time consuming when you rely on a separate tool or website to do it. In this guide, we are going to show you how to convert cm to inches and inches to cm in Excel. Download Workbook Manual approach The first approach we are going to show you is...
by Ilker | Oct 17, 2019 | Excel Tips & Tricks
Although Excel already has built-in sorting features, doing this with formulas might be useful in some cases for a more dynamic approach. The formula approach will be updated automatically whenever calculations are executed. In this article, we’re going to show...
by Ilker | Oct 16, 2019 | Excel Tips & Tricks
A subtotal is the aggregation of a data set, typically showing the totals of a certain section in that data set. A budgeting spreadsheet is a good example for this where subtotals are used to display more details of certain categories. In a budgeting application, you...
by Ilker | Oct 10, 2019 | Excel Tips & Tricks
If you want to remove file extension from full file names, first you need to locate the period (.) which separates the filename and the extension. This action is fairly easy to do if your file names do not contain any periods other than the extension separator....
by Ilker | Oct 8, 2019 | Excel Tips & Tricks
The square root of a number is a value which is equal to the number, when multiplied by itself. In this guide, we’re going to show you how to find square root in Excel using two different methods. Download Workbook How to find square root using the SQRT function...
by Ilker | Oct 7, 2019 | Excel Tips & Tricks
TRUE and FALSE are logical (Boolean) values in Excel. They are special values that can be used in formulas as is – although both values looks like a regular text string, you can include them in formulas without the use of double quotes. This behavior may seem...