Spreadsheet: 64334d1265200904-add-a-new-column-of-data-to-the-results-displayed-when-selecting-from-a-dropdown-box-working-on-v2
Sheet: Sheet1

Question | Category | check | Course overview | Course Objectives
LJ Course Title 1 | Sales Process | 1 | Applying your product knowledge to customer interactions and generating leads?  Test line 2 Test line 3 | Objectives for course 1 Line 2 Line 3
LJ Course Title 2 | Sales Process | 2 | Explaining the crucial things to them when they are considering Savings(SIM) Mortgages and pensions | Objectives for course 2
LJ Course Title 3 | Service Excellence | 1 | Current Affairs, MoneySense & Managing Personal Finances | Objectives for course 3
LJ Course Title 4 | Building Relationships | 1 | Playing a part in the team | Objectives for course 4
LJ Course Title 5 | Building Relationships | 2 | Active listening, questioning, building rapport (including dealing with difficult situations) | Objectives for course 5
LJ Course Title 6 | Building Relationships | 3 | Supporting New Colleagues | Objectives for course 6
LJ Course Title 7 | Service Excellence | 2 | Treating Customers Fairly | Objectives for course 7
LJ Course Title 8 | Personal Career Development | 1 | Developing Career within Bank | Objectives for course 8
LJ Course Title 9 | Account Control | 1 | Account Opening & New Account Sanctioning (Including Know Your Customer Criteria) | Objectives for course 9
LJ Course Title 10 | Account Enquiry | 1 | Setting up, Cancelling and Amending Overdrafts and Regular Payments (Direct Debits & Standing Orders) including terms and conditions? | Objectives for course 10
LJ Course Title 11 | Account Opening | 1 | Clubs & society accounts- setting up and terms and conditions | Objectives for course 11
LJ Course Title 12 | Account Opening | 2 | Current Accounts- setting up and terms and conditions | Objectives for course 12
LJ Course Title 13 | Account Opening | 3 | Credit Cards- setting up and terms and conditions | Objectives for course 13
LJ Course Title 14 | Account Opening | 4 | Youth accounts- setting up  and terms and conditions | Objectives for course 14
LJ Course Title 15 | Account Opening | 5 | Savings Accounts- setting up and terms and conditions | Objectives for course 15
LJ Course Title 16 | Account Opening | 6 | Fixed Rate Bonds | Objectives for course 16 | Category
LJ Course Title 17 | Branch Administration | 1 | Stationary Management/Ordering | Objectives for course 17 | Sales Process
LJ Course Title 18 | Control | 1 | Branch open and closure procedures (Including Early Morning Entry) | Objectives for course 18 | Service Excellence
LJ Course Title 19 | Cash Admin | 1 | Managing Automated Teller Machine (ATM)/Customer Deposit Machine  (CDM) (including filling with cash, removing, processing vouchers and balancing) | Objectives for course 19 | Building Relationships
LJ Course Title 20 | Cash Admin | 2 | Remittance (making up, accepting, remitting), End of Day Cash closing procedures and Balancing Individual Till (including error tracing) | Objectives for course 20 | Personal Career Development
LJ Course Title 21 | Cash Admin | 3 | Managing Suspense Statements | Objectives for course 21 | Account Control
LJ Course Title 22 | Cash Control | 1 | Balancing Reserve | Objectives for course 22 | Account Enquiry
LJ Course Title 23 | Cash Control | 2 | Achieving Control Excellence - Cash, Paying Away Funds and Authorising Payments (including Large Payment Proforma) | Objectives for course 23 | Account Opening
LJ Course Title 24 | Complaints | 1 | [NAME] (including Log Complaints, Queries, Care Calls & daily C&Q tasks) | Objectives for course 24 | Branch Administration
LJ Course Title 25 | Control | 2 | Achieving Control Excellence - Internal Control | Objectives for course 25 | Control
LJ Course Title 26 | Control | 3 | RACF Changes (including daily sign off) | Objectives for course 26 | Cash Admin
LJ Course Title 27 | Coaching | 1 | Coaching (including observations, providing targeted feedback and mentoring) | Objectives for course 27 | Cash Control
LJ Course Title 28 | Improvements | 1 | Continuous improvement and problem solving | Objectives for course 28 | Complaints
LJ Course Title 29 | Improvements | 2 | Facilitating Continuous Improvement/Workout Sessions | Objectives for course 29 | Coaching
LJ Course Title 30 | Assurance | 1 | Life Assurance | Objectives for course 30 | Improvements
LJ Course Title 31 | Insurance | 1 | Home Insurance | Objectives for course 31 | Assurance
LJ Course Title 32 | IT | 1 | Image Signature Verification (ISV) - finding customers signature and signing instructions | Objectives for course 32 | Insurance
LJ Course Title 33 | IT | 2 | Use of Insite (Internal Intranet site) | Objectives for course 33 | IT
LJ Course Title 34 | IT | 3 | Using e-mail | Objectives for course 34 | Loan Account Opening
LJ Course Title 35 | IT | 4 | letter writing and use of word | Objectives for course 35 | Managerial
LJ Course Title 36 | IT | 5 | MyMI | Objectives for course 36 | Transactions
LJ Course Title 37 | Loan Account Opening | 1 | Fixed Rate Loan (FRL) | Objectives for course 37
LJ Course Title 38 | Loan Account Opening | 2 | Mortgage Quotations and Applications | Objectives for course 38
LJ Course Title 39 | Managerial | 1 | Delivering Huddle | Objectives for course 39
LJ Course Title 40 | Managerial | 2 | Long term planning of branch performance | Objectives for course 40
LJ Course Title 41 | Managerial | 3 | Long term planning of staff development | Objectives for course 41
LJ Course Title 42 | Managerial | 4 | Sales planning | Objectives for course 42
LJ Course Title 43 | Managerial | 5 | Service planning | Objectives for course 43
LJ Course Title 44 | Managerial | 6 | Time management | Objectives for course 44
LJ Course Title 45 | Managerial | 7 | Staff Appraisals & 1:1s | Objectives for course 45
LJ Course Title 46 | Sales Process | 3 | Demographics of branch | Objectives for course 46
LJ Course Title 47 | Sales Process | 4 | Customer Preview | Objectives for course 47
LJ Course Title 48 | Sales Process | 5 | Business/Private/Financial Planning lead Referrals | Objectives for course 48
LJ Course Title 49 | Sales Process | 6 | Telephony (Outbound and Inbound Calling) | Objectives for course 49
LJ Course Title 50 | Sales Process | 7 | Use of Prompts | Objectives for course 50
LJ Course Title 51 | Sales Process | 8 | Undertaking Personal/Customer Reviews (PSR/CSR) | Objectives for course 51
LJ Course Title 52 | Sales Process | 9 | Prospecting | Objectives for course 52
LJ Course Title 53 | Account Enquiry | 2 | Executors / Power of Attorney(including setting up and operating accounts) | Objectives for course 53
LJ Course Title 54 | Account Enquiry | 3 | Sharedealing | Objectives for course 54
LJ Course Title 55 | Account Enquiry | 4 | Register Death | Objectives for course 55
LJ Course Title 56 | Account Enquiry | 5 | Safe Custody/Yoursafe | Objectives for course 56
LJ Course Title 57 | Account Enquiry | 6 | Account Maintenance (including [NAME] and Change of Address/Circumstances) | Objectives for course 57
LJ Course Title 58 | Account Enquiry | 7 | Charges | Objectives for course 58
LJ Course Title 59 | Transactions | 1 | Foreign Payment, Foreign Drafts/CHAPS/Drafts | Objectives for course 59
LJ Course Title 60 | Transactions | 2 | Foreign Currency | Objectives for course 60
LJ Course Title 61 | Transactions | 3 | Faster Payments | Objectives for course 61
LJ Course Title 62 | Transactions | 4 | Withdrawal & Paying in | Objectives for course 62
LJ Course Title 63 | Transactions | 5 | Account balance/mini statement/A4 statement | Objectives for course 63
LJ Course Title 64 | Building Relationships | 4 | Departments who support the branch (i.e Regional Office, Operations Support, Marketing) | Objectives for course 64
LJ Course Title 65 | Sales Process | 10 | Locating and understanding Information on our products and services | Objectives for course 65