98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
Advanced Excel and PivotTable Reports
Wed 26th November 2008
Pivot tables allow you to quickly summarise and analyse large amounts of data in lists and tables - independent of the original data layout in your spreadsheet - by dragging and dropping columns to different rows, columns, or summary positions.
You can use PivotTables and PivotCharts to analyse the data, make comparisons, detect patterns and relationships, and discover trends. A PivotTable organises and then summarises large amounts of data from any range that has labelled columns and rows. Any number of column headings can act as category items.
The PivotTable is known as such because the headings can be rotated around the data so as to view or summarise it in different ways. You can filter the data to display just the details for areas of interest. Alternatively, you can choose to create a PivotChart which will summarise the data in chart format rather than as a table. An advanced Excel course, led by a Microsoft certified trainer, is highly recommended as you will gain the necessary knowledge to make effective use of Advanced Excel, including PivotTables and PivotCharts.
PivotTables have for a long time been very useful for accountants, but have great advantages to managers too, as a data analysis tool. The source data for the PivotTable can include an Excel worksheet database or list, or any data range that has labelled rows and columns. This data can be in Excel or in an external application such as Microsoft Access. The general rule is that you need more than two criteria of data with which to work otherwise there will be nothing to pivot.
PivotTables are especially well-suited for taking enormous amounts of data and summarising that data into useful reports which can help you analyse your data from multiple perspectives, making it easier for you to discover patterns and exceptions and therefore make faster, better business decisions. In fact, PivotTables might just be the single most powerful tool in Excel for budgeting, financial reporting, and data analysis.
A few of the many advantages of PivotTables are that one can generate and extract meaningful information within a matter of minutes, and the fact that they do not use up a lot of memory from the computer. The drag-and-drop functionality makes PivotTables interactive in that once the table is complete you can very easily see what effect moving, or pivoting, the data has on the information.
Having the information update each time the workbook is opened and/ or by clicking the refresh tab is another feature. Some of the additional features of PivotTables are that they work well with other Excel tools such as AutoFilters, subtotalling, grouping, outlining, and publishing to the web, sending email, and copy and paste linking to MS Word and MS PowerPoint.
In conclusion, some of the many features of PivotTables are that you can summarise and analyse data, quickly rearrange the layout of the report, and they are a convenient way to build intelligent, flexible summary tables.
Author is a freelance copywriter. For more information on advanced+excel+course, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-368-advanced-excel-pivottable-reports.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsLocal Government Association
Adviser Kirsty Human Virtual Train The Trainer Im not sure the explanation of teams diary added much when using outlook is much better. Overall the training was excellent and i have taken away lots of tips to improve my online delivery of training - thank you LCR Property
AP & Treasury Manager Nicola Shaw Power BI DAX There is nothing - it was brilliant! Oxford Insurance Group Ltd
IT Infrastructure Manager Kevin Mossman Managing Teams Remotely Overall really useful and i've now got a lot to think about and review. Dennis you come across really clear and enthusiastic. The pieces i enjoyed the most are the group discussions and break out rooms, really interesting to hear how other aspects of the business percieve this managerial challenges. My only suggestion would be to condense the course if that is at all possible, to make it more concise. However, other people may need more time to digest topics so it's difficult to say whether that suggestion has validity. Thank you again |
PUBLICATION GUIDELINES