Oversee Financial Performance and Risk Reporting in Banking 

Source: Comptroller's Handbook

Performance and Risk Reports:

• understand the drivers of financial performance.
• understand and evaluate the potential impact of business units and their risk on financial performance.
• assess the adequacy of capital, liquidity, and earnings.
• monitor performance trends and projections.
• monitor financial performance against strategic goals.
• monitor risk positions in relation to the risk appetite, limits, and parameters.
• monitor the types, volumes, and impacts of exceptions to policies and operating procedures.
• understand model risks and reliance.
• assess the impact of new, modified, or expanded products or services.
• assess evolving risks related to changing technologies and market conditions.
• monitor risks related to third-party relationships involving critical activities.
• assess potential litigation costs and reserves.

Useful performance reports are likely to include, but are not limited to, the following information:

• Financial statements and peer comparison reports
• Budget variance reports
• Metrics on key risks
• Asset quality indicators and trends
• Allowance for loan and lease losses analysis
• Concentrations of credit
• Liquidity position and trends and contingency funding plans
• Interest rate sensitivity analyses
• Performance metrics for new, modified, or expanded products and services
• Outsourced critical activities
• Off-balance-sheet activity and exposures, including derivative exposures
• Growth rates and projections
• Capital position, trends, and capital adequacy assessments
• Key business unit performance
• Policy exception monitoring reports
• Performance measurements and metrics for risk appetite, performance goals, and strategic goals
• Earnings trends and quality, including non-interest income and expenses

    

 Cyber Security

• NIST Cyber Security Framework. Link1, Brief Overview, Five Core Elements or Components.
1. Identify
2. Protect
3. Detect
4. Respond
5. Recover
• What is Security Stack: Build, Example 1, Tools, 
• Ten steps to Cyber Security: 
1. Network Security
2. User Education and Awareness
3. Malware Protection
4. Removeable Media Controls
5. Secure Configuration
6. Managing User Privileges
7. Incident Management
8. Monitoring
9. Home and 
10. Mobile Working.
• Seven dimensions of security culture:  
1. Behaviors
2. Cognition
3. Communication
4. Compliance
5. Norms
6. Responsibilities
7. Attitude 

 Excel Learning

Microsoft Excel holds immense importance in the corporate world as a versatile and indispensable tool for data management, analysis, and reporting. Its spreadsheet capabilities empower professionals to organize vast amounts of information, perform complex calculations, and create visually appealing charts and graphs. Excel facilitates efficient financial modeling, budgeting, and forecasting, enabling businesses to make informed decisions. Moreover, it plays a crucial role in project management, tracking key performance indicators, and streamlining various business processes. The ability to collaborate in real-time through cloud-based solutions enhances teamwork and ensures data accuracy. In essence, Microsoft Excel has become a fundamental component in the daily operations of organizations, providing a robust foundation for data-driven decision-making and contributing significantly to overall productivity and efficiency in the corporate landscape.

For new graduates entering the workforce, acquiring proficiency in Microsoft Excel is a skill that can significantly enhance their employability and effectiveness in various roles. Excel proficiency is highly valued across industries as it enables individuals to efficiently manage and analyze data, a crucial aspect of decision-making in most professional settings. From creating organized spreadsheets to conducting data analysis, new graduates equipped with Excel skills can streamline tasks, demonstrate analytical prowess, and present information in a clear and visually appealing manner. This proficiency not only enhances one's problem-solving abilities but also showcases a commitment to efficiency and attention to detail. As organizations increasingly rely on data-driven insights, learning Excel provides new graduates with a valuable edge, facilitating a smoother transition into the dynamic and competitive landscape of the professional world.

Excel Basic Intro: https://www.youtube.com/watch?v=k1VUZEVuDJ8&t=1156s

21 most useful functions and formulas: https://www.youtube.com/watch?v=hGIz0NLmjBc

Pivot Table: https://www.youtube.com/watch?v=ZZRl7fALdjw

XLOOKUP, VLOOKUP, HLOOKUP: https://www.youtube.com/watch?v=3MdPSHkyfdI

Create Gantt Chart in Excel: https://www.youtube.com/watch?v=tuQpGzL_14g

Create Time Line: https://www.youtube.com/watch?v=00s5efQWrgU

SUMIF Function: https://www.youtube.com/watch?v=ZhLKp5VXIE0

Advanced Excel Full Course (7.5 hours): https://www.youtube.com/watch?v=RkQl2wVpQAo

Top 26 Free Courses on Excel.

• [1] Work Smarter with Microsoft Excel - 🔗https://lnkd.in/d38r3zTG
• [2] Getting started with Microsoft Excel - 🔗https://lnkd.in/df6tDHKE
• [3] Create a Project Management Tracker using Microsoft Excel - 🔗https://lnkd.in/dsmrFV8T
• [4] Create a Simple Gantt Chart using Microsoft Excel - 🔗https://lnkd.in/damVQgiC
• [5] Excel Skills for Business Specialization - 🔗https://lnkd.in/dRsV2Uvm
• [6] Excel for Beginners: Pivot Tables - 🔗https://lnkd.in/d5XRbJ_g
• [7] Excel/VBA for Creative Problem-Solving Specialization - 🔗https://lnkd.in/dtVZZUwr
• [8] Excel for Beginners: Introduction to Spreadsheets - 🔗https://lnkd.in/dnkxXARF
• [9] Excel for Beginners: Advanced Functions - 🔗https://lnkd.in/dce_34CY
• [10] Using Advanced Formulas and Functions in Excel - 🔗https://lnkd.in/d577DX7V
• [11] IBM Data Analytics with Excel and R - 🔗https://lnkd.in/dAKM2tRT
• [12] Excel to MySQL: Analytic Techniques for Business Specialization - 🔗https://lnkd.in/djavY4X5
• [13] Using Basic Formulas and Functions in Microsoft Excel - 🔗https://lnkd.in/dqrS4bb5
• [14] Excel Skills for Business: Advanced - 🔗https://lnkd.in/dX_DtnVw
• [15] Introduction to Data Analysis using Microsoft Excel - 🔗https://lnkd.in/dQbMda75
• [16] Excel Basics for Data Analysis - 🔗https://lnkd.in/dUCebmcc
• [17] Data Visualization with Advanced Excel - 🔗https://lnkd.in/drYHVEv7
• [18] Create Charts and Dashboards Using Microsoft Excel - 🔗https://lnkd.in/dC4dpBqv
• [19] Create a budget with Microsoft Excel - 🔗https://lnkd.in/ddTyzACz
• [20] Create a Simple Project Timeline in Microsoft Excel - 🔗https://lnkd.in/dqEHCp8w
• [21] Create a Financial Statement using Microsoft Excel - 🔗https://lnkd.in/dQW36KqG
• [22] Charts, Pictures, Themes, and Styles in Microsoft Excel - 🔗https://lnkd.in/d6TxYUDP
• [23] Excel Skills for Business Forecasting Specialization - 🔗https://lnkd.in/d_p98qWK
• [24] Custom & Conditional Formatting in Microsoft Excel - 🔗https://lnkd.in/d688i8C5
• [25] Create Customer Support Data with Microsoft Excel - 🔗https://lnkd.in/dd6M82uh
• [26] How to Use Lookup Reference Math and Text Functions in Excel - 🔗https://lnkd.in/ddz-tRNd