Microsoft+Excel+Beginner

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

 * Up to Speed with Excel 2007 (30 - 40 minutes)
 * What's Changed and Why?
 * The Ribbon
 * The Commands
 * Options
 * The Quick Toolbar
 * Favorite Keyboard Shortcuts
 * Page Layout View
 * Screen Resolutions (High/Low)
 * [[file:1 Up to speed with Excel 2007.xlsx]]
 * Quick Check
 * Get to Work in Excel
 * Open a File
 * Insert a Column
 * Format and Edit Data
 * Enter a Formula
 * Add Headers and Footers
 * Print
 * The New Workbook Window
 * [[file:2 Up to speed with Excel 2007.xls]]
 * Quick Check
 * A New File Format
 * 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
 * Learn How to Figure Out Dates Using Formulas in Excel(30 - 40 minutes)
 * Lesson 1: What Dates Mean to Excel
 * The Calendar Starts in 1900
 * How Excel Recognizes Dates
 * [[file:1 Learn how to figure out dates using formulas in Excel 2007.xlsx]]
 * Quick Check
 * Lesson 2: Calculate Dates Using Formulas
 * Find the Number of Days Between Two Dates
 * Find the Number of Workdays between Two Dates
 * Find the Date After a Number of Workdays
 * Find the Date After a Number of Months
 * Find the Date After a Number of Years, Months and Days
 * Find Out How Old You Are Today
 * [[file:2 Learn how to figure out dates using formulas 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

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