{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Topics","DA","D","S(1)","S(2)","S(3)","F(1)","Paste","F(2)","F(3)","F(4)","F(5)","PT(1)","PT(2)","PT(3)","PT(4)","PT(5)","Chart1","C(1)","For(1)","For(2)","For(3)","GD(1)","GD(2)"],"not_rendered":{"charts":3,"images":5,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":7},"unopened":[{"sheet":"Chart1","index":17,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Topics","index":0,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Highline Community College Professional Development Day 10/19/2012"]
["Excel Data Analysis Basics: Sort, Filter, Pivot Tables, Charts and Formulas"]
["Learn how to setup your data so you can quickly do data analysis."]
["Learn the basics of data analysis with Excel. Learn the tricks for sorting a"]
["data set by color, filtering a data set to find just the records that you"]
["want, and even how to make a PivotTable Report! If you have ever tried"]
["to use Excel and have not had success, this seminar will help greatly!"]
["Michael Girvin will not only show you great tricks in Excel, but he will"]
["make it easy and fun to learn. This seminar will have something for"]
["everyone from the basic beginner to the advanced Excel user."]
[]
["Topics:","Link","Sheet Name"]
["What is Data Analysis?",{"$f":"IF(C13=\"\",\"\",HYPERLINK(\"#'\"&C13&\"'!A1\",A13))","v":"What is Data Analysis?"},"DA"]
["How Data Must Be Setup",{"$f":"IF(C14=\"\",\"\",HYPERLINK(\"#'\"&C14&\"'!A1\",A14))","v":"How Data Must Be Setup"},"D"]
["Sort:",""]
["Sort with 1 criteria","Sort with 1 criteria","S(1)"]
["Sort with 2 criteria or more","Sort with 2 criteria or more","S(2)"]
["Sort by color","Sort by color","S(3)"]
["Filter:",""]
["Filter with 1 criteria","Filter with 1 criteria","F(1)"]
["Filter with 2 criteria or more","Filter with 2 criteria or more","F(2)"]
["Filter by color","Filter by color","F(3)"]
["Filter Text, Numbers, Dates","Filter Text, Numbers, Dates","F(4)"]
["Filter by Partial Text","Filter by Partial Text","F(5)"]
["Pivot Tables:",""]
["What is a PivotTable?","What is a PivotTable?","PT(1)"]
["Easy 3 step method","Easy 3 step method","PT(2)"]
["Cross Tabulation",""]
["Change the calculation",""]
["More than one calculation","More than one calculation","PT(3)"]
["Grouping Numbers","Grouping Numbers","PT(4)"]
["Filter in a Pivot Table","Filter in a Pivot Table","PT(5)"]
["Slicers",""]
["Charts:",{"$f":"IF(C34=\"\",\"\",HYPERLINK(\"#'\"&C34&\"'!A1\",A34))","v":""}]
["Column Charts from Pivot Tables",{"$f":"IF(C35=\"\",\"\",HYPERLINK(\"#'\"&C35&\"'!A1\",A35))","v":"Column Charts from Pivot Tables"},"C(1)"]
["Formulas:",""]
["SUMIFS","SUMIFS","For(1)"]
["COUNTIF","COUNTIF","For(2)"]
["Formula to Compare Two Lists","Formula to Compare Two Lists","For(3)"]
["Data Analysis Formula or PivotTables?","Data Analysis Formula or PivotTables?","ForPT(1)"]
["Getting Data Into Excel",""]
["Import from CSV file","Import from CSV file","GD(1)"]
["Import from Access","Import from Access","GD(2)"]

{"sheet":"DA","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: What is Data Analysis?"}]
[]
["What is Data Analysis?"]
["* Taking raw data and creating useful information."]
[]
["A simple Sort creates useful information:"]
[]
["Shift","Employee","Assembly Time",null,"Shift","Employee","Assembly Time"]
["2012-10-17","Jo",15.5,null,"2012-10-15","Jo",13.2]
["2012-10-17","Sioux",19.600000000000001,null,"2012-10-15","Phil",15.2]
["2012-10-17","Phil",22,null,"2012-10-16","Jo",15.3]
["2012-10-17","Sue",18.600000000000001,null,"2012-10-17","Jo",15.5]
["2012-10-16","Jo",15.3,null,"2012-10-17","Sue",18.600000000000001]
["2012-10-15","Jo",13.2,null,"2012-10-17","Sioux",19.600000000000001]
["2012-10-15","Sioux",21,null,"2012-10-15","Sioux",21]
["2012-10-15","Phil",15.2,null,"2012-10-17","Phil",22]
[]
["A formula can create useful information:"]
[]
["List 1:",null,null,"List 2:"]
[]
["Division Names",null,null,"Division Names","Is Name in List 2 in List 1?"]
["Babs",null,null,"Babs",{"$f":"ISNUMBER(MATCH(D24,$A$24:$A$29,0))","v":true}]
["Jeff W.",null,null,"Jeff T.",{"$f":"ISNUMBER(MATCH(D25,$A$24:$A$29,0))","v":false}]
["Anthony N.",null,null,"Anthony N.",true]
["Joy S.",null,null,"Joy S.",true]
["Ron S.",null,null,"Ron S.",true]
["Sioux",null,null,"Jessica N.",false]
[]
["A PivotTable can create useful information:"]
[]
["Student Name","Major","Class","Grade"]
["Erinn Kraeger","Accounting","Math 101",3.8]
["Devorah Passe","Nursing","English 101",2.7]
["Tommie Colborn","Accounting","Math 101",2.5,null,"Average of Grade","Class"]
["Shirleen Surrey","Nursing","English 101",3,null,"Major","English 101","Math 101"]
["Devorah Flight","Accounting","Math 101",3.9,null,"Accounting",3.2,3.4]
["Domingo Schoppe","Accounting","English 101",4,null,"Nursing",2.4499999999999997,3.4]
["Annett Stefanelli","Nursing","Math 101",3.4]
["Emilio Lindbeck","Nursing","English 101",2.5]
["Waltraud Kolasinski","Accounting","English 101",2.4]
["Waltraud Leaper","Nursing","English 101",1.6]

{"sheet":"D","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: How Data Must Be Setup"}]
[]
[null,null,null,null,null,null,"To use Data Analysis Features in Excel, Data must be set up:"]
[null,"Student Name","Major","Class","Grade",null,1,"First row has Field Names (Column Headers) in first row"]
[null,"Erinn Kraeger","Accounting","Math 101",3.8,null,2,"Records are in rows"]
[null,"Devorah Passe","Nursing","English 101",2.7,null,3,"No blanks in column headers"]
[null,"Tommie Colborn","Accounting","Math 101",2.5,null,4,"No blanks columns or rows in data set"]
[null,"Shirleen Surrey","Nursing","English 101",3,null,5,"Try not to have blank cells"]
[null,"Devorah Flight","Accounting","Math 101",3.9,null,6,"No data next to data set"]
[null,"Domingo Schoppe","Accounting","English 101",4,null,null,"(blanks or row/column headers all the way around data set)"]
[null,"Annett Stefanelli","Nursing","Math 101",3.4]
[null,"Emilio Lindbeck","Nursing","English 101",2.5]
[null,"Waltraud Kolasinski","Accounting","English 101",2.4]
[null,"Waltraud Leaper","Nursing","English 101",1.6]

{"sheet":"S(1)","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Sort with 1 criteria"},null,null,"Click in single cell in column you want to sort: 1) Right-click, 2) Home Tab, 3) Data Tab"]
[]
["Shift","Employee","Assembly Time"]
["2012-10-15","Jo",13.2]
["2012-10-15","Phil",15.2]
["2012-10-16","Jo",15.3]
["2012-10-17","Jo",15.5]
["2012-10-17","Sue",18.600000000000001]
["2012-10-17","Sioux",19.600000000000001]
["2012-10-15","Sioux",21]
["2012-10-17","Phil",22]

{"sheet":"S(2)","index":4,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Sort with 2 criteria or more"}]
[null,null,null,"When sorting more than one column:"]
[null,null,null,"1) Cell method: leave the Major Sort for last"]
[null,null,null,"2) Use Sort Dialog Box"]
[null,null,null,"Goal: Sort Grade within Major"]
[]
["Student Name","Major","Class","Grade"]
["Domingo Schoppe","Accounting","English 101",4]
["Devorah Flight","Accounting","Math 101",3.9]
["Erinn Kraeger","Accounting","Math 101",3.8]
["Tommie Colborn","Accounting","Math 101",2.5]
["Waltraud Kolasinski","Accounting","English 101",2.4]
["Annett Stefanelli","Nursing","Math 101",3.4]
["Shirleen Surrey","Nursing","English 101",3]
["Devorah Passe","Nursing","English 101",2.7]
["Emilio Lindbeck","Nursing","English 101",2.5]
["Waltraud Leaper","Nursing","English 101",1.6]

{"sheet":"S(3)","index":5,"n_rows":204,"n_cols":10,"rows_kept":204,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Sort by color"}]
[]
[null,"Date","Age","Coupon","Payment Method","Product","Region","Price","Units","Sales"]
[null,"2010-05-30",22,"Coupon","Visa","Yanaki","West",19.95,4,79.8]
[null,"2010-06-09",63,"Coupon","PayPal","Yanaki","Mid West",19.95,5,99.75]
[null,"2010-04-14",59,"No Coupon","PayPal","Aspen","Mid West",21.95,3,65.849999999999994]
[null,"2010-12-07",27,"No Coupon","Visa","Carlota","Mid West",22.95,5,114.75]
[null,"2010-12-23",54,"No Coupon","Visa","Aspen","Mid West",21.95,5,109.75]
[null,"2010-01-22",49,"Coupon","Visa","Carlota","West",22.95,7,160.65]
[null,"2010-01-15",25,"No Coupon","Visa","Bellen","West",24.95,1,24.95]
[null,"2010-07-03",25,"No Coupon","Visa","Sunset","Mid West",24.95,2,49.9]
[null,"2010-01-05",49,"No Coupon","PayPal","Yanaki","Mid West",19.95,1,19.95]
[null,"2010-05-09",27,"No Coupon","American Express","Yanaki","West",19.95,6,119.69999999999999]
[null,"2010-03-18",50,"Coupon","Mastercard","Yanaki","Mid West",19.95,6,119.69999999999999]
[null,"2010-05-07",55,"No Coupon","Visa","Yanaki","West",19.95,1,19.95]
[null,"2010-04-30",36,"Coupon","Mastercard","Bellen","East",24.95,1,24.95]
[null,"2010-05-22",21,"Coupon","Mastercard","Carlota","West",22.95,2,45.9]
[null,"2010-06-29",57,"Coupon","Mastercard","Yanaki","West",19.95,1,19.95]
[null,"2010-11-05",25,"No Coupon","Mastercard","Aspen","East",21.95,1,21.95]
[null,"2010-08-31",38,"No Coupon","American Express","Yanaki","West",19.95,1,19.95]
[null,"2010-10-05",29,"Coupon","PayPal","Yanaki","South",19.95,4,79.8]
[null,"2010-03-22",18,"Coupon","Visa","Yanaki","West",19.95,3,59.849999999999994]
[null,"2010-06-14",64,"No Coupon","Discover","Yanaki","West",19.95,7,139.65]
[null,"2010-08-28",22,"No Coupon","Visa","Aspen","West",21.95,2,43.9]
[null,"2010-11-30",39,"Coupon","PayPal","Aspen","Mid West",21.95,2,43.9]
[null,"2010-09-13",61,"No Coupon","Mastercard","Yanaki","Mid West",19.95,5,99.75]
[null,"2010-10-23",18,"No Coupon","Visa","Carlota","Mid West",22.95,5,114.75]
[null,"2010-09-19",22,"No Coupon","PayPal","Carlota","West",22.95,4,91.8]
[null,"2010-09-20",52,"No Coupon","American Express","Carlota","Mid West",22.95,5,114.75]
[null,"2010-01-18",22,"Coupon","Visa","Carlota","West",22.95,1,22.95]
[null,"2010-07-28",18,"No Coupon","Discover","Sunset","West",24.95,5,124.75]
[null,"2010-06-06",55,"No Coupon","PayPal","Yanaki","South",19.95,1,19.95]
[null,"2010-01-30",20,"No Coupon","PayPal","Aspen","East",21.95,4,87.8]
[null,"2010-10-09",42,"Coupon","PayPal","Carlota","Mid West",22.95,1,22.95]
[null,"2010-07-04",30,"No Coupon","PayPal","Delicate Arch","South",29.95,10,299.5]
[null,"2010-11-08",64,"Coupon","Visa","Yanaki","Mid West",19.95,1,19.95]
[null,"2010-03-17",41,"Coupon","Mastercard","Yanaki","South",19.95,2,39.9]
[null,"2010-04-07",21,"No Coupon","Visa","Aspen","East",21.95,3,65.849999999999994]
[null,"2010-01-05",63,"No Coupon","PayPal","Sunset","East",24.95,1,24.95]
[null,"2010-07-22",54,"No Coupon","American Express","Aspen","West",21.95,1,21.95]
[null,"2010-11-12",18,"No Coupon","American Express","Yanaki","West",19.95,1,19.95]
[null,"2010-05-11",26,"No Coupon","Discover","Carlota","West",22.95,4,91.8]
[null,"2010-08-11",30,"No Coupon","Discover","Yanaki","West",19.95,2,39.9]
[null,"2010-11-14",64,"No Coupon","Visa","Aspen","West",21.95,2,43.9]
[null,"2010-01-21",30,"No Coupon","PayPal","Aspen","West",21.95,3,65.849999999999994]
[null,"2010-04-12",41,"Coupon","American Express","Aspen","West",21.95,2,43.9]
[null,"2010-06-04",23,"Coupon","Mastercard","Yanaki","South",19.95,5,99.75]
[null,"2010-10-19",52,"Coupon","Visa","Delicate Arch","West",29.95,1,29.95]
[null,"2010-09-07",18,"No Coupon","PayPal","Aspen","West",21.95,3,65.849999999999994]
[null,"2010-09-19",32,"No Coupon","PayPal","Carlota","West",22.95,1,22.95]
[null,"2010-01-17",22,"Coupon","American Express","Yanaki","Mid West",19.95,1,19.95]
[null,"2010-03-15",29,"Coupon","PayPal","Yanaki","South",19.95,5,99.75]
[null,"2010-12-16",25,"No Coupon","Mastercard","Bellen","Mid West",24.95,5,124.75]
[null,"2010-07-08",63,"No Coupon","PayPal","Aspen","West",21.95,1,21.95]
[null,"2010-05-13",26,"No Coupon","Mastercard","Sunset","Mid West",24.95,7,174.65]
[null,"2010-03-03",31,"Coupon","Discover","Delicate Arch","West",29.95,1,29.95]
[null,"2010-04-30",23,"No Coupon","PayPal","Delicate Arch","Mid West",29.95,5,149.75]
[null,"2010-07-11",42,"Coupon","PayPal","Delicate Arch","Mid West",29.95,1,29.95]
[null,"2010-03-22",28,"Coupon","Visa","Carlota","East",22.95,2,45.9]
[null,"2010-08-27",23,"No Coupon","Visa","Carlota","West",22.95,7,160.65]
[null,"2010-11-16",19,"No Coupon","Mastercard","Carlota","Mid West",22.95,7,160.65]
[null,"2010-01-26",37,"Coupon","Visa","Yanaki","West",19.95,6,119.69999999999999]
[null,"2010-05-06",38,"No Coupon","Mastercard","Aspen","East",21.95,2,43.9]
[null,"2010-04-16",26,"No Coupon","Discover","Aspen","West",21.95,3,65.849999999999994]
[null,"2010-01-05",33,"No Coupon","PayPal","Carlota","South",22.95,1,22.95]
[null,"2010-11-09",59,"No Coupon","PayPal","Aspen","Mid West",21.95,3,65.849999999999994]
[null,"2010-07-29",32,"No Coupon","Visa","Aspen","Mid West",21.95,5,109.75]
[null,"2010-11-22",54,"Coupon","American Express","Bellen","West",24.95,10,249.5]
[null,"2010-01-10",63,"No Coupon","PayPal","Aspen","West",21.95,5,109.75]
[null,"2010-06-01",48,"No Coupon","Visa","Carlota","East",22.95,5,114.75]
[null,"2010-05-02",29,"No Coupon","American Express","Carlota","East",22.95,5,114.75]
[null,"2010-06-13",38,"Coupon","Visa","Delicate Arch","West",29.95,4,119.8]
[null,"2010-02-16",24,"Coupon","Mastercard","Delicate Arch","East",29.95,1,29.95]
[null,"2010-08-02",51,"No Coupon","Visa","Carlota","West",22.95,5,114.75]
[null,"2010-11-01",25,"Coupon","Mastercard","Delicate Arch","West",29.95,7,209.65]
[null,"2010-11-08",65,"No Coupon","Visa","Carlota","West",22.95,5,114.75]
[null,"2010-08-17",35,"No Coupon","PayPal","Yanaki","Mid West",19.95,3,59.849999999999994]
[null,"2010-09-27",35,"No Coupon","Mastercard","Sunset","East",24.95,5,124.75]
[null,"2010-01-09",21,"No Coupon","Visa","Yanaki","Mid West",19.95,2,39.9]
[null,"2010-10-10",47,"No Coupon","Mastercard","Sunset","West",24.95,5,124.75]
[null,"2010-12-31",62,"No Coupon","Discover","Sunset","East",24.95,1,24.95]
[null,"2010-12-06",63,"No Coupon","PayPal","Carlota","East",22.95,1,22.95]
[null,"2010-03-18",23,"No Coupon","American Express","Bellen","Mid West",24.95,10,249.5]
[null,"2010-03-22",59,"No Coupon","Visa","Yanaki","South",19.95,3,59.849999999999994]
[null,"2010-09-14",48,"Coupon","Visa","Aspen","West",21.95,2,43.9]
[null,"2010-02-09",57,"No Coupon","Mastercard","Yanaki","South",19.95,1,19.95]
[null,"2010-03-24",19,"No Coupon","Discover","Delicate Arch","Mid West",29.95,1,29.95]
[null,"2010-07-28",48,"Coupon","Mastercard","Yanaki","Mid West",19.95,1,19.95]
[null,"2010-08-26",21,"Coupon","Mastercard","Aspen","South",21.95,3,65.849999999999994]
[null,"2010-03-05",40,"No Coupon","American Express","Carlota","West",22.95,1,22.95]
[null,"2010-08-18",25,"No Coupon","Visa","Yanaki","Mid West",19.95,4,79.8]
[null,"2010-11-02",59,"Coupon","Mastercard","Yanaki","South",19.95,4,79.8]
[null,"2010-12-19",57,"No Coupon","Visa","Carlota","West",22.95,5,114.75]
[null,"2010-07-05",56,"Coupon","Discover","Carlota","West",22.95,1,22.95]
[null,"2010-04-16",19,"No Coupon","Visa","Yanaki","West",19.95,1,19.95]
[null,"2010-05-29",65,"No Coupon","PayPal","Delicate Arch","Mid West",29.95,2,59.9]
[null,"2010-05-01",25,"Coupon","PayPal","Aspen","West",21.95,2,43.9]
[null,"2010-07-03",30,"No Coupon","American Express","Yanaki","West",19.95,2,39.9]
[null,"2010-08-12",57,"No Coupon","Mastercard","Delicate Arch","West",29.95,7,209.65]
[null,"2010-06-21",43,"Coupon","PayPal","Yanaki","West",19.95,1,19.95]
[null,"2010-12-15",44,"No Coupon","Mastercard","Yanaki","South",19.95,4,79.8]
[null,"2010-05-25",21,"No Coupon","PayPal","Bellen","East",24.95,5,124.75]
[null,"2010-03-23",20,"No Coupon","PayPal","Bellen","West",24.95,1,24.95]
[null,"2010-09-26",37,"No Coupon","Mastercard","Aspen","South",21.95,3,65.849999999999994]
[null,"2010-12-27",26,"No Coupon","PayPal","Carlota","West",22.95,6,137.69999999999999]
[null,"2010-07-24",62,"No Coupon","Mastercard","Delicate Arch","East",29.95,1,29.95]
[null,"2010-04-27",38,"No Coupon","PayPal","Yanaki","West",19.95,6,119.69999999999999]
[null,"2010-03-03",24,"Coupon","American Express","Yanaki","East",19.95,2,39.9]
[null,"2010-03-23",30,"No Coupon","PayPal","Carlota","Mid West",22.95,5,114.75]
[null,"2010-12-05",39,"Coupon","Visa","Aspen","Mid West",21.95,1,21.95]
[null,"2010-11-11",59,"Coupon","PayPal","Delicate Arch","South",29.95,6,179.7]
[null,"2010-04-13",26,"No Coupon","Discover","Yanaki","East",19.95,2,39.9]
[null,"2010-12-13",33,"No Coupon","Visa","Sunset","Mid West",24.95,1,24.95]
[null,"2010-10-05",20,"No Coupon","Visa","Bellen","West",24.95,4,99.8]
[null,"2010-01-02",18,"No Coupon","Visa","Aspen","West",21.95,4,87.8]
[null,"2010-11-04",19,"Coupon","PayPal","Yanaki","East",19.95,2,39.9]
[null,"2010-04-29",61,"No Coupon","PayPal","Aspen","West",21.95,3,65.849999999999994]
[null,"2010-10-02",39,"Coupon","PayPal","Yanaki","East",19.95,10,199.5]
[null,"2010-12-26",52,"Coupon","Discover","Aspen","West",21.95,1,21.95]
[null,"2010-11-05",20,"No Coupon","Visa","Sunset","West",24.95,5,124.75]
[null,"2010-11-15",50,"No Coupon","Visa","Delicate Arch","West",29.95,1,29.95]
[null,"2010-06-27",29,"Coupon","PayPal","Aspen","South",21.95,1,21.95]
[null,"2010-04-21",55,"No Coupon","Visa","Delicate Arch","West",29.95,4,119.8]
[null,"2010-09-25",18,"No Coupon","American Express","Delicate Arch","West",29.95,3,89.85]
[null,"2010-01-24",39,"Coupon","Mastercard","Aspen","Mid West",21.95,3,65.849999999999994]
[null,"2010-01-04",35,"No Coupon","Visa","Carlota","South",22.95,4,91.8]
[null,"2010-05-06",38,"Coupon","American Express","Bellen","South",24.95,6,149.69999999999999]
[null,"2010-06-22",20,"No Coupon","Visa","Yanaki","East",19.95,3,59.849999999999994]
[null,"2010-07-12",60,"No Coupon","Discover","Aspen","Mid West",21.95,6,131.69999999999999]
[null,"2010-05-03",61,"No Coupon","Visa","Sunset","Mid West",24.95,2,49.9]
[null,"2010-03-09",62,"Coupon","PayPal","Aspen","West",21.95,2,43.9]
[null,"2010-03-02",21,"No Coupon","Visa","Yanaki","Mid West",19.95,1,19.95]
[null,"2010-03-28",40,"No Coupon","Discover","Aspen","South",21.95,1,21.95]
[null,"2010-11-18",50,"No Coupon","Mastercard","Yanaki","West",19.95,2,39.9]
[null,"2010-03-27",24,"No Coupon","Visa","Bellen","West",24.95,1,24.95]
[null,"2010-08-11",28,"Coupon","PayPal","Carlota","West",22.95,5,114.75]
[null,"2010-12-24",22,"No Coupon","Visa","Yanaki","Mid West",19.95,6,119.69999999999999]
[null,"2010-11-27",22,"No Coupon","PayPal","Aspen","West",21.95,2,43.9]
[null,"2010-03-12",27,"No Coupon","Visa","Bellen","West",24.95,1,24.95]
[null,"2010-09-16",54,"Coupon","Visa","Sunset","West",24.95,7,174.65]
[null,"2010-02-01",25,"No Coupon","Mastercard","Bellen","West",24.95,1,24.95]
[null,"2010-08-30",30,"No Coupon","PayPal","Yanaki","East",19.95,1,19.95]
[null,"2010-09-18",59,"Coupon","Mastercard","Yanaki","South",19.95,2,39.9]
[null,"2010-11-24",51,"No Coupon","Visa","Carlota","West",22.95,2,45.9]
[null,"2010-12-22",38,"No Coupon","Visa","Delicate Arch","West",29.95,6,179.7]
[null,"2010-04-23",28,"No Coupon","PayPal","Carlota","South",22.95,7,160.65]
[null,"2010-11-18",30,"Coupon","Discover","Aspen","West",21.95,1,21.95]
[null,"2010-10-28",43,"No Coupon","Visa","Bellen","South",24.95,5,124.75]
[null,"2010-08-14",42,"No Coupon","PayPal","Delicate Arch","West",29.95,3,89.85]
[null,"2010-05-05",24,"No Coupon","Visa","Bellen","Mid West",24.95,2,49.9]
[null,"2010-08-25",47,"Coupon","Visa","Carlota","Mid West",22.95,1,22.95]
[null,"2010-10-25",23,"No Coupon","PayPal","Yanaki","Mid West",19.95,1,19.95]
[null,"2010-07-31",59,"No Coupon","PayPal","Yanaki","East",19.95,5,99.75]
[null,"2010-07-25",22,"Coupon","Mastercard","Carlota","West",22.95,4,91.8]
[null,"2010-09-30",27,"Coupon","Visa","Bellen","Mid West",24.95,2,49.9]
[null,"2010-10-03",65,"No Coupon","Discover","Aspen","East",21.95,1,21.95]
[null,"2010-04-01",27,"No Coupon","Mastercard","Carlota","Mid West",22.95,2,45.9]
[null,"2010-12-15",27,"No Coupon","American Express","Carlota","East",22.95,1,22.95]
[null,"2010-01-07",28,"No Coupon","PayPal","Carlota","West",22.95,2,45.9]
[null,"2010-07-23",22,"Coupon","PayPal","Bellen","West",24.95,1,24.95]
[null,"2010-03-16",42,"No Coupon","PayPal","Yanaki","East",19.95,2,39.9]
[null,"2010-12-04",25,"No Coupon","American Express","Delicate Arch","East",29.95,6,179.7]
[null,"2010-01-08",41,"Coupon","Mastercard","Aspen","West",21.95,1,21.95]
[null,"2010-06-02",46,"Coupon","PayPal","Bellen","West",24.95,1,24.95]
[null,"2010-08-18",41,"No Coupon","Discover","Sunset","West",24.95,3,74.849999999999994]
[null,"2010-04-24",29,"No Coupon","Mastercard","Yanaki","West",19.95,4,79.8]
[null,"2010-12-01",50,"No Coupon","Visa","Yanaki","Mid West",19.95,1,19.95]
[null,"2010-12-31",50,"Coupon","Visa","Carlota","Mid West",22.95,1,22.95]
[null,"2010-04-30",34,"Coupon","PayPal","Carlota","Mid West",22.95,2,45.9]
[null,"2010-03-16",24,"Coupon","American Express","Aspen","West",21.95,3,65.849999999999994]
[null,"2010-01-28",29,"No Coupon","Mastercard","Yanaki","West",19.95,7,139.65]
[null,"2010-08-03",35,"No Coupon","Mastercard","Carlota","Mid West",22.95,1,22.95]
[null,"2010-11-11",24,"No Coupon","Visa","Yanaki","West",19.95,2,39.9]
[null,"2010-12-13",23,"Coupon","Visa","Aspen","South",21.95,5,109.75]
[null,"2010-03-27",31,"No Coupon","PayPal","Carlota","Mid West",22.95,7,160.65]
[null,"2010-10-08",24,"Coupon","PayPal","Bellen","Mid West",24.95,2,49.9]
[null,"2010-08-03",30,"No Coupon","Visa","Carlota","Mid West",22.95,1,22.95]
[null,"2010-03-10",22,"Coupon","Visa","Carlota","West",22.95,2,45.9]
[null,"2010-03-02",43,"No Coupon","Visa","Carlota","East",22.95,3,68.849999999999994]
[null,"2010-01-26",55,"No Coupon","Visa","Carlota","West",22.95,10,229.5]
[null,"2010-05-06",38,"No Coupon","American Express","Delicate Arch","West",29.95,1,29.95]
[null,"2010-03-10",28,"Coupon","Visa","Yanaki","West",19.95,2,39.9]
[null,"2010-11-18",30,"Coupon","PayPal","Aspen","Mid West",21.95,2,43.9]
[null,"2010-01-30",35,"Coupon","Discover","Yanaki","West",19.95,1,19.95]
[null,"2010-07-02",41,"No Coupon","Visa","Delicate Arch","West",29.95,2,59.9]
[null,"2010-10-13",28,"Coupon","Discover","Yanaki","East",19.95,5,99.75]
[null,"2010-02-07",65,"No Coupon","Discover","Bellen","Mid West",24.95,7,174.65]
[null,"2010-06-05",20,"No Coupon","Mastercard","Aspen","West",21.95,3,65.849999999999994]
[null,"2010-11-02",39,"No Coupon","Visa","Sunset","Mid West",24.95,5,124.75]
[null,"2010-12-13",19,"No Coupon","Visa","Aspen","East",21.95,4,87.8]
[null,"2010-10-23",64,"No Coupon","Visa","Carlota","West",22.95,10,229.5]
[null,"2010-12-22",42,"Coupon","PayPal","Yanaki","South",19.95,5,99.75]
[null,"2010-08-21",24,"Coupon","PayPal","Yanaki","Mid West",19.95,1,19.95]
[null,"2010-08-28",24,"Coupon","PayPal","Yanaki","Mid West",19.95,1,19.95]
[null,"2010-06-20",18,"No Coupon","American Express","Bellen","Mid West",24.95,4,99.8]
[null,"2010-10-14",61,"No Coupon","Mastercard","Carlota","Mid West",22.95,5,114.75]
[null,"2010-08-04",22,"No Coupon","Visa","Yanaki","West",19.95,3,59.849999999999994]
[null,"2010-10-28",55,"Coupon","PayPal","Aspen","West",21.95,2,43.9]
[null,"2010-11-04",27,"No Coupon","American Express","Sunset","West",24.95,3,74.849999999999994]
[null,"2010-12-11",29,"Coupon","Visa","Carlota","West",22.95,1,22.95]
[null,"2010-07-18",33,"No Coupon","PayPal","Aspen","West",21.95,7,153.65]
[null,"2010-05-31",52,"No Coupon","Visa","Yanaki","West",19.95,2,39.9]
[null,"2010-12-16",26,"Coupon","PayPal","Aspen","West",21.95,6,131.69999999999999]

{"sheet":"F(1)","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Filter with 1 criteria"},null,null,"Click in a single cell and turn Filter on: 1) Right-click, 2) Home Tab, 3) Data Tab"]
[]
["Student Name","Major","Class","Grade"]
["Erinn Kraeger","Accounting","Math 101",3.8]
["Devorah Passe","Nursing","English 101",2.7]
["Tommie Colborn","Accounting","Math 101",2.5]
["Shirleen Surrey","Nursing","English 101",3]
["Devorah Flight","Accounting","Math 101",3.9]
["Domingo Schoppe","Accounting","English 101",4]
["Annett Stefanelli","Nursing","Math 101",3.4]
["Emilio Lindbeck","Nursing","English 101",2.5]
["Waltraud Kolasinski","Accounting","English 101",2.4]
["Waltraud Leaper","Nursing","English 101",1.6]

{"sheet":"Paste","index":7,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Student Name","Major","Class","Grade"]
["Erinn Kraeger","Accounting","Math 101",3.8]
["Tommie Colborn","Accounting","Math 101",2.5]
["Devorah Flight","Accounting","Math 101",3.9]
["Domingo Schoppe","Accounting","English 101",4]
["Waltraud Kolasinski","Accounting","English 101",2.4]
[]
[]
["Student Name","Major","Class","Grade"]
["Erinn Kraeger","Accounting","Math 101",3.8]
["Tommie Colborn","Accounting","Math 101",2.5]
["Devorah Flight","Accounting","Math 101",3.9]
[]
["Student Name","Major","Class","Grade"]
["Shirleen Surrey","Nursing","English 101",3]
["Emilio Lindbeck","Nursing","English 101",2.5]
[]
["Date","Age","Coupon","Payment Method","Product","Region","Price","Units","Sales"]
["2012-07-04",30,"No Coupon","PayPal","Delicate Arch","South",29.95,10,299.5]
["2012-11-22",54,"Coupon","American Express","Bellen","West",24.95,10,249.5]
["2012-11-01",25,"Coupon","Mastercard","Delicate Arch","West",29.95,7,209.65]
["2012-03-18",23,"No Coupon","American Express","Bellen","Mid West",24.95,10,249.5]
["2012-08-12",57,"No Coupon","Mastercard","Delicate Arch","West",29.95,7,209.65]
["2012-01-26",55,"No Coupon","Visa","Carlota","West",22.95,10,229.5]
["2012-10-23",64,"No Coupon","Visa","Carlota","West",22.95,10,229.5]
[]
[]
["Business","Contact","Phone"]
["Bay Air Compressor","Dave","313-443-4435"]
["Porter Cable Compressor","Sioux","267-703-6244"]
["Senco Compressor","Tommy","314-524-9500"]
["DeVILBISS Compressor","Chin","593-805-2524"]
["Compressor Repair Kit","Hal","866-348-1778"]

{"sheet":"F(2)","index":8,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Filter with 2 criteria or more"}]
[]
["Student Name","Major","Class","Grade"]
["Erinn Kraeger","Accounting","Math 101",3.8]
["Devorah Passe","Nursing","English 101",2.7]
["Tommie Colborn","Accounting","Math 101",2.5]
["Shirleen Surrey","Nursing","English 101",3]
["Devorah Flight","Accounting","Math 101",3.9]
["Domingo Schoppe","Accounting","English 101",4]
["Annett Stefanelli","Nursing","Math 101",3.4]
["Emilio Lindbeck","Nursing","English 101",2.5]
["Waltraud Kolasinski","Accounting","English 101",2.4]
["Waltraud Leaper","Nursing","English 101",1.6]

{"sheet":"F(3)","index":9,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Filter by color"}]
[]
["Student Name","Major","Class","Grade"]
["Erinn Kraeger","Accounting","Math 101",3.8]
["Devorah Passe","Nursing","English 101",2.7]
["Tommie Colborn","Accounting","Math 101",2.5]
["Shirleen Surrey","Nursing","English 101",3]
["Devorah Flight","Accounting","Math 101",3.9]
["Domingo Schoppe","Accounting","English 101",4]
["Annett Stefanelli","Nursing","Math 101",3.4]
["Emilio Lindbeck","Nursing","English 101",2.5]
["Waltraud Kolasinski","Accounting","English 101",2.4]
["Waltraud Leaper","Nursing","English 101",1.6]

{"sheet":"F(4)","index":10,"n_rows":204,"n_cols":9,"rows_kept":204,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Filter Text, Numbers, Dates"}]
[]
["Date","Age","Coupon","Payment Method","Product","Region","Price","Units","Sales"]
["2012-05-22",21,"Coupon","Mastercard","Carlota","West",22.95,2,45.9]
["2012-06-29",57,"Coupon","Mastercard","Yanaki","West",19.95,1,19.95]
["2012-11-05",25,"No Coupon","Mastercard","Aspen","East",21.95,1,21.95]
["2012-08-31",38,"No Coupon","American Express","Yanaki","West",19.95,1,19.95]
["2012-05-30",22,"Coupon","Visa","Yanaki","West",19.95,4,79.8]
["2012-10-05",29,"Coupon","PayPal","Yanaki","South",19.95,4,79.8]
["2012-03-22",18,"Coupon","Visa","Yanaki","West",19.95,3,59.849999999999994]
["2012-06-14",64,"No Coupon","Discover","Yanaki","West",19.95,7,139.65]
["2012-05-09",27,"No Coupon","American Express","Yanaki","West",19.95,6,119.69999999999999]
["2012-08-28",22,"No Coupon","Visa","Aspen","West",21.95,2,43.9]
["2012-11-30",39,"Coupon","PayPal","Aspen","Mid West",21.95,2,43.9]
["2012-09-13",61,"No Coupon","Mastercard","Yanaki","Mid West",19.95,5,99.75]
["2012-10-23",18,"No Coupon","Visa","Carlota","Mid West",22.95,5,114.75]
["2012-09-19",22,"No Coupon","PayPal","Carlota","West",22.95,4,91.8]
["2012-09-20",52,"No Coupon","American Express","Carlota","Mid West",22.95,5,114.75]
["2012-01-18",22,"Coupon","Visa","Carlota","West",22.95,1,22.95]
["2012-07-28",18,"No Coupon","Discover","Sunset","West",24.95,5,124.75]
["2012-06-06",55,"No Coupon","PayPal","Yanaki","South",19.95,1,19.95]
["2012-01-30",20,"No Coupon","PayPal","Aspen","East",21.95,4,87.8]
["2012-10-09",42,"Coupon","PayPal","Carlota","Mid West",22.95,1,22.95]
["2012-07-04",30,"No Coupon","PayPal","Delicate Arch","South",29.95,10,299.5]
["2012-11-08",64,"Coupon","Visa","Yanaki","Mid West",19.95,1,19.95]
["2012-06-09",63,"Coupon","PayPal","Yanaki","Mid West",19.95,5,99.75]
["2012-03-17",41,"Coupon","Mastercard","Yanaki","South",19.95,2,39.9]
["2012-04-07",21,"No Coupon","Visa","Aspen","East",21.95,3,65.849999999999994]
["2012-01-05",63,"No Coupon","PayPal","Sunset","East",24.95,1,24.95]
["2012-07-22",54,"No Coupon","American Express","Aspen","West",21.95,1,21.95]
["2012-11-12",18,"No Coupon","American Express","Yanaki","West",19.95,1,19.95]
["2012-05-11",26,"No Coupon","Discover","Carlota","West",22.95,4,91.8]
["2012-04-14",59,"No Coupon","PayPal","Aspen","Mid West",21.95,3,65.849999999999994]
["2012-08-11",30,"No Coupon","Discover","Yanaki","West",19.95,2,39.9]
["2012-11-14",64,"No Coupon","Visa","Aspen","West",21.95,2,43.9]
["2012-01-21",30,"No Coupon","PayPal","Aspen","West",21.95,3,65.849999999999994]
["2012-04-12",41,"Coupon","American Express","Aspen","West",21.95,2,43.9]
["2012-06-04",23,"Coupon","Mastercard","Yanaki","South",19.95,5,99.75]
["2012-10-19",52,"Coupon","Visa","Delicate Arch","West",29.95,1,29.95]
["2012-09-07",18,"No Coupon","PayPal","Aspen","West",21.95,3,65.849999999999994]
["2012-09-19",32,"No Coupon","PayPal","Carlota","West",22.95,1,22.95]
["2012-01-17",22,"Coupon","American Express","Yanaki","Mid West",19.95,1,19.95]
["2012-03-15",29,"Coupon","PayPal","Yanaki","South",19.95,5,99.75]
["2012-12-16",25,"No Coupon","Mastercard","Bellen","Mid West",24.95,5,124.75]
["2012-07-08",63,"No Coupon","PayPal","Aspen","West",21.95,1,21.95]
["2012-05-13",26,"No Coupon","Mastercard","Sunset","Mid West",24.95,7,174.65]
["2012-03-03",31,"Coupon","Discover","Delicate Arch","West",29.95,1,29.95]
["2012-04-30",23,"No Coupon","PayPal","Delicate Arch","Mid West",29.95,5,149.75]
["2012-07-11",42,"Coupon","PayPal","Delicate Arch","Mid West",29.95,1,29.95]
["2012-03-22",28,"Coupon","Visa","Carlota","East",22.95,2,45.9]
["2012-08-27",23,"No Coupon","Visa","Carlota","West",22.95,7,160.65]
["2012-11-16",19,"No Coupon","Mastercard","Carlota","Mid West",22.95,7,160.65]
["2012-01-26",37,"Coupon","Visa","Yanaki","West",19.95,6,119.69999999999999]
["2012-05-06",38,"No Coupon","Mastercard","Aspen","East",21.95,2,43.9]
["2012-03-18",50,"Coupon","Mastercard","Yanaki","Mid West",19.95,6,119.69999999999999]
["2012-04-16",26,"No Coupon","Discover","Aspen","West",21.95,3,65.849999999999994]
["2012-01-05",33,"No Coupon","PayPal","Carlota","South",22.95,1,22.95]
["2012-11-09",59,"No Coupon","PayPal","Aspen","Mid West",21.95,3,65.849999999999994]
["2012-07-29",32,"No Coupon","Visa","Aspen","Mid West",21.95,5,109.75]
["2012-12-07",27,"No Coupon","Visa","Carlota","Mid West",22.95,5,114.75]
["2012-11-22",54,"Coupon","American Express","Bellen","West",24.95,10,249.5]
["2012-01-10",63,"No Coupon","PayPal","Aspen","West",21.95,5,109.75]
["2012-06-01",48,"No Coupon","Visa","Carlota","East",22.95,5,114.75]
["2012-05-02",29,"No Coupon","American Express","Carlota","East",22.95,5,114.75]
["2012-06-13",38,"Coupon","Visa","Delicate Arch","West",29.95,4,119.8]
["2012-02-16",24,"Coupon","Mastercard","Delicate Arch","East",29.95,1,29.95]
["2012-08-02",51,"No Coupon","Visa","Carlota","West",22.95,5,114.75]
["2012-11-01",25,"Coupon","Mastercard","Delicate Arch","West",29.95,7,209.65]
["2012-11-08",65,"No Coupon","Visa","Carlota","West",22.95,5,114.75]
["2012-08-17",35,"No Coupon","PayPal","Yanaki","Mid West",19.95,3,59.849999999999994]
["2012-09-27",35,"No Coupon","Mastercard","Sunset","East",24.95,5,124.75]
["2012-01-09",21,"No Coupon","Visa","Yanaki","Mid West",19.95,2,39.9]
["2012-10-10",47,"No Coupon","Mastercard","Sunset","West",24.95,5,124.75]
["2012-12-31",62,"No Coupon","Discover","Sunset","East",24.95,1,24.95]
["2012-12-06",63,"No Coupon","PayPal","Carlota","East",22.95,1,22.95]
["2012-03-18",23,"No Coupon","American Express","Bellen","Mid West",24.95,10,249.5]
["2012-03-22",59,"No Coupon","Visa","Yanaki","South",19.95,3,59.849999999999994]
["2012-09-14",48,"Coupon","Visa","Aspen","West",21.95,2,43.9]
["2012-02-09",57,"No Coupon","Mastercard","Yanaki","South",19.95,1,19.95]
["2012-03-24",19,"No Coupon","Discover","Delicate Arch","Mid West",29.95,1,29.95]
["2012-07-28",48,"Coupon","Mastercard","Yanaki","Mid West",19.95,1,19.95]
["2012-08-26",21,"Coupon","Mastercard","Aspen","South",21.95,3,65.849999999999994]
["2012-03-05",40,"No Coupon","American Express","Carlota","West",22.95,1,22.95]
["2012-08-18",25,"No Coupon","Visa","Yanaki","Mid West",19.95,4,79.8]
["2012-11-02",59,"Coupon","Mastercard","Yanaki","South",19.95,4,79.8]
["2012-12-19",57,"No Coupon","Visa","Carlota","West",22.95,5,114.75]
["2012-07-05",56,"Coupon","Discover","Carlota","West",22.95,1,22.95]
["2012-04-16",19,"No Coupon","Visa","Yanaki","West",19.95,1,19.95]
["2012-12-23",54,"No Coupon","Visa","Aspen","Mid West",21.95,5,109.75]
["2012-05-29",65,"No Coupon","PayPal","Delicate Arch","Mid West",29.95,2,59.9]
["2012-05-01",25,"Coupon","PayPal","Aspen","West",21.95,2,43.9]
["2012-07-03",30,"No Coupon","American Express","Yanaki","West",19.95,2,39.9]
["2012-08-12",57,"No Coupon","Mastercard","Delicate Arch","West",29.95,7,209.65]
["2012-06-21",43,"Coupon","PayPal","Yanaki","West",19.95,1,19.95]
["2012-12-15",44,"No Coupon","Mastercard","Yanaki","South",19.95,4,79.8]
["2012-05-25",21,"No Coupon","PayPal","Bellen","East",24.95,5,124.75]
["2012-03-23",20,"No Coupon","PayPal","Bellen","West",24.95,1,24.95]
["2012-01-22",49,"Coupon","Visa","Carlota","West",22.95,7,160.65]
["2012-09-26",37,"No Coupon","Mastercard","Aspen","South",21.95,3,65.849999999999994]
["2012-12-27",26,"No Coupon","PayPal","Carlota","West",22.95,6,137.69999999999999]
["2012-07-24",62,"No Coupon","Mastercard","Delicate Arch","East",29.95,1,29.95]
["2012-04-27",38,"No Coupon","PayPal","Yanaki","West",19.95,6,119.69999999999999]
["2012-05-07",55,"No Coupon","Visa","Yanaki","West",19.95,1,19.95]
["2012-03-03",24,"Coupon","American Express","Yanaki","East",19.95,2,39.9]
["2012-03-23",30,"No Coupon","PayPal","Carlota","Mid West",22.95,5,114.75]
["2012-12-05",39,"Coupon","Visa","Aspen","Mid West",21.95,1,21.95]
["2012-11-11",59,"Coupon","PayPal","Delicate Arch","South",29.95,6,179.7]
["2012-04-13",26,"No Coupon","Discover","Yanaki","East",19.95,2,39.9]
["2012-12-13",33,"No Coupon","Visa","Sunset","Mid West",24.95,1,24.95]
["2012-10-05",20,"No Coupon","Visa","Bellen","West",24.95,4,99.8]
["2012-01-02",18,"No Coupon","Visa","Aspen","West",21.95,4,87.8]
["2012-11-04",19,"Coupon","PayPal","Yanaki","East",19.95,2,39.9]
["2012-04-29",61,"No Coupon","PayPal","Aspen","West",21.95,3,65.849999999999994]
["2012-10-02",39,"Coupon","PayPal","Yanaki","East",19.95,10,199.5]
["2012-12-26",52,"Coupon","Discover","Aspen","West",21.95,1,21.95]
["2012-11-05",20,"No Coupon","Visa","Sunset","West",24.95,5,124.75]
["2012-11-15",50,"No Coupon","Visa","Delicate Arch","West",29.95,1,29.95]
["2012-06-27",29,"Coupon","PayPal","Aspen","South",21.95,1,21.95]
["2012-04-21",55,"No Coupon","Visa","Delicate Arch","West",29.95,4,119.8]
["2012-09-25",18,"No Coupon","American Express","Delicate Arch","West",29.95,3,89.85]
["2012-01-24",39,"Coupon","Mastercard","Aspen","Mid West",21.95,3,65.849999999999994]
["2012-01-04",35,"No Coupon","Visa","Carlota","South",22.95,4,91.8]
["2012-05-06",38,"Coupon","American Express","Bellen","South",24.95,6,149.69999999999999]
["2012-06-22",20,"No Coupon","Visa","Yanaki","East",19.95,3,59.849999999999994]
["2012-07-12",60,"No Coupon","Discover","Aspen","Mid West",21.95,6,131.69999999999999]
["2012-05-03",61,"No Coupon","Visa","Sunset","Mid West",24.95,2,49.9]
["2012-03-09",62,"Coupon","PayPal","Aspen","West",21.95,2,43.9]
["2012-03-02",21,"No Coupon","Visa","Yanaki","Mid West",19.95,1,19.95]
["2012-03-28",40,"No Coupon","Discover","Aspen","South",21.95,1,21.95]
["2012-01-15",25,"No Coupon","Visa","Bellen","West",24.95,1,24.95]
["2012-11-18",50,"No Coupon","Mastercard","Yanaki","West",19.95,2,39.9]
["2012-03-27",24,"No Coupon","Visa","Bellen","West",24.95,1,24.95]
["2012-08-11",28,"Coupon","PayPal","Carlota","West",22.95,5,114.75]
["2012-12-24",22,"No Coupon","Visa","Yanaki","Mid West",19.95,6,119.69999999999999]
["2012-11-27",22,"No Coupon","PayPal","Aspen","West",21.95,2,43.9]
["2012-03-12",27,"No Coupon","Visa","Bellen","West",24.95,1,24.95]
["2012-09-16",54,"Coupon","Visa","Sunset","West",24.95,7,174.65]
["2012-02-01",25,"No Coupon","Mastercard","Bellen","West",24.95,1,24.95]
["2012-07-03",25,"No Coupon","Visa","Sunset","Mid West",24.95,2,49.9]
["2012-08-30",30,"No Coupon","PayPal","Yanaki","East",19.95,1,19.95]
["2012-09-18",59,"Coupon","Mastercard","Yanaki","South",19.95,2,39.9]
["2012-11-24",51,"No Coupon","Visa","Carlota","West",22.95,2,45.9]
["2012-12-22",38,"No Coupon","Visa","Delicate Arch","West",29.95,6,179.7]
["2012-04-23",28,"No Coupon","PayPal","Carlota","South",22.95,7,160.65]
["2012-11-18",30,"Coupon","Discover","Aspen","West",21.95,1,21.95]
["2012-10-28",43,"No Coupon","Visa","Bellen","South",24.95,5,124.75]
["2012-08-14",42,"No Coupon","PayPal","Delicate Arch","West",29.95,3,89.85]
["2012-05-05",24,"No Coupon","Visa","Bellen","Mid West",24.95,2,49.9]
["2012-08-25",47,"Coupon","Visa","Carlota","Mid West",22.95,1,22.95]
["2012-10-25",23,"No Coupon","PayPal","Yanaki","Mid West",19.95,1,19.95]
["2012-07-31",59,"No Coupon","PayPal","Yanaki","East",19.95,5,99.75]
["2012-07-25",22,"Coupon","Mastercard","Carlota","West",22.95,4,91.8]
["2012-09-30",27,"Coupon","Visa","Bellen","Mid West",24.95,2,49.9]
["2012-10-03",65,"No Coupon","Discover","Aspen","East",21.95,1,21.95]
["2012-04-01",27,"No Coupon","Mastercard","Carlota","Mid West",22.95,2,45.9]
["2012-12-15",27,"No Coupon","American Express","Carlota","East",22.95,1,22.95]
["2012-01-07",28,"No Coupon","PayPal","Carlota","West",22.95,2,45.9]
["2012-07-23",22,"Coupon","PayPal","Bellen","West",24.95,1,24.95]
["2012-03-16",42,"No Coupon","PayPal","Yanaki","East",19.95,2,39.9]
["2012-12-04",25,"No Coupon","American Express","Delicate Arch","East",29.95,6,179.7]
["2012-01-08",41,"Coupon","Mastercard","Aspen","West",21.95,1,21.95]
["2012-06-02",46,"Coupon","PayPal","Bellen","West",24.95,1,24.95]
["2012-08-18",41,"No Coupon","Discover","Sunset","West",24.95,3,74.849999999999994]
["2012-04-24",29,"No Coupon","Mastercard","Yanaki","West",19.95,4,79.8]
["2012-12-01",50,"No Coupon","Visa","Yanaki","Mid West",19.95,1,19.95]
["2012-12-31",50,"Coupon","Visa","Carlota","Mid West",22.95,1,22.95]
["2012-04-30",34,"Coupon","PayPal","Carlota","Mid West",22.95,2,45.9]
["2012-03-16",24,"Coupon","American Express","Aspen","West",21.95,3,65.849999999999994]
["2012-01-28",29,"No Coupon","Mastercard","Yanaki","West",19.95,7,139.65]
["2012-08-03",35,"No Coupon","Mastercard","Carlota","Mid West",22.95,1,22.95]
["2012-11-11",24,"No Coupon","Visa","Yanaki","West",19.95,2,39.9]
["2012-12-13",23,"Coupon","Visa","Aspen","South",21.95,5,109.75]
["2012-03-27",31,"No Coupon","PayPal","Carlota","Mid West",22.95,7,160.65]
["2012-10-08",24,"Coupon","PayPal","Bellen","Mid West",24.95,2,49.9]
["2012-08-03",30,"No Coupon","Visa","Carlota","Mid West",22.95,1,22.95]
["2012-03-10",22,"Coupon","Visa","Carlota","West",22.95,2,45.9]
["2012-03-02",43,"No Coupon","Visa","Carlota","East",22.95,3,68.849999999999994]
["2012-01-26",55,"No Coupon","Visa","Carlota","West",22.95,10,229.5]
["2012-05-06",38,"No Coupon","American Express","Delicate Arch","West",29.95,1,29.95]
["2012-03-10",28,"Coupon","Visa","Yanaki","West",19.95,2,39.9]
["2012-11-18",30,"Coupon","PayPal","Aspen","Mid West",21.95,2,43.9]
["2012-01-30",35,"Coupon","Discover","Yanaki","West",19.95,1,19.95]
["2012-07-02",41,"No Coupon","Visa","Delicate Arch","West",29.95,2,59.9]
["2012-10-13",28,"Coupon","Discover","Yanaki","East",19.95,5,99.75]
["2012-02-07",65,"No Coupon","Discover","Bellen","Mid West",24.95,7,174.65]
["2012-06-05",20,"No Coupon","Mastercard","Aspen","West",21.95,3,65.849999999999994]
["2012-11-02",39,"No Coupon","Visa","Sunset","Mid West",24.95,5,124.75]
["2012-12-13",19,"No Coupon","Visa","Aspen","East",21.95,4,87.8]
["2012-10-23",64,"No Coupon","Visa","Carlota","West",22.95,10,229.5]
["2012-12-22",42,"Coupon","PayPal","Yanaki","South",19.95,5,99.75]
["2012-08-21",24,"Coupon","PayPal","Yanaki","Mid West",19.95,1,19.95]
["2012-08-28",24,"Coupon","PayPal","Yanaki","Mid West",19.95,1,19.95]
["2012-06-20",18,"No Coupon","American Express","Bellen","Mid West",24.95,4,99.8]
["2012-04-30",36,"Coupon","Mastercard","Bellen","East",24.95,1,24.95]
["2012-10-14",61,"No Coupon","Mastercard","Carlota","Mid West",22.95,5,114.75]
["2012-08-04",22,"No Coupon","Visa","Yanaki","West",19.95,3,59.849999999999994]
["2012-10-28",55,"Coupon","PayPal","Aspen","West",21.95,2,43.9]
["2012-11-04",27,"No Coupon","American Express","Sunset","West",24.95,3,74.849999999999994]
["2012-01-05",49,"No Coupon","PayPal","Yanaki","Mid West",19.95,1,19.95]
["2012-12-11",29,"Coupon","Visa","Carlota","West",22.95,1,22.95]
["2012-07-18",33,"No Coupon","PayPal","Aspen","West",21.95,7,153.65]
["2012-05-31",52,"No Coupon","Visa","Yanaki","West",19.95,2,39.9]
["2012-12-16",26,"Coupon","PayPal","Aspen","West",21.95,6,131.69999999999999]

{"sheet":"F(5)","index":11,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Filter by Partial Text"}]
[]
["Business","Contact","Phone"]
["Bay Air Compressor","Dave","313-443-4435"]
["10 H Motor","Phil","502-720-5112"]
["Porter Cable Compressor","Sioux","267-703-6244"]
["Ashby Lumber","Mo","809-640-6790"]
["V8 Mechanic Service","Jo","508-370-6184"]
["Senco Compressor","Tommy","314-524-9500"]
["DeVILBISS Compressor","Chin","593-805-2524"]
["Compressor Repair Kit","Hal","866-348-1778"]
["Large Motor","Pay","596-541-9817"]

{"sheet":"PT(1)","index":12,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: What is a PivotTable?"}]
[]
["A feature that can easily make calculations with 1 or more criteria"]
[]
["Student Name","Major","Class","Grade",null,"Average of Grade","Class"]
["Erinn Kraeger","Accounting","Math 101",3.8,null,"Major","English 101","Math 101"]
["Devorah Passe","Nursing","English 101",2.7,null,"Accounting",3.2,3.4]
["Tommie Colborn","Accounting","Math 101",2.5,null,"Nursing",2.4499999999999997,3.4]
["Shirleen Surrey","Nursing","English 101",3]
["Devorah Flight","Accounting","Math 101",3.9,null,"* Calculating an average, not of all the"]
["Domingo Schoppe","Accounting","English 101",4,null,"numbers in the grade column"]
["Annett Stefanelli","Nursing","Math 101",3.4]
["Emilio Lindbeck","Nursing","English 101",2.5,null,"* Calculating average with 2 criteria"]
["Waltraud Kolasinski","Accounting","English 101",2.4]
["Waltraud Leaper","Nursing","English 101",1.6]

{"sheet":"PT(2)","index":13,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Home",null,null,"With a single cell selected,",null,null,"1) ","Insert Tab, Table, PivotTable"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Easy 3 step method"},null,null,"and with a picture",null,null,"2) ","Drag fields to desired location in Field List dialog box"]
[null,null,null,"of end result in your head:",null,null,"3) ","Right-click values and point to calculation you would like."]
[null,null,null,null,null,null,"Formatting:","Design Tab, Report Layout, Tabular"]
["Student Name","Major","Class","Grade",null,null,null,"With a variable (field name, criteria) in the row and column, we"]
["Erinn Kraeger","Accounting","Math 101",3.8,null,null,null,"call this a \"cross tabulated\" table."]
["Devorah Passe","Nursing","English 101",2.7]
["Tommie Colborn","Accounting","Math 101",2.5]
["Shirleen Surrey","Nursing","English 101",3,null,"Average of Grade","Class"]
["Devorah Flight","Accounting","Math 101",3.9,null,"Major","English 101","Math 101","Grand Total"]
["Domingo Schoppe","Accounting","English 101",4,null,"Accounting",3.2,3.4,3.3199999999999994]
["Annett Stefanelli","Nursing","Math 101",3.4,null,"Nursing",2.4499999999999997,3.4,2.6399999999999997]
["Emilio Lindbeck","Nursing","English 101",2.5,null,"Grand Total",2.7000000000000006,3.4,2.9799999999999995]
["Waltraud Kolasinski","Accounting","English 101",2.4]
["Waltraud Leaper","Nursing","English 101",1.6]

{"sheet":"PT(3)","index":14,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Home",null,null,"Key: You can drop many fields into the Values area."]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: More than one calculation"},null,null,"Use \"Value Field Settings\" dialog box to change name, calculation, Number Formatting"]
[]
["ID","Employee","Department","Hours worked Last Year"]
["760-81-7404","Agramonte, Lexie","Accounting",3063,null,"Row Labels","Sum","Ave","StdDevp","Count"]
["760-37-1006","Higashi, Armanda","Accounting",274,null,"Accounting",26433,2033.3076923076924,1105.9678938597272,13]
["760-57-7436","Popoca, Jan","Operations",1621,null,"Finance",14101,1566.7777777777778,843.18045752413957,9]
["760-71-1468","Kinnick, Jenice","Marketing",2034,null,"Human Resources",30178,2155.5714285714284,800.38050899786003,14]
["760-89-9336","Livesey, Annett","Operations",1219,null,"Marketing",29051,2420.9166666666665,822.46716837546501,12]
["760-87-3551","Stockfisch, Angelena","Marketing",1817,null,"Operations",18096,1508,886.12151160737164,12]
["760-69-3010","Baar, Janay","Operations",2998,null,"Grand Total",117859,1964.3166666666666,964.40848004820498,60]
["760-53-4083","Galen, Fae","Accounting",1944]
["760-68-5496","Sayle, Brinda","Human Resources",1976]
["760-52-2536","Deppner, Mana","Human Resources",1396]
["760-33-5044","Hoesly, Dimple","Operations",2171]
["760-24-1698","Mins, Bojko","Human Resources",2050]
["760-55-4539","Rowson, Ozella","Human Resources",2739]
["760-76-6644","Streck, Tommie","Finance",1877]
["760-92-9661","Stayner, Randal","Marketing",2896]
["760-53-1356","Simley, Boyd","Accounting",2298]
["760-99-8354","Gazzo, Darnell","Accounting",1134]
["760-56-2995","Joens, Dominick","Operations",1262]
["760-86-5563","Stepler, Santos","Marketing",3489]
["760-16-9928","Kap, Talitha","Accounting",3460]
["760-43-2368","Menna, Roman","Accounting",1076]
["760-78-7988","Barnaba, Aubrey","Operations",104]
["760-85-1970","Lumbreras, Tameika","Finance",180]
["760-49-7089","Gottwald, Timmy","Operations",1873]
["760-98-2848","Colgrove, Randal","Human Resources",2348]
["760-26-2644","Gervin, Van","Accounting",1370]
["760-10-1459","Guedry, Emanuel","Human Resources",1764]
["760-88-1227","Knaff, Santos","Accounting",3318]
["760-28-4797","Therien, Cary","Operations",1725]
["760-16-2319","Norena, Emanuel","Marketing",2844]
["760-38-4772","Staniszewski, Isidra","Finance",2252]
["760-80-1353","Chirinos, Waltraud","Finance",2898]
["760-71-1098","Shown, Winston","Human Resources",2240]
["760-13-3820","Tooks, Emmett","Operations",297]
["760-20-9612","Alcorta, Boyd","Marketing",2928]
["760-96-1356","Niedermeyer, Mika","Marketing",2686]
["760-18-3557","Busher, Jacquiline","Finance",2160]
["760-33-6047","Okoro, Elois","Accounting",3493]
["760-71-6311","Stensrud, Erinn","Operations",2891]
["760-24-2922","Unna, Enno","Marketing",388]
["760-72-8820","Ewings, Domingo","Human Resources",264]
["760-34-8408","Dyas, Jenice","Accounting",2803]
["760-17-5621","Rinsind, Middlemiss","Operations",472]
["760-66-1293","Mondesir, Roman","Finance",1300]
["760-42-2966","Sherley, Aubrey","Human Resources",3531]
["760-15-5402","Hackford, Abel","Marketing",2001]
["760-95-8377","Schriner, Darnell","Finance",340]
["760-98-7165","Hermandez, Isidra","Marketing",1884]
["760-77-4087","Eisermann, Dominick","Human Resources",1964]
["760-70-1466","Mckinzey, Brendan","Finance",1224]
["760-58-5607","Dahman, Darnell","Human Resources",3222]
["760-82-1570","Zmolek, Tequila","Human Resources",1355]
["760-11-1484","Cabbagestalk, Cary","Human Resources",2726]
["760-71-1330","Manda, Francoise","Accounting",278]
["760-54-2947","Constanza, Echo","Human Resources",2603]
["760-86-5842","Ludemann, Emanuel","Operations",1463]
["760-89-4368","Killman, Emmett","Accounting",1922]
["760-36-3699","Onell, Aubrey","Finance",1870]
["760-57-9742","Wilfred, Courtney","Marketing",2617]
["760-77-8027","Stonum, Elijah","Marketing",3467]

{"sheet":"PT(4)","index":15,"n_rows":64,"n_cols":13,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Home",null,null,"Key: Right-click Number Field in Row Label and point to Group.",null,null,null,null,null,null,null,null,{"$f":"CHOOSE(RANDBETWEEN(1,5),RANDBETWEEN(1000,$G$4),RANDBETWEEN(1000,$G$4),RANDBETWEEN(1000,$G$4),RANDBETWEEN(1000,$G$4),RANDBETWEEN(100,500))","v":{"$error":"#NUM!"}}]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Grouping Numbers"}]
[]
["ID","Employee","Department","Hours worked Last Year"]
["760-81-7404","Agramonte, Lexie","Accounting",3063,null,"Hours worked Last Year","# of Employees"]
["760-37-1006","Higashi, Armanda","Accounting",274,null,"100-599",9]
["760-57-7436","Popoca, Jan","Operations",1621,null,"600-1099",1]
["760-71-1468","Kinnick, Jenice","Marketing",2034,null,"1100-1599",9]
["760-89-9336","Livesey, Annett","Operations",1219,null,"1600-2099",15]
["760-87-3551","Stockfisch, Angelena","Marketing",1817,null,"2100-2599",6]
["760-69-3010","Baar, Janay","Operations",2998,null,"2600-3099",13]
["760-53-4083","Galen, Fae","Accounting",1944,null,"3100-3600",7]
["760-68-5496","Sayle, Brinda","Human Resources",1976,null,"Grand Total",60]
["760-52-2536","Deppner, Mana","Human Resources",1396]
["760-33-5044","Hoesly, Dimple","Operations",2171]
["760-24-1698","Mins, Bojko","Human Resources",2050]
["760-55-4539","Rowson, Ozella","Human Resources",2739]
["760-76-6644","Streck, Tommie","Finance",1877]
["760-92-9661","Stayner, Randal","Marketing",2896]
["760-53-1356","Simley, Boyd","Accounting",2298]
["760-99-8354","Gazzo, Darnell","Accounting",1134]
["760-56-2995","Joens, Dominick","Operations",1262]
["760-86-5563","Stepler, Santos","Marketing",3489]
["760-16-9928","Kap, Talitha","Accounting",3460]
["760-43-2368","Menna, Roman","Accounting",1076]
["760-78-7988","Barnaba, Aubrey","Operations",104]
["760-85-1970","Lumbreras, Tameika","Finance",180]
["760-49-7089","Gottwald, Timmy","Operations",1873]
["760-98-2848","Colgrove, Randal","Human Resources",2348]
["760-26-2644","Gervin, Van","Accounting",1370]
["760-10-1459","Guedry, Emanuel","Human Resources",1764]
["760-88-1227","Knaff, Santos","Accounting",3318]
["760-28-4797","Therien, Cary","Operations",1725]
["760-16-2319","Norena, Emanuel","Marketing",2844]
["760-38-4772","Staniszewski, Isidra","Finance",2252]
["760-80-1353","Chirinos, Waltraud","Finance",2898]
["760-71-1098","Shown, Winston","Human Resources",2240]
["760-13-3820","Tooks, Emmett","Operations",297]
["760-20-9612","Alcorta, Boyd","Marketing",2928]
["760-96-1356","Niedermeyer, Mika","Marketing",2686]
["760-18-3557","Busher, Jacquiline","Finance",2160]
["760-33-6047","Okoro, Elois","Accounting",3493]
["760-71-6311","Stensrud, Erinn","Operations",2891]
["760-24-2922","Unna, Enno","Marketing",388]
["760-72-8820","Ewings, Domingo","Human Resources",264]
["760-34-8408","Dyas, Jenice","Accounting",2803]
["760-17-5621","Rinsind, Middlemiss","Operations",472]
["760-66-1293","Mondesir, Roman","Finance",1300]
["760-42-2966","Sherley, Aubrey","Human Resources",3531]
["760-15-5402","Hackford, Abel","Marketing",2001]
["760-95-8377","Schriner, Darnell","Finance",340]
["760-98-7165","Hermandez, Isidra","Marketing",1884]
["760-77-4087","Eisermann, Dominick","Human Resources",1964]
["760-70-1466","Mckinzey, Brendan","Finance",1224]
["760-58-5607","Dahman, Darnell","Human Resources",3222]
["760-82-1570","Zmolek, Tequila","Human Resources",1355]
["760-11-1484","Cabbagestalk, Cary","Human Resources",2726]
["760-71-1330","Manda, Francoise","Accounting",278]
["760-54-2947","Constanza, Echo","Human Resources",2603]
["760-86-5842","Ludemann, Emanuel","Operations",1463]
["760-89-4368","Killman, Emmett","Accounting",1922]
["760-36-3699","Onell, Aubrey","Finance",1870]
["760-57-9742","Wilfred, Courtney","Marketing",2617]
["760-77-8027","Stonum, Elijah","Marketing",3467]

{"sheet":"PT(5)","index":16,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Home",null,null,"Key: Right-click Number Field in Row Label and point to group."]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Filter in a Pivot Table"}]
[]
["ID","Employee","Department","Hours worked Last Year",null,"Hours worked Last Year","Count of Hours worked Last Year"]
["760-81-7404","Agramonte, Lexie","Accounting",3063,null,"100-599",2]
["760-37-1006","Higashi, Armanda","Accounting",274,null,"600-1099",1]
["760-57-7436","Popoca, Jan","Operations",1621,null,"1100-1599",2]
["760-71-1468","Kinnick, Jenice","Marketing",2034,null,"1600-2099",2]
["760-89-9336","Livesey, Annett","Operations",1219,null,"2100-2599",1]
["760-87-3551","Stockfisch, Angelena","Marketing",1817,null,"2600-3099",2]
["760-69-3010","Baar, Janay","Operations",2998,null,"3100-3600",3]
["760-53-4083","Galen, Fae","Accounting",1944,null,"Grand Total",13]
["760-68-5496","Sayle, Brinda","Human Resources",1976]
["760-52-2536","Deppner, Mana","Human Resources",1396]
["760-33-5044","Hoesly, Dimple","Operations",2171]
["760-24-1698","Mins, Bojko","Human Resources",2050]
["760-55-4539","Rowson, Ozella","Human Resources",2739]
["760-76-6644","Streck, Tommie","Finance",1877]
["760-92-9661","Stayner, Randal","Marketing",2896]
["760-53-1356","Simley, Boyd","Accounting",2298]
["760-99-8354","Gazzo, Darnell","Accounting",1134]
["760-56-2995","Joens, Dominick","Operations",1262]
["760-86-5563","Stepler, Santos","Marketing",3489]
["760-16-9928","Kap, Talitha","Accounting",3460]
["760-43-2368","Menna, Roman","Accounting",1076]
["760-78-7988","Barnaba, Aubrey","Operations",104]
["760-85-1970","Lumbreras, Tameika","Finance",180]
["760-49-7089","Gottwald, Timmy","Operations",1873]
["760-98-2848","Colgrove, Randal","Human Resources",2348]
["760-26-2644","Gervin, Van","Accounting",1370]
["760-10-1459","Guedry, Emanuel","Human Resources",1764]
["760-88-1227","Knaff, Santos","Accounting",3318]
["760-28-4797","Therien, Cary","Operations",1725]
["760-16-2319","Norena, Emanuel","Marketing",2844]
["760-38-4772","Staniszewski, Isidra","Finance",2252]
["760-80-1353","Chirinos, Waltraud","Finance",2898]
["760-71-1098","Shown, Winston","Human Resources",2240]
["760-13-3820","Tooks, Emmett","Operations",297]
["760-20-9612","Alcorta, Boyd","Marketing",2928]
["760-96-1356","Niedermeyer, Mika","Marketing",2686]
["760-18-3557","Busher, Jacquiline","Finance",2160]
["760-33-6047","Okoro, Elois","Accounting",3493]
["760-71-6311","Stensrud, Erinn","Operations",2891]
["760-24-2922","Unna, Enno","Marketing",388]
["760-72-8820","Ewings, Domingo","Human Resources",264]
["760-34-8408","Dyas, Jenice","Accounting",2803]
["760-17-5621","Rinsind, Middlemiss","Operations",472]
["760-66-1293","Mondesir, Roman","Finance",1300]
["760-42-2966","Sherley, Aubrey","Human Resources",3531]
["760-15-5402","Hackford, Abel","Marketing",2001]
["760-95-8377","Schriner, Darnell","Finance",340]
["760-98-7165","Hermandez, Isidra","Marketing",1884]
["760-77-4087","Eisermann, Dominick","Human Resources",1964]
["760-70-1466","Mckinzey, Brendan","Finance",1224]
["760-58-5607","Dahman, Darnell","Human Resources",3222]
["760-82-1570","Zmolek, Tequila","Human Resources",1355]
["760-11-1484","Cabbagestalk, Cary","Human Resources",2726]
["760-71-1330","Manda, Francoise","Accounting",278]
["760-54-2947","Constanza, Echo","Human Resources",2603]
["760-86-5842","Ludemann, Emanuel","Operations",1463]
["760-89-4368","Killman, Emmett","Accounting",1922]
["760-36-3699","Onell, Aubrey","Finance",1870]
["760-57-9742","Wilfred, Courtney","Marketing",2617]
["760-77-8027","Stonum, Elijah","Marketing",3467]

{"sheet":"C(1)","index":18,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Column Charts from Pivot Tables"}]
[]
["ID","Employee","Department","Hours worked Last Year",null,"Hours worked Last Year","Count of Hours worked Last Year"]
["760-81-7404","Agramonte, Lexie","Accounting",3063,null,"100-599",9]
["760-37-1006","Higashi, Armanda","Accounting",274,null,"600-1099",1]
["760-57-7436","Popoca, Jan","Operations",1621,null,"1100-1599",9]
["760-71-1468","Kinnick, Jenice","Marketing",2034,null,"1600-2099",15]
["760-89-9336","Livesey, Annett","Operations",1219,null,"2100-2599",6]
["760-87-3551","Stockfisch, Angelena","Marketing",1817,null,"2600-3099",13]
["760-69-3010","Baar, Janay","Operations",2998,null,"3100-3600",7]
["760-53-4083","Galen, Fae","Accounting",1944,null,"Grand Total",60]
["760-68-5496","Sayle, Brinda","Human Resources",1976]
["760-52-2536","Deppner, Mana","Human Resources",1396]
["760-33-5044","Hoesly, Dimple","Operations",2171]
["760-24-1698","Mins, Bojko","Human Resources",2050]
["760-55-4539","Rowson, Ozella","Human Resources",2739]
["760-76-6644","Streck, Tommie","Finance",1877]
["760-92-9661","Stayner, Randal","Marketing",2896]
["760-53-1356","Simley, Boyd","Accounting",2298]
["760-99-8354","Gazzo, Darnell","Accounting",1134]
["760-56-2995","Joens, Dominick","Operations",1262]
["760-86-5563","Stepler, Santos","Marketing",3489]
["760-16-9928","Kap, Talitha","Accounting",3460]
["760-43-2368","Menna, Roman","Accounting",1076]
["760-78-7988","Barnaba, Aubrey","Operations",104]
["760-85-1970","Lumbreras, Tameika","Finance",180]
["760-49-7089","Gottwald, Timmy","Operations",1873]
["760-98-2848","Colgrove, Randal","Human Resources",2348]
["760-26-2644","Gervin, Van","Accounting",1370]
["760-10-1459","Guedry, Emanuel","Human Resources",1764]
["760-88-1227","Knaff, Santos","Accounting",3318]
["760-28-4797","Therien, Cary","Operations",1725]
["760-16-2319","Norena, Emanuel","Marketing",2844]
["760-38-4772","Staniszewski, Isidra","Finance",2252]
["760-80-1353","Chirinos, Waltraud","Finance",2898]
["760-71-1098","Shown, Winston","Human Resources",2240]
["760-13-3820","Tooks, Emmett","Operations",297]
["760-20-9612","Alcorta, Boyd","Marketing",2928]
["760-96-1356","Niedermeyer, Mika","Marketing",2686]
["760-18-3557","Busher, Jacquiline","Finance",2160]
["760-33-6047","Okoro, Elois","Accounting",3493]
["760-71-6311","Stensrud, Erinn","Operations",2891]
["760-24-2922","Unna, Enno","Marketing",388]
["760-72-8820","Ewings, Domingo","Human Resources",264]
["760-34-8408","Dyas, Jenice","Accounting",2803]
["760-17-5621","Rinsind, Middlemiss","Operations",472]
["760-66-1293","Mondesir, Roman","Finance",1300]
["760-42-2966","Sherley, Aubrey","Human Resources",3531]
["760-15-5402","Hackford, Abel","Marketing",2001]
["760-95-8377","Schriner, Darnell","Finance",340]
["760-98-7165","Hermandez, Isidra","Marketing",1884]
["760-77-4087","Eisermann, Dominick","Human Resources",1964]
["760-70-1466","Mckinzey, Brendan","Finance",1224]
["760-58-5607","Dahman, Darnell","Human Resources",3222]
["760-82-1570","Zmolek, Tequila","Human Resources",1355]
["760-11-1484","Cabbagestalk, Cary","Human Resources",2726]
["760-71-1330","Manda, Francoise","Accounting",278]
["760-54-2947","Constanza, Echo","Human Resources",2603]
["760-86-5842","Ludemann, Emanuel","Operations",1463]
["760-89-4368","Killman, Emmett","Accounting",1922]
["760-36-3699","Onell, Aubrey","Finance",1870]
["760-57-9742","Wilfred, Courtney","Marketing",2617]
["760-77-8027","Stonum, Elijah","Marketing",3467]

{"sheet":"For(1)","index":19,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: SUMIFS"},"Adds with 1 or more criteria"]
[]
["ID","Employee","Department","Hours worked Last Year",null,"Department","SUM"]
["760-81-7404","Agramonte, Lexie","Accounting",3063,null,"Accounting",{"$f":"SUMIFS($D$5:$D$64,$C$5:$C$64,F5)","v":26433}]
["760-37-1006","Higashi, Armanda","Accounting",274,null,"Operations",{"$f":"SUMIFS($D$5:$D$64,$C$5:$C$64,F6)","v":18096}]
["760-57-7436","Popoca, Jan","Operations",1621,null,"Marketing",29051]
["760-71-1468","Kinnick, Jenice","Marketing",2034,null,"Human Resources",30178]
["760-89-9336","Livesey, Annett","Operations",1219,null,"Finance",{"$f":"SUMIFS($D$5:$D$64,$C$5:$C$64,F9)","v":14101}]
["760-87-3551","Stockfisch, Angelena","Marketing",1817]
["760-69-3010","Baar, Janay","Operations",2998]
["760-53-4083","Galen, Fae","Accounting",1944]
["760-68-5496","Sayle, Brinda","Human Resources",1976]
["760-52-2536","Deppner, Mana","Human Resources",1396]
["760-33-5044","Hoesly, Dimple","Operations",2171]
["760-24-1698","Mins, Bojko","Human Resources",2050]
["760-55-4539","Rowson, Ozella","Human Resources",2739]
["760-76-6644","Streck, Tommie","Finance",1877]
["760-92-9661","Stayner, Randal","Marketing",2896]
["760-53-1356","Simley, Boyd","Accounting",2298]
["760-99-8354","Gazzo, Darnell","Accounting",1134]
["760-56-2995","Joens, Dominick","Operations",1262]
["760-86-5563","Stepler, Santos","Marketing",3489]
["760-16-9928","Kap, Talitha","Accounting",3460]
["760-43-2368","Menna, Roman","Accounting",1076]
["760-78-7988","Barnaba, Aubrey","Operations",104]
["760-85-1970","Lumbreras, Tameika","Finance",180]
["760-49-7089","Gottwald, Timmy","Operations",1873]
["760-98-2848","Colgrove, Randal","Human Resources",2348]
["760-26-2644","Gervin, Van","Accounting",1370]
["760-10-1459","Guedry, Emanuel","Human Resources",1764]
["760-88-1227","Knaff, Santos","Accounting",3318]
["760-28-4797","Therien, Cary","Operations",1725]
["760-16-2319","Norena, Emanuel","Marketing",2844]
["760-38-4772","Staniszewski, Isidra","Finance",2252]
["760-80-1353","Chirinos, Waltraud","Finance",2898]
["760-71-1098","Shown, Winston","Human Resources",2240]
["760-13-3820","Tooks, Emmett","Operations",297]
["760-20-9612","Alcorta, Boyd","Marketing",2928]
["760-96-1356","Niedermeyer, Mika","Marketing",2686]
["760-18-3557","Busher, Jacquiline","Finance",2160]
["760-33-6047","Okoro, Elois","Accounting",3493]
["760-71-6311","Stensrud, Erinn","Operations",2891]
["760-24-2922","Unna, Enno","Marketing",388]
["760-72-8820","Ewings, Domingo","Human Resources",264]
["760-34-8408","Dyas, Jenice","Accounting",2803]
["760-17-5621","Rinsind, Middlemiss","Operations",472]
["760-66-1293","Mondesir, Roman","Finance",1300]
["760-42-2966","Sherley, Aubrey","Human Resources",3531]
["760-15-5402","Hackford, Abel","Marketing",2001]
["760-95-8377","Schriner, Darnell","Finance",340]
["760-98-7165","Hermandez, Isidra","Marketing",1884]
["760-77-4087","Eisermann, Dominick","Human Resources",1964]
["760-70-1466","Mckinzey, Brendan","Finance",1224]
["760-58-5607","Dahman, Darnell","Human Resources",3222]
["760-82-1570","Zmolek, Tequila","Human Resources",1355]
["760-11-1484","Cabbagestalk, Cary","Human Resources",2726]
["760-71-1330","Manda, Francoise","Accounting",278]
["760-54-2947","Constanza, Echo","Human Resources",2603]
["760-86-5842","Ludemann, Emanuel","Operations",1463]
["760-89-4368","Killman, Emmett","Accounting",1922]
["760-36-3699","Onell, Aubrey","Finance",1870]
["760-57-9742","Wilfred, Courtney","Marketing",2617]
["760-77-8027","Stonum, Elijah","Marketing",3467]

{"sheet":"For(2)","index":20,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: COUNTIF"},"Counts with 1 or more criteria"]
[]
["ID","Employee","Department","Hours worked Last Year",null,"Department","Count"]
["760-81-7404","Agramonte, Lexie","Accounting",3063,null,"Accounting",{"$f":"COUNTIF($C$5:$C$64,F5)","v":13}]
["760-37-1006","Higashi, Armanda","Accounting",274,null,"Operations",{"$f":"COUNTIF($C$5:$C$64,F6)","v":12}]
["760-57-7436","Popoca, Jan","Operations",1621,null,"Marketing",12]
["760-71-1468","Kinnick, Jenice","Marketing",2034,null,"Human Resources",14]
["760-89-9336","Livesey, Annett","Operations",1219,null,"Finance",9]
["760-87-3551","Stockfisch, Angelena","Marketing",1817]
["760-69-3010","Baar, Janay","Operations",2998]
["760-53-4083","Galen, Fae","Accounting",1944]
["760-68-5496","Sayle, Brinda","Human Resources",1976]
["760-52-2536","Deppner, Mana","Human Resources",1396]
["760-33-5044","Hoesly, Dimple","Operations",2171]
["760-24-1698","Mins, Bojko","Human Resources",2050]
["760-55-4539","Rowson, Ozella","Human Resources",2739]
["760-76-6644","Streck, Tommie","Finance",1877]
["760-92-9661","Stayner, Randal","Marketing",2896]
["760-53-1356","Simley, Boyd","Accounting",2298]
["760-99-8354","Gazzo, Darnell","Accounting",1134]
["760-56-2995","Joens, Dominick","Operations",1262]
["760-86-5563","Stepler, Santos","Marketing",3489]
["760-16-9928","Kap, Talitha","Accounting",3460]
["760-43-2368","Menna, Roman","Accounting",1076]
["760-78-7988","Barnaba, Aubrey","Operations",104]
["760-85-1970","Lumbreras, Tameika","Finance",180]
["760-49-7089","Gottwald, Timmy","Operations",1873]
["760-98-2848","Colgrove, Randal","Human Resources",2348]
["760-26-2644","Gervin, Van","Accounting",1370]
["760-10-1459","Guedry, Emanuel","Human Resources",1764]
["760-88-1227","Knaff, Santos","Accounting",3318]
["760-28-4797","Therien, Cary","Operations",1725]
["760-16-2319","Norena, Emanuel","Marketing",2844]
["760-38-4772","Staniszewski, Isidra","Finance",2252]
["760-80-1353","Chirinos, Waltraud","Finance",2898]
["760-71-1098","Shown, Winston","Human Resources",2240]
["760-13-3820","Tooks, Emmett","Operations",297]
["760-20-9612","Alcorta, Boyd","Marketing",2928]
["760-96-1356","Niedermeyer, Mika","Marketing",2686]
["760-18-3557","Busher, Jacquiline","Finance",2160]
["760-33-6047","Okoro, Elois","Accounting",3493]
["760-71-6311","Stensrud, Erinn","Operations",2891]
["760-24-2922","Unna, Enno","Marketing",388]
["760-72-8820","Ewings, Domingo","Human Resources",264]
["760-34-8408","Dyas, Jenice","Accounting",2803]
["760-17-5621","Rinsind, Middlemiss","Operations",472]
["760-66-1293","Mondesir, Roman","Finance",1300]
["760-42-2966","Sherley, Aubrey","Human Resources",3531]
["760-15-5402","Hackford, Abel","Marketing",2001]
["760-95-8377","Schriner, Darnell","Finance",340]
["760-98-7165","Hermandez, Isidra","Marketing",1884]
["760-77-4087","Eisermann, Dominick","Human Resources",1964]
["760-70-1466","Mckinzey, Brendan","Finance",1224]
["760-58-5607","Dahman, Darnell","Human Resources",3222]
["760-82-1570","Zmolek, Tequila","Human Resources",1355]
["760-11-1484","Cabbagestalk, Cary","Human Resources",2726]
["760-71-1330","Manda, Francoise","Accounting",278]
["760-54-2947","Constanza, Echo","Human Resources",2603]
["760-86-5842","Ludemann, Emanuel","Operations",1463]
["760-89-4368","Killman, Emmett","Accounting",1922]
["760-36-3699","Onell, Aubrey","Finance",1870]
["760-57-9742","Wilfred, Courtney","Marketing",2617]
["760-77-8027","Stonum, Elijah","Marketing",3467]

{"sheet":"For(3)","index":21,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Formula to Compare Two Lists"}]
[]
["List 1:",null,"List 2:",null,null,null,null,"List 2:"]
[]
["Division Names",null,"Division Names","Is Name in List 2 in List 1?",null," <<== or ==>>",null,"Division Names","Is Name in List 2 NOT in List 1?"]
["Babs",null,"Babs",{"$f":"ISNUMBER(MATCH(C7,$A$7:$A$12,0))","v":true},null,null,null,"Babs",{"$f":"ISNA(MATCH(H7,$A$7:$A$12,0))","v":false}]
["Jeff W.",null,"Jeff T.",{"$f":"ISNUMBER(MATCH(C8,$A$7:$A$12,0))","v":false},null,null,null,"Jeff T.",{"$f":"ISNA(MATCH(H8,$A$7:$A$12,0))","v":true}]
["Anthony N.",null,"Anthony N.",true,null,null,null,"Anthony N.",false]
["Joy S.",null,"Joy S.",true,null,null,null,"Joy S.",false]
["Ron S.",null,"Ron S.",true,null,null,null,"Ron S.",false]
["Sioux",null,"Jessica N.",false,null,null,null,"Jessica N.",true]
[]
[]
["MATCH function tells you what the relative position of an item is in a list"]
["ISNUMBER tells you whether a piece of data is a number or not."]
["ISNA tells you whether a piece of data is an #N/A error or not."]

{"sheet":"GD(1)","index":22,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Import from CSV file"}]
[]
["Copy from Word Pad, Paste, Smart Tag, Import Data Wizard"]
["Data Ribbon Tab, Get External Data, From Text"]
[]
["Student Name","Major","Class","Grade"]
["Erinn Kraeger","Accounting","Math 101",3.8]
["Devorah Passe","Nursing","English 101",2.7]
["Tommie Colborn","Accounting","Math 101",2.5]
["Shirleen Surrey","Nursing","English 101",3]
["Devorah Flight","Accounting","Math 101",3.9]
["Domingo Schoppe","Accounting","English 101",4]
["Annett Stefanelli","Nursing","Math 101",3.4]
["Emilio Lindbeck","Nursing","English 101",2.5]
["Waltraud Kolasinski","Accounting","English 101",2.4]
["Waltraud Leaper","Nursing","English 101",1.6]
[]
["Student Name","Major","Class","Grade"]
["Erinn Kraeger","Accounting","Math 101",3.8]
["Devorah Passe","Nursing","English 101",2.7]
["Tommie Colborn","Accounting","Math 101",2.5]
["Shirleen Surrey","Nursing","English 101",3]
["Devorah Flight","Accounting","Math 101",3.9]
["Domingo Schoppe","Accounting","English 101",4]
["Annett Stefanelli","Nursing","Math 101",3.4]
["Emilio Lindbeck","Nursing","English 101",2.5]
["Waltraud Kolasinski","Accounting","English 101",2.4]
["Waltraud Leaper","Nursing","English 101",1.6]

{"sheet":"GD(2)","index":23,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Home"]
[{"$f":"\"Topic: \"&INDEX(Topics!$A$13:$A$43,MATCH(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"]\",CELL(\"filename\",A1)),\"\"),Topics!$C$13:$C$43,0))","v":"Topic: Import from Access"}]
[]
["Data Ribbon Tab, Get External Data, From Access"]
[]
["ID","Student Name","Major","Class","Grade"]
[1,"Erinn Kraeger","Accounting","Math 101",3.8]
[2,"Devorah Passe","Nursing","English 101",2.7]
[3,"Tommie Colborn","Accounting","Math 101",2.5]
[4,"Shirleen Surrey","Nursing","English 101",3]
[5,"Devorah Flight","Accounting","Math 101",3.9]
[6,"Domingo Schoppe","Accounting","English 101",4]
[7,"Annett Stefanelli","Nursing","Math 101",3.4]
[8,"Emilio Lindbeck","Nursing","English 101",2.5]
[9,"Waltraud Kolasinski","Accounting","English 101",2.4]
[10,"Waltraud Leaper","Nursing","English 101",1.6]