by Ilker | May 22, 2018 | 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 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 Tips & Tricks
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...
by Ilker | Apr 25, 2018 | Excel Tips & Tricks
To return an entire row you need to use array returning functions like INDEX or OFFSET. Both of these functions can return arrays, as well as single values, which can be used in other functions like SUM, AVERAGE or even another INDEX or OFFSET. How to return an entire...
by Ilker | Apr 25, 2018 | Excel Tips & Tricks
To return an entire column you need array returning functions like INDEX or OFFSET. Both of these functions can return arrays, as well as single values, which can be used in other functions like SUM, AVERAGE or even another INDEX or OFFSET. How to return an entire...
by Ilker | Apr 23, 2018 | Excel Tips & Tricks
Your ultimate financial calculator Excel can help find out your monthly payments on a new loan. The function for this task is CUMIPMT and it can calculate cumulative loan interest over a period of time. Syntax =CUMIPMT(annual interest rate/12, periods by month, loan...
by Ilker | Apr 20, 2018 | Excel Tips & Tricks
Excel can detect URLs and convert them into hyperlinks when you press the Enter key on that particular cell. When working with a large data set with thousands of rows you may not want to go to each cell and repeat this process. Enter the HYPERLINK function. Syntax...
by Ilker | Apr 20, 2018 | Excel Tips & Tricks
Traditional Copy+Paste might do all you want, but when working with large tables that are constantly updated, it’s a tedious task to merge columns of data. Using this formula combination instead will save you time and prevent errors. Syntax =IFERROR( ...
