174 Courses in London

This course covers the essential Excel data skills. Our course is interactive, instructor-led. This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. These concepts are daily used by data analysts and is a basic essential skill for data professionals. By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. You will create Excel data analytical spreadsheets and samples that you can use as examples at work.

Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments

C++ Bootcamp is for coding beginners: You want all the basic stuff, all the advanced stuff and practical experience and get a fantastic job in C++

Full stack, in depth , comprehensive in classroom 3 month training on Java programming. 1 lesson a week, the other days you work on your own on structured homework and supported with a 1-1 mentor.

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. Private individuals are also very welcome.

About this Training The expanding human population and industrialisation are increasing the demand for energy worldwide. This has resulted in numerous challenges such as environmental pollution, reliable supply of fossil fuels, and increased demand of electricity supply, which must be overcome. To fulfil the energy demands and overcome these challenges, numerous projects and funds are involved in finding an adequate solution. Transport accounts for around one-fifth of global carbon dioxide (CO2) emissions and road travel accounts for three-quarters of transport emissions. Most of this comes from passenger vehicles. Emission limits are increasingly stringent, and the fuel industry must change its approach to product formulation to meet the challenge. Training Objectives Upon completion of this course, participants will be able to: Get a clear overview of the different types of bio and alternative fuels Understand how different bio and alternative fuels are produced Have an overview of feedstock utilised for biofuels production Realize how the biofuels production could be integrated in modern refinery Understand how bio and alternative fuels function as single and blended fuels Understand what impact bio and alternative fuels have on car engine Get an overview of the environmental impact of bio and alternative fuels Get the overview of regulation related to bio and alternative fuel Target Audience The course is intended for individuals who are interested in or developing in the field of bio and alternative fuels. The following personnel will benefit from the knowledge shared in this course: Refinery Technical Personnel Trading and blending personnel Sales, marketing, and product trading personnel Laboratory supervisors and technical personnel Policymakers Professionals who are interested in or developing in the field of bio and alternative fuels Process, project, and consultant engineers involved in bioenergy, petrochemical and chemical industries Course Level Basic or Foundation Trainer Your expert course leader is an experienced manager with more than 25 years of operational experience in the downstream Oil & Gas industry. She is a recognised expert in conventional, biofuels and alternative fuels with extensive experience in the crude selection process and formulation of finished products including product portfolio strategy, product quality road mapping and benchmarking. She is a long-time laboratory manager with comprehensive experience in laboratory processes, including financing, benchmarking, efficiency improvement and total quality management processes. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Osteopathic Approach to the Tempro-Mandibular Joint, exploring how the TMJ impacts posture and movement and vice versa. Course will include internal and external treatment to the TMJ

Still Technique course, suitable for osteopaths and final year osteopathic students

The CAIA Association is a global professional body dedicated to creating greater alignment, transparency, and knowledge for all investors, with a specific emphasis on alternative investments. Course Overview The CAIA Association is a global professional body dedicated to creating greater alignment, transparency, and knowledge for all investors, with a specific emphasis on alternative investments. A Member-driven organization representing professionals in more than 100 countries, CAIA Association advocates for the highest ethical standards. Whether you need a deep, practical understanding of the world of alternative investments, a solid introduction, or data science skills for the future in finance, the CAIA Association offers a program for you. Why CAIA? Distinguish yourself with knowledge, expertise, and a clear career advantage – become a CAIA Charterholder. CAIA® is the globally recognized credential for professionals allocating, managing, analyzing, distributing, or regulating alternative investments. For Level I, the curriculum takes a bottom-up approach to the alternative investments industry. The readings offer detailed insights into the variety of institutional-quality strategies spanning the alternatives universe. Upon completing Level I, Candidates should have working knowledge of the relevant strategies available for investment, along with the basic tools to evaluate them. The CAIA Charter is granted upon completion of two levels of qualifying exams, combined with relevant professional experience. Who will benefit from enrolling in the CAIA program? Professionals who want to develop a deep level of knowledge and demonstrated expertise in alternative investments and their contribution to the diversified portfolio should pursue the CAIA Charter including: • Asset Allocators • Risk managers • Analysts • Portfolio managers • Traders • Consultants • Business development/marketing • Operations • Advisors Curriculum Topics: Topic 1: Professional Standards and Ethics • Professionalism • Integrity of Capital Markets • Duties to Clients • Duties to Employers • Investment Analysis, Recommendations, and Actions • Conflicts of Interest Topic 2: Introduction to Alternative Investments • What is an Alternative Investment? • The Environment of Alternative Investment • Quantitative Foundations • Statistical Foundations • Foundations of Financial Economics • Derivatives and Risk-Neutral Valuation • Measures of Risk and Performance • Alpha, Beta, and Hypothesis Testing Topic 3: Real Assets • Natural Resources and Land • Commodities • Other Real Assets • Real Estate and Debt • Real Estate Equity Topic 4: Private Securities • Private Equity Assets • Private Equity Funds • Private Equity Funds of Funds • Evolution of Investing in Private Equity • Private Credit and Distressed Debt Topic 5: Hedge Funds • Structure of Hedge Funds • Macro and Managed Future Funds • Event-Driven and Relative Value Hedge Funds • Equity Hedge Funds • Funds of Hedge Funds Topic 6: Structured Products • Introduction to Structuring • Credit Risk and Credit Derivatives • CDO Structuring of Credit Risk • Equity-Linked Structured Products DURATION 200 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

The CAIA Association is a global professional body dedicated to creating greater alignment, transparency, and knowledge for all investors, with a specific emphasis on alternative investments. Course Overview The CAIA Association is a global professional body dedicated to creating greater alignment, transparency, and knowledge for all investors, with a specific emphasis on alternative investments. A Member-driven organization representing professionals in more than 100 countries, CAIA Association advocates for the highest ethical standards. Whether you need a deep, practical understanding of the world of alternative investments, a solid introduction, or data science skills for the future in finance, the CAIA Association offers a program for you. Why CAIA? Distinguish yourself with knowledge, expertise, and a clear career advantage – become a CAIA Charterholder. CAIA® is the globally recognized credential for professionals allocating, managing, analyzing, distributing, or regulating alternative investments. The Level II curriculum takes a top-down approach and provides Candidates with the skills and tools to conduct due diligence, monitor investments, and appropriately construct an investment portfolio. In addition, the Level II curriculum contains Emerging Topic readings; articles written by academics and practitioners designed to further inform and provoke the Candidate’s investment management process. After passing the Level II exam you are eligible, with relevant professional experience, to join the CAIA Association as a Member and receive the CAIA Charter. You will be part of an elite group of more than 13,000 professionals worldwide. Only after joining the Association, you are eligible to add the CAIA designation to your professional profiles. Who will benefit from enrolling in the CAIA program? Professionals who want to develop a deep level of knowledge and demonstrated expertise in alternative investments and their contribution to the diversified portfolio should pursue the CAIA Charter including: • Asset Allocators • Risk managers • Analysts • Portfolio managers • Traders • Consultants • Business development/marketing • Operations • Advisors Curriculum Topics: Topic 1: Emerging Topics • Decentralized Finance: On Blockchain- and Smart Contract-Based Financial Markets • Technical Guide for Limited Partners: Responsible Investing in Private Equity • Channels for Exposure to Bitcoin • Assessing Long-Term Investor Performance: Principles, Policies and Metrics • Demystifying Illiquid Assets: Expected Returns for Private Equity • An Introduction to Portfolio Rebalancing Strategies • Longevity and Liabilities: Bridging the Gap • A Short Introduction to the World of Cryptocurrencies Topic 2: Ethics, Regulation and ESG • Asset Manager Code • Recommendations and Guidance • Global Regulation • ESG and Alternative Investments • ESG Analysis and Application Topic 3: Models • Modeling Overview and Interest Rate Models • Credit Risk Models • Multi-Factor Equity Pricing Models • Asset Allocation Processes and the Mean-Variance Model • Other Asset Allocation Approaches Topic 4: Institutional Asset Owners and Investment Policies • Types of Asset Owners and the Investment Policy Statement • Foundations and the Endowment Model • Pension Fund Portfolio Management • Sovereign Wealth Funds • Family Offices and the family office Model Topic 5: Risk and Risk Management • Cases in Tail Risk • Benchmarking and Performance Attribution • Liquidity and Funding Risks • Hedging, Rebalancing, and Monitoring • Risk Measurement, Risk Management, and Risk Systems Topic 6: Methods for Alternative Investing • Valuation and Hedging Using Binomial Trees • Directional Strategies and Methods • Multivariate Empirical Methods and Performance Persistence • Relative Value Methods • Valuation Methods for Private Assets: The Case of Real Estate Topic 7: Accessing Alternative Investments • Hedge Fund Replication • Diversified Access to Hedge Funds • Access to Real Estate and Commodities • Access through Private Structures • The Risk and Performance of Private and Listed Assets Topic 8: Due Diligence and Selecting Managers • Active Management and New Investments • Selection of a Fund Manager • Investment Process Due Diligence • Operational Due Diligence • Due Diligence of Terms and Business Activities Topic 9: Volatility and Complex Strategies • Volatility as a Factor Exposure • Volatility, Correlation, and Dispersion Products and Strategies • Complexity and Structured Products • Insurance-Linked and Hybrid Securities • Complexity and the Case of Cross-Border Real Estate Investing DURATION 200 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate