209 Finance courses in Leatherhead

Overview Understand the structure and mechanics of Target Redemption Notes (TARNs), autocallables, accumulators, and faders. Who the course is for CEOs, CFOs, COOs with responsibility for Strategic Management Investment bankers Real estate consultants Management consultants Private Equity investors Financial analysts Institutional Funds and Portfolio Managers Retail investors Course Content To learn more about the day by day course content please click here. To learn more about schedule, pricing & delivery options speak to a course specialist now

Overview This is a 1 Day Product course and as such is designed for participants who wish to improve the depth of their technical knowledge surrounding Exotic Options. Who the course is for Equity and Derivative sales Equity and Derivative traders Equity & Derivatives structurers Quants IT Equity portfolio managers Insurance Company investment managers Risk managers 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

Course Duration: Full-day program (or two half-day modules), with options for virtual delivery or leadership retreats Target Audience: Mid to senior-level leaders, team managers, project leads, or high-potential employees who are responsible for leading through disruption, complexity, or organisational transformation. Course Objectives By the end of this course, participants will be able to: Understand the principles of adaptive leadership and why it's essential in unpredictable environments. Recognise the difference between technical and adaptive challenges. Build the mindset and behaviours needed to lead with resilience and flexibility. Engage and empower teams in the face of uncertainty and resistance. Apply practical tools to lead through change, conflict, and complexity. Course Outline Module 1: Understanding Adaptive Leadership What is adaptive leadership? Origins (Harvard Kennedy School, Ronald Heifetz model) How adaptive leadership differs from traditional leadership The link between complexity, uncertainty, and the need for adaptability Module 2: The Nature of Change and Challenge Technical vs adaptive challenges Why some problems can’t be solved with expertise alone Common leadership traps during crisis or disruption Adaptive work: reframing problems and shifting mindsets Module 3: The Core Principles of Adaptive Leadership Get on the balcony – seeing the bigger picture Regulate distress – maintaining productive tension Maintain disciplined attention – keeping teams focused Give the work back – empowering others to lead Protect voices of leadership from below – enabling diverse input Module 4: Leading Yourself Through Uncertainty Developing personal resilience and emotional agility Navigating ambiguity, setbacks, and pressure Identifying your leadership default style under stress Reflection: What kind of leader does your team need now? Module 5: Engaging Others in Times of Uncertainty Building trust and psychological safety during turbulence Managing resistance to change with curiosity and empathy Tools for courageous conversations and adaptive dialogue Creating shared purpose and distributed leadership in teams Module 6: Adaptive Tools and Techniques Scenario planning and sensemaking Stakeholder mapping in dynamic environments Using inquiry over advocacy Holding space for experimentation and learning Leading with both confidence and humility Module 7: Action Planning and Application Identify one adaptive challenge in your role/team Map your adaptive leadership response Peer coaching conversations Build a 30-day Adaptive Leadership Plan Delivery Style Workshop-style, highly interactive Case studies, breakout discussions, and guided self-reflection Scenario-based practice and small group exercises Option to include pre-work, post-session coaching or check-ins Course Materials Provided Adaptive Leadership workbook Reflection tools and leader self-assessment Conversation guide for adaptive challenges Change resistance diagnostic Personal Leadership Development Plan template Optional Add-ons Executive coaching package 360 feedback or team diagnostic on adaptive capacity Integration with change management or innovation programs Customisation for specific industries (e.g., public sector, healthcare, education, finance)

Course Duration: Full-day program (or two half-day modules), with options for virtual delivery or leadership retreats Target Audience: Mid to senior-level leaders, team managers, project leads, or high-potential employees who are responsible for leading through disruption, complexity, or organisational transformation. Course Objectives By the end of this course, participants will be able to: Understand the principles of adaptive leadership and why it's essential in unpredictable environments. Recognise the difference between technical and adaptive challenges. Build the mindset and behaviours needed to lead with resilience and flexibility. Engage and empower teams in the face of uncertainty and resistance. Apply practical tools to lead through change, conflict, and complexity. Course Outline Module 1: Understanding Adaptive Leadership What is adaptive leadership? Origins (Harvard Kennedy School, Ronald Heifetz model) How adaptive leadership differs from traditional leadership The link between complexity, uncertainty, and the need for adaptability Module 2: The Nature of Change and Challenge Technical vs adaptive challenges Why some problems can’t be solved with expertise alone Common leadership traps during crisis or disruption Adaptive work: reframing problems and shifting mindsets Module 3: The Core Principles of Adaptive Leadership Get on the balcony – seeing the bigger picture Regulate distress – maintaining productive tension Maintain disciplined attention – keeping teams focused Give the work back – empowering others to lead Protect voices of leadership from below – enabling diverse input Module 4: Leading Yourself Through Uncertainty Developing personal resilience and emotional agility Navigating ambiguity, setbacks, and pressure Identifying your leadership default style under stress Reflection: What kind of leader does your team need now? Module 5: Engaging Others in Times of Uncertainty Building trust and psychological safety during turbulence Managing resistance to change with curiosity and empathy Tools for courageous conversations and adaptive dialogue Creating shared purpose and distributed leadership in teams Module 6: Adaptive Tools and Techniques Scenario planning and sensemaking Stakeholder mapping in dynamic environments Using inquiry over advocacy Holding space for experimentation and learning Leading with both confidence and humility Module 7: Action Planning and Application Identify one adaptive challenge in your role/team Map your adaptive leadership response Peer coaching conversations Build a 30-day Adaptive Leadership Plan Delivery Style Workshop-style, highly interactive Case studies, breakout discussions, and guided self-reflection Scenario-based practice and small group exercises Option to include pre-work, post-session coaching or check-ins Course Materials Provided Adaptive Leadership workbook Reflection tools and leader self-assessment Conversation guide for adaptive challenges Change resistance diagnostic Personal Leadership Development Plan template Optional Add-ons Executive coaching package 360 feedback or team diagnostic on adaptive capacity Integration with change management or innovation programs Customisation for specific industries (e.g., public sector, healthcare, education, finance)

This course will provide delegates involved in tackling the financial underpinning of corrupt behaviour with the knowledge, concepts and practices necessary to understand and mitigate illicit financial flows.

Person-centred approaches are a core skills framework that articulates what it means to be person-centred and how to develop and support the workforce to work in this way. Developed in partnership with Skills for Health and Skills for Care, the Framework aims to distil best practices and to set out core, transferable behaviours, knowledge and skills. It is applicable across services and sectors and across different types of organisations. Person-centred approaches underpins existing dementia, learning disabilities, mental health and end of life care core skills frameworks. This subject forms standard 5 in The Care Certificate.

This course aims to increase and enhance delegates’ understanding of the various financial crime threats which impact upon the organisations, sectors and regions in which they operate and provide them with the tools to mitigate those threats. It assumes no prior knowledge of the subject but ensures through a high level of interactivity that delegates with any level of experience in the field will be able to share and receive the collective knowledge of the group.

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

Use some of the hidden statistical analysis tools within Excel to build complex data models. Course overview Duration: 1 day (6.5 hours) This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used. This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths. Objectives By the end of the course you will be able to: Use Goal Seek Create and view scenarios Use Forecast Sheet Create single and double input data tables Create models using the solver Install and use the Analysis Toolpak Create and use array formulas Use a range of advanced Financial and Statistical Excel functions Content Using what if analysis options Using Goal Seek Creating, saving and viewing scenarios Generating a Forecast sheet Solver Creating models Projecting scenarios with Solver Using data tables Creating single input data tables Creating double input data tables Projecting with data tables Financial functions PMT FV NPV Analysing data with Analysis ToolPak Installing the Analysis Toolpak Generating statistical analysis Visualising data using Histograms Array formulas Using embedded Excel Array formulas Create an Array formula Multi and single cell Array formula Using TRANSPOSE to flip rows or columns Use the FREQUENCY Function Use an array to count unique entries in a range Dynamic arrays Spilling data Using the new dynamic array functions Advance functions in formulas Statistical functions:MEAN, MEDIAN and MODERANKLARGE and SMALLMODPERCENTILE Use the AGGREGATE function to sum data in ranges with errors

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers