185 Software courses in Bradford

About this Virtual Instructor Led Training (VILT) This Virtual Instructor Led Training (VILT) course is designed with the aim of showing the degree of integration necessary in developing an offshore petroleum discovery, from field appraisal to development. The 5 half-day VILT course gives a comprehensive account of the methodology, processes and techniques utilised in developing an offshore oil or gas discovery. Technically, integration of expected reservoir behavior, well planning and design, and facilities concepts and selection are exemplified through detailed case histories, group discussions and exercises. Commercial aspects related to overall project evaluation are also covered. Training Objectives Course participants will obtain a comprehensive understanding of key aspects of offshore field development, from appraisal through to development planning and leading up to sanction. The VILT course covers the three key elements: reservoirs, wells and facilities, and covers the integration of these with commercial aspects, and the required management aspects, including uncertainty and risk. Target Audience This VILT course is designed for project managers, field development and planning engineers, asset managers, petroleum engineers, reservoir engineers as well as field geoscientists and managers who have an interest in or are involved in field development feasibility and planning. In particular, this VILT course would be of interest to managers leading multidisciplinary and diverse functional teams. Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Trainer 1: Your first expert course leader is a specialist in reservoir engineering, field development planning and petroleum management. Having worked for over 40 years in the petroleum industry, his most recent full-time position was Chief Operating Officer and Project Director for AED Oil and East Puffin (2007-09) for the Puffin offshore development, Timor Sea. Prior to his academic career (2001-2006), commencing in 2001 as head of the new School of Petroleum Engineering and Management at the UA, he worked for 16 years for BHP Petroleum (now BHP Billiton), most recently as Chief Reservoir Engineer for their worldwide operations. Other positions with BHP Billiton involved mainly technical and project management, and general management positions, including member of the BHP Board. He was project manager (feasibility) for two FPSO projects, the Skua and Griffin area fields, offshore Australia. He was also the Technical Manager for the Dai Hung project, offshore Vietnam where first oil was achieved in just 18 months from sanction. Before that time, he worked for Shell International (8 years) in the Netherlands, including two years as Senior Lecturer Reservoir Engineering at Shell's training centre and in Australia, seconded to Woodside Energy, with a key role in Australia's largest capital project (at the time), the Northwest Shelf Gas development. He started his career in Calgary, Canada, first with Hudson's Bay Oil and Gas and subsequently with the US consulting company, Scientific Software Corporation. He holds a BSc degree in Physics from the University of British Columbia and a MS degree in Nuclear Engineering from Stanford University. He has been an active member of the Society of Petroleum Engineers, including Director for the Asia-Pacific region (1996-98) and as a member of the Board. He was an SPE Distinguished Lecturer during 2001-02 and a PESA Distinguished Lecturer during 2002. He has lectured at many institutions and was a visiting professor at Stanford University in 2000. He has published over 50 papers on both technical and managerial topics. His professional interests are in optimal planning and project management of offshore petroleum discoveries. His primary research interests are in the area of special core analysis and the development of predictive models for reservoir characterisation. Trainer 2: Your other course leader is currently an independent consultant and trainer after 37 years in the upstream petroleum industry. His previous roles included Chief Geologist for GALP Energy, Consultant/ Head of Exploration for Qatar Petroleum, Technical/ Asset Manager for SASOL, and various technical and technical management roles in BHP Billiton Petroleum and Chevron. He managed/ executed many projects in diverse locations: West Grimes gas field development - California; Port Arguello heavy oil development - offshore California; exploration & development projects - Nigeria; Tengiz field early development, Korolev appraisal - Kazakhstan; Nkossa field development, Moho/ Bilondo exploration - offshore Congo; PNG divestment, Bayu-Undan LNG development - Australia; Ohanet acquisition, appraisal & development - Algeria; Pande development, Pande/ Temane gas plant expansion & near field exploration - Mozambique; Pre-Khuff (HP/HT) exploration, multiple blocks & operators - Qatar; Coral/ Mamba appraisal - Mozambique; Blocks 14/32 exploration & development - Angola; exploration & appraisal - onshore & offshore Brazil. He has an MSc in Geophysics from Stanford, an MBA from St. Mary's College of California, and a BSc in Geology (Honors) from Western Illinois University. He is a member of SEG, AAPG, SPE, PESGB, and PESA and is a Fellow of the Energy Institute (UK). His professional interests centre around deploying this extensive and international experience base to add value to future projects via training and consultancy, and to provide the leadership needed to execute, deliver, and ensure profitability of new projects. 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

Course Objectives At the end of this course you will be able to: Customise tables and charts Customise formatting with styles and themes Modify pictures in a document Create customised graphic elements Insert content using Quick Parts Control text flow Use templates to automate document creation Perform mail merges Use macros to automate common tasks '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Excelent enviroment for training. Tahnk you. Jenny Price - ACER ' 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. Working with Tables and Charts Sort Table Data Control Cell Layout Perform Calculations in a Table Create a Chart Customising Formats Using Styles and Themes Create and Modify Text Styles Create Custom List or Table Styles Apply Document Themes Using Images in a Document Resize an Image Adjust Image Appearance Integrate Pictures and Text Insert and Format Screenshots Use the Snipping tool Creating Custom Graphic Elements Create Text Boxes and Pull Quotes Draw Shapes Add WordArt and Other Text Effects Create Complex Illustrations with SmartArt Inserting Content Using Quick Parts Insert Building Blocks Create and Modify Building Blocks Insert Fields Using Quick Parts Controlling Text Flow Control Paragraph Flow Insert Section Breaks Insert Columns Link Text Boxes to Control Text Flow Using Templates Create a Document Using a Template Create a Template Using Mail Merge The Mail Merge Features Merge Envelopes and Labels Create a Data Source Using Word Using Macros Automate Tasks Using Macros Create a Macro Who is this course for? Who is this course for? This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools Requirements Requirements Preferably, delegates should have attended the Word Introduction course. 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 Certificates Certificates Certificate of completion Digital certificate - Included

How to be a Great Executive Sponsor: In-House Training This three-hour course provides key tips and techniques for becoming an actively engaged, and impactful, Executive Sponsor of projects and programs. It will explain not just what your role is, but the very specific actions you can, and must, take to increase your project's probability of success. This three-hour course provides key tips and techniques for becoming an actively engaged, and impactful, Executive Sponsor of projects and programs. It will explain not just what your role is, but the very specific actions you can, and must, take to increase your project's probability of success. And, it will highlight the key personality and other traits that are found in successful Sponsors. Regardless if you're sponsoring an Agile software development project, a construction megaproject, or any other type of project in between, this course will help get you 'hit the ground running' and being an 'impact player' on day one. Various activities and discussions will acquaint you with this important role and what you need to do to become a great executive sponsor. What you Will Learn At the end of this program, you will be able to: Define project success so everyone is 'singing from the same sheet of music' Immediately apply the ten key attributes of a great sponsor on your project Recognize great sponsorship and determine if you're the right fit for the role Practice Sponsorship over the course of the project life cycle by engaging in very specific actions and activities Be a better investment manager by analyzing the behaviors of successful activist investors Foundation Concepts The quantifiable benefits of being an actively engaged Sponsor Sponsor defined Clarence Kelly Johnson and the SR-71 Blackbird: An example of the power of Sponsorship Defining Project Success Project success: More than meeting the triple constraints Benefits management: The Sponsor's focus The Investment - Life-cycle vs. the Project Life-cycle The three questions Sponsors need to ask to define project success 10 Key Attributes of a Great Sponsor 10 Key Attributes of a Great Sponsor The Makings of a Great Sponsor The most important skills and competencies of an executive sponsor What great Sponsors do and when Four Things a Great Sponsor Can Learn from an Activist Investor The story of Outerwall, Inc. and Glen Welling of Engaged Capital, LLC Sponsors and Activist Investors Sponsorship of the 2nd Avenue Subway in Manhattan: A classic textbook example

Course Objectives At the end of this course you will be able to: Modify the PowerPoint environment Using Master View in order to customise a design template Add and customize SmartArt graphics Add animations and change its effect options Add action buttons to control the flow of the presentation Use various options to customise slide shows Use different PowerPoint file types to distribute presentations ' 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 Customer Feedback Very clearly explained Good pace. Lucy Tailor - ACER ' 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. Customising the PowerPoint Environment Customise the User Interface Set PowerPoint Options Customising Design Templates Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Adding SmartArt to a Presentation Create SmartArt Modify SmartArt Working with Media Add Audio to a Presentation Add Video to a Presentation Working with Animations Entrance, Emphasis and Exit Animations Animate Charts by Category and Series Customise Animations and Transitions Collaborating on a Presentation Review a Presentation Store and Share Presentations on the Web Customising a Slide Show Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks Add Action Buttons Record a Presentation Securing and Distributing a Presentation Secure a Presentation Create a Video or a CD Distribute the Presentation in different File Formats Who is this course for? Who is this course for? This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. Requirements Requirements Preferably, delegates should have attended the Powerpoint Introduction course. 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 Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk 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 Jenny Price - Acer ' 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. 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 five-day training course will cover aspects of FPSO operations with an emphasis on management of safety. A background of the methodology used to generate the various safety plans and codes used in the operational safety case will be covered. The course will also review general operational guidelines in the offshore environment to ensure that the operations are completed as designed. This will include offtake operations and maintenance processes for the plant and vessel as well as a session on subsea. Training Objectives To enable participants to obtain an in-depth understanding of FPSO operations, safety and maintenance: Provide a broad overview of how an FPSO operation is set up and established in the field Grasp the various methods used to moor the production units Analyse information and methods required to establish the operation according to local and international regulations. Assess the methods used to calculate the safety parameters and requirements to construct an approved valid safety case Explore conditions to monitor during operations with regards to safety and structure Inspect various types of hazards associated with production and produced materials Review regular and emergency operational maintenance requirements Examine cyclones and weather events causing disconnection Comprehend manning, training requirements and operations including cargo Case studies and Exercises: The training course uses real life examples and case studies to explain the setup, preparation, implementation and operational activities required to successfully complete FPSO operations from a safety and maintenance perspective. This will allow the application of participants' newly-acquired knowledge. Case studies also stimulate independent thinking and discussion among the participants. Case Studies The case studies proposed for this course will include: A group exercise to consider what is the minimum requirement for the production of a safety case Generic plan for the development of a maintenance management system using computer software systems (e.g. Amos) Construction of a UWILD plan to include scope and potential tendering requirements Quizzes The various quizzes can be expanded or arranged to suit the group/interests and topics covered but will generally include the following topics: Mooring types and location where they are primarily used Safety cases Safety management systems Process hazards and mitigation UWILD components and regulations Operations management Offtake operations Target Audience The course is generally aimed at personnel who are involved in FPSO operations as either offshore crew or onshore support team members. This course will also greatly benefit the following groups but not limited to: Process engineers Surveyors Facility engineers Naval architects Operations engineer Health, Safety, Environment (HSE) specialists and managers Maintenance engineers Course Level Intermediate Training Methods The training course is presented in an interactive workshop format that allows for discussion. The course will be delivered through analysis of case studies and running examples of problems. Course Duration: 5 days in total (35 hours) The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training comprises of information supplemented by visual activities including photographs from various operations and videos of operational and safety activities. Interaction verbally will be necessary to achieve the best learning outcome from the materials. Course timings and breaks  0830 - Registration 0900 - Start of training 1030 - Morning break 1045 - Training recommences 1230 - Lunch break 1330 - Training recommences 1515 - Afternoon break 1530 - Training recommences 1700 - End of training Trainer Your expert course leader has been involved in the Oil and Gas industry for over 28 years in several different roles commencing as a second deck officer on FPSO's and moving through the industry from deck officer to Master, OIM and Field Superintendent. He has also been in charge of semisubmersible and fixed production platforms as field superintendent before moving ashore into senior management roles. On completion of industry specific activities, he moved to teaching roles at South Tyneside Maritime College in the department of marine and simulation and presented live courses to maritime students from cadet to Master.  Prior to returning to Perth in March 2019, he was training manager for a subsidiary of Gaz Transport and Technigaz of France. He has a Master Class 1 certificate with endorsements for hazardous cargoes and a Graduate Certificate in Business Administration as well as multiple course certificates required to operate FPSO's, platforms and semisubmersible facilities. He has been involved in the preparation of national standards for Safety Cases (Australia); Designing and structural setup of competency-based training systems in South East Asia. He was also involved in the development of minimum standards, competency profiles position based and preparation and implementation of training plans to ensure competency in the local staff in Asian operations. He was part of the development team for minimum standards of offshore safety in Australian offshore operations including the implementation of the Common Safety Training Program (CSTP). He was also involved in implementing training plans for both simulator and classroom based courses in LNG operations and cargo tank design and construction. Highlighted work experience: Premier Petroleum Myanmar Ltd Petronas Carigali Newfield Australia (Cartier) Pty Ltd: FPSO Jabiru Venture FPSO Challis Venture Onshore OIM Australian FPSO Management Pty. Ltd. 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

Assessment and Planning: Survey the area where you want to install CCTV cameras. Identify key areas that need surveillance such as entry points, blind spots, and valuable assets. Determine the number of cameras needed and their types (e.g., dome, bullet, PTZ) based on the coverage required and environmental conditions. Plan the placement of cameras considering factors like lighting conditions, obstructions, and the angle of view required. Selecting Equipment: Choose high-quality CCTV cameras and other necessary equipment such as DVRs (Digital Video Recorders) or NVRs (Network Video Recorders), cables, connectors, power supplies, and storage devices. Ensure compatibility between cameras and recording devices. Consider features like resolution, night vision capability, and weather resistance. Mounting Cameras: Install cameras at the planned locations using appropriate mounting brackets or housings. Ensure cameras are securely fixed to prevent tampering or theft. Adjust the angle and direction of each camera to cover the desired area effectively. Running Cables: Plan the route for cables connecting cameras to the recording device. Use weatherproof cables suitable for outdoor installation. Conceal cables where possible to prevent tampering and maintain aesthetics. Connecting Components: Connect cameras to the DVR/NVR using appropriate cables and connectors. Ensure proper power supply to cameras and recording devices. Configure network settings if using an IP-based CCTV system for remote viewing. Configuring Settings: Access the DVR/NVR interface and configure settings such as recording schedule, motion detection, and video quality. Set up user accounts and passwords to restrict access to the system. Test the system to ensure cameras are capturing footage and recording properly. Remote Viewing (Optional): Set up remote viewing capabilities to access live or recorded footage from smartphones, tablets, or computers. Configure port forwarding on your router if accessing the system from outside the local network. Install and configure the necessary software or mobile apps provided by the CCTV system manufacturer. Testing and Maintenance: Test the system thoroughly to ensure all cameras are functioning correctly and recording as expected. Regularly check and clean cameras to maintain optimal performance. Update firmware and software periodically to patch security vulnerabilities and access new features.  

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 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. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS 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 Certificates Certificates Certificate of completion Digital certificate - Included

About this Virtual Instructor Led Training (VILT) This 4 half-day Virtual Instructor Led Training (VILT) course presents the principles and best practices of portfolio management in the upstream (E&P) oil and gas industry. The VILT course is equally valuable for small independents, large integrated international companies and national oil companies. The VILT course consists of presentations, case studies, illustrative practical exercises and syndicate discussions. Particular emphasis is given to pragmatic portfolio management approaches and solutions which can be implemented swiftly without recourse to major investments in planning and portfolio management software. The VILT course will draw on examples from your expert course leader's 35+ years' experience in the oil and gas industry as an explorationist, upstream vice-president and management consultant. The VILT course handout will comprise softcopy slides used in the presentation and a softcopy workbook for the exercises. Participants will gain proficiency in portfolio management techniques, understand how and why to undertake this activity and be able to apply key concepts directly in the business of their teams / divisions. The VILT course will be presented over 4 half-days, using Microsoft Teams or Zoom and a proprietary set of VILT tools. Participants will be asked to complete a pre course questionnaire (PCQ) addressing their objectives and experience, and attend a session to familiarise themselves with VILT tools before course commencement.     Training Objectives To present the tools, concepts and principles of portfolio management To define the quantitative metrics which are used to describe projects in a portfolio To understand the benefits of portfolio management at different stages of the upstream business: in strategy development, opportunity screening, business development, drilling prospects, conducting appraisal of discoveries and developing fields To put portfolio management in the organisational context by describing the role of the portfolio management team and examining how value assurance (quality control) is best conducted on portfolio data for projects and assets To demonstrate how portfolio management contributes to improved business performance By the end of the VILT course, participants will understand: Key concepts and principles of portfolio management How to design a simple portfolio database and describe complex projects in a small number of objective metrics How to segment the portfolio into meaningful units How to use portfolio data in making business choices and decisions at the strategic and tactical levels The extent to which it is meaningful and reasonable to make comparisons across different portfolio segments How the portfolio management team can support the wider business in decision-making Target Audience This VILT course is specially designed for exploration and development geoscientists, E&P economists and finance staff, and E&P managers. Both technical and non-technical staff will benefit from the concepts presented. Companies are encouraged to send participants from different functions and seniority levels to gain great benefits especially those which would like to implement the concepts presented in this VILT course. Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 4 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. The VILT course will be presented in an interactive workshop format that allows for discussion. Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total). Trainer Your expert course leader draws on more than 35 years of experience managing, reviewing and directing projects in all aspects of the exploration business: from exploration business development (new ventures), through prospect maturation and drilling, to the appraisal of discoveries. He has more than 30 years' experience with Shell International, followed by 10 years consulting to NOCs in Asia Pacific, Africa and South America and independent oil companies in the United Kingdom, continental Europe and North America. Other than delivering industry training, he has worked on projects for oil & gas companies of all sizes, including independents, national oil companies and (super)-majors, private equity firms, hedge funds and investment banks, and leading management consulting firms. He is an alumnus of Cambridge University. He has M.A and Ph.D. degrees in geology and is a Fellow of the Geological Society of London as well as a respected speaker on management panels at international conferences. Professional Experience Management consultancy & executive education: Advice to investment banks, businesses and major consulting firms. Specialist expertise in upstream oil & gas, with in depth experience in exploration strategy, portfolio valuation and risk assessment. Leadership: Managed and led teams and departments ranging from 3 - 60 in size. Provided technical leadership to a cadre of 800 explorationists in Shell worldwide. Member of the 12-person VP team leading global exploration in Shell, a $3 bln p.a. business and recognised as the most effective and successful among its industry peers. Accountability & decision-making: Accountable for bottom-line results: in a range of successful exploration ventures with budgets ranging from $10's million to $100's million. Made, or contributed to, complex business decisions / investments, taking into account strategic, technical, commercial, organisational and political considerations. Corporate governance: Served as non-executive director on the Boards of the South Rub al Khali Company (oversight of gas exploration studies and drilling in Saudi Arabia) and SEAPOS B.V. (exploration deep-water drilling and facilities management). Technical & operations: Skilled in exploration opportunity evaluation, the technical de risking of prospects, portfolio analysis and managing the interface between exploration and well engineering activities. Unparalleled knowledge of the oil and gas basins of the world, and of different operating regimes and contractual structures, ranging from Alaska, Gulf of Mexico and Brazil, through to the Middle East, former Soviet Union, Far East and Australia. Safety: Following an unsatisfactory audit, became accountable for safety performance in Shell's exploration new ventures. Through personal advocacy and leadership of a small team, delivered pragmatic and effective HSE systems, tools and staff training / engagement and a dramatically improved safety record. R&D: Experience in the 3 key roles in R&D: scientific researcher, research manager, and 'customer' for R&D products. After re-defining Shell's exploration R&D strategy, led the re-structuring of the R&D organization, its interface with 'the business' and approaches to deployment and commercialization. Strategy: Accomplished at formulating competitive strategies in business, R&D and technology deployment, translating them into actionable tactics and results. Defined the exploration strategy of PDO (a Shell subsidiary in Oman) and latterly of Shell's global exploration programme. Professional education, behavioural/motivational coaching: Experienced in organisational re-design, change management, leadership education and talent development. Commercial skills: Personally negotiated drilling compensation claims, educational contracts and E&P contracts, with values of $5 million to $100+ million. 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

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