Excel Tips and Tricks
How to convert inches to cm, and cm to inches
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. [button...
How to sort text in Excel using formulas
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 you...
How to calculate subtotal in Excel
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...
How to remove file extension from filename in Excel
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....
How to find square root in Excel
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. [button...
How to count Excel TRUE FALSE values
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...
How to calculate percentage in Excel
In Excel, you can actually show numbers as a percentage, without using any calculations. A percentage is a number or ratio that means a fraction of 100. They are expressed with the percentage sign (%), following the ratio. For example, 12% means 12/100, 0.12 or...
How to convert cm to inches, and vice versa
Working with multiple units of measure can often become a challenge, going back and forth between various calculators and your Excel workbooks. In this guide, we are going to show you how to convert cm to inches and inches to centimeters using various methods. [button...
How to create check boxes in Excel (Tick boxes)
A check box, also referred to as a tick box, is a form control input which you click to select or deselect a given option. If you click on an empty check box, a checkmark is added into the small box. The check box control works like a switch or toggle. Thus, if you...