98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Filtering
Filtering
Resolved · Low Priority · Version 2007
Tosin has attended:
Excel Intermediate course
Filtering
What's the difference between filtering mainly in a worksheet and a pivot table
RE: Filtering
Hi Tosin
Thank you for your question and welcome to the forum.
When you filter data in a spreadsheet you can only see the data on a row-by-row basis, and you are not necessarily given any useful information from an analytical perspective if the rows contain some figures.
Constructing a pivot table allows you to view the same data in a 3D format, and analyse any figures in various ways.
We do cover pivot tables as part of our Excel Advanced course, also there are good resources on the Microsoft web site and on www.contextures.com relating to pivot tables if you are interested in learning more.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:The Easiest and Quickest Way to use Autosum in Excel 2010Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature. |