Introduction+to+Excel

media type="custom" key="302359"

Introduction to Excel
I[|ntro to Excel Objectives]

Online Excel Online Resources

 * [|i4c] - Internet 4 Classrooms - helping teachers used the Internet effectively
 * [|Microsoft Excel Online Courses] - Good quality audio/visual files from Microsoft on a variety of Microsoft Excel 2003 lessons
 * [|Microsoft Excel 2003 Keyboard Shortcuts] - use keyboard shortcuts for fast navigation and tasks
 * [|Microsoft Excel 2003 Tutorial] - Excel 2003 Basics
 * [|Microsoft Excel 2003 Quick Reference Card] - A useful reference to keep near your computer
 * [|Excel List of Worksheet Functions] - Worksheet functions listed by category
 * [|Excel Resources for Teachers] - Many Excel examples used by teachers in the classroom
 * [|More Excel Resources for Teachers] - Excel projects by level and subject; reference to standards
 * [|Teacher Resource Exchange (Excel)] - Data analysis in Excel projects
 * [|Stats for Schools] - Provides students with real world data sets for use in Excel; a great place to start a project
 * [|Ways to Use Excel in the Classroom] - professional development for educators by educators; good projects for the classroom
 * [|Classrooms that Excel Resources] - guides, tutorials, applications, and lesson plans
 * [|Using Excel in the Classroom] - learn the basics in Excel through online modules
 * [|Microsoft Excel XP 2003 Online Lessons] - covers a lot of basic information in Excel
 * [|Excel Templates for the Classroom] - Site 1
 * [|Excel Templates for the Classroom] - Site 2
 * [|Excel Templates for the Classroom] - Site 3

**Most Common Excel Errors**

 * ~ **Error Code** ||~ **Description** ||
 * ##### || The column isn’t wide enough to display the value. ||
 * #VALUE! || The formula has the wrong type of argument (such as text where a TRUE or FALSE value is required). ||
 * #NAME? || The formula contains text that Excel doesn’t recognize (such as an unknown named range). ||
 * #REF! || The formula refers to a cell that doesn’t exist (which can happen whenever cells are deleted). ||
 * #DIV/0! || The formula attempts to divide by zero. ||

**Math Concepts Helpful in Excel**

 * [|Absolute Cell Referencing]** - how to keep a cell from relative referencing in functions and formulas
 * [|Order of Precedence]** - order of operations to explain use of parenthesis

Templates and Applications Teachers have Requested in Needs Assessment Survey
[|Lesson Plan Grid Excel spreadsheet] [|Lesson Plan Grid Excel spreadsheet 2] [|Lesson Plan Grid Excel spreadsheet 3] [|Gradebook Excel spreadsheet] [|Excel Templates for Student Data] [|Excel: Keeping Track of Student Grades] [|Using Excel to Record and Calculate Grades]

[|Student Grade Sample] [|Address Sample]

media type="custom" key="640135"