{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Excel TNA Intermediate"],"not_rendered":{"charts":1,"images":2,"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"Excel TNA Intermediate","index":0,"n_rows":104,"n_cols":5,"rows_kept":104,"merged":[[0,0,0,4],[1,0,1,4],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[10,1,11,4],[12,1,12,4],[15,1,15,2],[18,1,18,2],[22,1,22,2],[27,1,27,2],[33,1,33,2],[37,1,37,2],[41,1,41,2],[44,1,44,2],[50,1,50,2],[55,1,55,2],[59,1,59,2],[63,1,63,2],[67,1,67,2],[72,1,72,2],[77,1,77,2],[82,1,82,2],[87,1,87,2],[103,1,105,4]]}
["ATI-Mirage Training Solutions"]
["EXCEL - Intermediate - Training Needs Analysis (TNA)"]
[]
["Name:"]
["Organisation Name:"]
["Department:"]
["Telephone:"]
["Mobile :"]
["Email:"]
[]
[null,"Please choose one response that most accurately describes your knowledge for each topic. \nThis is not a test, therefore your responses will address your training needs for the level that you are at.\nIf you want to keep a copy please save the file with a name of your choice"]
[]
[null,"Use the Blue Coloured cells if you know all of a Section, otherwise click the yellow cell to select an option"]
[]
[null,"Section","Question","ALL","Response"]
[{"$f":"IF(ISBLANK(B16),\"\",\"A\")","v":"A"},"Using AutoFill"]
[null,{"$f":"IF(ISBLANK(C17),\" \",1)","v":1},"Use Autofill for number, days and month series (Jan,Feb,Mar)",null,{"$f":"IF($D$16=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C18),\"\",B17+1)","v":2},"Can use the mouse to select cells, and move cells",null,{"$f":"IF($D$16=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B19),\"\",\"B\")","v":"B"},"Linking Workbooks with calculations"]
[null,{"$f":"IF(ISBLANK(C20),\"\",B18+1)","v":3},"Create calculations using cells from other sheets or files",null,{"$f":"IF($D$19=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C21),\"\",B20+1)","v":4},"Create links between different worksheets and workbooks",null,{"$f":"IF($D$19=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C22),\"\",B21+1)","v":5},"Edit, update and fix links",null,{"$f":"IF($D$19=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B23),\"\",\"B\")","v":"B"},"Absolute References and Calculations "]
[null,{"$f":"IF(ISBLANK(C24),\"\",B22+1)","v":6},"Can use the AutoSum \"∑\" to add columns of numbers  ",null,{"$f":"IF($D$23=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C25),\"\",B24+1)","v":7},"Use cell references in calculations, e.g. \"=A1*A2\"",null,{"$f":"IF($D$23=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C26),\"\",B25+1)","v":8},"Use Absolute and Relative references: e.g. \"=$A$1*A2\"",null,{"$f":"IF($D$23=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C27),\"\",B26+1)","v":9},"Trace cell Precedent and Dependents",null,{"$f":"IF($D$23=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B28),\"\",\"C\")","v":"C"},"General Excel Usage"]
[null,{"$f":"IF(ISBLANK(C29),\"\",B27+1)","v":10},"Familiarity with ribbon, and location of commands on tabs",null,{"$f":"IF($D$28=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C30),\"\",B29+1)","v":11},"Can correctly enter: dates; numbers; time; text",null,{"$f":"IF($D$28=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C31),\"\",B30+1)","v":12},"Can use \"=\" sign to create calculations in Excel",null,{"$f":"IF($D$28=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C32),\"\",B31+1)","v":13},"Can safely open; close files and use save and use save as",null,{"$f":"IF($D$28=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C33),\"\",B32+1)","v":14},"Can change contents of a cells and do basic formatting",null,{"$f":"IF($D$28=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B34),\"\",\"D\")","v":"D"},"Working with labels and Names"]
[null,{"$f":"IF(ISBLANK(C35),\"\",B33+1)","v":15},"Can create a name for a cell or a range of cells",null,{"$f":"IF($D$34=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C36),\"\",B35+1)","v":16},"Have used a named cell in formulae",null,{"$f":"IF($D$34=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C37),\"\",B36+1)","v":17},"Can edit a named Range",null,{"$f":"IF($D$34=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B38),\"\",\"E\")","v":"E"},"Logical Functions"]
[null,{"$f":"IF(ISBLANK(C39),\"\",B37+1)","v":18},"Have used the IF function in Excel",null,{"$f":"IF($D$38=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C40),\"\",B39+1)","v":19},"Nesting an IF function within a formula",null,{"$f":"IF($D$38=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C41),\"\",B40+1)","v":20},"Using the AND, OR and NOT functions",null,{"$f":"IF($D$38=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B42),\"\",\"F\")","v":"F"},"Lookup Functions"]
[null,{"$f":"IF(ISBLANK(C43),\"\",B41+1)","v":21},"Have used the VLOOKUP function",null,{"$f":"IF($D$42=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C44),\"\",B43+1)","v":22},"Understand VLOOKUP for Exact matches",null,{"$f":"IF($D$42=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B45),\"\",\"G\")","v":"G"},"Data Validation"]
[null,{"$f":"IF(ISBLANK(C46),\"\",B44+1)","v":23},"Use Data Validation with numbers",null,{"$f":"IF($D$45=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C47),\"\",B46+1)","v":24},"Create Input messages, and Error alerts for data Validation",null,{"$f":"IF($D$45=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C48),\"\",B47+1)","v":25},"Creating drop down lists in data validation",null,{"$f":"IF($D$45=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,26,"Use formulae for data validation",null,{"$f":"IF($D$45=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,27,"Copy validation settings",null,{"$f":"IF($D$45=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B51),\"\",\"H\")","v":"H"},"Conditional formatting"]
[null,{"$f":"IF(ISBLANK(C52),\"\",B50+1)","v":28},"Used Conditional formatting for numbers",null,{"$f":"IF($D$51=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C53),\"\",B52+1)","v":29},"Use Top ten Items as part of conditional formatting",null,{"$f":"IF($D$51=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,30,"Use data bars, colour scales and icons",null,{"$f":"IF($D$51=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,31,"Managing and change conditional formats",null,{"$f":"IF($D$51=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B56),\"\",\"I\")","v":"I"},"Finding and Replacing"]
[null,{"$f":"IF(ISBLANK(C57),\"\",B55+1)","v":32},"Using find to locate text, cell references and values",null,{"$f":"IF($D$56=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C58),\"\",B57+1)","v":33},"Use replace",null,{"$f":"IF($D$56=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,34,"Use Go to Special to navigate a spreadsheet",null,{"$f":"IF($D$56=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B60),\"\",\"J\")","v":"J"},"Sorting Data"]
[null,{"$f":"IF(ISBLANK(C61),\"\",B59+1)","v":35},"Sorting columns within a list",null,{"$f":"IF($D$60=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C62),\"\",B61+1)","v":36},"Sorting by more than one column",null,{"$f":"IF($D$60=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,37,"Sorting by rows",null,{"$f":"IF($D$60=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B64),\"\",\"K\")","v":"K"},"Filtering data"]
[null,{"$f":"IF(ISBLANK(C65),\"\",B48+1)","v":26},"Use filters to extract a subset of data",null,{"$f":"IF($D$64=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C66),\"\",B65+1)","v":27},"Use multiple (compound) filters",null,{"$f":"IF($D$64=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,28,"Create Custom Filters",null,{"$f":"IF($D$64=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
["L","Summarise data with Subtotals"]
[null,{"$f":"IF(ISBLANK(C67),\"\",B53+1)","v":30},"Use Subtotals to analyse a list",null,{"$f":"IF($D$68=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C70),\"\",B69+1)","v":31},"Create nested Subtotals",null,{"$f":"IF($D$68=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,32,"Copy Subtotals",null,{"$f":"IF($D$68=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,33,"Use Subtotals with filters",null,{"$f":"IF($D$68=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
["M","Pivot Table Reports"]
[null,{"$f":"IF(ISBLANK(C74),\"\",B58+1)","v":34},"Create a basic Pivot table",null,{"$f":"IF($D$73=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C75),\"\",B74+1)","v":35},"Filter in a Pivot table",null,{"$f":"IF($D$73=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,36,"Pivot fields in a Pivot table",null,{"$f":"IF($D$73=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,37,"Formatting Pivot Tables",null,{"$f":"IF($D$73=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
["N","Pivot Charts"]
[null,{"$f":"IF(ISBLANK(C79),\"\",B53+1)","v":30},"Create a Pivot Chart",null,{"$f":"IF($D$78=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C80),\"\",B79+1)","v":31},"Format a Pivot Chart",null,{"$f":"IF($D$78=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,32,"Change location of Pivot Chart",null,{"$f":"IF($D$78=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,33,"Filter in a Pivot chart",null,{"$f":"IF($D$78=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
["O","Protecting Data"]
[null,{"$f":"IF(ISBLANK(C84),\"\",B58+1)","v":34},"Protecting cells",null,{"$f":"IF($D$83=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C85),\"\",B84+1)","v":35},"Protecting a worksheet",null,{"$f":"IF($D$83=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,36,"Add password to open a file",null,{"$f":"IF($D$83=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,37,"Create and use templates",null,{"$f":"IF($D$83=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
["P","Importing and Exporting data with Excel"]
[null,{"$f":"IF(ISBLANK(C89),\"\",B63+1)","v":38},"Import data into Excel",null,{"$f":"IF($D$88=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C90),\"\",B89+1)","v":39},"Working with data connections",null,{"$f":"IF($D$88=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,40,"Exporting to and from Word and Access",null,{"$f":"IF($D$88=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[null,41,"Linking data to Excel",null,{"$f":"IF($D$88=\"All\",Expert,click_to_select_value)","v":"click to select value"}]
[]
[]
[null,null,"PLEASE ENSURE THAT YOU HAVE ANSWERED ALL QUESTIONS"]
[]
[null,"Responses","Score","Percentage"]
[null,"No Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$93,No_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C98/COUNTA($E$17:$E$92))","v":{"v":0,"d":"0.00%"}}]
[null,"Basic Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$93,Basic_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C99/COUNTA($E$17:$E$92))","v":{"v":0,"d":"0.00%"}}]
[null,"Good Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$93,Good_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C100/COUNTA($E$17:$E$92))","v":{"v":0,"d":"0.00%"}}]
[null,"Expert",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$93,Expert))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C101/COUNTA($E$17:$E$92))","v":{"v":0,"d":"0.00%"}}]
[null,"click to select value",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$93,click_to_select_value))","v":60},{"$f":"IF(ISBLANK($E$17),\"\",C102/COUNTA($E$17:$E$92))","v":{"v":1,"d":"100.00%"}}]
[null,{"v":0.6,"d":"60%"},{"$f":"IF(OR(E17=No_Knowledge,E18=No_Knowledge,E24=No_Knowledge,E25=No_Knowledge,E29=No_Knowledge,E30=No_Knowledge,E31=No_Knowledge,E32=No_Knowledge),\"NYC\",\"IntroCompetency\")","v":"IntroCompetency"}]
[null,{"$f":"IF(C102>0,Not_Completed_All_Questions,IF(C103=\"NYC\",Do_Intro_Course,IF($D$101>80%,Do_Adv_Course,Do_Intermediate_Course)))","v":"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells"}]