Excel+1++2007

**Summer Institute 2009** **Microsoft Excel I** **August 20, 2009** **Facilitator: Frances O'Neill** __**Foneill@schools.nyc.gov** __ =**AGENDA**  = == Introduction- "What is Excel and how do we use it?" 8:30-10:00 == o  Quick Reference Card, fundamentals, vocabulary, navigation, editing, formatting, etc. == Creating a new workbook == o Saving a workbook o <span style="font-family: "Tekton Pro, sans-serif";">Save a workbook with a different name o<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">Print a workbook o<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">Close a workbook o<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">Exit Excel ==<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">Create Basic Formulas 10:00-11:00 == o<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">The Order of Operations P, E, M, D, A, S  o<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">  <span style="font-family: "Tekton Pro, sans-serif";">Functions o<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">Auto Sum o<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">Copying formulas and functions ==<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">Create a Grade/Record Book 11:00-12:00 ==

<span style="font-family: "Tekton Pro, sans-serif";">Lunch 12:00 - 1:00
==<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">Deeper into Formatting 1:00-1:30 == o<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">Inserting and Deleting Cells, Columns, and Rows o<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">Formatting Cells o<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">Applying Cell Styles ==<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> <span style="font-family: "Tekton Pro, sans-serif";">Creating Telephone/Address Book for Parent Contacts 1:30- 2:00 ==