{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sum","Count","CountIF","Graphs","RandomPassword","Stock Data","Primes","Staff Notes"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"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":"Sum","index":0,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Introduction to Excel"]
[]
[null,"1. The most important thing to start with",null,null,null,null,"Date","Goals Scored","Goals Conceded"]
[null,"is the SUM function.",null,null,null,null,"2025-10-01",3,1]
[null,"2. Each cell is referred to by the letter",null,null,null,null,"2025-10-07",2,2]
[null,"at the top and the number down.",null,null,null,null,"2025-10-13",0,0]
[null,"3. This cell is therefore E8 --> ",null,null,null,null,"2025-10-19",1,0]
[null,"4. To enter a formula like SUM into a cell",null,null,null,null,"2025-10-25",0,1]
[null,"click into that cell and enter an = sign",null,null,null,null,"2025-10-31",4,3]
[null,"Excel knows there will be a formula, not data",null,null,null,null,"2025-11-06",2,0]
[null,"in that cell.",null,null,null,null,"2025-11-12",1,1]
[null,"5. Enter =SUM( and then select the range of",null,null,null,null,"2025-11-18",2,1]
[null,"cells you want to add. Then add a closing ",null,null,null,null,"2025-11-24",0,0]
[null,"bracket."]
[null,"6. To see it, click on H15 to see it in operation",null,null,null,null,"Totals",{"$f":"SUM(H5:H14)","v":15}]

{"sheet":"Count","index":1,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Part 2: COUNT"]
[]
[null,"1. COUNT counts the number of numbers",null,null,null,null,"Date","Goals Scored","Goals Conceded"]
[null,"in a column",null,null,null,null,"2025-10-01",3,1]
[null,"2. You create it in the same way as SUM",null,null,null,null,"2025-10-07",2,2]
[null,"(see before)",null,null,null,null,"2025-10-13",0,0]
[null,"3. Excel counts dates as numbers, so ",null,null,null,null,"2025-10-19",1,0]
[null,"although the range is G5:G16, the",null,null,null,null,"2025-10-25",0,1]
[null,"Totals' line is ignored.",null,null,null,null,"2025-10-31",4,3]
[null,"4. To count anything not blank use COUNTA",null,null,null,null,"2025-11-06",2,0]
[null,"5. The opposite is COUNTBLANK",null,null,null,null,"2025-11-12",1,1]
[null,"6. See G18 for an example",null,null,null,null,"2025-11-18",2,1]
[null,null,null,null,null,null,"2025-11-24",0,0]
[]
[null,null,null,null,null,null,"Totals",{"$f":"SUM(H5:H14)","v":15},{"$f":"SUM(I5:I14)","v":9}]
[]
[null,null,null,null,"Matches Played",null,{"$f":"COUNT(G5:G16)","v":10}]

{"sheet":"CountIF","index":2,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Part 3: COUNTIF"]
[]
[null,"1. COUNTIF is similar to count but only",null,null,null,null,"Date","Goals Scored","Goals Conceded"]
[null,"counts when a value in the range meets",null,null,null,null,"2025-10-01",3,1]
[null,"a value or a logical condition.",null,null,null,null,"2025-10-07",2,2]
[null,"2. A value might be a string ie \"Y\"",null,null,null,null,"2025-10-13",0,0]
[null,"or a number: 1 or a logical condition ie \">1\"",null,null,null,null,"2025-10-19",1,0]
[null,"3. This is used for picking up data in ranges",null,null,null,null,"2025-10-25",0,1]
[null,"or where it matches a particular value",null,null,null,null,"2025-10-31",4,3]
[null,"4. See H20 for it in action",null,null,null,null,"2025-11-06",2,0]
[null,null,null,null,null,null,"2025-11-12",1,1]
[null,null,null,null,null,null,"2025-11-18",2,1]
[null,null,null,null,null,null,"2025-11-24",0,0]
[]
[null,null,null,null,null,null,"Totals",{"$f":"SUM(H5:H14)","v":15},{"$f":"SUM(I5:I14)","v":9}]
[]
[null,null,null,null,"Matches Played",null,{"$f":"COUNT(G5:G16)","v":10}]
[]
[null,null,null,null,"How many matches did we score in?",null,null,{"$f":"COUNTIF(H5:H14, \">0\")","v":7}]
[null,null,null,null,"How many clean sheets did we have?"]

{"sheet":"Graphs","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Graphing Data"]
[]
[null,"1. Excel is very good at graphing data"]
[null,"2. This is a table of rainfall over last month in Exeter"]
[]
[null,"Date","mm Rain"]
[null,"01/11/2025",0]
[null,"02/11/2025",2.4]
[null,"03/11/2025",4.5999999999999996]
[null,"04/11/2025",0]
[null,"05/11/2025",3.2]
[null,"06/11/2025",7.8]
[null,"07/11/2025",5]
[null,"08/11/2025",10.4]
[null,"09/11/2025",6]
[null,"10/11/2025",0]
[null,"11/11/2025",5.6]
[null,"12/11/2025",23]
[null,"13/11/2025",0]
[null,"14/11/2025",8.9]
[null,"15/11/2025",6.3]
[null,"16/11/2025",0]
[null,"17/11/2025",0]
[null,"18/11/2025",3.7]
[null,"19/11/2025",0]
[null,"20/11/2025",12.1]
[null,"21/11/2025",0]
[null,"22/11/2025",4]
[null,"23/11/2025",0,null,"3. Change some of the data in column C and see it reflected in the graph"]
[null,"24/11/2025",0.6]
[null,"25/11/2025",2.8]
[null,"26/11/2025",0]
[null,"27/11/2025",9.5]
[null,"28/11/2025",0]
[null,"29/11/2025",7.2]
[null,"30/11/2025",0]

{"sheet":"RandomPassword","index":4,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Part 3: Stuff you can't do in formulae"]
[]
[null,"1. There are thousands of functions in Excel (click on the",null,null,null,null,null,null,"dropdown to see how many"]
[null,"2. But sometimes you need to poke underneath the hood of Excel and code it in Visual Basic for Applications"]
[null,"3. If the Developer tab is not already shown, click File and select Options down at the bottom"]
[null,"4. Then select \"Customise Ribbon\" and select the \"Developer\" box which will be unticked"]
[null,"on the right hand window"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5. Clicking on \"Visual Basic\" will show you the IDE for VBA in which you can see some functions."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"8 letter random password"]
[null,"6. We can call a function from a cell. The formula in J38 calls the",null,null,null,null,null,null,null,{"$f":"RandomPassword(8)","v":"ujmTTzAy"}]
[null,"RandomPassword() function"]
[null,"7. But even cooler, we can set the length of the function",null,null,null,null,null,null,null,"Random Password",7,"letters long"]
[null,"in a cell and it will update the password",null,null,null,null,null,null,null,{"$f":"RandomPassword(K40)","v":"IAjrj2F"}]
[]
[null,null,null,null,null,null,null,null,null,"length of password is",{"$f":"LEN(J41)","v":7},"characters"]

{"sheet":"Stock Data","index":5,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"5. Getting Data from Elsewhere"]
[]
[null,null,null,null,null,"1. You can import data from Access, or a CSV file or a text file, but one"]
[null,null,null,null,null,"really cool feature to to be able to grab data directly from a data source"]
[null,"Field","Value",null,null,"2. This Sheet has a button which opens up a form and enables the user"]
[null,"Symbol","BBY.LON",null,null,"to select any one of the FTSE250 Companies and see their share price"]
[null,"Open",702,null,null,"yesterday."]
[null,"High",702.15,null,null,"3. It is possible to get this data in real time but that costs a lot of money"]
[null,"Low",682,null,null,"To get yesterday's data is free."]
[null,"Price",697]
[null,"Volume",1017364]
[null,"Latest Trading Day","2025-12-01"]
[null,"Previous Close",704]
[null,"Change",-7]
[null,"Change Percent",-9.9430000000000004E-3]

{"sheet":"Primes","index":6,"n_rows":107,"n_cols":8,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
[]
[null,"6. Determining Prime Numbers"]
[null,"1. Working our prime numbers is hard: you have to check each number against all the others."]
[null,"2. It is really hard in an excel formula, so we use code to process the data and see if the number is prime."]
[]
[null,null,null,null,"Is Prime?"]
[null,"First 100 numbers:",null,"Column1","Column2",null,"Number of Primes"]
[null,null,null,1,{"$f":"IsPrime(D8)","v":false},null,"under 100 is",{"$f":"COUNTIF(Table5[Column2], \"TRUE\")","v":25}]
[null,null,null,2,{"$f":"IsPrime(D9)","v":true}]
[null,null,null,3,{"$f":"IsPrime(D10)","v":true}]
[null,null,null,4,{"$f":"IsPrime(D11)","v":false}]
[null,null,null,5,{"$f":"IsPrime(D12)","v":true}]
[null,null,null,6,{"$f":"IsPrime(D13)","v":false}]
[null,null,null,7,{"$f":"IsPrime(D14)","v":true}]
[null,null,null,8,{"$f":"IsPrime(D15)","v":false}]
[null,null,null,9,{"$f":"IsPrime(D16)","v":false}]
[null,null,null,10,{"$f":"IsPrime(D17)","v":false}]
[null,null,null,11,{"$f":"IsPrime(D18)","v":true}]
[null,null,null,12,{"$f":"IsPrime(D19)","v":false}]
[null,null,null,13,{"$f":"IsPrime(D20)","v":true}]
[null,null,null,14,{"$f":"IsPrime(D21)","v":false}]
[null,null,null,15,{"$f":"IsPrime(D22)","v":false}]
[null,null,null,16,{"$f":"IsPrime(D23)","v":false}]
[null,null,null,17,{"$f":"IsPrime(D24)","v":true}]
[null,null,null,18,{"$f":"IsPrime(D25)","v":false}]
[null,null,null,19,{"$f":"IsPrime(D26)","v":true}]
[null,null,null,20,{"$f":"IsPrime(D27)","v":false}]
[null,null,null,21,{"$f":"IsPrime(D28)","v":false}]
[null,null,null,22,{"$f":"IsPrime(D29)","v":false}]
[null,null,null,23,{"$f":"IsPrime(D30)","v":true}]
[null,null,null,24,{"$f":"IsPrime(D31)","v":false}]
[null,null,null,25,{"$f":"IsPrime(D32)","v":false}]
[null,null,null,26,{"$f":"IsPrime(D33)","v":false}]
[null,null,null,27,{"$f":"IsPrime(D34)","v":false}]
[null,null,null,28,{"$f":"IsPrime(D35)","v":false}]
[null,null,null,29,{"$f":"IsPrime(D36)","v":true}]
[null,null,null,30,{"$f":"IsPrime(D37)","v":false}]
[null,null,null,31,{"$f":"IsPrime(D38)","v":true}]
[null,null,null,32,{"$f":"IsPrime(D39)","v":false}]
[null,null,null,33,{"$f":"IsPrime(D40)","v":false}]
[null,null,null,34,{"$f":"IsPrime(D41)","v":false}]
[null,null,null,35,{"$f":"IsPrime(D42)","v":false}]
[null,null,null,36,{"$f":"IsPrime(D43)","v":false}]
[null,null,null,37,{"$f":"IsPrime(D44)","v":true}]
[null,null,null,38,{"$f":"IsPrime(D45)","v":false}]
[null,null,null,39,{"$f":"IsPrime(D46)","v":false}]
[null,null,null,40,{"$f":"IsPrime(D47)","v":false}]
[null,null,null,41,{"$f":"IsPrime(D48)","v":true}]
[null,null,null,42,{"$f":"IsPrime(D49)","v":false}]
[null,null,null,43,{"$f":"IsPrime(D50)","v":true}]
[null,null,null,44,{"$f":"IsPrime(D51)","v":false}]
[null,null,null,45,{"$f":"IsPrime(D52)","v":false}]
[null,null,null,46,{"$f":"IsPrime(D53)","v":false}]
[null,null,null,47,{"$f":"IsPrime(D54)","v":true}]
[null,null,null,48,{"$f":"IsPrime(D55)","v":false}]
[null,null,null,49,{"$f":"IsPrime(D56)","v":false}]
[null,null,null,50,{"$f":"IsPrime(D57)","v":false}]
[null,null,null,51,{"$f":"IsPrime(D58)","v":false}]
[null,null,null,52,{"$f":"IsPrime(D59)","v":false}]
[null,null,null,53,{"$f":"IsPrime(D60)","v":true}]
[null,null,null,54,{"$f":"IsPrime(D61)","v":false}]
[null,null,null,55,{"$f":"IsPrime(D62)","v":false}]
[null,null,null,56,{"$f":"IsPrime(D63)","v":false}]
[null,null,null,57,{"$f":"IsPrime(D64)","v":false}]
[null,null,null,58,{"$f":"IsPrime(D65)","v":false}]
[null,null,null,59,{"$f":"IsPrime(D66)","v":true}]
[null,null,null,60,{"$f":"IsPrime(D67)","v":false}]
[null,null,null,61,{"$f":"IsPrime(D68)","v":true}]
[null,null,null,62,{"$f":"IsPrime(D69)","v":false}]
[null,null,null,63,{"$f":"IsPrime(D70)","v":false}]
[null,null,null,64,{"$f":"IsPrime(D71)","v":false}]
[null,null,null,65,{"$f":"IsPrime(D72)","v":false}]
[null,null,null,66,{"$f":"IsPrime(D73)","v":false}]
[null,null,null,67,{"$f":"IsPrime(D74)","v":true}]
[null,null,null,68,{"$f":"IsPrime(D75)","v":false}]
[null,null,null,69,{"$f":"IsPrime(D76)","v":false}]
[null,null,null,70,{"$f":"IsPrime(D77)","v":false}]
[null,null,null,71,{"$f":"IsPrime(D78)","v":true}]
[null,null,null,72,{"$f":"IsPrime(D79)","v":false}]
[null,null,null,73,{"$f":"IsPrime(D80)","v":true}]
[null,null,null,74,{"$f":"IsPrime(D81)","v":false}]
[null,null,null,75,{"$f":"IsPrime(D82)","v":false}]
[null,null,null,76,{"$f":"IsPrime(D83)","v":false}]
[null,null,null,77,{"$f":"IsPrime(D84)","v":false}]
[null,null,null,78,{"$f":"IsPrime(D85)","v":false}]
[null,null,null,79,{"$f":"IsPrime(D86)","v":true}]
[null,null,null,80,{"$f":"IsPrime(D87)","v":false}]
[null,null,null,81,{"$f":"IsPrime(D88)","v":false}]
[null,null,null,82,{"$f":"IsPrime(D89)","v":false}]
[null,null,null,83,{"$f":"IsPrime(D90)","v":true}]
[null,null,null,84,{"$f":"IsPrime(D91)","v":false}]
[null,null,null,85,{"$f":"IsPrime(D92)","v":false}]
[null,null,null,86,{"$f":"IsPrime(D93)","v":false}]
[null,null,null,87,{"$f":"IsPrime(D94)","v":false}]
[null,null,null,88,{"$f":"IsPrime(D95)","v":false}]
[null,null,null,89,{"$f":"IsPrime(D96)","v":true}]
[null,null,null,90,{"$f":"IsPrime(D97)","v":false}]
[null,null,null,91,{"$f":"IsPrime(D98)","v":false}]
[null,null,null,92,{"$f":"IsPrime(D99)","v":false}]
[null,null,null,93,{"$f":"IsPrime(D100)","v":false}]
[null,null,null,94,{"$f":"IsPrime(D101)","v":false}]
[null,null,null,95,{"$f":"IsPrime(D102)","v":false}]
[null,null,null,96,{"$f":"IsPrime(D103)","v":false}]
[null,null,null,97,{"$f":"IsPrime(D104)","v":true}]
[null,null,null,98,{"$f":"IsPrime(D105)","v":false}]
[null,null,null,99,{"$f":"IsPrime(D106)","v":false}]
[null,null,null,100,{"$f":"IsPrime(D107)","v":false}]

{"sheet":"Staff Notes","index":7,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Protection Password",null,"excelboss"]