Microsoft Excel Pivot Tables Training in the North East
Our Microsoft Excel Training
Our public scheduled, tutor-led courses take place at our training venues in the Newcastle-Upon-Tyne and Washington. If these locations are not convenient, you can choose to have a private course at your site or at a convenient location in the North East and throughout the UK.
Below are a list of Excel course outlines. To ensure you get exactly what you want out of your Microsoft Excel training in the North East, you can choose to have a course based directly on an Excel outline, or you can customise an Excel course outline to fit your organisation's specific requirements. Please click on the link to view the outline.
Excel Courses for 97, 2000, XP, 2003
Excel Level 1 (Introduction)
Excel Level 2 (Intermediate)
Excel Level 3 (Advanced)
Excel VBA
Excel Pivot Tables
Excel Courses for 2007
Excel 2007 Level 1 (Introduction)
Excel 2007 Level 2 (Intermediate)
Excel 2007 Level 3 (Advanced)
Excel VBA
Excel Pivot Tables
Microsoft Excel Pivot Tables
This course is designed for individuals who have a need to summarise data using Excel’s powerful Pivot Table feature. After the course delegates will be able to create pivot tables based on data both within Excel and from an external source.
After attending the Microsoft Excel Pivot Tables course delegates will be able to:
- Summarise an Excel datasheet into an easy to understand cross tabular layout (a Pivot Table)
- Improve the presentation of that cross tabular data through formatting wizards and/or field settings
- Demonstrate how to dynamically alter the data columns being used in a Pivot Table Summary
- Change the default sort order of summarised data
- Demonstrate how to change the column layout of a Pivot table
- Show that they can create a chart of summary data
- Connect to a Server based database (such as SQL Server and Oracle) and create summary pivot tables on the data as required
For information on Excel Pivot Trables course content click here
