Select Page

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. Download Workbook How to find square root using the SQRT function...

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....

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...

How to create radio buttons in Excel (Option Buttons)

A radio button, also known as option button, an input type that allows user to select from a list of pre-defined options. Radio buttons are useful if you want to limit the end-user to select a single option from a list. While a radio button looks more user-friendly, a...

How to create a dropdown list in Excel

The dropdowns are great tools for either increasing the end-user experience or limiting the end-user with specific options to select from. You can use Data Validation Lists to create your own dropdowns in Excel. In this guide, we are going to show you how to create a...

How to create a bell curve in Excel

A bell curve, also known as normal distribution, is the most common type of distribution for a variable. It is accepted as a distribution that occurs naturally in many situations. In a bell curve, the highest point of the arc defines the mean, which is the highest...

How to lock cells in Excel

By locking certain cells in your workbook, you can guide your users into other sections of your workbook and essentially convey the idea that the locked cells are to be treated as outputs, and all others inputs. This is especially useful in applications where you want...