Microsoft+Excel+Intermediate

**// I. Create Charts in Excel //**

 * Charts 1: How to Create a Chart in Excel 2007 (//30 - 40 minutes//)
 * Create a Basic Chart
 * Create Your Chart
 * How Worksheet data appears in the Chart
 * Chart Tools
 * Change the Chart View
 * Add Chart Titles
 * [[file:Charts I- How to create a chart in Excel 2007.xlsx]]
 * Quick Check
 * Customize Your Chart
 * Change the Look of Your Chart
 * Format Titles
 * Format individual Columns
 * Add Your Chart to a PowerPoint Presentation
 * [[file:ChartsOnePracticeTwo.xlsx]]
 * [[file:PowerPoint Chart Practice.pptx]]
 * Quick Check


 * PivotTable I: Get Started with PivotTable Reports in Excel 2007 (//40 - 50 minutes//)
 * Make Your Data Work for You
 * Review Your Source Data
 * Get Started
 * PivotTable Report Basics
 * Build a PivotTable Report
 * See Sales by Country
 * See Sales by Date
 * Pivot the Report
 * Where did Drag-and-Drop Go?
 * [[file:PivotTable I- Get started with PivotTable reports in Excel 20071.xlsx]]
 * Quick Check
 * PivotTable II: Filter PivotTable Report Data in Excel 2007 (//20 - 30 minutes//)
 * See Just the Data You Want to See in PivotTable Reports
 * Filter to See One Product Out of Many
 * Narrow the Filter to See a Single Item
 * Set a Value Filter to View Products by Specifying Amounts
 * Set a Date Filter to See data for a Selected Time
 * Remove Filters
 * [[file:PivotTable II- Filter PivotTable report data in Excel 2007.xlsx]]
 * Quick Check
 * PivotTable III: Calculate Data in PivotTable Reports in Excel 2007 (//20 - 30 minutes//)
 * Work with Numbers
 * Summarize Data Another Way
 * Perform a Custom Calculation
 * Who Gets a Bonus?
 * [[file:PivotTable III- Calculate data in PivotTable reports in Excel 2007.xlsx]]
 * Quick Check

**// Additional Resources //**
Microsoft Excel Training Microsoft Excel Tutorials Online HP Learning Center - Microsoft Office Microsoft Office Training Portal Brainstorm Quick Help Videos Microsoft Excel Training Courses

** Pennsylvania K-12 Staff, Parents, Students, who wish to purchase Microsoft Office: ** Purchase with an Academic Discount by clicking here. Note: In the //For Personal Use// section click on the words //Shop Here//.