Excel COLUMN Function Tips

How To Learn Excel? Start And Master With These Resources

A spreadsheet is an electronic document formed by the combination of rows and columns marked with a grid. Excel is a matrix and powerful platform and a massive program.

How To Use Excel Pivot Tables For Showing Percent Of Column Total?

The “Show Values As option” can be used for performing several calculations in Excel Pivot tables

Show The Percent of Parent Column Total With Excel Pivot Tables

Pivot tables include so many essential calculations in the SHOW VALUES AS option.

Transpose Data In Excel Quickly

In case you need to transpose a dataset in Excel, that is, you want to convert the columns into rows and vice versa, it is very hard to do that manually.

How To Use The MOD Function To Repeat Values

Have you ever used the MOD function in Excel? Well, the function actually performs modulo operation.

Microsoft Excel: Using Conditional Formatting To Make Heat Map

A data set’s comparative view can easily be represented visually with the aid of a heat map

Using Excel To Create Histogram

In business, several tools are used to analyze data. One of such tools is the histogram. The histogram is a chart, which has chart columns that signify how frequent a variable is present.

VLOOKUP for dummies

The simplest way to retrieve data in a database using a one criteria is use of VLOOKUP function. It is good to know that VLOOKUP function can be used with two or more criteria columns.

How to Unhide Columns in Excel

When you have some data columns that you don’t want to display can be hidden from the sheet.

Getting the row and column number of a cell

Using ROW() and COLUMN() functions.