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

{"sheet":"Excel TNA Advanced","index":0,"n_rows":125,"n_cols":5,"rows_kept":125,"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],[35,1,35,2],[39,1,39,2],[44,1,44,2],[52,1,52,2],[56,1,56,2],[63,1,63,2],[68,1,68,2],[75,1,75,2],[82,1,82,2],[87,1,87,2],[92,1,92,2],[95,1,95,2],[99,1,99,2],[103,1,103,2],[108,1,108,2],[124,1,126,4]]}
["ATI-Mirage Training Solutions"]
["EXCEL - 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},"Familiarity with Excel Intermediate topics",null,{"$f":"IF($D$16=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C18),\"\",B17+1)","v":2},"Use and create Calculations",null,{"$f":"IF($D$16=\"All\",$B$122,$B$123)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B19),\"\",\"B\")","v":"B"},"Worksheet Techniques"]
[null,{"$f":"IF(ISBLANK(C18),\"\",B18+1)","v":3},"Add, remove and copy sheets",null,{"$f":"IF($D$19=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C17),\"\",B20+1)","v":4},"Grouping sheets for editing",null,{"$f":"IF($D$19=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C20),\"\",B21+1)","v":5},"Hiding Rows and Columns",null,{"$f":"IF($D$19=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,6,"Use Freeze Rows and Columns",null,{"$f":"IF($D$19=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,7,"Use Split Windows",null,{"$f":"IF($D$19=\"All\",$B$122,$B$123)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B25),\"\",\"C\")","v":"C"},"Working with Multiple Workbooks"]
[null,{"$f":"IF(ISBLANK(C26),\"\",B24+1)","v":8},"Opening and switch between multiple workbooks",null,{"$f":"IF($D$25=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C27),\"\",B26+1)","v":9},"Comparing windows and files Side by Side",null,{"$f":"IF($D$25=\"All\",$B$122,$B$123)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B28),\"\",\"D\")","v":"D"},"Data Consolidation"]
[null,{"$f":"IF(ISBLANK(C29),\"\",B27+1)","v":10},"Use Data Consolidation",null,{"$f":"IF($D$28=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C30),\"\",B29+1)","v":11},"Consolidate data with identical and different layouts",null,{"$f":"IF($D$28=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C31),\"\",B30+1)","v":12},"Consolidate data with linking",null,{"$f":"IF($D$28=\"All\",$B$122,$B$123)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B32),\"\",\"E\")","v":"E"},"Grouping and Outlining"]
[null,{"$f":"IF(ISBLANK(C33),\"\",B31+1)","v":13},"Use Grouping and Automatic Outline",null,{"$f":"IF($D$32=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C34),\"\",B33+1)","v":14},"Create Manual Grouping",null,{"$f":"IF($D$32=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C35),\"\",B34+1)","v":15},"Work with grouping and outlining levels",null,{"$f":"IF($D$32=\"All\",$B$122,$B$123)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B36),\"\",\"F\")","v":"F"},"Collaboration"]
[null,{"$f":"IF(ISBLANK(C37),\"\",B35+1)","v":16},"Sharing workbooks",null,{"$f":"IF($D$36=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C38),\"\",B37+1)","v":17},"Tracking changes",null,{"$f":"IF($D$36=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C39),\"\",B38+1)","v":18},"Adding comments",null,{"$f":"IF($D$36=\"All\",$B$122,$B$123)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B40),\"\",\"G\")","v":"G"},"Labels and Names"]
[null,{"$f":"IF(ISBLANK(C41),\"\",B39+1)","v":19},"Create Names for a Cell and a range of Cells",null,{"$f":"IF($D$40=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C42),\"\",B41+1)","v":20},"Use Named cells in Calculations",null,{"$f":"IF($D$40=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C43),\"\",B42+1)","v":21},"Managing Names",null,{"$f":"IF($D$40=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,22,"Editing and Documenting Names",null,{"$f":"IF($D$40=\"All\",$B$122,$B$123)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B45),\"\",\"H\")","v":"H"},"Tables"]
[null,{"$f":"IF(ISBLANK(C46),\"\",B44+1)","v":23},"Create a Worksheet Table",null,{"$f":"IF($D$45=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C47),\"\",B46+1)","v":24},"Add and Remove records from a Table",null,{"$f":"IF($D$45=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,25,"Remove Duplicates in a Table",null,{"$f":"IF($D$45=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,26,"Sort Table data",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C50),\"\",B49+1)","v":27},"Filter Table data",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C51),\"\",B50+1)","v":28},"Format a table",null,"click to select value"]
[null,29,"Change and modify a Table's structure",null,"click to select value"]
[{"$f":"IF(ISBLANK(B53),\"\",\"J\")","v":"J"},"Pivot Tables"]
[null,{"$f":"IF(ISBLANK(C54),\"\",B52+1)","v":30},"Create Pivot Table Shell",null,{"$f":"IF($D$53=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C55),\"\",B54+1)","v":31},"Add Fields to a Pivot Tables",null,{"$f":"IF($D$53=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,32,"Format a Pivot Table",null,{"$f":"IF($D$53=\"All\",$B$122,$B$123)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B57),\"\",\"K\")","v":"K"},"Pivot Table Techniques"]
[null,{"$f":"IF(ISBLANK(C58),\"\",B56+1)","v":33},"Adding Multiple fields",null,{"$f":"IF($D$57=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C59),\"\",B58+1)","v":34},"Using Aggregate Functions in Pivot Tables",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C60),\"\",B59+1)","v":35},"Creating Calculated Fields in Pivot Tables",null,"click to select value"]
[null,36,"Creating Calculated Items in Pivot Tables",null,"click to select value"]
[null,37,"Use Pivot Table Options",null,"click to select value"]
[null,38,"Use Percentages in Pivot Tables",null,"click to select value"]
["L","Pivot Charts"]
[null,{"$f":"IF(ISBLANK(C65),\"\",B63+1)","v":39},"Create Pivot Charts",null,{"$f":"IF($D$64=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C66),\"\",B65+1)","v":40},"Adding Fields to a Pivot Chart",null,{"$f":"IF($D$64=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C67),\"\",B66+1)","v":41},"Change the Chart type",null,{"$f":"IF($D$64=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,42,"Filter a Pivot Chart",null,{"$f":"IF($D$64=\"All\",$B$122,$B$123)","v":"click to select value"}]
["M","Charts - Formatting AND Techniques"]
[null,{"$f":"IF(ISBLANK(C70),\"\",B68+1)","v":43},"Create a Chart",null,{"$f":"IF($D$69=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C71),\"\",B70+1)","v":44},"Change the Chart type",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C72),\"\",B71+1)","v":45},"Modify Properties of Chart Elements",null,"click to select value"]
[null,46,"Using Themes and chart styles",null,"click to select value"]
[null,47,"Format different parts (elements) of a chart",null,"click to select value"]
[null,48,"Add trendlines and Error bars",null,"click to select value"]
["N","Functions"]
[null,{"$f":"IF(ISBLANK(C77),\"\",B75+1)","v":49},"Use Statistical Functions",null,{"$f":"IF($D$76=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C78),\"\",B77+1)","v":50},"Use Maths Functions",null,{"$f":"IF($D$76=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C79),\"\",B78+1)","v":51},"Use Financial Functions",null,"click to select value"]
[null,52,"Use Date and Time Functions",null,"click to select value"]
[null,53,"Use Text Functions",null,"click to select value"]
[null,54,"Use Information Functions",null,"click to select value"]
["O","Formula Techniques"]
[null,{"$f":"IF(ISBLANK(C84),\"\",B82+1)","v":55},"Scope and design a complex Formula",null,{"$f":"IF($D$83=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C85),\"\",B84+1)","v":56},"Using nested Functions in calculations",null,{"$f":"IF($D$83=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C86),\"\",B85+1)","v":57},"Use Manual and Automatic Recalculation",null,"click to select value"]
[null,58,"Pasting values from formulae",null,"click to select value"]
["P","Advanced Filters"]
[null,{"$f":"IF(ISBLANK(C89),\"\",B87+1)","v":59},"Set up and use Advanced filters",null,{"$f":"IF($D$88=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C90),\"\",B89+1)","v":60},"Using an Advanced filter with a criteria range",null,{"$f":"IF($D$88=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C91),\"\",B90+1)","v":61},"Use formulae as criteria in the advanced filter",null,"click to select value"]
[null,62,"Use Database functions with a list / database",null,"click to select value"]
["Q","Goal Seek"]
[null,{"$f":"IF(ISBLANK(C94),\"\",B92+1)","v":63},"Understand Goal seek components",null,{"$f":"IF($D$93=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C95),\"\",B94+1)","v":64},"Use Goal Seek",null,{"$f":"IF($D$93=\"All\",$B$122,$B$123)","v":"click to select value"}]
["R","Scenario Manager"]
[null,{"$f":"IF(ISBLANK(C97),\"\",B95+1)","v":65},"Understand Scenario Manager",null,{"$f":"IF($D$96=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C98),\"\",B97+1)","v":66},"Create Scenarios",null,{"$f":"IF($D$96=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C99),\"\",B98+1)","v":67},"Using Named cells in Scenarios",null,"click to select value"]
["S","Data Tables"]
[null,{"$f":"IF(ISBLANK(C101),\"\",B99+1)","v":68},"Data tables and What-If models",null,{"$f":"IF($D$100=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C102),\"\",B101+1)","v":69},"Create One Variable Data Table",null,{"$f":"IF($D$100=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C103),\"\",B102+1)","v":70},"Create Two Variable Data Table",null,"click to select value"]
["T","Controls on a Sheet"]
[null,{"$f":"IF(ISBLANK(C105),\"\",B103+1)","v":71},"Using Controls on a spreadsheet",null,{"$f":"IF($D$104=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C106),\"\",B105+1)","v":72},"Using Controls to automate data entry",null,{"$f":"IF($D$104=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C107),\"\",B106+1)","v":73},"Add Comboboxes, Listboxes, Spinners and Option Buttons",null,"click to select value"]
[null,74,"Changing control properties and protect controls",null,"click to select value"]
["U","Recorded Macros"]
[null,{"$f":"IF(ISBLANK(C110),\"\",B108+1)","v":75},"Record simple macros",null,{"$f":"IF($D$109=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C111),\"\",B110+1)","v":76},"Set up Macro security",null,{"$f":"IF($D$109=\"All\",$B$122,$B$123)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C112),\"\",B111+1)","v":77},"Edit simple macros",null,"click to select value"]
[null,78,"Assign macros to objects",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$114,No_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C119/COUNTA($E$17:$E$113))","v":{"v":0,"d":"0.00%"}}]
[null,"Basic Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$114,Basic_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C120/COUNTA($E$17:$E$113))","v":{"v":0,"d":"0.00%"}}]
[null,"Good Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$114,Good_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C121/COUNTA($E$17:$E$113))","v":{"v":0,"d":"0.00%"}}]
[null,"Expert",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$114,Expert))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C122/COUNTA($E$17:$E$113))","v":{"v":0,"d":"0.00%"}}]
[null,"click to select value",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$114,click_to_select_value))","v":78},{"$f":"IF(ISBLANK($E$17),\"\",C123/COUNTA($E$17:$E$113))","v":{"v":1,"d":"100.00%"}}]
[null,{"v":0.6,"d":"60%"}]
[null,{"$f":"IF(C123>0,\"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells\",IF(OR($D$119>=CriteriaToPass,($D$120+$D$119)>=CriteriaToPass),\"We suggest that you do the Intermediate course\",IF($D$122>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"}]