by Ilker | Sep 9, 2022 | Excel Tips & Tricks
Although swapping two cells sounds easy, it may become complicated what you want to be swapped or not. In this article, we are going to show how to swap two cells in Excel for several scenarios. Download Workbook Swapping two adjoining cells Let's start with the...
by Ilker | Sep 8, 2022 | Excel Tips & Tricks
Descriptive statistics are summarizations of your dataset. This summary includes mean, median, mode, standard deviation, variance, minimum and maximum variables, kurtosis, and skewness. Excel can generate all these measures for a selected range in a proper table. In...
by Ilker | Sep 7, 2022 | Excel Tips & Tricks
A subtotal is the aggregation of a data set, typically showing the totals of a certain section in that data set. Excel gives you tools to calculate subtotals in different ways. In this article, we are going to show how to use the subtotal feature in Excel. Download...
by Ilker | Sep 6, 2022 | Excel Tips & Tricks
You might think "as the crow flies" distance is nothing more than a simple hypotenuse calculation back from geometry class. Unfortunately, not. You should work with either decimal degrees or degree-minute-second (DMS) notation due to the curvy structure of Earth. This...
by Ilker | Aug 23, 2022 | Blog
SpreadsheetWeb Hub supports Excel's LAMBDA function. The recently released LAMBDA function allows Excel users to build custom, reusable functions without VBA. There are so many use cases of the LAMBDA function. In this article, we will create a LAMBDA Function to...
by Ilker | Aug 18, 2022 | Excel Formulas
In Excel, The DEGREES function is a Math & Trigonometry function that converts radians into degrees. In this guide, we’re going to show you how to use the DEGREES function and go over some tips and error handling methods. Supported versions All versions Syntax...
by Ilker | Aug 17, 2022 | Excel Formulas
In Excel, The RADIANS is a Math & Trigonometry function that converts degrees into radians. In this guide, we’re going to show you how to use the RADIANS function and go over some tips and error handling methods. Supported versions All versions Syntax...
by Ilker | Aug 11, 2022 | Blog
SpreadsheetWeb Hub supports Excel's LAMBDA function. Recently released LAMBDA function allows Excel users to build custom, reusable functions without VBA. There are so many use cases of LAMBDA function. In this article, we will build a function to calculate distance...
by Ilker | Jul 6, 2022 | Excel Tips & Tricks
In this guide, we’re going to show you How to display negative numbers as zero in Excel in two ways. Download-Workbook Formula approach to display negative numbers as zero The first method in our list is the formula way. An obvious way is to use the IF function which...
