Excel Tips and Tutorials

Creating Linked Tables in Excel Using Power Pivot

Working with Microsoft Excel to produce multiple tables that are linked together is easy.

Display Parent Row Total Percentage Using Microsoft Excel Pivot Tables

Microsoft Excel Pivot Tables have many functions available through the option of Show Values As. One particular calculation can be used to display the Parent Row Total Percentage.

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.

How To Extract A URL From A Hyperlink On Excel

Many of the people find it difficult to extract the URLs from the list of text. It is as easy as anything. There are two different ways of doing it.

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

New Power Pivot updates in the 2016 version of Microsoft Excel

The Office 365 subscription comes with new Power Pivot updates for the features in the 2016 version of Microsoft Excel.

Use Excel 2016 and Design Your Box and Whisker Chart

Among the numerous new charts available on the new Excel 2016 is the Box and Whisker Chart. This chart was originally created by John Tukey in the 1970s

Total Count  : 192