405 Courses in London

About this Training Course Liquefied Natural Gas (LNG) has provided intercontinental mobility to natural gas, which now provides about 25% of the global primary energy. Being the cleanest fossil fuel, natural gas/LNG consumption is forecasted to grow in all future scenarios. With the entry of various players, including Trading companies, the LNG value chain is becoming increasingly complex, and a solid understanding of its economics and management of its interfaces have become crucial to identify and assess investment opportunities and risks. Recent market disturbances caused by COVID-19, Oil & Gas price instabilities - coupled with the political (Ukraine/Russia) challenges - make a deep understanding of LNG Value Chain Logistics and Economics even more essential to ensure the security of energy supplies sustainably and profitably. This intermediate level 3 full-day course starts with a concise introduction to the LNG business. Thereafter, the elements of the LNG value chain are described, and their individual economics analysed. A Business Activity Model along the value chain will be developed and discussed in depth, covering the following key processes: 'Buy Gas - Transport Gas - Liquefy Gas - Sell LNG/Products - Ship LNG - Regasify LNG' The integrated chain economics will then be developed and quantified. A hands-on group workshop/exercise developing the economic case of a full-sized Liquefaction project will be carried out, considering the forecasted cash flows throughout the project life, the location of the plant, its markets, project sensitivities and profitability assessment. Participants will be provided with Excel based tools/models (LNG Liquefaction project development Net Present Value (NPV) analyses, Shipping Freight Calculations and Economics) to work through the exercises and also for their future personal use. Training Objectives After the completion of this course, participants will be able to: Understand how the LNG Value Chain operates, bound by the relevant Contracts and Agreements. Learn the basic economic parameters (operating, capital costs, financing, profitability) of each major element of the value chain. Appreciate the complexity of the value chain, and the associated opportunities and risks. Develop quantitative project evaluation skills. Explore options to maximise profitability in a given LNG value chain. Discuss best practices on how to manage, steer and govern these activities. Target Audience Technical, Operational, Shipping, Commercial, Project and Governance professionals who are already active in a specific section of the LNG Value Chain will directly benefit in developing a wider and deeper perspective on how the LNG Value Chain operations and can be optimised. Managers (Technical, Financial, Legal and Governance) less familiar with the specifics of the LNG Industry will also benefit from attending this VILT course, as they will obtain the required background to be able to set sharper targets, suitable performance indicators, and governance and performance assessment guidelines for units engaged in the chain. The course is most relevant for professionals engaged in the LNG industry at: National and International Oil & Gas/Energy Companies LNG Importers/Exporters/Traders/Shippers Government & Regulatory Agencies Finance Institutions It will also apply to the following audience: Business Development Managers Corporate Planning Professionals Project Developers Supply Planners & Scheduling Professionals Regulators Tax & Finance Advisors Compliance Officers Equity Analyst and Bankers Joint Venture Representatives, Board Directors Negotiators and Contracting Staff Trading Professionals Course Level Intermediate Trainer Your expert course leader is an Oil & Gas/LNG professional with more than 35 years of international experience, majority of which was gained at Shell International Joint Ventures engaged in Oil Refining, Supply / Trading, Gas Supply and LNG Businesses in the Netherlands, France, Thailand, Dominican Republic and Nigeria. Since 2004, he has had several roles in the management of the LNG Value Chain including the Commercial Operational Management of Nigeria LNG (NLNG). He played an active role in the start-up and integration of LNG trains 4, 5 and 6 with NLNG becoming the 3rd largest LNG producer in the world in 2007. Commercial operations spanned 4 Gas Supply, 11 LNG Sales & Purchase Agreements, ad-hoc LPG and Condensate Sales and LNG Ship Chartering contracts. Under his supervision, more than 2,000 LNG cargoes were exported. He was part of the organizational transformation of the company from a Project-based set-up to a Production / Commercial based structure and implemented an 'Integrated Planning and Scheduling Department' in which he optimized the value chain (Buy-Gas - Liquify Gas to LNG - Sell - Ship LNG). Staff competence management was one of his focus areas during this period. He was also the NLNG representative on JV Technical, Commercial, Shipping Committees where he interfaced with Government & Regulatory authorities. In 2014, he was appointed as Shell Shareholder representative to NLNG and became a Non-Executive Board member to NLNG companies, including Bonny Gas Transport (BGT) managing 24 LNG Ships. During this period, he was involved in the Economic and Technical steering of the Shipping Fleet and Liquefaction Plant Rejuvenation projects and a further capacity expansion of liquefaction plant which resulted in the achievement of NLNG train 7 project FID in 2019. Since 2016, he has been active as an independent consultant. He co-authored 2 patents and more than 30 published papers/presentations. He holds a PhD from Delft University of Technology in the Netherlands and a MSc and BSc in Chemical Engineering from the University of Birmingham, UK. 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

NPORS Excavator as a Crane (N100)

NPORS Slinger / Signaller (N402)

This qualification is aimed at individuals who require training in conflict management. It is appropriate for a wide range of sectors, including Security, Healthcare Services, Event Organisers, Customer Service, Teachers and is suitable for anyone who has a customer-facing role, deals with service users or the public.

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored training courses: In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

NPORS Telescopic Handler Suspended Loads (N138)

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualisations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Introducing our comprehensive “Online Dating Tips for Miss Date Doctor” package, designed to equip you with expert guidance and proven strategies for navigating the digital dating landscape with confidence and success. Discover the secrets to standing out in the online dating world and attracting quality matches who are genuinely compatible with you. In this package, you’ll gain access to a wealth of valuable resources and personalized coaching from Miss Date Doctor, a trusted relationship expert. With her guidance, you’ll learn how to optimize your online dating profile, enhance your communication skills, and overcome common challenges faced in the world of online dating. Here’s what you can expect from our “Online Dating Tips for Miss Date Doctor” package: Profile Optimization Techniques: Craft an enticing and authentic online dating profile that captures attention and showcases your unique personality. Learn the art of choosing the perfect profile picture, writing engaging bios, and optimizing your presence on popular dating platforms like Tinder, Bumble, or OkCupid. Effective Communication Strategies: Master the art of online conversation and learn how to engage potential partners in meaningful dialogue. Discover techniques for initiating conversations, keeping them flowing, and creating a genuine connection that translates from the digital realm to real-life interactions. Gain insights into flirting, banter, and maintaining interesting conversations. Navigating Online Platforms: Understand the nuances of different online dating platforms and maximize your chances of finding success on each one. Whether it’s a mainstream app or a specialized dating website, you’ll learn how to tailor your approach and increase your visibility among potential matches. Explore related terms such as “best dating apps,” “dating site tips,” and “online dating platform comparison” to gain a comprehensive understanding. Safety and Security Guidelines: Prioritize your well-being with essential safety tips for online dating. Learn to identify red flags, protect your personal information, and ensure your online interactions remain secure. Explore related topics like “online dating safety,” “scam awareness,” and “privacy precautions” to stay informed and confident while navigating the digital dating world. Overcoming Common Challenges: Gain insights into overcoming common hurdles and setbacks encountered in online dating. From handling rejection gracefully to managing expectations, you’ll develop resilience and a positive mindset that will propel you forward on your dating journey. Explore related terms such as “dealing with rejection in online dating,” “managing dating expectations,” and “building dating confidence” for additional guidance. Enroll in our “Online Dating Tips for Miss Date Doctor” package today and empower yourself with the tools and knowledge necessary to transform your online dating experience. Let us guide you toward attracting meaningful connections and finding the love you deserve. Don’t let online dating become a source of frustration; embrace it as an exciting opportunity for personal growth and fulfilling relationships. With the “Online Dating Tips for Miss Date Doctor” package, you’ll be equipped to navigate the digital landscape confidently and embark on a journey towards love and happiness. https://relationshipsmdd.com/product/online-dating-tips-package/

Students will learn and develop skills needed for a range of financial processes, including maintaining cost accounting records, advanced bookkeeping and the preparation of financial reports and returns.  Course Overview This qualification covers a range of essential and higher-level accounting techniques and disciplines. Students will learn and develop skills needed for a range of financial processes, including maintaining cost accounting records, advanced bookkeeping and the preparation of financial reports and returns. Study the Level 3 Diploma to learn higher accounting techniques and disciplines and qualify for AAT bookkeeping membership (AATQB). The jobs it can lead to: • Accounts assistant • Accounts payable clerk • Audit trainee • Credit controller • Payroll administrator/supervisor • Practice bookkeeper • Finance assistant • Tax assistant • Accounts payable and expenses supervisor Entry requirements: Students can start with any qualification depending on existing skills and experience. For the best chance of success we recommend that students begin their studies with a good standard of English and maths. Course Content: Business Awareness: This unit provides students with an understanding of the business, its environment and the influences that this has on an organisation’s structure, the role of its accounting function and its performance. Students will examine the purpose and types for businesses that exist and the rights and responsibilities of the key stakeholders, as well as gain an understanding of the importance of professional ethics and ethical management within the finance function. Learning outcomes: • Understand business types, structure and governance and the legal framework in which they operate. • Understand the impact of the external and internal environments on business, their performance and decisions. • Understand how businesses and accounts comply with principles of professional ethics. • Understand the impact of new technologies in accounting and the risks associated with data security. • Communicate information to stakeholders. Financial Accounting: Preparing Financial Statements: This unit provides students with the skills required to produce statements of profit or loss and statements for financial position for sole traders and partnerships, using a trial balance. Students will gain the double-entry bookkeeping skills needed to record financial transactions into an organisation’s accounts using a manual bookkeeping system. Learning outcomes: • Understand the accounting principles underlaying final accounts preparation. • Understand the principles of advanced double-entry bookkeeping. • Implement procedures for the acquisition and disposal of non-current assets. • Prepare and record depreciation calculations. • Record period end adjustments. • Produce and extend the trial balance. • Produce financial statements for sole traders and partnerships. • Interpret financial statements using profitability ratios. • Prepare accounting records from incomplete information. Management Accounting Techniques: This unit provides students with the knowledge and skills needed to understand the role of management accounting in an organisation, and how organisations use such information to aid decision making. Students will learn the principles that underpin management accounting methodology and techniques, how costs are handled in organisations and why organisations treat costs in different ways. Learning outcomes: • Understand the purpose and use of management accounting within organisations. • Use techniques required for dealing with costs. • Attribute costs according to organisational requirements. • Investigate deviations from budgets. • Use spreadsheet techniques to provide management accounting information. • Use management accounting techniques to support short-term decision making. • Understand principles of cash management. Tax Processes for Businesses: This unit explores tax processes that influence the daily operations of businesses and is designed to develop students’ skills in understanding, preparing and submitting Value Added Tax (VAT) returns to HM Revenue and Customs (HMRC). The unit provides students with the knowledge and skills that are needed to keep businesses, employers and clients compliant with laws and practices that apply to VAT and payroll. Learning outcomes: • Understand legislation requirements relating to VAT. • Calculate VAT. • Review and verify VAT returns. • Understand principles of payroll. • Report information within the organisation. DURATION 250-300 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate