Excel Tips and Tutorials

Convert Text To Numbers In Excel – A Step By Step Tutorial

We often see numbers stored in Excel as text which leads to wrong calculations, especially while using the cells in the functions i.e.

Combine Data With TEXTJOIN

Included in the group of six functions released by Excel 2016 is a very valuable function; TEXTJOIN. 

Show The Percent of Parent Column Total With Excel Pivot Tables

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

Extracting Data With Excel’s LEFT Formula

Left formula? What does it returns? Well, it gives back the first character in a string. The amount of characters is given as an input and result is extracted on basis of that.

MATCH- Excel 2016 Function

The MATCH function of Excel 2016 permits users to select the position of an object in a range instead of selecting the entire actual item

Group Rows And Get Counts Using Power Query

Power Query is a very strong tool available in Excel. It allows you to perform different types of transformations on your data.

INDIRECT Function For Dependent Dropdown Lists In Excel

The INDIRECT function is a powerful function as it allows you to carry out different tasks that come in very handy.

Total Count  : 191