How to Use Excel PivotTables

Excel is full of great tools for doing data analysis, in fact it is sometimes useful to import data from another application or database and analyse it in Excel. One of these great tools is the PivotTable. It is quick and easy to use and you can easily move your data around which might help you see the data better.

Other useful tools for data analysis in Excel include data tables, goal seek and the scenario manager.

Here is a video tutorial that will help you get started with PivotTables.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast
This entry was posted in Excel, Microsoft Access, Microsoft Office and tagged , , , , . Bookmark the permalink.

1 Response to How to Use Excel PivotTables

Leave a Reply

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

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

Facebook photo

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

Connecting to %s