Spacebar See Links Below CIT Home Page CIT Site Map CIT Logo
Training Banner - Classroom Picture
Training Home | Courses | My Training | Contact Us
#829Excel 2007 Advanced Topics - PivotTables
 
Description:
This course is for those who have an advanced knowledge of Excel. PivotTables allow one to see data visually in a variety of ways in order to analyze the report. We will also look at creating PivotCharts that are based on the information gather in the PivotTable. Will the chart update if the PivotTable is refreshed? This is one of the questions that will be addressed in this session.
 
Objectives:
Topics to be covered include:
  • Configure Excel
  • Create a PivotTable
  • Rearrange a PivotTable
  • PivotTable options
  • Create a PivotChart
  • Share workbooks
  • Insert Excel components in Microsoft Office applications
  • Creating basic macros
Who should attend:
NIH staff using the Office 2007 products who have an advanced knowlege of Microsoft Excel.

For an introductory level course to Excel, go to the HHS University Learning Management System. All personnel are eligible for this training. To navigate to HHS University's Training Opportunities web page click here.
 
Instructor(s):
Michele Schwartzman, Division of Customer Support, CIT
 
Time Required:
3 hours
 
Sections Available:
829A-09F Moved to March 17 9:00 - 11:30 Fernwood Building, Lower Level Classroom - 1NW02
Course Listing

Home | Index | Map | Comments | Disclaimers | Privacy | Accessibility