Excel Tips and Tutorials

Keyboard Shortcut Metrics

Majority of people working with computer systems love shortcuts on keyboard. Few of the shortcuts which are custom made can help you to clean Undo Stack, which is quite painful.

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.

Total Count  : 192