{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Sheet4","Quote Registration","Sheet3","Courses"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":44,"n_cols":2,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Question","Answer"]
["What is Excel used for?","Developing spreadsheets for doing analyses by creating formulas, charts, filtering etc. Could also be used for maintaining a database"]
["What is the difference between a workbook and worksheet?","A workbook is made up of multiple worksheets.  "]
["How would you create a new workbook using a template?","File, New"]
["How many worksheets automatically get inserted into a new workbook",3]
["What is the purpose of a toolbars, menus and scrollbars?","Toolbars are quicker to use.  The same features can be found in the menu.  You usually find that in the menu, there are more options eg. Printing 5 copies."]
[]
[null,"Scroll bars enable you to move around on the spreadsheet (up, down, left, right)"]
["How are cell references made up and why do we have them?","Each cell has a cell reference.  It is determined by the row and column Number reference.  Cell references are used in formulas to ensure that the formula automatically update."]
["How do you get into page break preview?","View, page break preview"]
["How do you know how to change your zoom level?","On the Standard toolbar, select the zoom from the drop down"]
["Do you know how to select a:"]
[]
["Cell","Cell : Click on the cell"]
["Range","Range : Click and drag"]
["Non adjacent","Non adjacent : Hold CTRL and select cells"]
["Worksheets","Worksheets : Click o the worksheet tabs"]
["How to select the entire worksheet?","On the top left section of your spreadsheet, click on the blank block next to column A"]
["How do you formatting numbers to a currency?"]
[null,"Format, Cell, Number, Currency"]
["Are you  proficient with Copy & Paste, Cut & Paste","Yes/No"]
["Are you proficient  with using print preview?","Yes/No"]
["How do you edit the contents of a cell?","Double click on the cell, press F2"]
["What is the difference between save and save as?","Save – When you initially save a file"]
[null,"Save As- To create a copy of the file, change the location of the saved file"]
[]
["If you have multiple workbooks open, how do you switch between them?","On the Menu bar, click on WINDOW and switch between files"]
[]
[null,"On the Task bar, click on the file you want to activate"]
["Are you able to perform a spell check?","Yes/No"]
["Do you know how to create a formula","Type ="]
[null,"Select the cell you want to calculate"]
[null,"Type in the parenthesis e.g. +, *"]
[null,"Select other cells as required and press enter"]
[]
["Do you know how to use the Sum function?","Used to add"]
[null,{"$f":"SUM(range)","v":{"$error":"#NAME?"}}]
["Do you know how to use the Auto Sum button?","Used to quickly add columns and rows, click on the Auto Sum button found on the Standard toolbar"]
["Do you know how to copy formulas with the auto fill?","Get your auto fill and drag down or across"]
["Do you know how to auto fit column and row widths?","Place your mouse on the side of the column,  when you get the double headed arrow, double click your mouse"]
[]
[null,"Fits to the longest work in that particular column"]
["Do you know how to change your page from portrait to landscape?","File, page setup, page"]
["Can you use the Help facility?","Yes/No"]

{"sheet":"Sheet4","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[[11,0,11,1],[28,0,28,1],[18,0,18,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[21,0,21,1],[27,0,27,1],[22,0,22,1],[20,0,20,1],[12,0,12,1],[14,0,14,1],[15,0,15,1],[19,0,19,1],[13,0,13,1],[17,0,17,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1]]}
[]
[]
[]
[]
[]
["21. Where do change the Page Setup from Portrait to Landscape?",null,"Please select your Answer",{"$f":"IF(VLOOKUP(#REF!,Sheet3!$A:$B,2,0)=C6,1,0)","v":{"$error":"#REF!"}}]
["A. Look in the Menu File, then select Page Setup, then Page"]
["B. Look in the Menu View, then select Landscape under Setup"]
["C. Look in the Menu Window, then select Landscape under the Page link"]
["D. Any of the Above"]
[]
["22. How do you Lock the Row and Column Headings so that you can view the Headings while scrolling down and across the Worksheet?",null,"Please select your Answer",{"$f":"IF(VLOOKUP(#REF!,Sheet3!$A:$B,2,0)=C12,1,0)","v":{"$error":"#REF!"}}]
["A. Use the Lock view funtion"]
["B. Use the Freeze Panes which is found under the Menu Window "]
["C. Select Row and Column Lock under Print Setup"]
["D. Any of the Above"]
[]
["23. What symbol is used to create Absolute References in Formulas?",null,"Please select your Answer",{"$f":"IF(VLOOKUP(#REF!,Sheet3!$A:$B,2,0)=C18,1,0)","v":{"$error":"#REF!"}}]
["* Hint * Absolute References are used when creating formulas so that when you copy the formula down/across cells allowing the cell references to remain constant, i.e. they fix cell references"]
["A. The Question Mark (?)"]
["B. The Asterisk (*)"]
["C. The dolloar sign ($)"]
["D. All of the Above"]
[]
["24. Where would you find the \"Print Titles\" feature?",null,"Please select your Answer",{"$f":"IF(VLOOKUP(#REF!,Sheet3!$A:$B,2,0)=C25,1,0)","v":{"$error":"#REF!"}}]
["A. Select Menu File, then select Page Setup, then select Sheet"]
["B. Select Menu View, then select Print Titles"]
["C. Select Menu Window, then select Print Titles"]
["D. All of the Above"]

{"sheet":"Quote Registration","index":2,"n_rows":62,"n_cols":25,"rows_kept":62,"cut":false,"hidden":false,"merged":[[11,6,11,7],[48,2,48,14],[39,2,39,14],[40,2,40,14],[7,9,7,10],[8,9,8,10],[9,9,9,10],[13,10,13,11],[14,10,14,11],[0,4,0,11],[26,12,26,14],[27,12,27,14],[28,12,28,14],[2,9,2,10],[4,9,4,10],[5,9,5,10],[6,9,6,10],[23,2,23,14],[22,2,22,3],[16,6,16,7],[16,10,16,11],[19,6,19,7],[11,10,11,11],[12,10,12,11],[3,9,3,10],[12,6,12,7],[56,8,56,11],[53,11,53,14],[54,6,54,8],[53,6,53,8],[47,2,47,14],[42,2,42,14],[20,10,20,11],[52,4,52,14],[38,2,38,14],[49,2,49,14],[43,2,43,14],[44,2,44,14],[45,2,45,14],[53,2,53,4],[56,4,56,5],[56,2,56,3],[56,12,56,14],[56,6,56,7],[55,2,55,14],[17,10,17,11],[36,11,36,12],[21,10,21,11],[14,6,14,7],[25,12,25,14],[15,6,15,7],[9,5,9,8],[28,6,28,8],[26,4,26,8],[27,4,27,9],[46,2,46,14],[18,6,18,7],[18,10,18,11],[19,10,19,11],[11,2,11,3],[24,12,24,14],[13,6,13,7],[21,6,21,7],[41,2,41,14],[20,6,20,7],[17,6,17,7],[15,10,15,11]]}
[null,null,null,null,"TRAINING QUOTE & REGISTRATION BOOKING FORM"]
[]
[null,null,"TRAINING QUOTE",null,null,"Excel Version","Quantity","Unit Price","Sub Total","Less: Group Discount",null,"Total ",null,null,"Sage Intelligence",null,null,null,null,1,6,7,8,9,10]
[null,null,"Excel ABC's",null,null,null,null,1700,{"$f":"SUM(H4*G4)","v":0},{"$f":"IF(G4<6,0,I4-IFERROR(HLOOKUP(G4,$T$3:$Y$7,2,0),0)*G4)","v":0},null,{"$f":"I4-J4","v":0},null,null,null,null,null,null,"ABC",1700,{"$f":"8700/U3","v":1450},{"$f":"9850/V3","v":1407.1428571428571},{"$f":"11000/W3","v":1375},{"$f":"12200/X3","v":1355.5555555555557},{"$f":"13300/Y3","v":1330}]
[null,null,"Discovering Excel",null,null,null,null,2000,{"$f":"SUM(H5*G5)","v":0},{"$f":"IF(G5<6,0,I5-IFERROR(HLOOKUP(G5,$T$3:$Y$7,3,0),0)*G5)","v":0},null,{"$f":"I5-J5","v":0},null,null,"Flexcel Reporting CC",null,null,null,"DISC",2000,{"$f":"9650/U3","v":1608.3333333333333},{"$f":"10750/V3","v":1535.7142857142858},{"$f":"12000/W3","v":1500},{"$f":"13000/X3","v":1444.4444444444443},{"$f":"14200/Y3","v":1420}]
[null,null,"Excel on Steroids - 3 Course Bundle",null,null," ",null,5100,0,{"$f":"IF(G6<6,0,I6-IFERROR(HLOOKUP(G6,$T$3:$Y$7,4,0),0)*G6)","v":0},null,0,null,null,"29 Cuyler Street, Central, Port Elizabeth",null,null,null,"EOS",5100,{"$f":"24500/U3","v":4083.3333333333335},{"$f":"27900/V3","v":3985.7142857142858},{"$f":"31300/W3","v":3912.5},{"$f":"34650/X3","v":3850},{"$f":"38000/Y3","v":3800}]
[null,null,"Excel on Steroids - Plus",null,null," ",null,4050,0,{"$f":"IF(G7<6,0,I7-IFERROR(HLOOKUP(G7,$T$3:$Y$7,5,0),0)*G7)","v":0},null,0,null,null,"TEL: 041 585 0745",null,null,null,"EOS Plus",4050,{"$f":"19300/U3","v":3216.6666666666665},{"$f":"21600/V3","v":3085.7142857142858},{"$f":"23950/W3","v":2993.75},{"$f":"26300/X3","v":2922.2222222222222},{"$f":"28600/Y3","v":2860}]
[null,null,"SUB TOTAL (excl. Vat)",null," "," ",{"$f":"SUM(G5:G7)","v":0},null,{"$f":"SUM(I4:I7)","v":0},{"$f":"SUM(J4:K7)","v":0},null,{"$f":"I8-J8","v":0},null,"Quote Ref "]
[null,null,"Plus Vat @ 14%",null,null,null," "," "," "," ",null,{"$f":"SUM(L8*14%)","v":0},null,"Date "]
[null,null,"TOTAL (Incl. Vat)",null," ","This quote is valid for 30 days from date hereof",null,null,null," ",null,{"$f":"SUM(L8:L9)","v":0},null,null,"Vat No. 462 022 5427",null,"Discovering Excel"]
[null,null,"To register, please complete Delegate's details below:-"]
[null,null,"Delegate's Full Name                       (To appear on Certificate)",null,"Job Title","Cell Number","E-mail",null,"Dietary Requirements","IQ Quiz Results","Workshop Name",null,"Excel Version\n2007/ 2010/  2013","Training Dates","VENUE - PE / ONSITE ",null,"Excel ABCs"]
[null,1,null,null," "," "]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,null,"DIETARY REQUIRMENTS:",null,"Please indicate above :","None","NO Beef / Pork","Halaal","Vegetarian"]
[null,null,"Who should we invoice?"]
[null,null,"Title",null,"Full Name"," ",null,null,null,null,null,"Job Title",null,null,null,null,"Classroom (specify dates)"]
[null,null,"Industry/Sector",null," ",null,null,null,null,null,null,"E-mail address"," ",null,null,null,"Online"]
[null,null,"Company",null,null,null,null,null,null,null,null,"Company VAT Number"," "]
[null,null,"Postal Address",null,null,null,null,null,null,null,null,"Order Number"]
[null,null,"Telephone"," ",null,"Cell No.",{"$f":"F13","v":" "},null,null,null,null,"How did you hear about us? "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010]
[null,null,"Have you completed the Course pre-assessment?",null,null,null,null,null,null,null,"Do you use Excel for reporting in your business?",null,null,null,null,null,2013]
[]
[null,null,null,null,null,null,null,null,null,null,"     How many employees in your business?","o <10","o <50","o <100","o >100"]
[null,null,"What Accounting software does your business use?"]
[null,null,"o Sage Pastel Partner ",null,"o Sage ERP X3",null,"o Sage VIP Payroll",null,"o SAP Business One"]
[null,null,"o Sage Evolution",null,"o Sage 300 ERP",null,null,null,"o SYSPRO",null,null,"o Other - Please Specify"]
[]
[null,null,"Flexcel Reporting - Registration Process and Terms and Conditions apply"]
[null,null,"1.  On receipt of this fully completed booking form, Flexcel Reporting cc, will send you an invoice.  "]
[null,null,"2.  Payment via bank transfer is required to book your seat, payment via Credit Card is not available.  All training must be paid for before attending class. "]
[null,null,"3.  The price includes: training manuals, pre and post assessments, refreshments (unless onsite or a special meal) and 30 days email support.  "]
[null,null,"4.  Upon completion of training you will be given 4 weeks access to our Sage Intelligence Academy in order to complete your post course assessment, thereafter we charge R350 per assessment for a 4 week extension."]
[null,null,"5.  Cancellations and Postponements"]
[null,null,"     a.  Once booked and paid – you have 90 days to attend your training, thereafter we reserve the right to cancel your training at 100% cancellation fee."]
[null,null,"     b.  Postponements must be emailed to emma@flexcel.co.za at least 5 working days prior to course commencement date or full course fees will be payable.  We only accept 2 postponements – thereafter 100% cancellation fee applies."]
[null,null,"     c.  Cancellations are only accepted upon written notification, at least 10 working days prior to the course commencement date, failing which a 20%  cancellation fee will be levied."]
[null,null,"     d.  Failure to cancel, within 5 working days of the course commencement date, will incur full course fees.  Substitutions can, however, be made at any time."]
[null,null,"     e.  We reserve the right to cancel or postpone any course, should there be an insufficient number of delegates booked, at 100% refund."]
[null,null,"6.  Classroom registration at 08h00, Workshops commence 08h30.  Seats are allocated on a first-paid-first-served basis."]
[]
[null,null,"Authorisation:",null,"I, the undersigned, confirm that I accept the Terms and Conditions above, and that I am duly authorised to sign and accept this Quote and Registration form, "]
[null,null,null,null,"binding the company to the purchase of the listed Flexcel Reporting training courses."]
[]
[null,null,"Full Name",null,null,null,"Job Title",null,null,null,null,"Signature"]
[null,null,"Please return signed and completed form to the following email:-"]
[null,null,"Account Executive: ",null,"Emma Van Der Merwe",null,"Tel: 041 585 0745",null,"Cell: 078 174 1401",null,null,null,"Email: emma@flexcel.co.za"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fin doc: 2016"]
[null,null,"Excel on Steroids"]
[null,null,"Discovering Excel"]
[null,null,"Excel ABCs"]
[null,null,"Alchemex Basic & Advanced Report Writing"]

{"sheet":"Sheet3","index":3,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Question","Answer",null,"Please select your Answer"]
[1,"B",null,"A"]
[2,"A",null,"B"]
[3,"D",null,"C"]
[4,"B",null,"D"]
[5,"B"]
[6,"D"]
[7,"C"]
[8,"D"]
[9,"A"]
[10,"A"]
[11,"A"]
[12,"A"]
[13,"A"]
[14,"C"]
[15,"B"]
[16,"C"]
[17,"A"]
[18,"B"]
[19,"D"]
[20,"C"]

{"sheet":"Courses","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,"Excel on Steroids"]
[null,null,"Discovering Excel"]
[null,null,"Excel ABCs"]
[null,null,"Alchemex Basic & Advanced Report Writing"]
[null,null,"Alchemex Advanced Customised Report Writing"]
[null,null,"Pastel Accounting BIC Basic & Advanced Report Writing"]
[null,null,"Pastel Accounting BIC Advanced Customised Report Writing"]
[null,null,"Pastel Evolution BIC  Basic & Advanced Report Writing"]
[null,null,"Pastel Evolution BIC Advanced Customised Report Writing"]
[null,null,"Sage Accpac Intelligence: Basic and Advanced Report Writing"]
[null,null,"Sage Accpac Intelligence Connector: Advanced Customized Report Writing"]