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 2, 2020 | Excel Formulas
The STANDARDIZE Excel function is a Statistical formla that calculates and returns normalized value (z-score) based on the mean and standard deviation of a data set. In this guide, we’re going to show you how to use the STANDARDIZE function and also go over some tips...
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 | Mar 26, 2020 | Excel Tips & Tricks
You can use the COUNTIFS function to count the values in ranges that meet certain criteria. The criteria can contain a not equal logic as well. However, the COUNTIFS function requires individual arguments for each range-criteria pair. This requirement can make it...
by Ilker | Mar 5, 2020 | Excel Tips & Tricks
The COUNTIFS function can count the values in multiple ranges with multiple criteria. The function counts each given range-criteria pair and combines the result with AND logical operator. Unfortunately, there is no quick and easy way to use an OR logic with the...
by Ilker | Mar 5, 2020 | Excel Tips & Tricks
Excel allows you to enter a formula with up to 8,192 characters. However, managing a formula will certainly get harder as you get closer to that limit. You might especially have this issue when working with nested formulas – functions in functions. In this...
by Ilker | Jan 16, 2020 | Excel Tips & Tricks
Are extremely long, formulas nested arguments intimidating you? The Evaluate Formula feature can help you untangle these complex formulas! This tool essentially solves complex formulas step by step. In this guide, we’re going to show you how to step through...
by Ilker | Dec 31, 2019 | Excel Tips & Tricks
Excel TEXTJOIN and CONCAT functions are relatively new, and welcome additions to Excel’s plethora of functions. Both functions have been released with Excel 2016 as a replacement for the CONCATENATE function to make it easier to merge multiple text strings. In this...
by Ilker | Dec 27, 2019 | Excel Tips & Tricks
Wouldn’t be nice if images in Excel updated automatically with certain prompts? In this guide, we’re going to show you how to create dynamic images in Excel. Download Workbook Preparing the Dynamic Images First, we need to place our images somewhere in the...
