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

{"sheet":"Excel TNA Introduction","index":0,"n_rows":73,"n_cols":5,"rows_kept":73,"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],[24,1,24,2],[27,1,27,2],[31,1,31,2],[34,1,34,2],[37,1,37,2],[43,1,43,2],[48,1,48,2],[52,1,52,2],[56,1,56,2],[72,1,74,4]]}
["ATI-Mirage Training Solutions"]
["EXCEL - Introduction - Training Needs Analysis (TNA)"]
[]
["Name:"]
["Organisation Name:"]
["Department:"]
["Telephone:"]
["Mobile :"]
["Email:"]
[]
[null,"Please choose one response that most accurately describes your knowledge level for each topic. This is not a test, therefore your responses will address your training needs for the level that you are at."]
[]
[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"},"What is Excel?"]
[null,{"$f":"IF(ISBLANK(C17),\" \",1)","v":1},"Understand the functionality of a spreadsheet application ",null,{"$f":"IF($D$16=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C18),\"\",B17+1)","v":2},"Familiarity the different elements of the Excel screen",null,{"$f":"IF($D$16=\"All\",$B$70,$B$71)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B19),\"\",\"B\")","v":"B"},"Creating a Workbook"]
[null,{"$f":"IF(ISBLANK(C20),\"\",B18+1)","v":3},"Create a new workbook ",null,{"$f":"IF($D$19=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C21),\"\",B20+1)","v":4},"Move around the worksheet using the mouse and keyboard ",null,{"$f":"IF($D$19=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C22),\"\",B21+1)","v":5},"Select cells using the mouse and the keyboard ",null,{"$f":"IF($D$19=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,6,"Use the Zoom controls",null,{"$f":"IF($D$19=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,7,"Use Undo and Redo",null,{"$f":"IF($D$19=\"All\",$B$70,$B$71)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B25),\"\",\"C\")","v":"C"},"Entering and Editing Data"]
[null,{"$f":"IF(ISBLANK(C26),\"\",B24+1)","v":8},"Enter text, values, and dates in cells ",null,{"$f":"IF($D$25=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C27),\"\",B26+1)","v":9},"Edit cells",null,{"$f":"IF($D$25=\"All\",$B$70,$B$71)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B28),\"\",\"D\")","v":"D"},"Creating a Formula"]
[null,{"$f":"IF(ISBLANK(C29),\"\",B27+1)","v":10},"Understand formulae and create simple calculations ",null,{"$f":"IF($D$28=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C30),\"\",B29+1)","v":11},"Use AutoSum to add numbers",null,{"$f":"IF($D$28=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C31),\"\",B30+1)","v":12},"Create simple calculations in Excel",null,"click to select value"]
[{"$f":"IF(ISBLANK(B32),\"\",\"E\")","v":"E"},"Moving and Copying Data"]
[null,{"$f":"IF(ISBLANK(C33),\"\",B31+1)","v":13},"Use the AutoFill tool",null,{"$f":"IF($D$32=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C34),\"\",B33+1)","v":14},"Use Cut and copy in Excel",null,{"$f":"IF($D$32=\"All\",$B$70,$B$71)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B35),\"\",\"F\")","v":"F"},"Editing a Formula"]
[null,{"$f":"IF(ISBLANK(C36),\"\",B34+1)","v":15},"Use Insert Function dialog box",null,{"$f":"IF($D$35=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C37),\"\",B36+1)","v":16},"Use basic arithmetic functions Sum, Average, Count, Min, Max)",null,{"$f":"IF($D$35=\"All\",$B$70,$B$71)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B38),\"\",\"G\")","v":"G"},"Formatting Cells"]
[null,{"$f":"IF(ISBLANK(C39),\"\",B37+1)","v":17},"Apply  formatting (currency, percentage, date, comma)",null,{"$f":"IF($D$38=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C40),\"\",B39+1)","v":18},"Apply font styles (typeface, size, colour, enhancements)",null,{"$f":"IF($D$38=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C41),\"\",B40+1)","v":19},"Modify vertical and horizontal alignment of cell contents",null,{"$f":"IF($D$38=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,20,"Merge and unmerge cells",null,{"$f":"IF($D$38=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,21,"Use the Format Painter to copy cell formats",null,{"$f":"IF($D$38=\"All\",$B$70,$B$71)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B44),\"\",\"H\")","v":"H"},"Working with a Worksheet"]
[null,{"$f":"IF(ISBLANK(C45),\"\",B43+1)","v":22},"Modify the size of columns and rows",null,{"$f":"IF($D$44=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C46),\"\",B45+1)","v":23},"Insert and delete rows and columns",null,{"$f":"IF($D$44=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,24,"Hide and Unhide Rows and Columns",null,{"$f":"IF($D$44=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,25,"Insert and delete selected cells",null,{"$f":"IF($D$44=\"All\",$B$70,$B$71)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B49),\"\",\"I\")","v":"I"},"Page Layout"]
[null,{"$f":"IF(ISBLANK(C50),\"\",B48+1)","v":26},"Change paper size and orientation",null,{"$f":"IF($D$49=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C51),\"\",B50+1)","v":27},"Set page margins and alignment",null,{"$f":"IF($D$49=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,28,"Set up headers and footers",null,{"$f":"IF($D$49=\"All\",$B$70,$B$71)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B53),\"\",\"J\")","v":"J"},"Printing and Print Preview"]
[null,{"$f":"IF(ISBLANK(C54),\"\",B52+1)","v":29},"Print a worksheet",null,{"$f":"IF($D$53=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C55),\"\",B54+1)","v":30},"Print a selection",null,{"$f":"IF($D$53=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,31,"Set Printing options",null,{"$f":"IF($D$53=\"All\",$B$70,$B$71)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B57),\"\",\"K\")","v":"K"},"Charting"]
[null,{"$f":"IF(ISBLANK(C58),\"\",B56+1)","v":32},"Use the Chart Wizard to create different chart types",null,{"$f":"IF($D$57=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C59),\"\",B58+1)","v":33},"Move, resize a chart",null,{"$f":"IF($D$57=\"All\",$B$70,$B$71)","v":"click to select value"}]
[null,34,"Change the chart type",null,"click to select value"]
[null,35,"Print a chart",null,"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$62,No_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C67/COUNTA($E$17:$E$61))","v":{"v":0,"d":"0.00%"}}]
[null,"Basic Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$62,Basic_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C68/COUNTA($E$17:$E$61))","v":{"v":0,"d":"0.00%"}}]
[null,"Good Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$62,Good_Knowledge))","v":0},{"v":0,"d":"0.00%"}]
[null,"Expert",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$62,Expert))","v":0},{"v":0,"d":"0.00%"}]
[null,"click to select value",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$62,click_to_select_value))","v":35},{"v":1,"d":"100.00%"}]
[null,{"v":0.6,"d":"60%"}]
[null,{"$f":"IF(C71>0,\"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells\",IF(OR(D67>=CriteriaToPass,(D67+D68)>=CriteriaToPass),\"We suggest that you do the Introduction course\",\"Based on your response you have good knowledge of Introductory Excel concepts, we suggest that you do the Intermediate TNA, to check if you would be comfortable doing the Intermediate Course\"))","v":"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells"}]