Spreadsheet: 63327d1264233552-dropdown-box-for-selecting-a-category-and-displaying-more-than-1-result-question-20bank-1-
Sheet: Sheet1

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