641 Courses

Enhance your knowledge on CO2 capture and processing technologies with EnergyEdge's virtual instructor-led training course. Sign up now!

Discover EnergyEdge's course for decision-based geothermal field development. Unlock your potential and excel in this dynamic industry.

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 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 in company 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. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. 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

About this Training Course  This 3 full-day training course will introduce participants to the Microsoft Power BI® software solution for extracting, manipulating, visualising and analysing data. This is a very practical, hands-on course that takes participants through a series of exercises which help users understand the Power BI® environment, how to use the key areas of functionality, and how to apply the tools it contains to design and produce analyses of their own data. The first two days focus on learning the key concepts and practising these using clean, simple datasets. The third day provides participants with the opportunity to apply what they've learned to their own data. This makes the course far more relevant and meaningful for them, it allows our facilitator to help them structure their data models, queries and DAX formulas correctly, and it allows our facilitator to help them solve any additional problems that may arise but which were not covered as part of the standard the course. In addition, at the end of the day, each participant walks away with something of real, practical use for their job role. Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn't be able to do what they need to do. This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included. Microsoft® PowerBI® is a trademark of Microsoft Corporation in the United States and/or other countries. Training Objectives Upon completion of this training course, participants will be able to: Confidently use the Power BI® solution, including Power BI® Desktop, PowerBI®.com and the Power BI® Gateway Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis Combine data sources together and gain an introductory understanding of the M language Write formulas using the DAX language for generating custom columns, measures and tables Design reports and dashboards using a wide range of both built-in and custom visuals Publish reports and dashboards to PowerBI®.com Share reports and dashboards with others using PowerBI®.com Customize reports and dashboards so that different user groups automatically see their own personalized views Target Audience This training course is intended for: Financial Analysts Accountants Budgeting and planning specialists Treasury Risk Managers Strategic Planners This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included. Course Level Basic or Foundation Trainer Your expert course leader has a Masters (Applied Finance & Investment), B.Comm (Accounting & Information Systems), CISA, FAIM, F Fin and is a Microsoft Certified Excel Expert. He has over 20 years' experience in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world. He is skilled in the development and maintenance of analytical tools and financial models for middle-market companies to large corporates, at all levels of complexity, in both domestic and international settings. He has trained delegates from a wide variety of Oil & Gas companies including Chevron, Woodside, BHP Billiton, Petronas, Carigali, Shell, Nippon, Eni, Pertamina, Inpex, and many more. He provides training in financial modelling for companies throughout the Asia, Oceania, Middle East and African regions. Before his current role, he spent 6 years working in the Corporate and IT Consulting divisions of a large, multinational Chartered Accounting firm. He is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing. Highlights from his oil and gas experience include: Development of economic models to assist Decision Analysts modelling for a wide range of scenarios for multinational oil & gas assets. Auditing and further development of life of project models for Chevron's Strategic Planning Division analysing their North West Shelf assets. Development of business plan and budgeting models for multinational oil & gas assets. Development of cash flow and taxation models for a variety of oil gas companies. Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment. 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

About this Virtual Instructor Led Training (VILT)  This 5 half-day course provides a detailed description of all performance testing methods for all thermal power plant equipment including boilers, turbines, condensers, pumps, fans, deaerators, and feedwater heaters. The methodology, and code requirements for the performance tests for all thermal power plant equipment will be explained in detail. The preparatory work and instrumentation required for each test will also be covered during the course. The efficiency calculations for all equipment used in circulating fluidized bed (CFB) boiler and pulverized coal boiler power plants will be explained, including all processes, operational and maintenance activities, capital projects, technical options, potential initiatives and incentives to implement upgrades / repairs for increasing the power plant equipment efficiency. The course will also provide a thorough explanation of CFB and pulverized coal boiler technology including hydrodynamics, combustion, emissions, design considerations, gas-solid separators, design of CFB and pulverized coal boiler components, management of solid residues, materials, stoichiometric calculations, and model for sulfur capture. The operation, maintenance, testing, and refurbishment options of all the equipment and systems used in CFB and pulverized coal power plants will be presented, including boilers, superheaters, reheaters, turbines, condensers, feedwater heaters, deaerators, pumps, compressors, fans, electric generators, instrumentation and control systems, and governing systems, etc. The participants will get equipped on all factors which affect the CFB and pulverized coal boiler power plant efficiency and emissions, all methods used to calculate the heat rate of CFB and pulverized coal power plants as well as all areas in CFB and pulverized coal boiler power plants where efficiency loss can occur. Updated information on the methods used to improve CFB boiler and pulverized coal boiler power plant heat rate will also be provided. It includes: Optimizing the combustion process and sootblowing Controlling the steam temperature Recovering moisture from boiler flue gas Performing steam turbine maintenance Lowering condenser back pressure Pre-drying high moisture coal and reducing stack temperature Training Objectives Thermal Plant Performance Testing: Gain a thorough understanding of all the performance testing methods for all thermal power plant equipment including boilers, turbines, condensers, pumps, fans, daerators, and feedwater heaters Performance Test Methodology and Code Requirements: Understand the methodology, and code requirements for performance tests of all thermal power plant equipment Performance Test Preparatory Work and Instrumentation: Learn about the preparatory work and instrumentation required for each equipment performance test in a thermal power plant Equipment Efficiency Calculations: Gain a thorough understanding of the efficiency calculations for all the equipment used in circulating fluidized bed (CFB) boilers and pulverized coal boilers power plants Calculating the Heat Rate of CFB and Pulverized Coal Boiler Power Plants: Learn all the methods used to calculate the heat rate of CFB and pulverized coal boiler coal power plants Benefits of Lowering the Heat Rate of CFB and Pulverized Coal Boiler Power Plants: Understand all the benefits of lowering the heat rate of CFB coal power plants Methods Used to Improve CFB and Pulverized Coal Boiler Power Plants Heat Rate: Gain a thorough understanding of all the methods used to improve the heat rate of CFB and pulverized boiler coal power plants Processes, Operational and Maintenance Activities in CFB and Pulverized Coal Boiler Power Plants: Discover all the processes, operational and maintenance activities used to improve the heat rate of CFB and pulverized coal power plants Capital Projects Used to Improve the Heat Rate of CFB and Pulverized Coal Boiler Power Plants: Learn about all the capital projects used to improve the heat rate of CFB and pulverized coal power plants Technical Options for Improving the Heat Rate of CFB and Pulverized Coal Boiler Power Plants: Understand all the technical options used to improve the heat rate of CFB and pulverized coal boiler power plants Potential Initiatives and Incentives to Implement Upgrades / Repairs for Improving the Heat Rate of CFB and Pulverized Coal Bed Boiler Power Plants: Discover all the potential initiatives and incentives to implement upgrades / repairs for improving the heat rate of CFB and pulverized coal power plants Factors Affecting CFB and Pulverized Coal Boiler Power Plants Efficiency and Emissions: Learn about all the factors which affect CFB and pulverized coal boiler power plants efficiency and emissions Areas in CFB and Pulverized Coal Power Plants where Efficiency Loss Can Occur: Discover all the areas in CFB and pulverized coal power plants where efficiency loss can occur Optimize the Operation of CFB and Pulverized Coal Power Plant Equipment and Systems to Improve the Plant Heat Rate: Understand all the techniques and methods used to optimize the operation of CFB and pulverized coal power plant equipment and systems to improve the plant heat rate CFB and Pulverized Coal Power Plant Equipment and Systems: Learn about the various types of CFB and pulverized coal power plant equipment and systems including boilers, superheater, reheaters, steam turbines, governing systems, deaerators, feedwater heaters, coal-handling equipment, transformers, generators and auxiliaries Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Training Methods The VILT will be delivered online in 5 sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day, including time for lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course. The instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all the delegates gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Trainer Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a soft copy of the following materials written by the instructor: 'POWER GENERATION HANDBOOK' second edition published by McGraw-Hill in 2012 (800 pages) Excerpt of the relevant chapters from the 'POWER PLANT EQUIPMENT OPERATION AND MAINTENANCE GUIDE' published by McGraw-Hill in 2012 (800 pages) THERMAL POWER PLANT PERFORMANCE TESTING MANUAL (includes practical information about all the performance testing methods for all thermal power plant equipment - 400 pages) 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 about post training coaching support and fees applicable for this. Accreditions And Affliations

Dive deep into LNG loading operations with EnergyEdge's master certification course. Gain valuable skills and knowledge. Enroll now!

Enhance your financial skills in the oil & gas industry with EnergyEdge's courses on finance for non-finance professionals and petroleum fiscal regimes.

About this Training Course This separately bookable 3 full-day course is not designed to skill Oil & Gas engineers to be accountants, but to give the participants the confidence and ability to communicate with accountants and finance managers and to improve their own financial decision making. For technical professionals, a high level of single subject matter expertise is no longer sufficient for superior management performance. Oil & Gas technical professionals who wish to succeed in the resources industry are required to develop skills beyond their core functional knowledge. An understanding of financial information and management, and an awareness of the economic theory that drives value creation, are an integral part of the managers required suite of skills. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Workshop A: Finance for Non-Finance for Oil & Gas Professionals Attend this industry specific course and benefit from the following: Demystify financial jargon and fully interpret financial statements Understand Balance Sheets and Profit & Loss statements of Oil & Gas companies Discover the crucial distinction between cash flow and profit Understand how to make correct investment decisions using Net present Value and Internal Rate of Return Interpret oil and gas company financial reports using ratio analysis Learn the difference between cash costs and full costing of energy products Learn how to manage working capital for increased shareholder value Workshop B: Petroleum Fiscal Regimes and Applied Finance for Oil & Gas Industry Professionals Attend this advanced Training course to enhance your financial acumen from the following: Build and compare cash flow based models of both production sharing contract projects and royalty regime projects Gain an awareness of the different valuation methods for producing properties and undeveloped acreage Learn the industry specific accounting issues that apply when interpreting oil and gas company financial statements Understand how the physical characteristics of energy assets (e.g. reserves, reservoir quality) are translated into project valuations Learn how the investment analysts value oil and gas stocks and make buy/sell recommendations Target Audience This course is specifically designed for those with a non-finance background training from the Oil & Gas sector and requires only basic mathematical ability as a pre-requisite. It is presented in a manner that reduces the jargon to basic principles and applies them to numerous real-life examples. This course has been researched and developed for Managers, Superintendents, Supervisors, Engineers, Planners, Lawyers, Marketers, Team Leaders and Project Coordinators in the technical and non-technical departments in the Oil and Gas industry. Course Level Basic or Foundation Trainer Your expert course leader has presented over 300 courses and seminars in financial management. He began his career as a graduate in the Corporate Treasury of WMC Ltd having completed a degree in Applied Mathematics and Geology at Monash University. After five years with WMC, he pursued an MBA in finance and accounting at Cornell University in New York. He later gained a PhD in energy policy from the University of Melbourne. He worked for WMC Ltd in Perth as a Senior Financial Analyst in the Minerals Division and subsequently as an Energy Analyst in the Petroleum Division. In April 1997, he established an independent consultancy business providing advice to companies such as Woodside, Shell and Japan Australia LNG (MIMI). He spent many years as a consultant and commercial manager in the North West Shelf Gas project in Western Australia. Since 2006, he has been an Adjunct Fellow at the Macquarie University Applied Finance Centre where he teaches courses in valuation, financial statement modelling, and resources industry investment analysis. His background in geology and mathematics allows him to empathise with those who seek an understanding of finance but are approaching the learning experience with a technical mind. He receives consistently high ratings for his breadth of knowledge of the subject matter. He presents in a lively interactive style using real life examples and cases. 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

As well as being the owner and manager of The Scottish Soapworks, Jenny is an award-winning graphic designer with many years of experience creating brands for a range of clients including Arran Aromatics, Fairtrade and Matthew Algie Coffee. These one-to-one brand design surgeries are perfect for creatives who want to start making money from selling what they make, or for existing entrepreneurs and small creative businesses who want to review their current branding. In this 1.5 hour, one-to-one brand design surgery you will discuss: your business idea; a brief to create your brand identity; and how you will apply your brand to ensure you have a recognisable 'look' across all your digital and printed products and marketing materials - everything from packaging to social media, and business cards to aprons. Jenny will follow up your session with notes from the conversation, and practical suggestions on how to design your brand, and apply it to various marketing materials. Appointments are available throughout the day and evening starting from 9.30am. More information  The Arienas Collective workshops, courses and events are run from a supportive and welcoming home-based environment within a Georgian mews home in Edinburgh’s City Centre New Town. We invite you to join us, leave any day-to-day worries behind, and immerse yourself in being creative. Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us.  All the equipment and materials you will need are included in the price, unless stated otherwise, plus light refreshments (a selection of Shibui teas, coffee, hot chocolate, and sweet or savoury snacks). On full day workshops you are welcome to bring your own lunch to eat inside or out; or there are a wide range of independent sit-in or takeaway delis, cafés, and restaurants, plus supermarkets, within a 5-10 minute walk. PLEASE NOTE: Our workshop space is on the first-floor of a Georgian mews building and unfortunately we do not have lift access. The workshop space is in our home which is not nut free. Please let us know of any skin or food allergies before booking. Private workshop bookings Most of our workshops are also available to book for small private get-togethers; themed wedding and birthday celebrations; corporate team building and well-being purposes; and as in-store retail events. For larger groups, many of our workshops can be brought to a location of your choice. Please email Lynn or phone 07732 901150 for more information. Age restrictions Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.

Enhance your forecasting skills with EnergyEdge's Advanced Load Forecasting Methodology course. Join our classroom training for expert insights.