by Ilker | Sep 10, 2020 | Excel Formulas
The YEARFRAC is a Date & Time function that calculates and returns the fraction of the year between two days. The function calculates the fraction by the number of whole days in given day count basis. In this guide, we’re going to show you how to use the YEARFRAC...
by Ilker | Sep 9, 2020 | Excel Tips & Tricks
A percentage value is a great way to express a proportion’s size in whole. You may want to calculate and see what percent of the year is completed. In this article, we are going to show you how to calculate the percent of completed year in Excel. Download Workbook...
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...
