Resources

How to swap two cells in Excel

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

How to generate Descriptive Statistics in Excel

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

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

How to get size of an array in Excel

How to get size of an array in Excel

An array is a collection of similar-type values or objects in computer science. This isn’t different for Excel. The only caveat is that Excel has two definitions for arrays, one for workbooks and the other for VBA. In this guide, we’re going to show you How to get the...

How to Create Charts with Formula in Excel

How to Create Charts with Formula in Excel

Excel keeps growing its visualization tools with each version. And the charts are the flagship of those. Although they present lots of customization options, they may become overwhelming when you just need to create a simple bar or column chart. In this guide, we’re...

How to Roll Dice in Excel in 3 Ways

How to Roll Dice in Excel in 3 Ways

The throw of dice is a common way of generating random numbers. It's not necessary to talk about the role of dice in board and role-playing games. Although, a simple formula can give what you need easily, you can make the dice rolling fancy in Excel. In this guide,...