Select Page

## How to group columns in Excel

Excel's Grouping is a very useful tool to display the data in a compact view. The feature allows you to hide the less prior data to let the major values remain visible. In this article, we are going to show how to group columns in Excel. Download Workbook Grouping...

## How to swap two cells in Excel

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...

## How to generate Descriptive Statistics in Excel

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...

## How to use subtotal feature in Excel

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...

## How to calculate as-the-crow-flies distance between two cities in Excel

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...

## Building Timesheet Applications with SpreadsheetWeb Hub

With SpreadsheetWeb, you can transform your timesheet spreadsheets into web applications and configure workflows with the new ‘Tag’ feature! In this article, we will take a fictitious company using a timesheet application for their employees to log their weekly work...

## Excel DEGREES Function

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...