 |
|
What
is a Pivot
Table/Chart ? Microsoft Excel and Access offer a powerful data analysis tool that enables interactive reporting on large amounts of data. The Pivot Table/Chart tool is typically used to analyse transactional information allowing the user to view the data in many different ways. A Sales Company may have data for each Sales Person recorded in a corporate back end system. The existing system does not provide for flexible reporting. The data can be extracted into Excel or Access and then a Pivot Chart can be created in a matter of minutes that will allow the Sales team to review performance of the company sales by Person over time and by Region or Product. The options are limited only by the amount and type data available for reporting. You can try the Pivot Table/Chart tool for yourself within Excel by accessing "Pivot Table" toolbar and using the wizard to create your first Chart. Click Here to access a sample Pivot Chart from our website. If you would like help in building a report or a reporting package then Contact Us and we will help you build an effective reporting solution for your business. If you are not yet a subscriber to the XLAutomation newsletter then Click Here to subscribe and receive guidance and tools that will increase your efficiency in using Microsoft Excel, Word and Powerpoint. |
Latest Offers "Free Consultation" Take advantage of our 1 hour free on-site consultation. We guarantee to provide advice that will improve the way you currently use your Microsoft® Office software. Click Here to book a session with one of our consultants. Coming Soon "Message Blaster" The much anticipated launch of our latest product will take place in Janaury, 2009. Message Blaster provides "One Click" communication with your customers and contacts. Imagine a system that automatically sends SMS's and Emails, without manual intervention! Click Here to find out more about Message Blaster and to register your interest. |
|
|