194 Accounting & Finance courses in London

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 click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

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 Learn about contract triggers, including European vs. American style, and variations like one-touch, no-touch, and double no-touch options. Who the course is for Risk managers IT System developers Traders and derivatives teams Consultants and brokers 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 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 click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

In today's competitive business world firms are under unprecedented pressure to deliver value to their shareholders and other key stakeholders. Senior executives in all parts of the organisation are finding that they need some degree of financial know how to cope with the responsibility placed on them as business managers and key decision-makers; monitoring and improving business performance, investing in capital projects, mergers and acquisitions: all require some degree of financial knowledge. The key financial skills are not as difficult to learn as many people believe and in the hands of an experienced senior executive they can provide a formidable competitive advantage. After completing this course delegates will be able to: Understand fundamental business finance concepts; understand, analyse and interpret financial statements: Profit Statement, Balance Sheet and Cashflow Statement Understand the vital difference between profit and cashflow; identify the key components of working capital and how they can be managed to generate strong cashflow Evaluate pricing decisions based on an understanding of the nature of business costs and their impact on gross margin and break-even sales; managing pricing, discounts and costs to generate strong business profits; understand how lean manufacturing methods improve profit Use powerful analytical tools to measure and improve the performance of their own company and assess the effectiveness of their competitors Apply and interpret techniques for assessing and comparing investment opportunities in capital projects, business acquisitions and other ventures; understand and apply common methods of business valuation Understand the role of business finance in formulating and implementing competitive business strategy; the role of budgeting as part of the planning process and the various approaches to budgeting and performance measurement 1 Basic principles Delivering value to key stakeholders Accounting concepts, GAAP, IFRS and common terms Understanding and using the balance sheet Understanding and using the profit statement Recognising the vital difference between profit and cashflow Understanding and using the cashflow statement What financial statements can and cannot tell us 2 Managing and improving cashflow Sources of finance and their advantages and disadvantages What is working capital and why is it so important? Managing stocks, debtors and creditors Understanding how working capital drives business growth Understanding and avoiding the over-trading trap Unlocking the funds tied up in fixed assets: asset backed loans and leasing 3 Managing and improving profit Understanding how profits generate cashflow The fundamental nature of costs: fixed and variable business costs Understanding gross margin and break-even How common pricing methods affect gross margin and profit Effective strategies to improve gross margin Using value chain analysis to reduce costs Lean manufacturing methodsUnderstanding Just-in-time, 6 Sigma and Kaizen methods Improving profitEffective and defective strategies 4 Measuring and managing business performance Measures of financial performance and strength Investor behaviour: the risk and reward relationship Return on investment (ROI): the ultimate measure of business performance How profit margin and net asset turnover drive return on net assets Why some companies are more profitable that others Understanding competitive advantage: cost and differentiation advantage Why great companies failWhat happened to Kodak? Using a 'Pyramid of Ratios' to improve business performance Using Critical Success Factors to develop Key Performance Indicators 5 Budgeting and forecasting methods Using budgets to support strategy Objectives and methods for effective budgets Using budgets to monitor and manage business performance Alternative approaches to budgeting Developing and implementing Balanced Scorecards Beyond Budgeting Forecasting methods and techniques Identifying key business drivers Using rolling forecasts and 'what-if' models to aid decision-making

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

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 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 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

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

Finance doesn't have to be a puzzle. And if you want to get anywhere with your career, it had better not be! Whatever your role, you have an impact on the financial wellbeing of the organisation you work for, whether you've got specific financial responsibilities or not. This thoroughly practical, fun and enjoyable one-day workshop will help unpuzzle finance for you. It's an ideal opportunity to master the terminology, get to grips with the concepts, learn how 'the finance department' works and understand the part you play. This course will help participants: Appreciate the role and importance of Finance within organisations Be able to recognise and describe some of the common items and jargon used Identify the elements of the Profit & Loss and the Balance Sheet Understand cashflow Make better decisions Manage budgets 1 Introduction Expectations Terminology Key financial principlesAccrualsConsistencyPrudenceGoing concern 2 The three main financial statements Profit & Loss accountIncomeCost of salesGross profitAdministrative expenses ('overheads')Net profit/(loss) for the financial year (the 'bottom line')P&L format Balance SheetTerminologyFixed AssetsCurrent AssetsCurrent LiabilitiesLong-term LiabilitiesCapitalB/S format Cashflow Statement Financial and management information systems 3 Budgets and forecasts Why budget? Types of budget - incremental or zero-based Budgeting for costs - fixed and variable Budgeting for income An eight point plan for budgeting for your department Case study: Small Brother Ltd Problems and solutions 4 Accruals Accruals - what and why? Prepayments 5 Open forum