MICROSOFT EXCEL 2003 - A COURSE IN PIVOT TABLES For all those looking to learn about the Pivot Tables of the Microsoft Excel 2003, a Microsoft training course has been developed specifically with the objective of enhancing the skills and knowledge in Pivot Tables of all who attend. The prerequisite of this course is that a delegate needs to have attended Microsoft training in Excel Advanced or have equivalent knowledge of this software. Course duration is one full day. The objectives of this course includes: Introduction to Pivot Tables Advanced Pivot Tables Changing the Layout Selecting in Pivot Tables Modifying Fields Hiding & Showing data Grouping & Ungrouping Calculations Consolidating multiple ranges The course outline is listed as follows: Pivot Tables Review Changing the Layout Positioning fields on the page axis Cycling through items on the axis page Displaying totals for a field in the page area Hiding and showing details Hiding and showing particular field items Moving page fields to separate workbook pages Copying a pivot table Rearranging the page field buttons Show hide data field detail Selecting elements Turning structured selection on or off Selecting and entire pivot table Renaming fields and items Sorting Items Sorting field items on the basis of data values Sorting field items on the basis of label values Using non-standard sorting orders Creating a chart form a pivot table Grouping and Ungrouping Data Creating ad hoc item groupings Grouping items in date or time ranges Using Custom Calculations Using calculated fields and items Creating a calculated field Creating a calculated item Included in the overall cost of this Microsoft training is equipment, training material, lunch and refreshments Booking Information Courses are offered on the availability of students. If you are interested in one of these courses then please click on the e-mail link: (Please specify the course in your email enquiry) Back to Top