50382 Courses delivered Online

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives  By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code

Overview Understand the role of corporate structure, dividends and equity indices in equity markets. Become familiar with the building blocks of repos / stock lending, futures and forwards – and how to use these products. Understand how to price, and risk manage equity swaps and dividend swaps. Gain experience in their uses in trading, corporate finance and portfolio management. Learn how to price equity options and the features that make them different from other asset classes, explore how to use these products for taking equity risk, yield enhancement and portfolio protection. Understand strategies designed to trade / hedge volatility using options. Who the course is for Risk management Finance Sales and trading Treasury Technology Financial Engineering 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

Understand how to effectively manage conflict and learn that conflict can be healthy and need not damage relationships. Course overview Duration: 1 day (6.5 hours) Conflict and differences of opinion are inevitable in the today’s fast moving, complex business world, some would argue they are even necessary. This highly interactive and practical course addresses the many aspects of effectively managing conflict and will help you ensure that conflict can be healthy and need not damage the relationship. This workshop has been specifically designed to give you an opportunity to learn and test a range of influencing and conflict handling models and techniques. The course is aimed at anyone who interacts with others on a regular basis. Objectives  By the end of the course you will be able to: Utilise influencing skills to pre-empt and defuse conflict Resolve conflict by choosing the right approach Recognise the impact of non-verbal communication in managing conflict Use language skills necessary to get you message across in the ‘right’ way Present your case in a reasonable and responsible manner Identify behaviours that can help or hinder interactions with others Apply different techniques for managing conflict positively and for dealing with aggression Content Developing Influence Networking Sources of influence Influencing techniques Effective Behaviour Choosing the right approach Techniques to pre-empt or defuse conflict Behavioural styles and their impact on working relationships Triggers to aggressive behaviour Managing conflict flash points Dealing with different behaviour types Developing Skills Communication skills in conflict situations Using the right language Verbal and non verbal communications Managing our body language Your conflict management style analysis Thomas Killman Conflict Handling Instrument Working in groups Practical exercises and case studies The language of mediation Transactional Analysis Practical Practical exercises Case studies Personal action planning

Coming soon! Tailored for seasoned professionals, our Level 7 Senior Leader course is for those seeking to enhance their leadership capabilities, this program is designed for individuals aspiring to or currently occupying senior leadership roles. Delve into advanced concepts of strategic leadership, organizational effectiveness, and change management. Explore the nuances of decision-making at the executive level, honing your skills in navigating complex business landscapes.

To increase your awareness and understanding of what safeguarding children means, in order to increase your confidence to enable you to make a positive contribution towards the process.

Overview A review of the most enduringly popular structured equity-linked products. This 1 day hands-on programme will help you gain familiarity with 1st generation & 2nd generation structured products convexity – and their applications. Discover techniques for maximising the participation rate to enhance returns for investors. Explore the trade-offs between coupon payments and gearing, and how they affect the risk-return profile of the notes. Explore ladder structures, their relationship to lookbacks, and the benefits they offer to investors. Learn about accumulators, their structuring, and the reasons behind their controversy in the market. Who the course is for Structured Products Desks, Financial Engineers, Product Controllers Traders, Dealing Room Staff and Sales People Risk Managers, Quantitative Analysts and Middle Office Managers Fund Managers, Investors, Senior Managers Researchers and Systems Developers 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

Coming soon! Embark on a pioneering journey into the realm of strategic learning and development with our Level 5 Learning & Development Consultant (Business Partner) course. Tailored for individuals poised to step into the pivotal role of a Learning & Development Consultant, whether through recent recruitment or a well-deserved promotion, this program serves as a catalyst for acquiring advanced skills and unique insights crucial for excelling in the dynamic field of L&D.

Understand the biases we all have and the impact they can have in the workplace. Look at how to minimise their impact on others and the organisation. Course overview Duration: 1 day (6.5 hours) The purpose of this course is to help individuals understand and recognise their own unconscious biases, and to provide strategies on how to minimise the impact of those biases in the workplace. The course will provide an overview of what unconscious bias is, its prevalence and impact, and ways to mitigate its effects. Objectives By the end of the course you will be able to: Define unconscious bias and recognise different types of bias Understand how unconscious bias affects decision-making and behaviours in the workplace Identify their own unconscious biases Understand the impact of unconscious bias on individual and team performance Apply strategies to mitigate the effects of unconscious bias in the workplace Content Module 1: Introduction to Unconscious Bias Definition of unconscious bias History and prevalence of unconscious bias Different types of unconscious bias (e.g. affinity bias, confirmation bias) Module 2: Understanding the Impact of Unconscious Bias How unconscious bias affects decision-making and behaviours in the workplace Examples of unconscious bias in the workplace Impact of unconscious bias on individual and team performance Module 3: Recognising Your Own Unconscious Biases Identifying personal biases Tools to recognise and minimise unconscious biases Module 4: Mitigating the Impact of Unconscious Bias in the Workplace Best practices for reducing unconscious bias in the workplace Strategies for managerial and executive leadership to combat unconscious bias Tips for creating a culture of inclusion and diversity

We've all sat through far more bad presentations than good ones, but knowing what 'good' looks like is easier than successfully replicating it. Sales presentations are a performance and, as salespeople, fluffing our lines can cost us a lot more than hurt pride. Having discovered and understood the specific needs and burning issues our prospect has, then this course will help any salesperson avoid dropping the ball and instead wowing their prospects with a high-impact, tailored and compelling case for purchase. This course will help participants: Prepare mentally and physically for stand-up presentations Use voice modulation and bullet-pointing to demand attention Avoid boring their prospects Master the do's and don'ts of PowerPoint Deal more effectively with technical hitches and prospect's interruptions Use eye contact and engagement to avoid prospects 'tuning out' Deploy best practice essentials for presenting with colleagues Steer through the toughest Q&A 1 Preparing your presentation Mindset Knowing your objective(s) Vocal warm-up techniques Assembling pre-agreed benefits Time management Room set-up Technical preparation 2 How to open your presentation Vocal energy Summary and agreement of prospect's needs How to have posture and confidence Use of humour What to do with those dreaded hands Confident v non-confident body language 3 How to get and keep people's attention Bullet pointing Linking benefits to specific, stated needs Practical exercise - formulating and delivering tailored benefits Being selective with features Third party reinforcement and case studies 'Watering the garden' eye contact technique Practical exercise - participants practise 'sharing out' eye contact to audience How to handle a prospect's negative body language Handling interruptions 4 Presenting in groups Credentialing all participants Role delineation for group presentations Edifying other participants' messages - do's and don'ts How to maintain energy when not speaking Practical exercise - good and bad practice when not speaking Teamwork in Q&A sessions How to hand over professionally 5 PowerPoint do's and don'ts Use of visual aids Good and bad PowerPoint slides How to make PowerPoint work for you Classic PowerPoint errors Avoiding and handling technical problems Good and bad flipchart practice 6 Closing and / or achieving next action steps Power of summary Good Q&A practice Handling objections Practical exercise - handling objections on one's feet Creating consensus among prospect panel What to do when prospects disagree with each other When to trial close How to close on next action steps 7 Wrap-up Key learning points from each participant Action steps to be implemented on next presentations

Fraud should not happen, but it does. It can happen at the highest to lowest levels in an organisation. Recent surveys show that incidents of fraud are not decreasing. Fraud costs companies money and, perhaps even more importantly, reputational damage. The losers are not just the shareholders, suppliers, customers, etc, but society as a whole. This programme shows why frauds happen, how organisations put themselves at risk and what they can do to prevent it. This programme will help directors and others understand: The motives for committing fraud Directors' responsibilities for identifying and reporting fraud What types of frauds there are How frauds are perpetrated How they can be prevented How regulators deal with fraud Above all, the principal objective of this programme is to help make your organisation as secure as possible from the threat of fraud. 1 Motives for committing fraud - drivers of fraud Session objective: to understand why people might commit fraud Drivers of fraudulent behaviourAmbitionGreedTheftConceit? And more! 2 Accounting mechanisms that allow fraud Session objective: to review the elements of the accounting, internal control and management processes that allow creative accounting Income or liability? Asset or expense? Coding errors and misclassification Netting off and grossing up Off-balance sheet items 3 Structures that allow fraud Session objective: to consider company and trading structures that allow frauds to be perpetrated Group structures Trading structures Tax havens Importing and exporting 4 Interpretations and other non-compliance that allow fraud Session objective: to look at how creative interpretations of law and accounting practice may permit fraud The place of accounting standards Accounting policies Trading methods The place of auditing standards 5 Money laundering Session objective: to review what constitutes money laundering Types of money laundering Identifying laundering Preventing laundering 6 Preventing fraud - proper management structures Session objective: to review the place of proper corporate governance Corporate governance Company management structure Audit committees The place of internal audit 7 Preventing fraud - proper accounting Session objective: to review best accounting and auditing practice Accounting standards Internal accounting policies Adequacy of internal controls Internal audit 8 Preventing fraud - regulation Session objective: to look at how regulators aim to prevent fraud The regulatory environment Financial services regulation 9 Conclusion Course review Open forum Close 10 Course summary - developing your own cost action plan Group and individual action plans will be prepared with a view to participants identifying their cost risks areas and the techniques which can be immediately applied to improve costing and reduce costs