Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 19

कार्यक्रम PROGRAM |  |  | एसडब्ल्यूओ के  तलए [NAME] कार्यक्रम - प्रथम चरण 1st PHASE OF INDUCTION TRAINING FOR SWOs | PROGRAM CODE
 |  |  |  | IT 1052
तर्षर् समूह/ SUBJECT GROUP |  |  | HR, MARKETING, CUSTOMER SERVICE & COMPLIANCE
उद्देश्य/OBJECTIVE |  |  | TO  IMBIBE  OUR  BANK’S  CULTURE  AND  BRING  AWARENESS ABOUT THE IMPORTANCE OF CUSTOMER SERVICE. TO IMPART SOFT  &  TECHNOLOGY  SKILLS,  AND  JOB  KNOWLEDGE  TO ENABLE     PARTICIPANTS     TO     PERFORM     THE     DUTIES EFFECTIVELY
लतक्षि समूह/TARGET GROUP |  |  | NEWLY INDUCTED SWOs
अर्तध/DURATION |  |  | 11 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Inauguration and Introduction, Ice-breaking
 | II | Bank’s History, culture, core values and Organization, Structure
 | III & IV | Future  of  banking  and  career  planning.  Uniqueness  of  Our  Bank, Achievements and accolades
 |  | Vision,   Mission,   Values   &   Ethics   of   the   organization,   Service Conditions & Service Rules
Day 2 | I | Overview  of  Banking  Operations:  Asset  side  and  Liability  side, Banking functions and activities
 | II | Roles and responsibilities of SWO’s.
 | III | Definition  and  [NAME]  of  customers-  Individual  and  Non-individual Customers,   KYC/AML/CFT   Guidelines   and   FATCA   -   Purpose, Importance and regulatory requirements, , CKYC, EKYC
 | IV | Deposit  Accounts  (CASA)  :  Demand  Deposits-  Saving  &  Current Accounts, Variances  - Opening, renewal, closure, mode of operation, interest application etc.
Day 3 | I | Interest  application  etc.  Government  Business  viz.  PPF,  APY,  SSA SCSS, SGB, etc.  - Opening, renewal, closure, mode of operation,
 | II | NRI   Deposits   -   NRE,   NRO,   FCNB,   RFC,   FEMA   Guidelines   NRI Remittances -SWIFT, [NAME], International Money Order, INB
 | III | Time  Deposit  Accounts:  Term  Deposits,  Variances     -  Opening, renewal, closure
 | IV | Interaction with Higher Executives.
Day 4 | I | Legal framework – NI Act, BR Act, RTI Act, PSS Act, RBI Act, Bankers book evidence Act, Banker Customer Relationship, KYC documents for  different  types  of  customers  Remittances  -  Cheque  Collection Policy ([NAME])
 | II | RBI   Guidelines   on   currency   management   (Clean   Note   Policy, Counterfeit Currency handling etc.)
 | III | Safe custody, Safe Deposit Locker, Single Lock and Double Lock Book
 | IV | Internet and Digital Banking, [NAME], POS – ME, Debit Cards & Pre-paid Cards - Concept, Products & Variances ,
Day 5 | I | Basics of Retail Lending & Products (PSS, CIBIL report, TIR, Valuation, POA and due diligence, HL, VL, EL)
 | II | Important and popular MSME & Agri-Loan Product- foundation
 | III | Basics of Documentation
 | IV | Preventive Vigilance
Day 6 | I | Post Sanction loan Accounts Monitoring (Overdue, SMA),IRAC Norms, Recovery
 | II | Marketing- In-house marketing, Digital Marketing, In- person Marketing
 | III | Your role as a Digital Mitra
 | IV | Cyber Security & Frauds in Digital Banking
Day 7 | I | Communication Skills, Business Etiquette, Personal Grooming, Cell Phone & Online Etiquette
 | II | Team work, Customer as a Business Partner
 | III | [NAME], Business Etiquette
 | IV | Fraud Awareness
Day 8 | I | CBS-overview, architecture, [NAME], Add-on Modules, Branch Operation
 | II | Customer Creation- Customer ID, [NAME], Short name
 | III | Additional Information to be captures for customer (CRM), signature Linking, Memo, Customer related menu
 | IV | CASA – Account Opening
Day 9 | I | Addition of Names, Operating Instructions, Master Details, Cheque Book Issue, Stop Cheque, [NAME],
 | II | Standing Instruction, Hold Funds, Sweep In, Sweep Out, Nomination, [NAME] issue, Transfer / Closure of Accounts.
 | III | CBS Lab (Cash), Receipts, Payments
 | IV | Opening of Term deposit accounts. and their Operational Aspects (Lab)
Day 10 | I | IT Act, Promotion of Digital Transactions, CKYC, EKYC and Data Infringement. CANNET, SAS and CanDLE - Self- Learning & Knowledge Resources Available in the Bank (Banks website, e- Learning, Special initiatives etc.)
 | II | Internal Control & Minor Subsidiaries
 | III & IV | Branch Visit
Day 11 | I | HRD Concepts, Punctuality, Gender Sensitivity and Inclusion of PWD employees and customers
 | II | Official language Act (Rajbhasha) Act, 1963
 | III | Marketing - Customer Value Enhancement (Financial Planning & Cross Selling : Mutual Fund, General and Life Insurance, Cards concepts and popular products)
 | IV | Assessment test & Valediction