GETPIVOTDATA in PivotTable

GETPIVOTDATA is an amazing formula use to extracts summary data from a PivotTable report. The good thing about this function is how it makes use of criteria to ensure that the right data are extracted without being mindful of any change made to the PivotTable layout. Below is the syntax that appears automatically whenever you[…]

Shares 0

Apply Styles to PivotTable

In order to make PivotTable reports more readable and visual appealing, there is need to apply style of our choice  from eighty-five (85) built-in styles. This categories in to “Light”, “Medium”, “Dark” plus sixteen (16) combinations of styles options in the PivotTable styles gallery located on the design tab under PivotTable tools. You can go a[…]

Shares 0

HLOOKUP and its Application

HLOOKUP and its Application HLOOKUP function performed it search horizontally by matching lookup value located at the first row (unlike VLOOKUP that is vertical) at the top to the row that holds the value you intend to return. It searched for either EXACT MATCH of the value you intend looking up in the table or[…]

Shares 0

How to build an Interactive Chart

The concept of an interactive chart is aim at making Excel dashboard more flexible for users to choose whatever they wanted to see by changing the selection in the drop down menus to drive automatic chart updates in their report. I will show the simplest way to build an interactive chart once. This will allow[…]

Shares 0

VLOOKUP and its Application

VLOOKUP Function is one of the powerful Excel Formula that does a lot of magic for me. Interestingly, it enables me to carry out hundreds of calculations and analysis in minutes. Though the golden rule is to search vertically (top to bottom) of the left column (usually leftmost) of the lookup table until it established[…]

Shares 0

Using LEFT, MID and RIGHT for String Extraction

LEFT, MID and RIGTH functions are ideal tools to extract parts of text. LEFT function is used to extract the left-most characters, MID function is used to extract selected characters within text, and RIGHT function is used to extract right-most characters of a text in Excel. Let’s demonstrate how these functions work in the data[…]

Shares 0

Add Format to Numbers in PivotTable Values Area

It is important to format number in PivotTable values area in order to make your reports more readable. Though there are many ways to accomplish this task which I will explain in details later. Let me quickly demonstrate how to perform formatting on numbers in values area of the above PivotTable. Right-click any cell in[…]

Shares 0

Data Analysis of Ondo 2016 Governorship Election

It is no longer news that the good people of Ondo state had chosen their next premier citizen that will lead the Sunshine State for the next four years at least a Term in a peaceful poll conducted by INEC on the November 26th, 2016. It is imperative to take a deep look at the[…]

Shares 0

What PivotTable is all about?

PivotTable is an essential Excel tool used to explore and analyse huge data set in order to generate an interactive and user friendly summary reports. Its ability to automatically group, sort and filter different subset of data, and ensure data are summarised by categories and sub categories are its cool features that stand it out[…]

Shares 0