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

{"sheet":"Access TNA Advanced","index":0,"n_rows":83,"n_cols":5,"rows_kept":83,"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],[25,1,25,2],[30,1,30,2],[34,1,34,2],[38,1,38,2],[43,1,43,2],[51,1,51,2],[55,1,55,2],[62,1,62,2],[67,1,67,2],[82,1,84,4]]}
["ATI-Mirage Training Solutions"]
["Access - Advanced - 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"},"Review of Intermediate concepts"]
[null,{"$f":"IF(ISBLANK(C17),\" \",1)","v":1},"Creating Forms in  Design View",null,{"$f":"IF($D$16=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C18),\"\",B17+1)","v":2},"Creating Queries",null,{"$f":"IF($D$16=\"All\",$B$80,$B$81)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B19),\"\",\"B\")","v":"B"},"Access-Excel Interaction"]
[null,{"$f":"IF(ISBLANK(C18),\"\",B18+1)","v":3},"Import from Excel",null,{"$f":"IF($D$19=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C17),\"\",B20+1)","v":4},"Export Data to Excel",null,{"$f":"IF($D$19=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C20),\"\",B21+1)","v":5},"Link Data to Excel",null,{"$f":"IF($D$19=\"All\",$B$80,$B$81)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B23),\"\",\"C\")","v":"C"},"Working with Multiple Workbooks"]
[null,{"$f":"IF(ISBLANK(C22),\"\",B22+1)","v":6},"Opening multiple workbooks",null,{"$f":"IF($D$23=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C21),\"\",B24+1)","v":7},"Comparing windows and files Side by Side",null,{"$f":"IF($D$23=\"All\",$B$80,$B$81)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B26),\"\",\"D\")","v":"D"},"Working with Macros"]
[null,{"$f":"IF(ISBLANK(C27),\"\",B25+1)","v":8},"Create macros",null,{"$f":"IF($D$26=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C28),\"\",B27+1)","v":9},"Saving macros",null,{"$f":"IF($D$26=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C29),\"\",B28+1)","v":10},"Automating Access processes by running macros",null,"click to select value"]
[null,11,"Using macros on Forms",null,"click to select value"]
[{"$f":"IF(ISBLANK(B31),\"\",\"E\")","v":"E"},"Controlling Macro Procedures"]
[null,{"$f":"IF(ISBLANK(C32),\"\",B30+1)","v":12},"Add actions to macros",null,{"$f":"IF($D$31=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C33),\"\",B32+1)","v":13},"Set arguments for macros",null,{"$f":"IF($D$31=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C34),\"\",B33+1)","v":14},"Using Msgbox and Inputbox tools",null,{"$f":"IF($D$31=\"All\",$B$80,$B$81)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B35),\"\",\"F\")","v":"F"},"Collaboration"]
[null,{"$f":"IF(ISBLANK(C36),\"\",B34+1)","v":15},"Sharing workbooks",null,{"$f":"IF($D$35=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C37),\"\",B36+1)","v":16},"Tracking changes",null,{"$f":"IF($D$35=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C38),\"\",B37+1)","v":17},"Adding comments",null,{"$f":"IF($D$35=\"All\",$B$80,$B$81)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B39),\"\",\"G\")","v":"G"},"Labels and Names"]
[null,{"$f":"IF(ISBLANK(C40),\"\",B38+1)","v":18},"Create Names for a Cell and a range of Cells",null,{"$f":"IF($D$39=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C41),\"\",B40+1)","v":19},"Use Named cells in Calculations",null,{"$f":"IF($D$39=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C42),\"\",B41+1)","v":20},"Managing Names",null,{"$f":"IF($D$39=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,21,"Editing and Documenting Names",null,{"$f":"IF($D$39=\"All\",$B$80,$B$81)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B44),\"\",\"H\")","v":"H"},"Advanced Form Features"]
[null,{"$f":"IF(ISBLANK(C45),\"\",B43+1)","v":22},"Setting Tab Order",null,{"$f":"IF($D$44=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C46),\"\",B45+1)","v":23},"Using bound Combo Boxes",null,"click to select value"]
[null,24,"Creating Calculated controls",null,"click to select value"]
[null,25,"Setting default values",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C49),\"\",B48+1)","v":26},"Using Macros on Forms",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C50),\"\",B49+1)","v":27}," ",null,"click to select value"]
[null,28," ",null,"click to select value"]
[{"$f":"IF(ISBLANK(B52),\"\",\"J\")","v":"J"},"Creating Navigation within Access"]
[null,{"$f":"IF(ISBLANK(C53),\"\",B51+1)","v":29},"Create Switchboards As a user interface tool",null,{"$f":"IF($D$52=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C54),\"\",B53+1)","v":30},"Create Custom Menus & Toolbars",null,{"$f":"IF($D$52=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,31,"Set Start Up Options",null,{"$f":"IF($D$52=\"All\",$B$80,$B$81)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B56),\"\",\"K\")","v":"K"},"Pivot Table Techniques"]
[null,{"$f":"IF(ISBLANK(C57),\"\",B55+1)","v":32},"Adding Multiple fields",null,{"$f":"IF($D$56=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C58),\"\",B57+1)","v":33},"Using Aggregate Functions in Pivot Tables",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C59),\"\",B58+1)","v":34},"Creating Calculated Fields in Pivot Tables",null,"click to select value"]
[null,35,"Creating Calculated Items in Pivot Tables",null,"click to select value"]
[null,36,"Use Pivot Table Options",null,"click to select value"]
[null,37,"Use Percentages in Pivot Tables",null,"click to select value"]
["L","Security Settings"]
[null,{"$f":"IF(ISBLANK(C64),\"\",B62+1)","v":38},"Set password access",null,{"$f":"IF($D$63=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C65),\"\",B64+1)","v":39},"Hiding/Unhiding Access objects",null,{"$f":"IF($D$63=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C66),\"\",B65+1)","v":40},"Encode/Decode Database file",null,{"$f":"IF($D$63=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,41,"Create a Multi-user environment",null,{"$f":"IF($D$63=\"All\",$B$80,$B$81)","v":"click to select value"}]
["M","Split a Database"]
[null,{"$f":"IF(ISBLANK(C69),\"\",B67+1)","v":42},"Use The database splitter wizard",null,{"$f":"IF($D$68=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C70),\"\",B69+1)","v":43},"Working with a Split Database",null,{"$f":"IF($D$68=\"All\",$B$80,$B$81)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C71),\"\",B70+1)","v":44},"Working with a Linked database",null,{"$f":"IF($D$68=\"All\",$B$80,$B$81)","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$72,No_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C77/COUNTA($E$17:$E$71))","v":{"v":0,"d":"0.00%"}}]
[null,"Basic Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$72,Basic_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C78/COUNTA($E$17:$E$71))","v":{"v":0,"d":"0.00%"}}]
[null,"Good Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$72,Good_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C79/COUNTA($E$17:$E$71))","v":{"v":0,"d":"0.00%"}}]
[null,"Expert",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$72,Expert))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C80/COUNTA($E$17:$E$71))","v":{"v":0,"d":"0.00%"}}]
[null,"click to select value",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$72,click_to_select_value))","v":44},{"$f":"IF(ISBLANK($E$17),\"\",C81/COUNTA($E$17:$E$71))","v":{"v":1,"d":"100.00%"}}]
[null,{"v":0.6,"d":"60%"}]
[null,{"$f":"IF(C81>0,\"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells\",IF(OR($D$63>=CriteriaToPass,($D$64+$D$63)>=CriteriaToPass),\"We suggest that you do the Intermediate course\",IF($D$66>80%,\"Based on your responses you have  knowledge of some Advanced  concepts, we suggest that you do the  Advanced Course\",\"Based on your responses you have  knowledge of some Advanced  concepts, we suggest that you do the  Advanced Course\")))","v":"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells"}]