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 » excel course in london - Pivot Tables/ Charts
excel course in london - Pivot Tables/ Charts
Resolved · Low Priority · Version Standard
Amy has attended:
Excel Intermediate course
Pivot Tables/ Charts
I am having difficulty formatting my information. Can you send me an example as to where I am going wrong? Thanks
RE: Pivot Tables/ Charts
Dear Amy
By Formatting I assume that you mean the appearance of the Pivot table.
There is a Autoformat feature that you can use to save time shading cells and Autoformat can make your pivot tables look professional within few clicks!!
To do that click anywhere inside your Pivot Table .
Click on the Auto format button on the Pivot Table Toolbar (or you can also choose [b]Format > Auto format
Attached files...
RE: Pivot Tables/ Charts
Dear Rajeev,
I was not very clear.
I need to know how to build a pivot table/ graph and what sort of information do I use to build one?
Thanks,
Amy
RE: Pivot Tables/ Charts
Dear Amy
Sorry for the delay in responding!!
The main purpose of creating Pivot Table is to summarize your data. Although the same result can be achieved via Auto filters but the main advantage of Pivot Tables is that it can perform various functions such as Sum, Count Min, Max and Average and is Interactive which means that you can simply drag the column headings to the appropriate areas in the Pivot and it does summarizes that data. You have the option of displaying the fields' headings either as rows or columns!!
The answer to your question about what type of data do you require to create a Pivot Table is that it doesn't really matter!! You should have some numeric data to perform calculations.
You can create a chart based on the pivot data by a simple click!!
Please follow these steps to create the Pivot table.
Step 1. Click inside the table that the Pivot Table is to be based upon.
Step 2. Select [b]Data > Pivot Table and PivotChart Wizard
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:Seeing named ranges as part of the zoomIf you have large areas of named ranges this works better. |