ATTENTION EXCEL USERS: Now you can massively increase your productivity when analysing data. This online video course will enable you to...
Master Pivot Tables in under an hour!
After over 11 years of working with Excel, I honestly believe that if you have not got the hang of Pivot Tables, you are missing out on Excel's most powerful feature by far - and the real shame is that you will be surprised at how easy they are to use once the penny drops.
Using Pivot Tables you can:
- Make sense of raw data from your systems on the fly;
- Change the layout of reports in seconds when your boss or client wants to see data analysed in a different way..
- Set up reports that refresh at the click of a button.
- Analyse, summarise and present tens of thousands of rows of data in seconds;
Pivot tables bring this kind of flexibility to any kind of data from any source, examples include:
- Web Statistics;
- Transactions or balances from your accounting system;
- Sports Scores;
- Contact Data;
- Anything else you can think of.
- Sales Data;
- Scientific measurements;
It will teach you:
- How to add information from outside the pivot table/source data;
- How to provide more detailed analysis of your data;
- Invaluable insights into real world applications from an experienced consultant.
- How to modify your pivot table to present and summarise the data however you want;
- How to create a basic pivot table to manipulate large chunks of data;
When you order you will receive both the Excel 2003 and Excel 2007 versions of the course.