Excel COLUMNS Function Tips

Online Training For Excel

A spreadsheet is a sheet consisting of rows and columns which intersect with each other to form cell. Data are entered in each cell for calculation, storage or manipulation. Excel is collection of electronic spreadsheets

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.

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.

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.