Empowerment_Office_Excel

**// I. Get Familiar with Excel //**

 * Get to Know Excel: Create Your First Workbook(30 - 40 minutes)
 * Meet the Workbook
 * The Ribbon
 * Workbooks and Worksheets
 * Columns, Rows and Cells
 * Cells are Where the Data Goes
 * [[file:1 Get to know Excel 2007- Create your first workbook.xlsx]]
 * Quick Check
 * Enter Data
 * Start with Column Titles
 * Start Typing
 * Enter Dates and Times
 * Enter Numbers
 * Quick Ways to Enter Data
 * [[file:2 Get to know Excel 2007- Create your first workbook.xlsx]]
 * Quick Check
 * Enter Data and Revise Worksheets
 * Edit Data
 * Remove Data Formatting
 * Insert a Column or Row
 * [[file:3 Get to know Excel 2007- Create your first workbook.xlsx]]
 * Quick Check


 * Get to Know Excel: Enter Formulas(40 - 50 minutes)
 * Getting Started
 * Begin with an Equal Sign
 * Use Other Math Operators
 * Total Values in a Column
 * Copy a Formula Instead of Creating a New One
 * [[file:4 Get to know Excel 2007- Enter formulas.xlsx]]
 * Quick Check
 * Cell References
 * Update Formula Results
 * Other Ways to Enter Cell References
 * References Types
 * Using an Absolute Cell Reference
 * [[file:5 Get to know Excel 2007- Enter formulas.xlsx]]
 * Quick Check
 * Simplify Formulas Using Functions
 * Find an Average
 * Find the Largest or Smallest Value
 * Print Formulas
 * What's That Funny Thing in My Worksheet?
 * Find More Functions
 * [[file:6 Get to know Excel 2007- Enter formulas.xlsx]]
 * Quick Check

**// II. 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
 * 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 Course



** 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//.