Overview 2 day applied course with comprehensive case studies covering both Standardised Approach (SA) and Internal Models Approach (IMA). This course is for anyone interested in understanding practical examples of how the sensitivities-based method is applied and how internal models for SES and DRC are built. Who the course is for Traders and heads of trading desks Market risk management and quant staff Regulators Capital management staff within ALM function Internal audit and finance staff Bank investors – shareholders and creditors Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now
Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge
Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge
FourSquare Training specialise in private, corporate Microsoft Excel courses delivered at your premises and tailored to your needs.
For boards and staff, board meetings always involve too much time, too much effort, too much material to review, and too few tools to make governance effective. Here are the top tools, tips and timesavers boards around the world use to make your impossible boardroom tasks do-able.
Overview This two-day intensive course is ideal for finance professionals seeking to deepen their expertise in options trading and volatility management. The course will cover option pricing and risk management techniques. Exploring differences between physical and cash-settled options European versus American/Bermudan options, and the implications of deferred premiums. Examining the role of volatility in option pricing & Managing First-Generation Exotics. Who the course is for Derivative traders Quants and research analysts Fund managers, fund of funds Structured product teams Financial and valuation controllers Risk managers and regulators Bank and corporate treasury managers IT Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now
Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE
The Professional Driver 7-Hour Course for One Day Course Introduction: This one-day course is designed to provide professional drivers with the essential knowledge and skills required to operate their vehicles safely and efficiently. The course covers a wide range of topics, including: Licence requirements Personal protective equipment (PPE) Vehicle pre-trip inspections Safe and economic driving Bridge strike avoidance and route planning Vehicle security Overnight parking The course is delivered in a classroom/remote location setting and includes a mix of lectures, interactive discussions, and practical exercises. Participants will also have the opportunity to network with other professional drivers and share their experiences. Who should attend? This course is suitable for all professional drivers, regardless of experience level. It is particularly beneficial for drivers who are new to the profession, as well as drivers who are looking to refresh their skills and knowledge. What will you learn? Upon completion of this course, participants will be able to: Understand and comply with all applicable licence requirements for professional drivers Identify and use the correct PPE for different driving tasks Conduct pre-trip vehicle inspections to identify any potential problems Drive safely and economically, taking into account road conditions, traffic, and fuel efficiency Avoid low bridges and plan routes effectively Secure vehicles to prevent theft and hijacking Park vehicles safely overnight We look forward to seeing you there! 😃
Overview 1 day course on IFRS 9 expected credit loss modelling, both for financial statement and capital stress testing purposes Who the course is for Credit risk management Quants ALM staff Finance Internal audit External auditors Bank investors – equity and credit investors Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now
If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on the core values of customer service.