Excel Pivot Table Tutorial Pdf. Excel gives you a more powerful way of creating a pivottable from multiple tables different data sources and external data sources. Pdf version quick guide resources job search discussion.
Your data source is chosen from the create pivottable dialogue box which was shown earlier in figure 3. When you pivot a report you transpose the vertical or horizontal view of a field moving rows to the column area or moving columns to the row area. Navigate to the insert tab and then click on the pivottable icon.
Right click the field you want to pivot.
You can also pivot the report to get a different view. Users may also select the data on the worksheet navigate to the insert tab and then click the pivottable icon. Microsoft excel 2010 allows you to quickly generate reports based on filtered information that is most useful to you. Right click the field you want to pivot.
