EXCEL Pivot Tables

As an EXCEL user, if you have been creating a lot of tables and have not yet been introduced to Pivot Tables, you are missing out on EXCEL’s most advanced & powerful business intelligence (BI) solution for data analysis. It comes with EXCEL and there is no need to pay for a plug-in.

Pivot Tables empowers you to visually & interactively slice & dice (BI’s jargon for filtering & segmenting your data repeatedly) your data to get to the level of data you require for reporting & analysis. And to further aid your analysis, present your results graphically as Pivot Charts which are linked to your Pivot Tables. They are dynamically updated as you work with the tables.

Here’s the full article on my personal blog DO*DID*DONE

gcflearnfree_org-excel2013

Advertisements

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s