Excel+Beyond+Excel+Cells

 Jen Legatt Technology Integration Specialist https://sites.google.com/site/jenlegatt/ =RANDBETWEEN(1,5) =INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1) =CONCATENATE(A1, " ",B1)
 * < **Basic Lists**
 * Copy from Word (Paste special)
 * Insert Column
 * Text to Columns
 * Resize columns
 * Alpha by Last
 * Sort by date
 * Filter by Gender
 * Format cells: Date
 * Random Number
 * Drag formula
 * Choose a name
 * Concatenate
 * Create a dropdown ||  ||< [[file:1- Basic Lists in Word.docx]]

Data Validation Settings List =List || =B4*C4 =SUM(D4:D12) || Steps included in lesson. || ||
 * < **Basic Math**
 * Format cells: Currency
 * Multiplication
 * Drag formulas
 * Total/Sum
 * Format as table ||  ||< [[file:2- Basic Math.xls]]
 * < **M&M Activity*** Create data table
 * Total data
 * Create a column chart
 * Copy data to a new sheet
 * Drag formulas
 * Find percent
 * Create a pie chart
 * Page layout ||  ||< [[file:3- M&MLesson.docx]]
 * < **NWEA Sample Data:**
 * Create Mail Merge in Word**
 * Name:
 * Grade:
 * Fall 2003:
 * Spring 2004 Target:
 * Spring 2004:
 * Target Growth:
 * Target Met? ||  ||< [[file:4- Achievement_Status_Growth_Report.pdf]]
 * < **Pivot Table*** Go to Source Data tab
 * Highlight Data
 * Insert Pivot Table
 * Switch Order ID to Order Amount
 * Play with other variations (and check out other tabs) ||  ||< [[file:5- Pivot Table data.xlsx]] ||
 * < **Student Data Sheet*** View finished data sheet
 * If statements for comments
 * Graph student progress with line graph
 * Select summaries and create bar graph
 * Unlock Cells
 * Tools: Protect Sheet ||  ||< [[file:6- Student Data Sheet (complete).xls]]

Select each cell or range. On the Format menu, click Cells, click the Protection tab, and then clear the Locked check box. ||


 * Additional Resources:**
 * Lesson: Calculating profits from selling virtual lemonade
 * Lessons/Tutorials: "Excel"lent Resources for Educators
 * Lessons/Resources: Ideas for Using Excel in the Classroom
 * Tutorial: Data, Analysis and Excel
 * Tutorial: Using Functions in Excel
 * Tutorial: Create a Drop-Down List
 * Tutorial: Creating a Timeline using Excel
 * Tutorial: Keep track of grades using Excel
 * Tutorial: View your grade book in a PivotTable
 * Tutorial/Resource: A Huge Collection of Spreadsheets for Teachers: What Excel Can Do
 * Resource: Excel for Educators Blog
 * Resource: Excel for Teachers
 * Resource: internet4classroom's Excel Resources
 * Resource: [|PivotTable reports 101]
 * Resource: [|What Is a Pivot Table?] (And keep a close eye on the critter in the corner.)
 * Tutorial: [|Pivot Table Tutorial]