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

INDIRECT Function

INDIRECT is used to create reference from text. More so, it can be use to generate random values. it returns reference to a range. Syntax: INDIRECT(ref_text[a1]) ref_text: a cell reference or text string that create the range reference. a1: this is said to be TRUE if the reference is using A1 reference style and FALSE[…]

Shares 0