DA751 - Advanced Excel 2007 - PivotTables & More
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
Reasonable Accommodations
Individuals who need reasonable accommodation to participate in CIT Training courses should let CIT Training know at least 5 days prior to the class.
For interpreting services, please request them from the ORS Interpreting Services by completing the form at
Interpreting Services Form or calling (301) 402-8180 or TTY (301) 435-1908 at least 5 days before the start of the class.
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, CIT
Time Required:
2 Hours
Sections Available: