by Ilker | Dec 15, 2020 | Excel Formulas
The LET function can define names within the scope of a formula. This essentially offers better readability and help with calculation performance. In this guide, we are going to show you how to use the LET function and go over some tips and error handling methods....
by Ilker | Jul 27, 2020 | Excel Tips & Tricks
Excel is rich in data sorting features - you have built in features like Sort and functions like SORT or SORTBY. However, these methods won’t work without some modification when you need to sort dates in Excel. In this article, we are going to show you how to...
by Ilker | Jul 21, 2020 | Excel Tips & Tricks
Sorting is a crucial part of organizing data. Being everyone’s go-to spreadsheet tool, Excel thankfully offers various tools for sorting data like the sort feature and functions like SORT or SORTBY. However, neither of these approaches can really help you with...
by Ilker | Jul 16, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to create a Funnel chart in Excel versions older than 2019 – including 365. Funnel charts are fairly popular among sales and marketing processes. You can use a funnel chart to display the progression of data through...
by Ilker | Mar 27, 2020 | Excel Tips & Tricks
SUMIFS like other …IF or …IFS function are great tools to aggregate data based on a set of conditions. The downside of this approach is that the criteria must be supplied manually, especially when you need to create a summary table. In this guide, we’re going to show...
by Ilker | Jul 11, 2019 | Excel Formulas, Excel Tips & Tricks
A dynamic drop down (also known as a dependent drop down) is a term for drop downs with a dynamic list. The list items of a dynamic drop down get updated according to another input which is usually another drop down as well. A common example is to have lots of items...
by Ilker | Jul 10, 2019 | Excel Tips & Tricks
A common way to populate lists or tables in Excel is using the INDEX function. However, you need to create a helper column or row, to define row and column numbers for the INDEX function. This way, the INDEX can populate return the values into the corresponding cells....
by Ilker | Jul 2, 2019 | Excel Tips & Tricks
Excel doesn’t have a built-in method to sort data randomly. Instead, you need to rely on formulas to sort a list of values randomly. Before dynamic array formulas, you needed to build a structure of formulas and helper columns to achieve this. Thanks to the...
by Ilker | Jun 25, 2019 | Excel Tips & Tricks
Excel can get the stock market data from 60 different stock exchanges around the world. However, this information will not refresh automatically, and currently you need to refresh stock data manually, or write a VBA code to automate the process. In this article, we...
