{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["List","Simple functions","Fibonacci  & more","Cherry Pumpkin example","Grier example","DAWN example","File ext."],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":9,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"List","index":0,"n_rows":152,"n_cols":14,"rows_kept":152,"cut":false,"hidden":false,"merged":[[76,5,76,8],[84,5,84,8],[17,9,18,13],[26,13,27,13]],"flags":["formulas_cached_only"]}
[]
[null,"EXCEL 2007",{"$nulls":9},"Today's date:",40198]
[]
[null,"Presented by Larry Wittig at the 20 January 2010 Lexington Computer and Technology Meeting"]
[null,"This presentation uses Excel from Microsoft Office Home and Student Edition 2007"]
[]
[null,"Say a few words about the background of spreadsheets including Visicalc",{"$nulls":6},"VisiCalc - Wikipedia, the free encyclopedia"]
[]
[null,"Say a few words about how Excel files can be saved. (*.xls,  *.xlsx, *.xlsm  etc.)",{"$nulls":6},"You can download this workbook  from our Yahoo Group page."]
[{"$nulls":8},"LexingtonComputerGroup : Lexington Computer and Technology Group"]
[{"$nulls":8},"These versions are available at"]
[]
[null,"RECOMMENDED REFERENCE SITES (pasted into this worksheet as hyperlinks)"]
[]
[null,null,null,"Go to"]
[null,null,"Quick Reference hand out","Microsoft Excel Training - Customizable Microsoft Excel Software Tutorials and Online Computer Training Courseware"]
[null,null,null,"http://www.customguide.com/index.htm"]
[null,null,null,"and click on the guide you want",{"$nulls":5},"If these do not work as hot links , you may have to copy & paste the \"http:// …\" lines into you Web Browser"]
[]
[]
[null,null,"Help for Excel 2007","http://office.microsoft.com/en-us/excel/FX100646951033.aspx?CTT=96&Origin=CL100570551033"]
[]
[null,null,"Video courses","Excel 2007 - Training - Microsoft Office Online"]
[null,null,null,"http://office.michttp://office.microsoft.com/en-us/training/CR100479681033.aspx?stt=16rosoft.com/en-us/training/CR100479681033.aspx?stt=16"]
[null,null," Excel 2007  home page","Get started download page"]
[null,null,null,"http://cbt.brainstorminc.com/microsoft/help.php?file=excel4"]
[null,null,"New in 2007","Overview - Training - Microsoft Office Online",{"$nulls":9},"These are the same"]
[null,null,null,"http://office.microsoft.com/training/training.aspx?AssetID=RC100620751033&pid=CR100479681033"]
[null,null,null,"Excel ribbon discussed in this video"]
[null,null,"Short cuts","Excel shortcut and function keys - Excel - Microsoft Office Online"]
[null,null,null,"http://office.microsoft.com/en-us/excel/HP100738481033.aspx#backtotop"]
[null,null,null,"For a more extensive list than the Quick Reference hand out"]
[null,null,null,"ALSO SHOW HOW ALT KEY GIVES YOU KEYBOARD CONTROL"]
[null,null,"Templates","Templates - Microsoft Office Online"]
[null,null,null,"http://office.microsoft.com/en-us/templates/FX100595491033.aspx?pid=CL100632981033"]
[null,null,null,"Used for address label and home inventory examples"]
[null,null,"Another source of info","Microsoft Excel Tutorials - FunctionX"]
[null,null,null,"http://www.functionx.com/excel/index.htm"]
[]
[null,"Get started tab"]
[null,null,"Up to speed with Excel",null,"This is good but it takes 30 to 40 minutes"]
[]
[null,null,"Get up to speed ",null,"Play this, it's about 5 min long"]
[null,null,null,"Talks about the \"Ribbon\" -- also show how the Ribbon changes with screen size."]
[]
[null,"Discuss first"]
[null,null,"Office button","new -- how to start"]
[null,null,null,"open & open options"]
[null,null,null,"save and save as -- there are now more ways to save"]
[null,null,null,"print",{"$nulls":5},"Note that this stuff is all in Column D, but"]
[null,null,null,"Excel options",{"$nulls":5},"since there is nothing in Column E it overflows."]
[{"$nulls":9},"One could make Column D wider or wrap the text."]
[null,null,"Misc","quick access tool bar & hide ribbon"]
[null,null,null,"size control in lower right corner"]
[null,null,null,"tab options"]
[null,null,null,"no ribbon & full screen"]
[]
[null,"Use Example Work Sheets to demo:"]
[]
[null,null,"Edit"]
[null,null,"insert data"]
[null,null,"insert & delete rows"]
[null,null,"insert comment --review tab"]
[null,null,"auto sum, fill and clear"]
[null,null,"fill -- based on a pattern"]
[null,null,"undo"]
[null,null,"cut (or copy) and paste "]
[null,null,"move"]
[null,null,"sorting"]
[null,null,"auto sum, fill and clear"]
[null,null,"paste special"]
[]
[null,null,"Formatting"]
[null,null,"format cells or arrays"]
[null,null,"format painter"]
[null,null,"conditional formatting"]
[{"$nulls":5},"Show grouping -- on Data tab"]
[null,null,"Formulas"]
[null,null,"formulas -- basic concepts"]
[null,null,"copy a formula "]
[null,null,"copy a formula "]
[null,null,"trace precedents"]
[null,null,"color code dependents"]
[]
[null,null,"Help",null,null,"(Show Styles on Home Tab)"]
[null,null,"excel built-in help"]
[null,null,"Microsoft web help"]
[null,null,"other wed help"]
[]
[null,null,"Insert stuff"]
[null,null,"charts"]
[null,null,"add comments "]
[null,null,"drawing -- insert shape"]
[null,null,"arrange (e.g. bring to front)"]
[null,null,"insert hypertext"]
[]
[]
[null,null,"DEMO WORKSHEETS (on the other tabs of this workbook)"]
[null,null,null,"First explain tabs"]
[null,null,"Simple functions","insert & fill data, format cells & alignment, simple equations, dates"]
[null,null,"Fibonacci & More","fill, simple functions, chart, multiplication table, conditional formation"]
[null,null,"Cherry Pumpkin Day Care ","formatting"]
[null,null,"GRIER SUMMER CAMP","sorting"]
[null,null,"DAWN ","Colors & no grid lines"]
[]
[]
[null,"Address labels: ","In Excel:  Start a new workbook and download label template"]
[null,null,"fill/format form"]
[null,null,"Example using Word 2007"]
[null,null,"You may first want to determine what label you have or decide what label you want.  "]
[null,null,"For example by going to",null," Address Labels | Return Address Labels & Mailing Labels | Avery"]
[null,null,"THEN"]
[null,null,"·         Open WORD"]
[null,null,"·         Click on MAILINGS tab"]
[null,null,"·         Click on CREATE & LABLES"]
[null,null,"·         Click on OPTIONS"]
[null,null,"·         Pick the label you want (e.g., Avery 8660)"]
[null,null,"·         Click NEW DOCUMENT"]
[null,null,"·         Click LAYOUT (Not Page Layout)"]
[null,null,"·         Click on the  selection arrow (in the top left corner) and select the whole table"]
[null,null,"·         Select ALIGNMENT and the CENTER LEFT icon"]
[null,null,"·         (It seems like you should be able to set cell margins, but I couldn’t get it to work)"]
[null,null,"·         So click above each column and drag the left margin tabs in a 1/10th of an inch or so"]
[null,null,"·         Then start filling in the form"]
[null,null,"·         If font size needs adjustment, select the table again and go to the HOME tab and adj. the font"]
[null,null,"·         Enter for new rows within a cell and click on next cell to fill it out"]
[null,null,"·         Go the OFFICE BUTTON and save when you’re done – you can also print from here"]
[]
[null,"Use Home inventory list to demo"]
[null,null,"freeze panes"]
[null,null,"auto wrap formatting"]
[null,null,"insert photo or link"]
[null,null,"insert text box"]
[]
[null,"Use Sudoku WS (Basic tab) to demo"]
[null,null,"Quick overview of spreadsheet"]
[null,null,null,"zoom out"]
[null,null,null,"increase/decrease size"]
[null,null,"Note "]
[null,null,null,"small square cells"]
[null,null,null,"no ribbon"]
[null,null,"How it works & avoiding circular references"]
[null,null,"Excel options -- e.g. don't show zeros"]
[null,null,"paste special"]
[null,null,"quick access toolbar -- adding and removing things"]
[null,null,"split screen"]
[null,null,null,"some time you need to scroll tabs"]
[null,null,"formulas"]
[null,null,null,"trace precedents"]
[null,null,null,"color code dependents"]
[null,null,"conditional formatting"]
[null,null,"macros",".xlsx  vs  .xlsm"]

{"sheet":"Simple functions","index":1,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Clicking on this allows you to select the whole page, for example if you wanted to change the font size for the page."]
[]
[]
[null,"A","B ","A+B","5*(A+B)","Rating",null,"THINGS TO DEMO"]
[null,1,2,3,15,"Bad"]
[null,2,4,6,30,"Good",null,"insert data and headings -- the heading do NOT control what happens in the cells"]
[{"$nulls":7},"undo"]
[{"$nulls":7},"format cells "]
[{"$nulls":8},"number of decimal places",{"$nulls":7},1.98,"Joe "]
[{"$nulls":8},"font & font size",{"$nulls":7},2,"Mary"]
[{"$nulls":8},"left , center, right; top, middle, bottom",{"$nulls":7},4.5,"Joshua"]
[{"$nulls":8},"alignment with indent",{"$nulls":7},1.325,"Madison"]
[{"$nulls":8},"row height and column width"]
[{"$nulls":7},"cut (or copy) and paste [from same worksheet or another worksheet]"]
[{"$nulls":7},"move"]
[{"$nulls":7},"simple equations"]
[{"$nulls":7},"auto sum, fill and clear"]
[{"$nulls":7},"fill -- based on a pattern"]
[{"$nulls":7},"insert & delete rows -- add a row before 5*B"]
[{"$nulls":7},"paste special"]

{"sheet":"Fibonacci  & more","index":2,"n_rows":16,"n_cols":32,"rows_kept":16,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"DEMO",{"$nulls":5},"There's more over here ",{"$nulls":15},"There's more over here "]
[]
[null,"Simple array",{"$nulls":15},"Multiplication table example",{"$nulls":11},"Wind chill example"]
[null,"fill",{"$nulls":6},"Simple bar chart",{"$nulls":8},"simple function w/ fixed rows/columns"]
[null,"a little  formatting",{"$nulls":15},"conditional formation",{"$nulls":12},5,10]
[null,"simple chart",{"$nulls":6},"MONTH","VALUE",{"$nulls":19},45,42.34519893957256,39.83967578555787]
[null,null,"Note: some ribbon items do not appear unless you",{"$nulls":5},"January",5,{"$nulls":19},40,36.47240485832117,33.64254827558847]
[null,null,"have clicked on an item to which they would apply",{"$nulls":15},1]
[null,null,"(e.g., if you click on a chart a \"layout\" tab appears)",{"$nulls":14},1]
[{"$nulls":17},2]
[null,"Index","Squares","Fibonacci"]
[null,0,0,0]
[null,1,1,1]
[null,2,4,1]
[null,3,9,2]

{"sheet":"Cherry Pumpkin example","index":3,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Cherry Pumpkin Day Care",{"$nulls":13},"SHOW:"]
[{"$nulls":14},"column width"]
[null,"First Name","MI","Last Name","Friendly Name","Age","Gender","Emergency Contact Name","Relationship","Emergency Contact Phone","Allergies",null,null,null,"center"]
[null,"Laurraine","G","Caffrey","Laurie",4,"Female","Jasmine Caffrey","Mother","(410) 644-5309","Cat",null,null,null,"wrap"]
[null,"John",null,"Brooks","Johnny",4.5,"Male","Sarah","Babysitter","(410) 877-5281",{"$nulls":4},"group emergency info"]
[null,"Alfred","S","Simpson",null,5,"Male","Gertrude Simpson","Mother",{"$nulls":6},"merge and center"]
[null,"Victorine",null,"Runge",null,4,"Female",null,"Aunt","(410) 825-2346"]
[null,"Chelsea",null,"Hamilton",null,4,"Female","Jamie MacAuliffe","Stepmother"]
[null,"Alexander","X","Bassano","Alex",3.5,"Male",null,"Babysitter"]
[null,"Gabriella","H","Andriamiradano",null,5,"Female",null,null,"(410) 727-7751","Pollen"]
[null,"Antonio",null,"Chenoweth","Antonio",3,"Male","Helene Matz","Mother"]
[null,"Lance","L","Hamden","Lenny",4.5,"Male",null,null,null,"Pollen"]
[null,"Simon","M","Baer",null,5,"Male","Robert Baer","Father","(410) 276-6001"]
[null,"Lucille",null,"Greenwood","Lucy",5,"Female",null,"Mother"]

{"sheet":"Grier example","index":4,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"GRIER SUMMER CAMP"]
[]
[null,"Regist Date","First Name","MI","Last Name","DOB","Gender","T-Shirt Size",null,null,null,"adjust colums 1 at a time"]
[null,"2008-04-03","Annie","G","Adamson","1998-03-22","Female","Large"]
[null,"2008-04-10","Brigitte","","Andersen","1994-01-10","Female","Large",null,null,null,"column width by picking columns B to H"]
[null,"2008-04-08","Suzie","F","Arlins","1996-05-19","Female","Small"]
[null,"2008-04-03","Marie-Julie","","Ayers","1997-01-28","Female","Small",null,null,null,"use control-shift-down to select down to bottom of data"]
[null,"2008-04-10","Danielle","H","Banneker","1993-08-10","Female","X-Large"]
[null,"2008-04-02","Christine","T","Banneker","1998-07-10","Female","Small",null,null,null,"column width"]
[null,"2008-04-07","Willy","D","Banneker","1992-01-20","Male","Large",{"$nulls":4},"auto column width"]
[null,"2008-04-10","Gerard","V","Beirs","1992-04-30","Male","Large"]
[null,"2008-04-17","Helene","R","Blount","1998-05-03","Female","Small",null,null,null,"center"]
[null,"2008-04-18","Brigitte","N","Blue","1993-01-04","Female","Large"]
[null,"2008-04-17","Leonard","","Brzynski","1997-10-29","Male","Medium",null,null,null,"align and indent"]
[null,"2008-04-15","Christopher","F","Burda","1993-06-25","Male","Large"]
[null,"2008-04-17","Christian","A","Cabril","1992-12-05","Male","X-Large",null,null,null,"select & sort"]
[null,"2008-04-09","Sally","X","Chang","1994-11-09","Female","Medium"]
[null,"2008-04-15","Gerardine","L","Clayton","1995-07-10","Female","Small"]
[null,"2008-04-02","Mylene","","Coldwell","1995-04-14","Female","Large"]
[null,"2008-04-17","John","G","Compton","1993-05-10","Male","Large"]
[null,"2008-04-03","Theophile","P","Corton","1996-07-14","Male","X-Large"]
[null,"2008-04-13","Jocelyne","","Cropp","1998-12-08","Female","Small"]
[null,"2008-04-07","Roger","","Eddington","1998-06-11","Male","Small"]
[null,"2008-04-02","Julienne","C","Eddison","1996-02-24","Female","X-Large"]
[null,"2008-04-03","Franky","","Estamos","1995-02-01","Male","Large"]
[null,"2008-04-02","Joshua","D","Farmer","1998-11-22","Male","Small"]
[null,"2008-04-06","Patrick","A","Farms","1996-12-15","Male","Small"]
[null,"2008-04-03","Jeremiah","L","Farms","1996-10-04","Male","Large"]
[null,"2008-04-08","Mauricette","R","Forget","1995-02-23","Female","Medium"]
[null,"2008-04-09","David","G","Ginsberg","1992-10-27","Male","Large"]
[null,"2008-04-17","Brandon","V","Glenwood","1994-02-03","Male","X-Large"]
[null,"2008-04-17","Paule","O","Greenwood","1994-05-28","Female","Large"]
[null,"2008-04-06","Charles","E","Gridley","1997-10-05","Male","Large"]
[null,"2008-04-15","Jacquie","S","Guerard","1992-01-18","Female","Large"]
[null,"2008-04-06","Suzanne","A","Hammerskil","1998-04-24","Female","X-Large"]
[null,"2008-04-08","Alicia","L","Kelley","1993-07-12","Female","Large"]
[null,"2008-04-09","Bertine","Y","Kwang","1998-01-05","Female","Small"]
[null,"2008-04-08","Patrick","P","Natolli","1992-08-29","Male","X-Large"]
[null,"2008-04-10","Michael","L","Neat","1995-10-21","Male","Medium"]
[null,"2008-04-08","Josephine","","Neirs","1994-04-04","Female","X-Large"]
[null,"2008-04-14","Christopher","","Newmann","1994-04-11","Male","Large"]
[null,"2008-04-06","Cynthia","M","Nightingale","1996-10-02","Female","Large"]
[null,"2008-04-10","Thommy","C","Packard","1996-02-28","Male","Small"]
[null,"2008-04-17","Cecile","I","Plant","1997-03-27","Female","Small"]
[null,"2008-04-03","Margueritte","L","Rebel","1995-05-24","Female","X-Large"]
[null,"2008-04-10","Albertine","G","Rivers","1997-03-18","Female","Small"]
[null,"2008-04-08","Franck","","Seats","1993-10-27","Male","Large"]
[null,"2008-04-10","Phillipe","O","Shear","1992-04-15","Male","X-Large"]
[null,"2008-04-07","Dimitry","T","Washington","1994-03-14","Male","Medium"]
[null,"2008-04-17","Jeanne","Y","Whites","8/30/1886","Female","Small"]
[null,"2008-04-18","Adrien","W","Whites","1998-10-23","Male","Small"]
[null,"2008-04-13","Jeannie","B","Williams","1993-08-31","Female","Medium"]
[null,"2008-04-10","Robert","","Wilson","1995-12-02","Male","Large"]
[null,"2008-04-10","Tracie","P","Yang","1996-05-19","Male","Medium"]
[null,"2008-04-09","Jules","R","Young","1997-03-22","Male","Medium"]
[null,"2008-04-17","Justine","D","Yun","1995-04-26","Female","Medium"]
[null,"2008-04-10","Aline","E","Yung","1998-11-02","Female","Small"]

{"sheet":"DAWN example","index":5,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,1,4,4],[4,6,4,9]],"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":12},"example of colors -- original had no grid lines"]
[null,null,null,"Drug Mentions In The DAWN System For 1992",{"$nulls":9},"show how to turn gridlines off on VIEW tab"]
[null,"Emergency Room Episodes",{"$nulls":4},"Drug-Related Deaths",{"$nulls":6},"or change their color in Excel Options"]
[{"$nulls":4},"Percentage",{"$nulls":4},"Percentage"]
[null,null,null,"Number of","of total",null,null,null,"Number of","of total",null,null,"fix column width formating"]
[null,"Rank","Drug Name","mentions","episodes",null,"Rank","Drug Name","mentions","episodes"]
[null,"1.","Alcohol-in-combination",141773,3270,null,"1.","Cocaine",3465,4600]
[null,"2.","Cocaine",119843,2765,null,"2.","Alcohol-in-combination",2944,3909]
[null,"3.","Heroine/Morphine",48003,1107,null,"3.","Heroine/Morphine",2912,3866]
[null,"4.","Acetaminophen",31355,723,null,"4.","Codeine",880,1168]
[null,"5.","Marijuana/Hashish",23997,554,null,"5.","Diazepam (Valium)",640,850]
[null,"6.","Aspirin",18843,434,null,"6.","Methadone",431,572]
[null,"7.","Alprazolam (Xanox)",16498,381,null,"7.","Amytriptyline",414,550]
[null,"8.","Ibuprofen",16400,378,null,"8.","D-propoxylene",398,528]
[null,"9.","Diazepam (Valium)",13947,322,null,"9.","Marijuana/Hashish",359,477]
[null,"10.","Amytriptyline",10132,234,null,"10.","Amytriptyline",335,445]

{"sheet":"File ext.","index":6,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Format ","Extension Description ","Format Extension Description "]
[null,"Excel Workbook \n(before 2007)",".xls"," Microsoft Excel used a proprietary binary file format called Binary Interchange File Format (BIFF) as its primary format -- it's not ZIPPED (like .xlsx) hence it takes more room  -- it also supports macros"]
[null,"Excel Workbook \n(after 2006)"," .xlsx ","The default Excel 2007 workbook format. In reality a ZIP compressed archive with a directory structure of XML text documents. Functions as the primary replacement for the former binary .xls format, although it does not support Excel macros for security reasons. "]
[null,"Excel Macro-enabled Workbook \n(after 2006)"," .xlsm "," As Excel Workbook, but with macro support. "]
[null,"Excel Binary Workbook (after 2006)",".xlsb","As Excel Macro-enabled Workbook, but storing information in binary form rather than XML documents for opening and saving documents more quickly and efficiently. Intended especially for very large documents with tens of thousands of rows, and/or several hundreds of columns. "]
[null,"Excel Macro-enabled Template \n(after 2006)"," .xltm ","A template document that forms a basis for actual workbooks, with macro support. The replacement for the old .xlt format. "]
[null,"Excel Add-in \n(after 2006)"," .xlam "," Excel add-in to add extra functionality and tools. Inherent macro support because of the file purpose. "]