Excel+2010

**Excel 2010**

 * Course Outline**

 1. Survey Results 2. Great starting resource for all levels - []  3. Graph Tutorial [] []  4. //**Graph Challenge**// - Take a class poll and change the "dummy data" below to reflect the makeup of our Excel 2010 participants. Enter the data in an Excel spreadsheet. Create a pie graph.  5. Sort and Filter Tables Tutorial - [] [] [] []  6. //**Sort and Filter Tables Challenge**// - Download and open the file. Sort the database based on the Name Field. Now, display the records that list "corn" as one of the items under the Agriculture field.  7. Formulas Tutorial [] []  8. //**Formulas Challenge**// - Create the following spreadsheet using formulas for the totals and grand total (in other words, do not type in the total amounts). If time, format the spreadsheet.  9. Drop-down List Tutorial [] [] 10. //**Drop-down List Challenge**// - Create the following spreadsheet where the grade level column displays a drop-down list including 6th grade, 7th grade, and 8th grade  11. Tips, Tricks, Video [] 12. Practice, Create, Share
 * Elementary || 7 ||
 * Middle || 9 ||
 * High School || 1 ||
 * Admin || 0 ||
 * Other || 2 ||
 * **Item** || **Quantity** || **Price** || **Total** ||
 * Laser Pointer || 2 || $25 || $50 ||
 * Projector Bulb || 4 || $200 || $800 ||
 * Flash Drive || 10 || $8 || $80 ||
 * **Grand Total** ||  ||   || **$930** ||
 * Student Name || Grade Level ||
 * Interactive Guides- 2003 to 2010 (Where are the commands???) **

Make the Switch to Excel 2010 [] Excel Help and How-Tos [] Protecting Your Files [] Ribbon Hero []
 * Resources**