Spreadsheet: 140046d1328608118-returning-specific-values-based-on-multiple-criteria-in-a-tablewith-duplicate-entries-training-records-with-compliance-summary
Sheet: Course Codes

Course ID | Title | Course ID | Resource Type | Learning Type | Capability | Sub Category
ASSESS-GEN | Assessments - General |  |  | Self-Study
BKCCH001 | Coaching People | BKCCH001 | Book | Self-Study | Leadership | Coaching
BKCCH002 | Coaching Pocketbook | BKCCH002 | Book | Self-Study | Leadership | Coaching
BKCCH003 | Coaching Successfully | BKCCH003 | Book | Self-Study | Leadership | Coaching
BKCCH004 | How to be a great Coach | BKCCH004 | Book | Self-Study | Leadership | Coaching
BKCCH005 | Mentoring Pocketbook | BKCCH005 | Book | Self-Study | Leadership | Coaching
BKCCH006 | [NAME] | BKCCH006 | Book | Self-Study | Leadership | Coaching
BKCCH007 | Coaching For Performance | BKCCH007 | Book | Self-Study | Leadership
BKCCH008 | The Complete Guide to Coaching at Work | BKCCH008 | Book | Self-Study | Leadership | Coaching
BKCCH009 | Behavioral Coaching | BKCCH009 | Book | Self-Study | Leadership | Coaching
BKCOM001 | Adair on Communication & Presentation Skills | BKCOM001 | Book | Self-Study | Communication | Presentations
BKCOM002 | Communicate Clearly | BKCOM002 | Book | Self-Study | Communication
BKCOM003 | Giving Presentations | BKCOM003 | Book | Self-Study | Communication | Presentations
BKCOM004 | Making Presentations | BKCOM004 | Book | Self-Study | Communication | Presentations
BKCOM005 | Presentations Pocketbook | BKCOM005 | Book | Self-Study | Communication | Presentations
BKCOM006 | Telephone Skills from A to Z | BKCOM006 | Book | Self-Study | Communication | Telephone Techniques
BKCOM007 | Telephone Skills Pocketbook | BKCOM007 | Book | Self-Study | Communication | Telephone Techniques
BKCOM009 | The Concise Guide to Telephone Tactics | BKCOM009 | Book | Self-Study | Communication | Telephone Techniques
BKCOM010 | Writing Skills | BKCOM010 | Book | Self-Study | Communication | Writing
BKCOM011 | Better Business Writing | BKCOM011 | Book | Self-Study | Communication | Writing
BKCOM012 | Business Writing Pocketbook | BKCOM012 | Book | Self-Study | Communication | Writing
BKCOM013 | Openers & Closers Pocketbook | BKCOM013 | Book | Self-Study | Communication
BKCUS001 | Calming Upset Customers | BKCUS001 | Book | Self-Study | Customer Service
BKCUS002 | Customer Service | BKCUS002 | Book | Self-Study | Customer Service
BKCUS003 | Customer Sevice Pocketbook | BKCUS003 | Book | Self-Study | Customer Service
BKCUS004 | Handling Complaints Pocketbook | BKCUS004 | Book | Self-Study | Customer Service
BKCUS005 | Managing Quality Customer Service | BKCUS005 | Book | Self-Study | Customer Service
BKCUS006 | Putting Customers First | BKCUS006 | Book | Self-Study | Customer Service
BKCUS007 | Telephone Courtesy & Customer Service | BKCUS007 | Book | Self-Study | Customer Service
BKDEV001 | Appraisals Pocketbook | BKDEV001 | Book | Self-Study | Personal Development | Appraisals
BKDEV002 | Assertiveness Pocketbook | BKDEV002 | Book | Self-Study | Communication
BKDEV003 | Fish | BKDEV003 | Book | Self-Study | Personal Development | Motivation
BKDEV004 | Fish for Life | BKDEV004 | Book | Self-Study | Personal Development | Motivation
BKDEV005 | Fish Sticks | BKDEV005 | Book | Self-Study | Personal Development | Motivation
BKDEV006 | Fish Tales | BKDEV006 | Book | Self-Study | Personal Development | Motivation
BKDEV007 | Influencing Pocketbook | BKDEV007 | Book | Self-Study | Communication
BKDEV009 | Motivation Pocketbook | BKDEV009 | Book | Self-Study | Personal Development | Motivation
BKDEV010 | Teamworking Pocketbook | BKDEV010 | Book | Self-Study | Personal Development | Teamwork
BKDEV011 | Trainer's Pocketbook | BKDEV011 | Book | Self-Study | Facilitation | Personal Development
BKDEV012 | Who moved my cheese | BKDEV012 | Book | Self-Study | Personal Development | Change
BKDEV013 | Effective Teambuilding | BKDEV013 | Book | Self-Study | Personal Development
BKDEV014 | Woman 2 Woman | BKDEV014 | Book | Self-Study | Personal Development | Women's Leadership
BKDEV015 | Polar Bear Pirates | BKDEV015 | Book | Self-Study | Personal Development
BKDEV016 | Fish! The Guide | BKDEV016 | Book | Self-Study | Personal Development | Motivation
BKDEV017 | The Fish! [NAME] | BKDEV017 | Book | Self-Study | Facilitation
BKDEV018 | Women's Business Women's Wealth | BKDEV018 | Book | Self-Study | Personal Development | Women's Leadership
BKFIN001 | Understanding & Managing Financial Risk | BKFIN001 | Book | Self-Study | Finance
BKIND001 | 50 Years from Wales to Westpac | BKIND001 | Book | Self-Study | Induction
BKIND002 | Westpac Our Heritage | BKIND002 | Book | Self-Study | Induction
BKLEAD001 | Adair on Leadership | BKLEAD001 | Book | Self-Study | Leadership
BKLEAD002 | Fast Track Leadership: Instant access to key tips, tactics and techniques | BKLEAD002 | Book | Self-Study | Leadership
BKLEAD003 | Leadership in the new millennium | BKLEAD003 | Book | Self-Study | Leadership
BKLEAD004 | [NAME] | BKLEAD004 | Book | Self-Study | Leadership
BKLEAD005 | The Tools of Leadership | BKLEAD005 | Book | Self-Study | Leadership
BKLEAD006 | Leadership Is……. | BKLEAD006 | Book | Self-Study | Leadership
BKLEAD007 | Be Your Best LEADER and Beyond | BKLEAD007 | Book | Self-Study | Leadership
BKLEAD008 | Built to Last | BKLEAD008 | Book | Self-Study | Leadership
BKLEAD009 | [NAME] | BKLEAD009 | Book | Self-Study | Leadership | Recruitment
[NAME] | Finding True North | [NAME] | Book | Self-Study | Leadership
BKLEAD011 | 1001 Ways to energise employees | BKLEAD011 | Book | Self-Study | Leadership | Motivation
BKLEAD012 | 1001 Ways to reward employees | BKLEAD012 | Book | Self-Study | Leadership | Motivation
BKLEAD013 | Good to Great | BKLEAD013 | Book | Self-Study | Leadership
BKSALE001 | How to Sell | BKSALE001 | Book | Self-Study | Sales
BKSALE002 | [NAME] Dummies | BKSALE002 | Book | Self-Study | Sales
BKSALE003 | Sales Excellence Pocketbook | BKSALE003 | Book | Self-Study | Sales
BKSALE004 | [NAME] Pocketbook | BKSALE004 | Book | Self-Study | Sales
BKSALE005 | Selling Successfully | BKSALE005 | Book | Self-Study | Sales
BKSALE006 | SOLD - how to make it easy for people to buy from you | BKSALE006 | Book | Self-Study | Sales
BKSALE007 | Successful Telephone Selling | BKSALE007 | Book | Self-Study | Sales
BKSALE008 | The Sales Success Handbook | BKSALE008 | Book | Self-Study | Sales
BKTIM001 | Effective Meeting skills | BKTIM001 | Book | Self-Study | Personal Development | Time Management
BKTIM002 | Knock your socks off selling | BKTIM002 | Book | Self-Study | Sales
BKTIM003 | Organising & Participating in Meetings | BKTIM003 | Book | Self-Study | Personal Development | Time Management
BKTIM004 | Taming Time or how do you eat an elephant? | BKTIM004 | Book | Self-Study | Personal Development | Time Management
BKTIM005 | The Everything Time Management Book | BKTIM005 | Book | Self-Study | Personal Development | Time Management
BKTIM006 | Time Management & Personal Development | BKTIM006 | Book | Self-Study | Personal Development | Time Management
BKTIM007 | Time Management Pocketbook | BKTIM007 | Book | Self-Study | Personal Development | Time Management
CCH0000 | Coaching | CCH0000 | Coaching | Coaching
COM001-TT | Telephone Techniques | COM001-TT | Short Course | Internal Formal Workshop | Communication | Telephone Techniques
COM002-TT | Telephone Techniques | COM002-TT | Learning Forum | Internal Formal Workshop | Communication | Telephone Techniques
COM003-EW | [NAME] | COM003-EW | Learning Forum | Internal Formal Workshop | Communication | Writing
COM004-LC | Let's Communicate |  | Learning Forum | Internal Formal Workshop | Communication | Communication Techniques and Westpac Communication Standards
COM005-PGTF | Practical Guide to Facilitation |  | Workshop | Internal Formal Workshop | Facilitation
COMP001-AMLCTF | AML/CTF Awareness | COMP001-AMLCTF | Workshop | Internal Formal Workshop | Compliance
COMP002-AMLCIP | AML Customer Identification Process | COMP002-AMLCIP | Workshop | Internal Formal Workshop | Compliance
COMP003-EP | Emergency Preparedness | COMP003-EP | Workshop | Internal Formal Workshop | Compliance
[NAME] | Technology Code of Use | COMP004-TCOC | Learning Forum | Internal Formal Workshop | Compliance
COMP005-DTRT | Doing The Right Thing | COMP005-DTRT | Workshop | Internal Formal Workshop | Compliance
COMP006-ETS | Economic Trade Sanctions |  | CDRom | Self-Study | Compliance
COMP007-DTRTFB | Doing The Right Thing - Fraud Buster |  | Compliance | Internal Formal Workshop | Compliance
COMP008-COC | Code of Conduct |  | Compliance | Self-Study | Compliance
CONF001-OTHER | Conferences Conducted (No L&D Ivolvement) |  | Conference | External Workshop
CS001-TI | Tuning IN | CS001-TI | Workshop | Internal Formal Workshop | Customer Service
CS002-CS | Customer Service | CS002-CS | Short Course | Internal Formal Workshop | Customer Service
CS003-RCC | Resolving Customer Compliants | CS003-RCC | Short Course | Internal Formal Workshop | Customer Service
CS004-AO | Ask Once | CS004-AO | Learning Forum | Internal Formal Workshop | Customer Service
CS005-WC | Welcoming Complaints | CS005-WC | Learning Forum | Internal Formal Workshop | Customer Service
CS006-SI | Stepping IN |  | Workshop | Internal Formal Workshop | Customer Service
CS007-QNBC | Quality Needs Based Conversations |  | Workshop | Internal Formal Workshop | Customer Service
CS008- DOCSI | Delighting our Customers & Stepping In |  | Workshop | Internal Formal Workshop | Customer Service
DVD001 | Balance Sheet Barrier | DVD001 | DVD | Internal Formal Workshop | Finance
DVD002 | Emergency Procedures | DVD002 | DVD | Internal Formal Workshop | Compliance
DVD003 | FISH! | DVD003 | DVD | Internal Formal Workshop | Personal Development
EACAD0000 | eAcademy |  | Self-Paced | Self-Study
EXT0000 | General External Courses | EXT0000 | External Workshop | External Workshop
EXT0001-LSI | Life Styles Inventory |  | External Workshop (Provided In-House) | Internal Formal Workshop | Personal Development
FIN001-MYMTFS | Managing your money to financial success | FIN001-MYMTFS | Learning Forum | Internal Formal Workshop | Finance
FIN002-AB | Accounting Bingo | FIN002-AB | Learning Forum | Internal Formal Workshop | Finance
FIN003-BA | Basic Accounting | FIN003-BA | Learning Forum | Internal Formal Workshop | Finance
FIN004-AT | Accounting Terminology | FIN004-AT | Learning Forum | Internal Formal Workshop | Finance
FIN005-FFS | Financial First Steps |  | Learning Forum | Internal Formal Workshop | Finance
IND0000-WS | [NAME] (Includes; [NAME], AML, CoC, DoC, [NAME], FFS, CSWS, TeleTech, FISH!, ICBS, etc) |  | Workshop | Internal Formal Workshop | Induction
IND0001-WICL | Workplace Induction Checklist |  | On-The-Job Training | On-The-Job Training | Induction
INTCD001-AV | Accounting/Valuation | INTCD001-AV | Intuition - CDRom | Self-Study | Finance
INTCD002-BFM | Budgeting & Financial Managemnt | INTCD002-BFM | Intuition - CDRom | Self-Study | Finance
INTCD003-FE | Foreign Exchange | INTCD003-FE | Intuition - CDRom | Self-Study | Finance
INTCD004-MM | Money Markets | INTCD004-MM | Intuition - CDRom | Self-Study | Finance
INTCD005-PMF | Project Management Funadamentals | INTCD005-PMF | Intuition - CDRom | Self-Study | Business
INTCD006-PMP | Project Management Professional | INTCD006-PMP | Intuition - CDRom | Self-Study | Business
INTCD007-RM | Risk Management | INTCD007-RM | Intuition - CDRom | Self-Study | Business
INTCD008-TEM | The Effective Manager | INTCD008-TEM | Intuition - CDRom | Self-Study | Business
INTCD009-E | Excel | INTCD009-E | Intuition - CDRom | Self-Study | Technology
INTCD010-W | Word | INTCD010-W | Intuition - CDRom | Self-Study | Technology
INTCD011-P | Powerpoint | INTCD011-P | Intuition - CDRom | Self-Study | Technology
INTCD012-N&IE | Notes and Internet Explorer | INTCD012-N&IE | Intuition - CDRom | Self-Study | Technology
LEAD001-BTPG | Bridging the Performance Gap | LEAD001-BTPG | Workshop | Internal Formal Workshop | Leadership | Appraisals
LEAD002-CEPD | Conducting Effective Performance Discussions | LEAD002-CEPD | Workshop | Internal Formal Workshop | Leadership | Appraisals
LEAD003-KMSA | Keeping my ship afloat | LEAD003-KMSA | Learning Forum | Internal Formal Workshop | Leadership | Appraisals
LEAD004-PF | Performance Feedback | LEAD004-PF | Learning Forum | Internal Formal Workshop | Leadership | Appraisals
LEAD005-PLACC | People Leader as Career Coach | LEAD005-PLACC | Workshop | Internal Formal Workshop | Leadership | Coaching
LEAD006-C | Coaching | LEAD006-C | Short Course | Internal Formal Workshop | Leadership | Coaching
LEAD007-DFR | Delegating for Results | LEAD007-DFR | Learning Forum | Internal Formal Workshop | Leadership | Development
LEAD008-YTO(IS) | You're the One! ([NAME]) | LEAD008-YTO(IS) | Learning Forum | Internal Formal Workshop | Leadership | Recruitment
LEAD009-LTV1 | Living the Values - Part 1 | LEAD009-LTV1 | Learning Forum | Internal Formal Workshop | Leadership | Values
[NAME] | LIving the Values - Part 2 | [NAME] | Learning Forum | Internal Formal Workshop | Leadership | Values
LEAD011-LTV3 | LIving the Values - Part 3 | LEAD011-LTV3 | Learning Forum | Internal Formal Workshop | Leadership | Values
LEAD012-PLSP | People Leader Skills Program | LEAD012-PLSP | Workshop | Internal Formal Workshop | Leadership
LEAD013-MC | Managing Conflict | LEAD013-MC | Learning Forum | Internal Formal Workshop | Leadership | Conflict Resolution
LEAD014-RP&TSI | Recruitment Process and Target Selection Interview Workshop |  | Workshop | Internal Formal Workshop | Leadership | Recruitment
LEAD015-PLDP | People Leader Development Program |  | Workshop | Internal Formal Workshop | Leadership | Development
LEND001-ITBLF | Introduction to Business Lending & Financials | LEND001-ITBLF | Workshop | Internal Formal Workshop | Lending
[NAME] | On-The-Job Training | [NAME] | On-The-Job Training | On-The-Job Training
PDEV001-DWC | Dealing with Change | PDEV001-DWC | Learning Forum | Internal Formal Workshop | Personal Development | Change
PDEV002-MC | Managing Change | PDEV002-MC | Learning Forum | Internal Formal Workshop | Personal Development | Change
PDEV003-MYC | Managing your career | PDEV003-MYC | Learning Forum | Internal Formal Workshop | Personal Development | Development
PDEV004-MRC | My report card | PDEV004-MRC | Learning Forum | Internal Formal Workshop | Personal Development | Development
PDEV005-MMB | Making Meetings Better | PDEV005-MMB | Learning Forum | Internal Formal Workshop | Personal Development | Meetings
PDEV006-MJDI | Motivation - just do it! | PDEV006-MJDI | Learning Forum | Internal Formal Workshop | Personal Development | Motivation
PDEV007-T | Teamworking | PDEV007-T | Learning Forum | Internal Formal Workshop | Personal Development | Teamwork
PDEV008-IMT | It's my time | PDEV008-IMT | Learning Forum | Internal Formal Workshop | Personal Development | Time Management
PDEV009-PWI | Present with Impact | PDEV009-PWI | Learning Forum | Internal Formal Workshop | Personal Development | Presentation Skills
RELIEF0000 | Cross Learning Through Relief | Cross Learning Through Relief | Cross Learning Through Relief | Cross Learning Through Relief
SALE001-BOC | Banker of Choice | SALE001-BOC | Workshop | Internal Formal Workshop | Sales
SALE002-UTSC | Understanding the Sales Cycle | SALE002-UTSC | Learning Forum | Internal Formal Workshop | Sales
SALE003-DYHTS | Do you have the SPARK? | SALE003-DYHTS | Learning Forum | Internal Formal Workshop | Sales
SALE004-KYC | Know your customer | SALE004-KYC | Learning Forum | Internal Formal Workshop | Sales
SALE005-PTRS | Proposing the right solution | SALE005-PTRS | Learning Forum | Internal Formal Workshop | Sales
SALE006-CAS | Closing a sale | SALE006-CAS | Learning Forum | Internal Formal Workshop | Sales
SALE007-STC | Servicing the customer | SALE007-STC | Learning Forum | Internal Formal Workshop | Sales
SALE008-SR | Sales Referrals | SALE008-SR | Learning Forum | Internal Formal Workshop | Sales
SALE009-NS | Negotiation Skills | SALE009-NS | Learning Forum | Internal Formal Workshop | Sales
SPL001-BLFD | Business Lending & Financial Drivers | SPL001-BLFD | Self-Paced | Self-Study | Lending
SPL002-DP | Development Planning | SPL002-DP | Self-Paced | Self-Study | Personal Development | Development
SPL003-ICL | Introduction to Consumer Lending | SPL003-ICL | Self-Paced | Self-Study | Lending
SPL004-JIP | [NAME] | SPL004-JIP | Self-Paced | Self-Study | Induction
TCD0107 | Destination Westpac | TCD0107 | CDRom | Self-Study | Induction
TCD082 | Microsoft Office 2000 Suite | TCD082 | CDRom | Self-Study | Technology
TCD093 | Customer Service Suite | TCD093 | CDRom | Self-Study | Customer Service
TCD094 | Budgeting & Financial Management | TCD094 | CDRom | Self-Study | Finance
TCD095 | Business Finance Suite | TCD095 | CDRom | Self-Study | Finance
TCD096 | Business Fundamentals Suite | TCD096 | CDRom | Self-Study | Business
TCD097 | Developing Marketing Strategy Suite | TCD097 | CDRom | Self-Study | Business
TCD098 | Finance for non financial managers | TCD098 | CDRom | Self-Study | Finance
TCD101 | Interpersonal Skills | TCD101 | CDRom | Self-Study | Personal Development
TCD102 | Management & Leadership | TCD102 | CDRom | Self-Study | Leadership
TCD103 | Organisational Behaviour | TCD103 | CDRom | Self-Study | Business
TCD104 | Planning & Managing Business Strategy | TCD104 | CDRom | Self-Study | Business
TCD105 | Quantative Management Suite | TCD105 | CDRom | Self-Study | Business
TCD106 | The Business of Selling | TCD106 | CDRom | Self-Study | Sales
TCD107 | Discrimination & Harassment | TCD107 | CDRom | Self-Study | Compliance
TCD108 | Knowledge by Design | TCD108 | CDRom | Self-Study
TCD109 | Doing The Right Thing | TCD109 | CDRom | Self-Study | Compliance
[NAME] | Anti-Money Laundering & Counter Terrorist Financing | [NAME] | CDRom | Self-Study | Compliance
TECH001 | Technical Training & Workshops Facilitated In-House |  | Workshop | Internal Formal Workshop
TECH002-TAC | Teller's Accreditation Workshop |  | Workshop | Internal Formal Workshop | Teller Training
TECH003-TRW | Teller's [NAME] |  | Workshop | Internal Formal Workshop | Teller Training
TECH004-PMA | Process Map Accreditation |  | Self-Paced | Self-Study | Technical
TECH005-PK | Product Knowledge |  | Self-Paced | Self-Study | Technical
TRUST001 | A Better Place to Work | TRUST001 | CDRom | Self-Study | Compliance
TS0000 | Tertiary Studies (Study Assistance Scheme) | Tertiary Studies (Study Assistance Scheme) | Tertiary Studies (Study Assistance Scheme) | Tertiary Studies (Study Assistance Scheme)
VT001 | Hold Ups | VT001 | Video Tape | Internal Formal Workshop | Compliance
VT002 | Welcoming Complaints | VT002 | Video Tape | Internal Formal Workshop | Customer Service
 | - |  | - | - | - | -