by Ilker | Sep 13, 2019 | Excel Tips & Tricks
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...
by Ilker | Sep 12, 2019 | Excel Tips & Tricks
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...
by Ilker | Sep 11, 2019 | Excel Tips & Tricks
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...
by Ilker | Sep 10, 2019 | Excel Tips & Tricks
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...
by Ilker | Sep 4, 2019 | Excel Tips & Tricks
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...
by Ilker | Sep 3, 2019 | Excel Tips & Tricks
If you are working with a huge data, it can be difficult to recognize which cell is under which column or row. Excel’s Freeze Panes feature allows you to lock a number of rows and/or columns and make it easier to navigate other parts of your workbook and the...
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...
