1979 Courses in Edinburgh

Overview 2 day course on single name CDS, index CDS and index CDS options and how to use them to express views and hedge risks in credit markets Who the course is for Consultants Analysts Managers C-Level executives People in need of knowledge to develop a blockchain strategy People working with blockchain projects Regulators Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview This 2 day course focuses on best practice bank ALM in today’s environment of a multiplicity of regulatory constraints on the balance sheet Who the course is for Asset Liability Committee (ALCO) members Treasury Risk Finance and internal audit capital management Funding management Liquidity buffer investment team Derivative structurers and salespeople; IT software providers Regulators Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Domestic Abuse Perpetrator Program 'Empowering Change'

Overview This 2-day programme covers the latest techniques used for fixed income attribution. This hands-on course enables participants to get a practical working experience of fixed income attribution, from planning to implementation and analysis. After completing the course you will have developed the skills to: Understand how attribution works and the value it adds to the investment process Interpret attribution reports from commercial systems Assess the strengths and weaknesses of commercially available attribution software Make informed decisions about the build vs. buy decision Present results in terms accessible to all parts of the business Who the course is for Performance analysts Fund and portfolio managers Investment officers Fixed Income professionals (marketing/sales) Auditors and compliance Quants and IT developers Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview 2 day course on scorecards, rating agency frameworks, regulation and integration and quantification of Environmental, Social and Governance (ESG) analysis into equity and credit investing / lending for / to corporates, banks and other financial institutions, applied to many case study companies and industries Who the course is for Investors and analysts – equity and credit; public and private Bank loan officers M&A advisors Restructuring advisors Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Overview 2 day course on key interest rate derivative products, covering both theory (product mechanics, market conventions and valuation) and practice (wide range of applications for wide range of market participants showcased) Who the course is for Interest rate traders, salespeople and quants Asset-liability management staff with banks and insurance companies Fixed income and credit asset managers / hedge funds / pension funds / insurance companies Corporate treasurers Risk management Anyone using interest rate derivatives Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview The first half of the course will cover all the essential tools of the currency markets – spot FX, forwards, FX swaps and NDFs. We look both at the pricing of these products and also how customers use them. The afternoon session will cover a range of important topics beyond the scope of an elementary course on currency options. We start with a quick review of the key concepts and terminology, and then we look at the key exotics (barriers and digitals) and how they are used to create the most popular customer combinations. We move on to look at the currently most-popular 2nd generation exotics, such as Accumulators, Faders and Target Redemption structures. Who the course is for FX Sales, traders, structurers, quants Financial engineers Risk Managers IT Bank Treasury ALM Central Bank and Government Treasury Funding managers Insurance Investment managers Fixed Income portfolio managers Regulators Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview The objective of this course is to equip professionals with comprehensive knowledge and practical skills in WEB 3 technologies and crypto assets. Participants will gain a deep understanding of the underlying principles of blockchain, the operational mechanics of cryptocurrencies, the potential impact of these technologies on the banking sector and the latest trends. Who the course is for Consultants Analysts Managers C-Level executives People in need of knowledge to develop a blockchain strategy People working with blockchain projects Regulators Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

The CIEH Introductory Certificate in Occupational Health and Safety provides an awareness of key health and safety issues, and the part that staff should play in keeping themselves and others free from harm at work. This course will give you a basic background in, and understanding of, general health and safety practices and the control measures required to reduce risks in the workplace.