Gin seems unstoppable at the moment with new micro-distilleries opening up seemingly every month, but what exactly is gin? Where was it first made? Which country drinks the most gin and what are the styles of gin available today? Find out everything you need to know about gin during this fascinating two-hour tasting. We'll be taking a look at (and sniffing) a range of the botanicals used in the production of gin, then we'll taste six gins from around the world alongside some of our favourite premium tonic waters.
Join us as we journey through the wine regions of Italy. Discover what makes Italy the most fascinating wine-producing nation in the world! Taste beautiful Barolo, velvety Valpolicella, and charming Chianti amongst many others. We will explore regions such as Piedmont, Veneto, Tuscany, Umbria, Lazio, Lombardia, Puglia, Trentino, and Sicily. Three whole weeks dedicated to Italy enabling us to unravel the mysteries and delights of Italian wine.
The Portable Appliance Testing course or PAT testing course as it is more commonly known is one of our most popular courses as it does not require you to have any formal previous qualifications and once completed, will enable you to offer your services. In the commercial setting, the law places a responsibility on all employers to ensure that the electrical equipment to be used by their staff and the public, should be fit for purpose and safe for use. Hence, all portable appliances have to be regularly checked and maintained by a competent person.
Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 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. 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. 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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
Wine and Beer go head-to-head to see which makes the best pairing with Steak! Which will you choose as we pit Wines from around the World with the ultimate Beers all accompanied by succulent Steaks? A wonderful culinary evening showcasing mouth-watering steaks, paired with 3 superb wines from classic wine regions and 3 beers. A fabulous feast for food, wine, and beer lovers!
About this Training Course The two elements which consistently remain in the forefront of every executive, tasked to manage a project, are 'Cost' and 'Time'. There is probably no disagreement or a need to prove that a strong correlation exists between Cost and Schedule. The mechanics of capturing cost during the execution is not that difficult a task, as it is when undertaking Design, Engineering, Estimating, Planning, Scheduling, and seeking financing for the project. The corporate management is expected to provide realistic, reliable and risks adjusted projections of a project's overall financial performance. This 3 full-day course and workshop is developed to make the delegates walk through the engineering formulas and equations to become a professional in managing estimates, projections, risks, uncertainties and secure financing for high value, high risk projects, from both On-shore and Offshore Oil & Gas industry segments. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Objectives of this Training Course: This course and the workshops are developed for the participants to gain comprehensive understanding of the field of Cost Engineering and its impact on the project execution, financing and risk management. The underlying objectives are: Enhance familiarization with mechanics of cost engineering in developing budgets and Project Cost Models. Gain understanding of diversity in financing of EPC Projects in context of Offshore and Onshore Oil & Gas projects in international arena. Identify risks associated with cost estimates and costing elements, with an objective of developing project strategies and minimizing the exposure to escalation of prices and market factors. Appreciate the correlation between cost and schedule, resulting in the delivery of contractual obligations. Develop competency to manage risks of costs and time overrun, by implementing appropriate cost control mechanism. Target Audience If you are responsible for undertaking one or more of the following functions in the Oil & Gas and Offshore & Marine Industry, you can't afford to miss this course: Management Accountants, Finance Managers, Cost Controllers, Project Directors, Contracts & Projects Managers, Estimators, Planners and Risk Managers. Course Level Intermediate Training Methods Unique Features of this Enhanced Course Curriculum: This course and the workshops are developed for the participants to gain comprehensive understanding of the field of Cost Engineering and its impact on the project execution, financing and risk management. The underlying objectives are: Enhance familiarization with mechanics of cost engineering in developing budgets and Project Cost Models. Gain understanding of diversity in financing of EPC Projects in context of Offshore and Onshore Oil & Gas projects in international arena. Identify risks associated with cost estimates and costing elements, with an objective of developing project strategies and minimizing the exposure to escalation of prices and market factors. Appreciate the correlation between cost and schedule, resulting in the delivery of contractual obligations. Develop competency to manage risks of costs and time overrun, by implementing appropriate cost control mechanism. Trainer Principal Management Consultant Chartered Valuer and Appraiser (CVA) FACICA | FAMTAC | FAIADR | M.S.I.D | Member, AIEN LL.M. (IP Law), M. Sc. (Maritime Studies), M. Tech (Knowledge Engineering), MBA, First Class CoC (MCA, UK), B. E. (Elect) Your expert course leader, during the last 47 year period, has worked and consulted in the industry verticals encompassing: Technology, Oil & Gas Exploration & Production, Petrochemical Process Plants and Power Plant Construction Projects, Logistics & Warehousing, Marine, Offshore, Oil & Gas Pipelines, Infrastructure Development Projects (Ports, Offshore Supply Bases, Oil & Gas Terminals and Airports etc), EPCIC Contracts, and Shipyards, in South East Asia, Africa, Middle East, Americas and Europe. He serves as the Principal Management Consultant with a management consultancy in Hong Kong and Singapore, specialising in the fields of corporate management consultancy, international contracts reviews and alternative dispute resolutions services. He undertakes special assignments for conducting audits and valuation of intangible properties involving proprietary processes for licensed production, and licensing of intellectual property rights (IP Rights) in patents, trademarks, and industrial designs. He is frequently engaged for assignments like due diligence, acquisitions, mergers, resolving various operational issues, technology transfer and agency services contracts reviews, cost controls, and enhancement of Supply Chain Management. He has been conferred the credentials of Chartered Valuer & Appraiser (CVA) by SAC and IVAS, in accordance with the international valuation standards setting body IVSC. His consulting experience includes Charterparty Management, Business Process Re-engineering, Diversifications, Corporate Development, Marketing, Complex Project Management, Feasibility Studies, Dispute Resolutions and Market Research. He has successfully assisted Marine and offshore E & P clients in managing contractual disputes arising from various international contracts for upgrading & conversion projects. He continues to be actively engaged in claims reviews, mediation, arbitration, litigation, and expert witness related assignments, arising from international contracts and Charterparty Agreements. He graduated with a Bachelor's degree in Electrical Engineering, MBA in General Management, Master of Technology in Knowledge Engineering, Master of Science in Maritime Studies, and LL.M. (IP Law). He also holds professional qualifications in Business Valuations and Appraisers for CVA, arbitration, law, and marine engineering, including the Chief Engineer's First-Class Certificate of Competency (MCA, UK). He is further qualified and accredited as Certified International Arbitrator, Chartered Arbitrator, Sports arbitrator under CAS Rules, WIPO Neutral, Australian Communications and Media Authority (ACMA) Bargaining Code Arbitrator, Accredited Adjudicator and Accredited Mediator (Malaysia). He is admitted to the international panels of arbitrators and neutrals with WIPO, Geneva; ACICA, AMTAC and ACMA, Australia; BVIAC (British Virgin Islands); JIAC (Jamaica); HKIAC Hong Kong; AIAC, Malaysia; AIADR, Malaysia; KCAB, Seoul, South Korea; ICA, Delhi, India; ICC (Singapore); SISV, Singapore; SCMA, Singapore; SCCA, Saudi Arabia; VIAC Vienna, Austria; Thailand Arbitration Centre (THAC), and Mediator with AIAC Malaysia, CMC, and SIMI Singapore. 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
Elevate your skills with Energy Edge's classroom training on CSOV and WIV charterparty management. Learn essential maritime laws and enhance your professional journey.
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
Java CrossOver Course for Coders 1-Day, 11am - 6pm Online, Instructor-led, Interactive, Practical Java Basics to coders who are converting to Java from a different coding language. You do not need much time to learn the syntax of Java, because you have done similar work in other programming languages Hands-on, Practical Course, Instructor-led Course. Online with Gotomeeting.com 1 day, from 11am - 6pm. In classroom at on request only. Locations Java CrossOver Course description Overview of Java: This course covers Java Object-Oriented Programming (OOP) principles. Java Data Types and using Variables in Java: Here we learn to code using data types and variables of different data types: Primitives; Characters; Boolean; Variables and variable scope; String class; Type conversion and casting. Java Operators and Expressions: What are operators and how to use them; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators. Decision Making: The Java Syntax for the If-statement; If,else; If,else if,else; Nested if; Switch Statements; Using Loops: For loops, while loops, do while, Enhanced for loop; Nesting loops; break, continue; The return statement. Arrays: Working with arrays, 2-d arrays, iterating arrays. Using the for-each loop with Arrays Lists: Working with lists. Lists vs Arrays. Files,streams with Java: Open, Read and Write to CSV Files, txt files and bin files. Exception Handling: Fundamentals of exception handling; Exception types; Using try and catch; Multiple catch clauses; Nested try statements; Throw and throws; The finally blocks Introduction to Classes and Objects: Creating a Class; Creating an Object; Using an Object; Adding Instance variables; Controlling accessibility; Naming conventions for class members. Class Constructors; Parameterized Constructors; Inheritance. Abstraction. Interfaces and implementing interfaces. Override. Polymorphism. The dot operator, this keyword, the static keywords, the super keyword. Using Methods: Introduction of methods; Creating a Method in class; Calling a Method; Returning value from a Method; Adding a Method that takes parameters; More in Methods and Classes: Overloading methods; Overloading Constructors; Using objects as parameters; Returning objects; Recursion; Access control : private, public and protected; The final keyword. What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java CrossOver Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments