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

{"sheet":"Word Advanced TNA","index":0,"n_rows":112,"n_cols":5,"rows_kept":112,"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],[21,1,21,2],[26,1,26,2],[30,1,30,2],[34,1,34,2],[43,1,43,2],[48,1,48,2],[55,1,55,2],[69,1,69,2],[74,1,74,2],[78,1,78,2],[82,1,82,2],[87,1,87,2],[94,1,94,2],[111,1,113,4]]}
["ATI-Mirage Training Solutions"]
["Word Advanced - Training Needs Analysis (TNA)"]
[]
["Name:",null," "]
["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.  Your answers will give you an indicator of your current knowledge. This will help you to decide which course to attend."]
[]
[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"},"Formatting Word Documents"]
[null,{"$f":"IF(ISBLANK(C17),\" \",1)","v":1},"Use Page Breaks and Section Breaks",null,{"$f":"IF($D$16=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C18),\"\",B17+1)","v":2},"Use multiple columns in a document",null,{"$f":"IF($D$16=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C19),\"\",B18+1)","v":3},"Use and set up Headers and Footers",null,{"$f":"IF($D$16=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C20),\"\",B19+1)","v":4},"Create Tables in Word",null,{"$f":"IF($D$16=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C21),\"\",B20+1)","v":5},"Control text flow and set up level paragraph formatting",null,{"$f":"IF($D$16=\"All\",$B$109,$B$110)","v":"click to select value"}]
["B","Document Formatting with Styles"]
[null,{"$f":"IF(ISBLANK(C23),\"\",B21+1)","v":6},"Apply and use styles ( Heading 1, Heading 2)",null,{"$f":"IF($D$22=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C24),\"\",B23+1)","v":7},"Use Styles to format a document",null,{"$f":"IF($D$22=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C25),\"\",B24+1)","v":8},"Create and Modify Styles",null,{"$f":"IF($D$22=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C26),\"\",B25+1)","v":9},"Manage Styles",null,{"$f":"IF($D$22=\"All\",$B$109,$B$110)","v":"click to select value"}]
["C","Templates"]
[null,{"$f":"IF(ISBLANK(C28),\"\",B26+1)","v":10},"Create a Template",null,{"$f":"IF($D$27=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C29),\"\",B28+1)","v":11},"Create a new Files based on a template",null,{"$f":"IF($D$27=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C30),\"\",B29+1)","v":12},"Edit a Template",null,{"$f":"IF($D$27=\"All\",$B$109,$B$110)","v":"click to select value"}]
["D","Fields in Word"]
[null,{"$f":"IF(ISBLANK(C32),\"\",B30+1)","v":13},"Inserted and used fields in Words",null,{"$f":"IF($D$31=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C33),\"\",B32+1)","v":14},"Updated fields in a Word document",null,{"$f":"IF($D$31=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C34),\"\",B33+1)","v":15},"Edited and customised fields",null,{"$f":"IF($D$31=\"All\",$B$109,$B$110)","v":"click to select value"}]
["E","Mail Merge"]
[null,{"$f":"IF(ISBLANK(C36),\"\",B34+1)","v":16},"Use the Mail Merge Wizard",null,{"$f":"IF($D$35=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C37),\"\",B36+1)","v":17},"Filter records for a mail merge",null,{"$f":"IF($D$35=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C38),\"\",B37+1)","v":18},"Insert merge fields",null,{"$f":"IF($D$35=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C39),\"\",B38+1)","v":19},"Create and add data to a merge data source",null,{"$f":"IF($D$35=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,20,"Merge techniques sort and filter recipients",null,{"$f":"IF($D$35=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,21,"Working with envelopes and labels",null,{"$f":"IF($D$35=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,22,"Use Merge Rules to apply decision making to a Merge",null,{"$f":"IF($D$35=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,23,"Use IF then Else in a Merge",null,{"$f":"IF($D$35=\"All\",$B$109,$B$110)","v":"click to select value"}]
["F","Working with Large Documents"]
[null,{"$f":"IF(ISBLANK(C45),\"\",B43+1)","v":24},"Use the Outline view",null,{"$f":"IF($D$44=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C46),\"\",B45+1)","v":25},"Creating Master and Subdocuments",null,{"$f":"IF($D$44=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C47),\"\",B46+1)","v":26},"Use sections to structure the layout of a document",null,{"$f":"IF($D$44=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,27,"Importing files from other applications",null,{"$f":"IF($D$44=\"All\",$B$109,$B$110)","v":"click to select value"}]
["G","Document Enhancements"]
[null,{"$f":"IF(ISBLANK(C50),\"\",B48+1)","v":28},"Add or create a Cover Page",null,{"$f":"IF($D$49=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C51),\"\",B50+1)","v":29},"Save a Cover Page as a Building Block",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C52),\"\",B51+1)","v":30},"Insert Pictures and images",null,"click to select value"]
[null,31,"Format and modify graphics",null,"click to select value"]
[null,32,"Using WordArt and 3D and Shadow text effects",null,"click to select value"]
[null,33,"Working with drawing tools, text boxes and Auto shapes",null,"click to select value"]
["H","References"]
[null,{"$f":"IF(ISBLANK(C57),\"\",B55+1)","v":34},"Add Bookmarks to a Document",null,{"$f":"IF($D$56=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C58),\"\",B57+1)","v":35},"Use Bookmarks to navigate a document",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C59),\"\",B58+1)","v":36},"Inserting Footnotes and Endnotes",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C60),\"\",B59+1)","v":37},"Modifying Footnotes and Endnotes",null,"click to select value"]
[null,38,"Insert and modify and Comments",null,"click to select value"]
[null,39,"Compile a Table Of Contents",null,"click to select value"]
[null,40,"Modifying and Updating a Table Of Contents",null,"click to select value"]
[null,41,"Compile an Index",null,"click to select value"]
[null,42,"Marking Index items",null,"click to select value"]
[null,43,"Inserting and Updating an Index",null,"click to select value"]
[null,44,"Inserting Hyperlinks in a document",null,"click to select value"]
[null,45,"Linking documents using Hyperlinks",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C69),\"\",B68+1)","v":46},"Adding Captions to Pictures and Tables",null,"click to select value"]
["I","SmartArt"]
[null,{"$f":"IF(ISBLANK(C71),\"\",B69+1)","v":47},"Insert SmartArt",null,{"$f":"IF($D$70=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C72),\"\",B71+1)","v":48},"Adding text to SmartArt",null,{"$f":"IF($D$70=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C73),\"\",B72+1)","v":49},"Format SmartArt"," ",{"$f":"IF($D$70=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,50,"Modify SmartArt",null,{"$f":"IF($D$70=\"All\",$B$109,$B$110)","v":"click to select value"}]
["J","Text Boxes"]
[null,{"$f":"IF(ISBLANK(C76),\"\",B74+1)","v":51},"Inserting Text boxes",null,{"$f":"IF($D$75=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C77),\"\",B76+1)","v":52},"Add a Text box as Building Block",null,{"$f":"IF($D$75=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C78),\"\",B77+1)","v":53},"Adjusting size and position of a Text Box"," ","click to select value"]
["K","Importing into Word"]
[null,{"$f":"IF(ISBLANK(C80),\"\",B78+1)","v":54},"Importing Text into Word",null,{"$f":"IF($D$79=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C81),\"\",B80+1)","v":55},"Importing Excel data into Word",null,{"$f":"IF($D$79=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C82),\"\",B81+1)","v":56},"Linking and embedding data into Word",null,"click to select value"]
["L","Protecting Documents"]
[null,{"$f":"IF(ISBLANK(C84),\"\",B82+1)","v":57},"Make a document read only",null,{"$f":"IF($D$83=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C85),\"\",B84+1)","v":58},"Protect a document with restricted formatting",null,{"$f":"IF($D$83=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C86),\"\",B85+1)","v":59},"Protect sections of a document"," ","click to select value"]
[null,60,"Protect a document for forms, tracking or comments",null,"click to select value"]
["M","Electronic Forms"]
[null,{"$f":"IF(ISBLANK(C89),\"\",B87+1)","v":61},"Create Electronic Forms with fields",null,{"$f":"IF($D$88=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C90),\"\",B89+1)","v":62},"Create Electronic Forms with controls",null,{"$f":"IF($D$88=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C91),\"\",B90+1)","v":63},"Add Controls to a document"," ","click to select value"]
[null,64,"Using formulae with controls on a form",null,"click to select value"]
[null,65,"Adding content controls",null,"click to select value"]
[null,66,"Protect sections of electronic forms",null,"click to select value"]
["N","Automating Documents"]
[null,{"$f":"IF(ISBLANK(C96),\"\",B94+1)","v":67},"Use macros in Word",null,{"$f":"IF($D$95=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C97),\"\",B96+1)","v":68},"Recorded simple macro in Word",null,{"$f":"IF($D$95=\"All\",$B$109,$B$110)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C98),\"\",B97+1)","v":69},"Edited a macro"," ","click to select value"]
[null,70,"Assigned a macro to a object",null,"click to select value"]
[null,71,"Customise the QAT, Tabs and keyboard shortcuts",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$101,No_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C106/COUNTA($E$17:$E$100))","v":{"v":0,"d":"0.00%"}}]
[null,"Basic Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$101,Basic_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C107/COUNTA($E$17:$E$100))","v":{"v":0,"d":"0.00%"}}]
[null,"Good Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$101,Good_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C108/COUNTA($E$17:$E$100))","v":{"v":0,"d":"0.00%"}}]
[null,"Expert",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$101,Expert))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C109/COUNTA($E$17:$E$100))","v":{"v":0,"d":"0.00%"}}]
[null,"click to select value",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$101,click_to_select_value))","v":71},{"$f":"IF(ISBLANK($E$17),\"\",C110/COUNTA($E$17:$E$100))","v":{"v":1,"d":"100.00%"}}]
[null,{"v":0.75,"d":"75%"}]
[null,{"$f":"IF(ISBLANK($C$4),\"\",IF(OR($D$106>=CriteriaToPass,($D$107+$D$106)>=CriteriaToPass),\"We suggest that you do the Intermediate course\",IF($D$109>80%,\"Based on your response you have good knowledge of Advanced  concepts, we suggest that you do the VBA TNA, to check if you would be comfortable doing the VBA Course\",\"Based on your responses you have  knowledge of some Advanced  concepts, we suggest that you do the  Advanced Course\")))","v":"Based on your responses you have  knowledge of some Advanced  concepts, we suggest that you do the  Advanced Course"}]