by Ilker | May 22, 2018 | Excel Formulas, Excel Tips & Tricks
Excel has several built-in features that help analyze data. For example, you can count the number of columns in your data model by selecting those columns, and you will see the count on the bottom right corner. However, this is a repetitive task, one that can be...
by Ilker | May 22, 2018 | Excel Formulas, Excel Tips & Tricks
Excel has several built-in features that help analyze data. For example, you can count the number of entries in your form by selecting those rows and you will see the count on the bottom right corner. However, this is a repetitive task, one that can be handled with a...
by Ilker | May 21, 2018 | Excel Tips & Tricks
Dropdown type of inputs are very common in Excel models, but dependent dropdowns take it to the next level, and are dynamic. This means that available options of the dropdown menu will change based on other selections. This article will show you how to create...
by Ilker | May 21, 2018 | Excel Formulas, Excel Tips & Tricks
We often find data in a raw, unorganized form that contain empty cells. In this article we’re going to show you how to remove blanks from a list and create a new table using only formulas. Syntax =IFERROR(INDEX(list range,SMALL(IF(ISTEXT(list range),ROW(rows...
by Ilker | May 18, 2018 | Excel Formulas
If you want to convert a number to time values, you need some additional operations, multiplying and dividing between days, hours, minutes, and seconds. Here, we’re going to take a look at a simpler approach by using Excel’s TEXT function. Syntax...
