Excel

>>> ===Section A: Formatting Data=== >>> >>> ===Section B: Formatting Numbers=== >>> >>> ===Section C: Formatting Text and Tables=== >>> >>> ===Section D: Understanding Formulas=== >>> ===Section A: Introduction=== >>> >>> ===Section B: Navigating Excel=== >>> >>> ===Section C: Excel 2010 Shortcuts=== >>> >>> ===Section D: Creating and Manipulating Data=== >>> >>> ===Section F: Data Validation=== >>> >>> ===Section G: Modifying Cell Content=== >>> >>> ===Section H: Changing Views=== >>> 12:15-1:00: Review >>> >>> • Operations: over four hundred formulas; operations vs formulas: zoom to 200; = sign creates dependency and relationships-all characters depend on each other >>> >>> • Arithmetic Operations: ; =2+4 hit enter; get 6; 6-3 get 3-jun so double click into cell to edit it and add the equal sign before the operation; or hit F2 key; f2-edit cell contents key; copy top format down; click in previous cell click on format painter; double click on new cell; = 2*5  10; =12/4  3 ; **format painter practice** >>> >>> • Additional Operation Symbols: & ampersand concatenation; ^shift + 6  ^exponent caret symbol : a number to its power; define operations with formulas?? >>> >>> • SUM Function: go to bottom of number range; 1st formula-most common ; =sum(open parameter; excel prompts us with functions that begin with s then sum, etc; hit tab to select the function**; syntax=how the function is displayed = sign function name; a set of parens; >>> >>> • Ranges in Functions: =sum(hit arrow key and shift and select adjacent cells; e2:e22 :=through; need final parentheses; hit enter and get the simple sum; >>> >>> • AutoSum: click on autosum buttom: greek letter sigma; speed key alt + = hit enter; can copy formula and place it elsewhere; change format of cell two ways in the home tab general click down arrow; or format paint the currency; = sum; hold ctrl key and randomly select cells to add hit enter; >>> >>> • Average: edit a cell that has a sum function; f2; replace sum with average; >>> >>> • Min/Max Functions: edit the average cell; = min=minimum; = min(e2:e22); shows the lowest number in the range; = max (e2:e22) >>> >>> • Count Formula: counts all the cells that contain values; numbers go into cells as values as default; =count (e2:e22); get 21; counts all the cells that contain values; delete a value from the range and the value should change; type text string; get 20 bc count formula only recognizes numerical values; =count a : f2-edit formula; *counta(e2:e22) counts all non-blank cells in a range; so count = 21; delete cells and count automatically updates; other paste options >>> >>> • AutoCalculate: select any two cells; two or more that contain numerical values; see status bar-average; count and sum; ctrl key hold and randomly select cells; ctrl + select cells with mouse; auto calculate; two or more cells with values >>> >>> • Modifying AutoCalculate: 3 best friends; right click on the status bar; can customize the status bar; check or uncheck the choices >>> >>> • Copying Formulas: f2 or double click; examine the range-e2-e22; copy formula to h; range changes o h2 to h22; cell address is copied relatively-built in default >>> >>> • Cell Multiplication: use for restaurant tip; tip 15%; amount column has meal prices; =left arrow*click on 15% hit enter—$4.50 >>> >>> • Relative Cell References: copy that formula; double click; get zero values for other cells; when copy formula down; ctrl shift down arrow; >>> >>> • Absolute Cell References: tip example data sheet; =a4*$C$3; absolute the formula >>> >>> >>>> >>>> • Formatting Worksheets-view-show: gridlines-turn on/off; formula bar; headings-row #s and column #s-can deselect-worksheet looks like word for windows; >>>> >>>> • Cell/Font Color-select cell or range or worksheet; select data range-ctrl a; home tab; paint bucket icon-pull-down-array of colors; roll over –live preview; no fill-default-white; more colors-color wheel; paint button pull-down; colors; custom; slider; density/intensity of color; rgb-red green blue; manually put in number 0-255; all 255 white; all 0-black; change font color to white; undo-; ctrl a a –select whole worksheet; >>>> >>>> • Background Images: background is bottom layer of worksheet; picture goes on top; insert picture-superficially on top of data cells; true background: page layout-background-vivid pic might obscure the data; busy compensation; get rid of grid lines; view-show-gridlines-; opposite of orange is blue-ctrl a-data-ctrl a a-all of worksheet; choose a darker blue >>>> >>>> • Watermarks-washout the background so it’s not intrusive; page layout-background-ok; delete background; insert; header; page layout view; cursor in header; in context tools; header footer tools added as sub tab-design; click on design; see groups in ribbon; picture-add picture-select-insert &[picture]; format picture-click on picture tab not size; image control section; right click on picture and format picture to get that dialog box in general; watermark=brightness up; contrast lessen; brightness 75; contrast 25; click ok; hit enter; click view or off to side; view-normal-no background; print preview under file; >>>> >>>> • Worksheet Tab Color: right click on sheet tab-tab color; tab color-choose color; >>>> >>>> Section B: Formatting Numbers >>>> >>>> • Modifying Cell Formats-to see cell format click on cell ex: under number group will see currency; what is the name of the format and how do we find out-home tab-number; can change format on down arrow; right click on dollar sign; dollar format with decimals-accounting format; increase-decrease decimal; number; >>>> >>>> • Format Painter-copy format of existing cell-representative cell-click on format painter; click into cell you want to format; want to keep that format; double click on format painter; esc will get out of format painter; >>>> >>>> • Date Formatting: 12/25/2010; December 25, 2010 25 dec-10-default; select column-click on I to select entire column; home; format; dialog box; date; type; choose format; ok; dates are numerical values-not text-but mathematical arithmetic bc can add subtract dates-can’t do that if dates are text; 10/25/2010; right click format cells-general 10/25-/2010 = 40476; Jan 1, 1900-reformat-format cells-general = 1; 1/1/1900=1; 40,476 days from Jan 1, 1900; >>>> >>>> • Formatting Multiple Cells >>>> >>>> • Numerical Cell Values: zip codes that begin with zero ex: 00907 enter - 907; cell format is general; zeros aren’t displayed-have to format cells; r click; format cell; special; ctrl down arrow bottom of data range; format cell-special-zip format-see sample-zip+4 will automatically throw in dash; phone # with dashes also SSN* >>>> >>>> • Special Formats-general cell; add code number with mix number digits; 1-9 ok; 1-9 with leading zeros 000000907;  907; need leading zeros; format cells; custom; default-general; zeros will serve as placeholders 000000000; 000000907 appears**p; custom place holders; zips r aligned; text-left aligned; can format zips as texts; format blank cell; r click; text; 00907 enter; *custom place holders; zip codes; zips with leading zeros don’t need numerical formats; can do text format as text; type 00907-left aligned as if text; green arrow-might be an error; move cursor over green-> smart tag pull down arrow; options; ignore error; green triangle gone; short way; type apostrophe with zip and will become text** >>>> >>>> **Section C: Formatting Text and Tables** >>>> >>>> **• Formatting Fonts / Fills-ctrl shift right arrow select row cells; home tab; bold is highlighted bc text in cell is highlighted; home tab-format cells-font-color; style font Arial; can change size of font; cell height will make accommodations for cell; can click and drag and manually adjust or double click to auto fit;** >>>> >>>> **• Cell Height/Width-can manually make row height bigger double click in cell to edit it; can insert a break between first and name; get rid of extra space; double click in the cell; first and name on two different levels; return will take you to cell below; put cursor near N-alt hit enter and enter; double click between columns to auto fit; place cursor between row names and double click** >>>> >>>> **• Noncompatible Commands: speed keys that DO NOT work in Excel; ctrl + l = left align; ctrl + e = center align; ctrl + r = right align ; ctrl + j = justified; ctrl r copy to right; ctrl d copy down**practice; >>>> >>>> • Cell Alignment-alignment group in the home tab; since alignment speed keys don’t work, format cells; highlight cells; r click; format cells ; alignment; pull down on horizontal click center; or use alignment buttons in the home tab >>>> >>>> • Inserting Comments: right click or insert tab; when some functions are not available it might be that there is a grouping setup; now r click; should see insert comment; user name appears; type in a comment….; >>>> >>>> • Merge and Center: putting a title in multiple columns; choose a blank row and select a few cells and click merge and center; or type into one cell and then hit merge center button; select all of data range to merge and center a title; undo 100x in Excel; >>>> >>>> • Tables: select worksheet; insert menu; click on table; default-my table has headers; click ok; get a look; a design; new context tab at the end of ribbon-design tab with various tools; quick styles can move over designs and get a preview; table style options; header row; banded rows; deselect header row; still have a table but no categories so reselect it; keep as a data table-two options: tools-convert to range-are you sure; OR data menu; deselect filter-will take pull downs off; >>>> >>>> >> >> Objective: Student will be able to: modify cell formats; use format painter; format dates; formatting multiple cells; create numerical cell values; use special Formats >> >> 9-10 am Hour 1: review "Product Analysis for the Pizzeria" and day 6 >> >> 10-11 am Hour 2: guided practice lesson-modify cell formats through use special formats >> >> 11-12 noon Hour 3: Learn key notes and practice-Session 2 >> >> 12 noon- 1 pm Hour 4: review hours 1-3; be sure all of session 1 activities are complete; organize/reflect on our work >> >> []. Are there interesting websites that you would like to share with others? >> 9-10 am Hour 1: review-"Removing Duplicates" last week; >> 10-11 am Hour 2: guided practice lesson-format data >> 11-12 noon Hour 3: Learn key notes and practice-Session 2 >> 12 noon- 1 pm Hour 4: review hours 1-3; begin the "advanced pizzeria project" to review session 1 >> >> === === >>> [] >>> [] >> [] >> >> July 8, 2013-August 9, 2013 >> Room 408 >> Teacher: Michele Persaud >> Email: mpersau3@schools.nyc.gov >> Class website: http://schooldays360.wikispaces.com/Excel >> >> Using Excel 2010 via Online Expert LearnKey, you can: >> •Organize, sort, and record data. >> •Enter in text and mathematical equations. >> •Keep, track, chart, graph, and compare statistics. >> •Maintain records. >> •Create mathematical equations and functions to accurately keep records and statistics whenever data changes. >> You can also use Excel to manage finances, schedule calendar time, plan projects or events, create checklists, etc. >> >> == Week of July 8, 2013 S ession 1== >> ===Section A: Introduction=== >> >> ===Section B: Navigating Excel=== >> >> ===Section C: Excel 2010 Shortcuts=== >> >> ===Section D: Creating and Manipulating Data=== >> >> ===Section E: Managing Worksheets=== >> >> ===Section F: Data Validation=== >> >> ===Section G: Modifying Cell Content=== >> >> ===Section H: Changing Views=== >> >> ==Week of July 15, 2013 Session 2== >> ===Section A: Formatting Data=== >> >> ===Section B: Formatting Numbers=== >> >> ===Section C: Formatting Text and Tables=== >> >> ===Section D: Understanding Formulas=== >> >> ==Week of July 22, 2013 Session 3== >> ===Section A: Referencing Formulas=== >> >> ===Section B: Ranges and Dates=== >> >> ===Section C: Subtotals=== >> >> ===Section D: Using VLOOKUP=== >> >> ===Section E: Using Nested Formulas=== >> >> ===Section F: Conditional Logic=== >> >> ===Section G: More Conditional Logic=== >> >> ==Week of July 29, 2013 Session 4== >> ===Section A: Financial Formulas=== >> >> ===Section B: What-If Functions=== >> >> ===Section C: Working with Text Formulas=== >> >> ===Section D: Paste Special=== >> >> ===Section E: Introduction to Charts=== >> >> ===Section F: Formatting Charts=== >> >> ===Section G: Conditional Formatting=== >> >> ===Section H: Adding Graphics to Spreadsheets=== >> >> ==Week of August 5, 2013 Session 5== >> ===Section A: Outlining, Sorting, and Filtering=== >> >> ===Section B: PivotTables and PivotCharts=== >> >> ===Section C: Protecting Data=== >> >> ===Section D: Introduction to Backstage=== >> >> ===Section E: Collaboration=== >> >> ===Section F: Saving Workbooks=== >> >> ===Section G: Printing Workbooks=== >> >> ===Section H: Macros with VB for Applications===
 * 1) Welcome students!
 * 2) Please read #s 3, 4, and 5 daily
 * 3) The following exercises/projects should be in your folder on the "Room 408 Student S" drive. These assignments will be graded as: "Master of Skill" or "Review Master of Skill." Proper spelling, grammar and punctuation are required for all assignments.
 * 4) TravelExpenses_YourInitials.xlsx (week 1)
 * 5) WishList_YourInitials.xlsx (week 1)
 * 6) ProductAnalysis_YourInitials.xlsx (week 2)
 * 7) Shopping_Start_YourInitials (week 2)
 * 8) Bank Statement_Your Initials (week 3)
 * 9) Fantasy Football_Your Initials (week 3)
 * 10) Online Expert Work
 * 11) The following should be completed for Session 1: pre-assessment, all of the training, all labs, post-assessment
 * 12) The following should be completed for Session 2: pre-assessment, all training for sessions, all labs
 * 13) The following should be completed for Session 3: pre-assessment, all training sessions, all labs
 * 14) Day 25 of 25 August 9, 2013
 * 15) PPT-How do we demonstrate our knowledge and skills in PPT?
 * 16) Objective: Review PPT topics on LearnKey; Showcase your work
 * 17) Agenda:
 * 18) 9-10: Review PPT on LearnKey
 * 19) 10-11: Student Presentations
 * 20) 11-11:20: Break
 * 21) 11:20-12:00: Personal Projects
 * 22) Excel-How do we demonstrate out knowledge and skills in Excel?
 * 23) Objective: Review Excel Topics in sessions 1-4
 * 24) Agenda:
 * 25) 9-10: Session 3 Training on LearnKey
 * 26) 10-11: Presentations/Work on Portfolio annotations
 * 27) 11-11:20: break
 * 28) 11:20-12:00; Personal Projects
 * 29) Day 24 of 25 :-) August 8, 2013
 * 30) PPT-How do we showcase our PPT work?
 * 31)  Objective: present on a topic of interest using  PPT knowledge and skills
 * 32) Objective:
 * 33) 9-10: Work on final presentation project/review session 1-2 packet; mini-lesson-->forms
 * 34) 10-11:Presentations
 * 35) 11-11:20: Break
 * 36) 11:20-12:20: Online Expert-Sessions 1-3 selected topics
 * 37) 12:20-1:00 Quotations project- Session 1-3 review
 * 38) Excel-How are the vlookup and ifs functions used?
 * 39) Objective: use conditional logic formulas (if, and, or, iferror, vlookup)
 * 40) Agenda
 * 41) 9-9:30: Personal Projects/Review yesterday (and, or, iferror, etc) on LearnKey; mini-lesson-->forms
 * 42) 9:30-10: Lesson: sumif, vlookup functions
 * 43) 10-11: Project Annotations for Portfolio
 * 44) 11:20-12:20: Session 3-LearnKey-pre-training-labs-
 * 45) 12:20-1:00: session 3 projects/portfolio annotations
 * 46) Day 23-August 7, 2013
 * 47) PPT-How do we customize slide shows?
 * 48) Objective: manipulate animations and effects
 * 49) Agenda:
 * 50) 9-10: work on final presentation project
 * 51) 10-11: review sessions 1 and sessions 2 selected topics-learnkey
 * 52) 11-11:15: lesson-customize slide shows
 * 53) 11:15-11:35: Break for Staff Meeting
 * 54) 11:35-12:35: Work on final presentation
 * 55) 12:35-1:00 Quotations project--
 * 56) Excel: How do we use conditional logic functions?
 * 57) Objective: Use nested if, and, or, not, iferror, vlookup functions
 * 58) Agenda:
 * 59) 9-9:30: Personal Projects/Review
 * 60) 9:30-10: Lesson: nested if, and, or, not, iferror, vlookup functions
 * 61) 10-11:15: Project Annotations for Portfolio
 * 62) 11:15-11:35: Break for Staff Meeting
 * 63) 11:35-12:35: Continue Lesson on conditional logic/annotations of projects
 * 64) 12:35-1:00: LearnKey review
 * 65) Day 22-August 6, 2013
 * 66) Excel: How do we use conditional logic?
 * 67) Objective: Use the if, or, and functions
 * 68) Agenda:
 * 69) 9-9:30: Review nested formulas, naming ranges and absolute values
 * 70) 9:30-10:00: Lesson - Conditional Logic
 * 71) 10-11: work on portfolios-annotations-model for students
 * 72) 11:20-12:20-Session 3 LearnKey
 * 73) 12:20-1:00: Portfolios
 * 74) PowerPoint: How do we use multimedia in PPT?
 * 75) Objective: manipulate audio, video and animation functions
 * 76) Agenda:
 * 77) 9-9:30: Review shapes, outlines, clipart,
 * 78) 9:30-10:00: work on presentation
 * 79) 10-10:30: lesson on multimedia
 * 80) 10:30-11: practice multimedia
 * 81) 11:20-12:20: work on presentations
 * 82) 12:20-1:00: Review on LearnKey
 * 83) Day 21-August 5, 2013
 * 84) PowerPoint-How do we work with outlines, tables, shapes and clip art?
 * 85) Objective: work with and manipulate outlines, images, tables and shapes
 * 86) Agenda:
 * 87) 9-10: sign up for presentation slots; review tables, images, shapes
 * 88) 10-11: lesson: inserting content and lesson in tables, images and shapes; [[file:PowerPoint August 5 2013.pptx]]
 * 89) 11:20-12:20: project practice
 * 90) 12:20-1:00: work on presentation
 * 91) Excel: How do we use nested and logic formulas in Excel?
 * 92) 9-10: complete session 3 training and labs
 * 93) 10-11: lesson on logic: [[file:Wellingstoner Inc Sales-Subtotals NOTES Aug 5 2013.xlsx]]
 * 94) 11:20: 12:20 session 3 projects
 * 95) 12:20-1:00: review
 * 96) Day 20-August 2, 2013
 * 97) Excel: How do we insert a secondary axis in charts and create data ranges?
 * 98) Objective: create secondary axis to show various data ranges; create data ranges to efficiently use formulas
 * 99) Agenda:
 * 100) 9-10: review Excel session 3; secondary axis
 * 101) 10-11: complete session 3 training and labs
 * 102) 1:20-12:20: session 3 projects
 * 103) 12:20-1:00: personal projects
 * 104) PowerPoint: How do use text from other documents in PPT?
 * 105) Agenda:
 * 106) 9-10: Complete session 1 training & labs in PPT
 * 107) 10-11: Review session 1 training and labs in PPT
 * 108) 11:20-12:20: post assessment session1
 * 109) 12:20-1: session 2-pre assessment; Body Language TED Talk: []
 * 110) Day 19-August 1, 2013
 * 111) Excel: How are data points organized in Excel charts?
 * 112) Objective: choose the appropriate chart tool to represent data
 * 113) Agenda:
 * 114) 9-10: continue to work on Chart Exercises
 * 115) 10-11: Q & A: reviewing charts
 * 116) 11-11:20: Break
 * 117) 11:20-12:20: LearnKey Session 4-Charts; Session 3: review
 * 118) 12:20-1:00: Personal Projects-resumes, etc. Amazon.com is hiring :-) []
 * 119) PowerPoint: How are data points organized in Excel charts?
 * 120) Objective: choose the appropriate chart tool to represent data
 * 121) Agenda:
 * 122) 9-10: continue to work on Chart Exercises
 * 123) 10-11: Q & A: reviewing charts
 * 124) 11-11:20: Break
 * 125) 11:20-12:20: LearnKey session 1
 * 126) 12:20-1:00: Personal Projects-resumes, etc. Amazon.com is hiring :-) []
 * 127) Day 18-July 31, 2013
 * 128) Excel: How do we create charts in Excel?
 * 129) Objective: Use chart tools to correctly represent data
 * 130) Agenda:
 * 131) 9-10 Session 4: Introduction to Charts/Formatting Charts
 * 132) 10-10: 30: Lesson on charts
 * 133) 10:30-11: Chart exercises
 * 134) 11-11:20: Break
 * 135) 11:20-12:20: Chart Exercises con't
 * 136) 12:20-1: Review/Personal Projects
 * 137) Word/PPT:
 * 138) How do we create charts in PPT?
 * 139) Objective: Use chart tools to correctly represent data
 * 140) Agenda:
 * 141) 9-10: Finish Bird Research exercise; finish session 1 training in ppt (answer key will be uploaded)
 * 142) 10-10: 30: Lesson on charts
 * 143) 10:30-11: Chart exercises
 * 144) 11-11:20: Break
 * 145) 11:20-12:20: Chart Exercises con't
 * 146) 12:20-1: Review/Personal Projects
 * 147) Excel: How are various charts used in Excel/
 * 148) Objective: Create and format 3 basic chart types
 * 149) Agenda:
 * 150) 9-10: Listen to and take notes on Session 4: Formatting Charts
 * 151) 10-11: Mini-Lesson on Charts and Practice Exercise
 * 152) 11-11:20---Break
 * 153) 11:20-12:20: Review Exercises-Excel
 * 154) 12:20-1:00: Personal Projects
 * 155) PowerPoint: How do we create simple research presentations with charts in PowerPoint?
 * 156) Objective: Research information on a bird and create a PowerPoint presentation with relevant charts and graphics
 * 157) Agenda:
 * 158) 9-10; finish "About Me" ppt exercise; listen to session 1 ppt training and take notes
 * 159) 10-11: lesson on charts and graphs in ppt
 * 160) 11:20-12:20: research exercise
 * 161) 12:20-1:00; review/personal projects
 * 162) Day 16-July 29, 2013
 * 163) Day 15-July 26, 2013
 * 164) Excel and PowerPoint Classes meet in the same classroom
 * 165) Day 14-July 25, 2013
 * 166) Day 13-July 24, 2013
 * 167) Aim: How are formulas referenced in Excel?
 * 168) Objectives; review big ideas from sessions 1 & 2 (knowledge, skills, projects): basic navigation of excel & formatting data and performing simple operations; evaluate knowledge and skills of sessions 1 & 2: basic navigation of excel & formatting data and performing simple operations; take session 3 pre-assessment; obtain an overview of referencing formulas;
 * 169) Agenda:
 * 170) 9:00 - 10:00~Do Now: 1) log on to http://oace.onlineexpert.com and review sessions 1 & 2 skills & projects; finish any outstanding assignments/tasks (see #s 3 & 4 above)
 * 171) 10:00 - 11:00~Midterm Quiz Practice on sessions 1 & 2 skills (closed book); Actual Midterm will be on Friday 7/26/2013 from 10:00-11:00
 * 172) 10:00-11:00~session 3 pre-assessment
 * 173) 11:00-12:00~Direct instruction and guided on referencing formulas
 * 174) 12:00-12:15~Break
 * 175) 12:15-1:00~LearnKey Session 3 - Training on "Referencing Formulas'
 * 176) Lesson:
 * 177) Day 12-July 23, 2013
 * 178) Aim: How do we format data and perform simple operations in Excel 2010?
 * 179) Reminder: no drinks or food near the computers
 * 180) Do Now: Work on "Bank Statement" project and save this file as 'Bank Statement_Your Initials' in your folder on the S drive
 * 181) Lesson: Review session 3 big ideas from the review packet
 * 182) Work on "Fantasy Football" project save this file as 'Bank Statement_Your Initials' in your folder on the S drive
 * 183) Review Session 2
 * 184) Complete the post-assessment on session 3
 * 185) Day 11-July 22, 2013
 * 186) Aim: How do we format data and perform simple operations in Excel?
 * 187) Do Now: Check your responses to session 2 note-taking/review handouts
 * 188) Objective: review formatting data and formulas
 * 189) Agenda:
 * 190) 9:30-10:30-review session 2-fill in the blanks and glossary
 * 191) 10:30-11:00-review session 2-short answers
 * 192) 11:00-11:15-B R E A K
 * 193) 11:15-12:15-project 1- review/finish project Shopping_start.xlsx; begin BankStatement project
 * 194) 12:15-1:00-review today's work
 * 195) Day 10-July 19, 2013
 * 196) Happy Friday to all. Sorry that I am not in class today. Please work on the following tasks at your own pace:
 * 197) Complete yesterday's project on the "Shopping_Start" file
 * 198) Log on to []. Take notes on the topics below as you watch the videos in session 2 (New Students -please watch and take notes on the session 1 videos) *Make sure you've done the pre-assessment for sessions 1 & 2. After you've taken notes on the videos complete the labs for the session. Have a pleasant weekend. See you all on Monday.
 * 199) Session 2 video topics:
 * 1) Day 10-July 19, 2013
 * 2) Happy Friday to all. Sorry that I am not in class today. Please work on the following tasks at your own pace:
 * 3) Complete yesterday's project on the "Shopping_Start" file
 * 4) Log on to []. Take notes on the topics below as you watch the videos in session 2 (New Students -please watch and take notes on the session 1 videos) *Make sure you've done the pre-assessment for sessions 1 & 2. After you've taken notes on the videos complete the labs for the session. Have a pleasant weekend. See you all on Monday.
 * 5) Session 2 video topics:
 * Formatting Worksheets
 * Cell/Font Color
 * Background Images
 * Watermarks
 * Worksheet Tab Color
 * Modifying Cell Formats
 * Format Painter
 * Date Formatting
 * Formatting Multiple Cells
 * Numerical Cell Values
 * Special Formats
 * Formatting Fonts / Fills
 * Cell Height/Width
 * Noncompatible Commands
 * Cell Alignment
 * Inserting Comments
 * Merge and Center
 * Tables
 * Operations
 * Arithmetic Operations
 * Additional Operation Symbols
 * SUM Function
 * Ranges in Functions
 * AutoSum
 * Average
 * Min/Max Functions
 * Count Formula
 * AutoCalculate
 * Modifying AutoCalculate
 * Copying Formulas
 * Cell Multiplication
 * Relative Cell References
 * Absolute Cell References
 * 1) Session 1 topics (for New students and those who haven't yet watched all of session 1 videos)
 * Course Overview
 * Excel 2010 Introduction
 * Quick Access Toolbar
 * Toolbar Customization
 * Additional Customization Buttons
 * Ribbon Organization
 * Function Grouping
 * Multiple Function Access
 * The Document Window
 * Basic Navigation
 * Workbook Options
 * Best Practice Guidelines
 * Common Hot Keys
 * Speed Keys
 * Function Keys
 * CTRL Keys
 * ALT Keys
 * Visible Speed Keys
 * Entering Data
 * Auto Fill a Series
 * Creating Custom Lists
 * Fill Adjacent Cells
 * Fill Non-Adjacent Cells
 * Auto Fill on Multiple Sheets
 * 1) ===Section E: Managing Worksheets===
 * Copying/Moving Worksheets
 * Renaming Worksheets
 * Inserting/Deleting Worksheets
 * Hiding Worksheets
 * Range Criteria
 * List Criteria
 * Extending the List
 * Input Message
 * Validation Error Alerts
 * Validation by Character
 * Copy/Paste Options
 * Paste
 * Inserting Columns
 * Transporting Data
 * Copy Cell Formatting
 * Removing Duplicates
 * Zoom
 * Workbook Views
 * Page Layout
 * Freeze Panes
 * Split Windows
 * Viewing Multiple Windows
 * 1) Day 9-July 18, 2013
 * 2) Aim: How do we perform simple calculations?
 * 3) Objectives: perform arithmetic operations and simple formulas in Excel
 * 4) Agenda:
 * 5) 9-10: common core state standards [] review yesterday day 8; Understanding formulas lesson-guided instruction
 * 6) 10-11: Understanding formulas lesson-guided instruction con't
 * 7) 11-11:15-b-r-e-a-k
 * 8) 11:15-12:15: shopping project: copy the " Shopping_Start.xlsx" file from S:\Excel Summer 2013 Michele Persaud\Data Files to your folder and then open up the file. Begin the project :-)
 * 1) Check this website for tomorrow's work
 * 2) Lesson:
 * 3) Understanding Formulas
 * 1) Day 8-July 17, 2013
 * 2) Aim: How do we format text, numbers and tables?
 * 3) Objective: use special formats to modify cells
 * 4) Agenda
 * 5) 9-10 am: TED talks and review yesterday
 * 6) 10 am - 11 am: format text, numbers, tables
 * 7) 11 am - 11:15: break :-)
 * 8) 11:15 - 12:15: Independent practice (complete session 1 work, do session 2 pre-assessment; begin session 2 training)
 * 9) 12:15 - 1:00: Review sessions 1 & 2 skills (handouts, etc)
 * 10) Do Now: Go to www.ted.com/talks --> on the left side of the page select "most viewed" --> do you see anything of interest? Let's watch a talk together.
 * 11) Lesson:
 * 12) Section A: Formatting Data
 * 1) Day 7-July 16, 2013
 * 2) Aim: How do we format data text, numbers and tables in Excel 2010?
 * 1) Day 6-July 15, 2013
 * 2) How do we format data in Excel?
 * 3) Do Now: For interesting articles Browse the "Business Insider" website [] and for "50 websites that make the web great" click on this link:
 * 1) Objectives: format data, text, numbers and tables
 * 1) My Notes: Review Session 1
 * 2) Removing Duplicates: ctrl z undo up to 100x; select row 13 by clicking row 13; copy ctrl c; insert cells; from tab or ctrl shift +sign; ctrl a highlight data range; data tab; remove duplicates; remove rows by columns; my data has headers should be checked; click ok; 1 duplicate and 21 unique values;
 * 3)  Section H: Changing Views
 * 4)  • Zoom: view tab; zoom button; dialog box; default 100%; fit the selection; select all; ctrl a; fit selection-see entire worksheet ex: 77%; click on slider and will see dialog box or use the slider; + or – sign incrementally increase/decrease; zoom to selection; fills entire window to see data range; default 100%
 * 5)  • Workbook Views: view tab; workbook views; page layout; ruler; margin around as if on paper; if print what it would look like; page break preview; do not show dialog box; you can adjust page breaks by clicking and dragging with the mouse; dotted lines; page 1; page 2; fix column borders; click drag border manually; double click on border to auto fit nicely; click and drag the dotted line border; page layout; full screen; min, max. restore down; maximize; double click in the title area; click on normal view….play with views to print
 * 6)  • Page Layout: under page setup; print area; set print area; will see border to delineate print area; how to get rid of page break; appears when page break preview or preview/print area/ or specify new page break; how to get rid of them; click on file; options; advanced; display; display option for workbook/worksheet; show page breaks is selected; deselect and click ok; margins- normal; customize; change orientation portrait-vertical; landscape horizontal; size-default is letter; legal abroad A4;
 * 7)  • Freeze Panes: view tab; freeze panes; place cursor in cell A2; below top row; freeze top row; see margin line on top row; to add new entry; keep seeing title; unfreeze-click freeze panes; have titles in left column; place cursor in B2; titles in first column; b2; freeze panes; choose freeze panes; cursor down and to the right; unfreeze; click on freeze panes and unfreeze;
 * 8)  • Split Windows; window split bar; click and drag; will split the screen; click and drag back to get rid; vertical scroll bar can split the screen; or double click and it disappears; can split for ways; if you have entries on one side and results on other side; if you know worksheet well splitting is recommended; large worksheet-freeze panes if unfamiliar
 * 9)  • Viewing Multiple Windows: view tab; new window; click; colon #; :2. Created a mirror image; arrange all; vertical; can work with different sections of the worksheet simultaneously; same file same version; whatever changes make; all will be saved; two files; arrange all- vertical or horizontal; compare; copy and paste; minimize the ribbon; expand the ribbon; tent icon; right click on zoom and add to quick access toolbar; practice;
 * 10) My Notes: Session 2 Formatting Data
 * Formatting Worksheets-view-show: gridlines-turn on/off; formula bar; headings-row #s and column #s-can deselect-worksheet looks like word for windows;
 * Cell/Font Color-select cell or range or worksheet; select data range-ctrl a; home tab; paintbucket icon-pull-down-array of colors; roll over –live preview; no fill-default-white; more colors-color wheel; paint button pull-down; colors; custom; slider; density/intensity of color; rgb-red green blue; manually put in number 0-255; all 255 white; all 0-black; change font color to white; undo-; ctrl a a –select whole worksheet;
 * <span style="font-family: Arial,Helvetica,sans-serif;">Background Images: background is bottom layer of worksheet; picture goes on top; insert picture-superficially on top of data cells; true background: page layout-background-vivid pic might obscure the data; busyà compensation; get rid of grid lines; view-show-gridlines-; opposite of orange is blue-ctrl a-data-ctrl a a-all of worksheet; choose a darker blue
 * <span style="font-family: Arial,Helvetica,sans-serif;">Watermarks-washout the background so it’s not intrusive; page layout-background-ok; delete background; insert; header; page layout view; cursor in header; in context tools; header footer tools added as sub tab-design; click on design; see groups in ribbon; picture-add picture-select-insertà &[picture]; format picture-click on picture tab not size; image control section; right click on picture and format picture to get that dialog box in general; watermark=brightness up; contrast lessen; brightness 75; contrast 25; click ok; hit enter; click view or off to side; view-normal-no background; print preview under file;
 * <span style="font-family: Arial,Helvetica,sans-serif;">Worksheet Tab Color: right click on sheet tab-tab color; tab color-choose color;
 * 1) Day 5-July 12, 2013
 * 2) Aim: How do we demonstrate our learning of basic navigation of the Excel 2010 interface?
 * 3) Objective: review session 1 knowledge and skills via short answer, fitb, matching questions, and projects
 * 4) Do Now: Review Session 1 vocabulary and major skills-f-i-t-b, short answer, glossary
 * 5) Lesson: Review session 1 key ideas--ANSWER KEYS are in my folder :-)
 * 6) Projects 1-3
 * 7) LearnKey Post Assessment
 * 8) Thank you for your work in week 1. Have a good weekend! :-)
 * 9) Day 4-July 11, 2013
 * 10) Aim: What have we learned in session 1?
 * 11) Objectives: perform drills and exercise to review the skills in Session 1
 * 12) Do Now:
 * 13) Download google chrome browser to your computer for easier web access
 * 14) search for google chrome in any search engine
 * 15) click on the google chrome link and select "download chrome" and follow the steps
 * 16) Read about the top job search sites here: []
 * 17) You can also search for jobs at these sites: NYS Dept of Labor [] and Idealist
 * 1) Lesson: Review data validation; modifying cell contents; changing views;
 * 2) Practice session 1 skills
 * 3) Independent Review on LearnKey
 * 4) Day 3- July 10, 2013
 * 5) Aim: How do we create, manipulate and validate data?
 * 6) Objectives: perform the following tasks in Excel: Entering Data, Auto Fill a Series, Creating Custom Lists, Fill Adjacent/l Non-Adjacent Cells, Auto Fill on Multiple Sheets
 * 7) Activities
 * 8) Review class website http://schooldays360.wikispaces.com/Excel and LearnKey site http://oace.onlineexpert.com
 * 9) Reading: Forget Business School: Why An Emotional Education Is Indispensible
 * 1) Reading: Forget Business School: Why An Emotional Education Is Indispensible
 * 1) Lesson on creating, manipulating, validating data
 * 2) Excel Drills
 * 3) Pre-assessment & Labs
 * 4) Exit Label parts of Excel workbook; Review Session 1 sections A-F
 * 5) Day 2-July 9, 2013
 * 6) Aim: How do we navigate Excel 2010:
 * 7) Objectives: become familiar with the Excel 2010 interface; create, edit and delete worksheets; explore and describe the Excel window; learn to edit a worksheet, save the workbook, and properly exit the program.
 * 8) Lesson on Excel Interface: see pages 2-15 in the document at []
 * 9) Excel Exercises: pages 13-15 at []
 * 10) Save all files in "your name" folder on the 408 S drive. Follow the filename directions listed in the exercise/task
 * 11) Quiz: True/False and MCQs pages 13-14 []
 * 12) Day 1-July 8, 2013
 * 13) Aim: How is Excel 2010 utilized?
 * 14) Syllabus
 * 15) Introductions
 * 16) Create student data sheet in excel: student name; experience with Excel; goals for the course; something to share with the class
 * 17) Pre-assessment-Session 1
 * 18) Session 1: I ntroduction through Introduction to Shorcuts
 * 19) Q & A
 * 20) Exit-questions 1-6:
 * 21) Where is home in excel? How do I get home?
 * 22) True or false: There are over a million columns and over sixteen thousand rows in Excel 2010
 * 23) How many sheets can fit in a workbook?
 * 24) What is the speed key to get to the start menu? my computer? the desktop?
 * 25) What do the following function keys do: F1? F4*? F7?
 * 26) What are the speed keys to: copy? paste? print? select all? get a new worksheet?
 * 27) A1; Ctrl home
 * 28) False: over a million rows and over 16,000 columns
 * 29) 255 sheets
 * 30) windows key-(key after ctrl); windows key + e; windows + D
 * 31) help; repeat last simple command*; spell check
 * 32) ctrl c; ctrl p; ctrl a; ctrl n
 * 33) Cool Web Tools
 * 34) []
 * 1) Excel Course Outline
 * 2) == Office of Adult and Continuing Education Mid-Manhattan Adult Learning Center Excel 2010 Course Outline ==
 * Course Overview
 * Excel 2010 Introduction
 * Quick Access Toolbar
 * Toolbar Customization
 * Additional Customization Buttons
 * Ribbon Organization
 * Function Grouping
 * Multiple Function Access
 * The Document Window
 * Basic Navigation
 * Workbook Options
 * Best Practice Guidelines
 * Common Hot Keys
 * Speed Keys
 * Function Keys
 * CTRL Keys
 * ALT Keys
 * Visible Speed Keys
 * Entering Data
 * Auto Fill a Series
 * Creating Custom Lists
 * Fill Adjacent Cells
 * Fill Non-Adjacent Cells
 * Auto Fill on Multiple Sheets
 * Copying/Moving Worksheets
 * Renaming Worksheets
 * Inserting/Deleting Worksheets
 * Hiding Worksheets
 * Range Criteria
 * List Criteria
 * Extending the List
 * Input Message
 * Validation Error Alerts
 * Validation by Character
 * Copy/Paste Options
 * Paste
 * Inserting Columns
 * Transporting Data
 * Copy Cell Formatting
 * Removing Duplicates
 * Zoom
 * Workbook Views
 * Page Layout
 * Freeze Panes
 * Split Windows
 * Viewing Multiple Windows
 * Formatting Worksheets
 * Cell/Font Color
 * Background Images
 * Watermarks
 * Worksheet Tab Color
 * Modifying Cell Formats
 * Format Painter
 * Date Formatting
 * Formatting Multiple Cells
 * Numerical Cell Values
 * Special Formats
 * Formatting Fonts / Fills
 * Cell Height/Width
 * Noncompatible Commands
 * Cell Alignment
 * Inserting Comments
 * Merge and Center
 * Tables
 * Operations
 * Arithmetic Operations
 * Additional Operation Symbols
 * SUM Function
 * Ranges in Functions
 * AutoSum
 * Average
 * Min/Max Functions
 * Count Formula
 * AutoCalculate
 * Modifying AutoCalculate
 * Copying Formulas
 * Cell Multiplication
 * Relative Cell References
 * Absolute Cell References
 * Totaling Multiple Sheets
 * AutoFit Multiple Cells
 * Linked Formulas
 * Grand Totals
 * Sparkline Graphics
 * Sparkline Colors
 * Consolidation
 * Consolidating Data
 * Linking to Source Data
 * Hierarchical Outline
 * Consistency
 * Naming Ranges
 * Adding Named Ranges
 * Dates
 * Date Speed Keys
 * Formula Calculations
 * Formula Auditing
 * The Watch Window
 * Formula Evaluation
 * Using Subtotals
 * Subtotal Options
 * Using Data Hierarchy
 * Selecting Visible Data
 * VLOOKUP
 * VLOOKUP Type I
 * VLOOKUP's Three Arguments
 * VLOOKUP Type I Methodology
 * VLOOKUP Type II
 * Nested Formulas
 * Absolute Numbers
 * Nested Absolutes
 * Nested Formula Logic
 * FIND
 * INDIRECT
 * ROW/COL
 * The IF Formula
 * The IF Statement
 * Nested IF
 * Nested IF Syntax
 * Insert Wizard
 * AND
 * OR
 * NOT
 * IFERROR
 * SUMIF / AVERAGEIF / COUNTIF
 * SUMIFS
 * AVERAGEIFS
 * COUNTIFS
 * Working with Financial Formulas
 * Future Value Function
 * Function Categories
 * Calculating Interest Rate
 * Calculating Total Payment
 * Calculating Monthly Payment
 * Using Goal Seek
 * Solver Add-in
 * Using Solver
 * Constraints
 * Reports
 * Comparing Options
 * Scenario Manager
 * Scenario Report
 * Data Tables
 * Applying Data Tables
 * Comparing Data Tables
 * Concatenate
 * Text to Columns
 * Extraction Formulas
 * Combining with Previous Formulas
 * UPPER/LOWER/PROPER
 * Converting Formulas with Function Keys
 * Pasting Values
 * Pasting Formats
 * Quick Multiplication
 * Addition
 * TRIM
 * Substitute
 * Charts
 * Chart Types
 * Instant Chart
 * Updating Charts
 * Add Secondary Y/Value Axis
 * Adding Data Labels
 * Fill
 * Picture Fill
 * Line/Scatter Charts
 * Chart Styles
 * 3-D Charts
 * Quick Layouts
 * Formatting Chart Labels
 * Layout
 * Chart Title
 * Legends
 * Conditional Formatting Options
 * Selecting Cells to Format
 * Top/Bottom Rules
 * Data Bars/Color Scales/Icon Sets
 * Managing Rules
 * Wildcards
 * Alternative Row Shading via Formulas
 * Inserting Pictures
 * Modifying Pictures
 * Inserting Shapes
 * Inserting SmartArt
 * Modifying SmartArt
 * Themes
 * Grouping
 * Ungrouping
 * Sorting Data
 * Sorting Levels
 * Filtering Data
 * Selecting Filtered Rows
 * Advanced Filtering
 * PivotTables
 * Creating PivotTables
 * PivotTable Layout
 * Defaults
 * Updating/Modifying Data
 * Calculated Fields
 * Calculated Items
 * Filtering PivotTables
 * Slicer
 * PivotCharts
 * Locking Cells
 * Protect Workbook
 * Hiding Cells
 * Hiding Worksheets
 * Document Properties
 * Titles/Tags/Categories
 * Related Dates / People
 * Formatting Comments
 * Document Inspector
 * Sparklines/Slicer
 * Compatibility Checker
 * Document Inspection
 * Sharing Documents
 * Sharing Workbooks
 * Protecting Shared Workbooks
 * Tracking Changes
 * Accept/Reject Changes
 * Information Rights Management
 * Document Signature
 * Mark as Final
 * Save as Previous Version
 * File Sharing with Previous Excel Version
 * Customization/Compatibility
 * Excel Options
 * Templates
 * Opening/Deleting Templates
 * Save as a Web Page
 * Single File Web Page
 * Page Orientation
 * Margins
 * Print Area/Page Breaks
 * Page Sailing
 * Headers/Footers
 * Row/Column Headings
 * Other Print Options
 * Macros
 * Recordable Macros
 * Non-Recordable Macros
 * Creating a Macro
 * Naming Macros
 * Shortcut Keys
 * Storage Options
 * Recording a Macro
 * Testing Macros
 * Editing Macros with Visual Basic
 * Testing Edited Macros
 * Relative Reference Macros
 * Assigning Buttons to Macros
 * Modifying Button Icons
 * Macro-Enabled Workbooks
 * Save Workspace