443 Systems courses in London

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

About this Training Course In our pursuit to discover oil & gas in deeper horizons, wells are often drilled in a HPHT environment. To be considered a HPHT well, the downhole conditions will have pressures in excess of 10,000 psi (69 MPa) and 300° F (150° C). To drill these usually expensive wells successfully, the planning and execution phase has to be of an exceptionally high standard. Therefore, both operator and drilling/service contractor staff must be seamlessly aligned and work as a coherent team to reach and then harness the well objectives. This is particularly important when speciality services such as Managed Pressure Drilling (MPD) are being applied with crews and/or supervisors who are not intricately familiar with complicated well control incidents. As we seek to prevent costly non-productive time, attention will also be paid to enabling technologies like expandable solid tubulars, mud coolers and specialty mud. The 3 full-day course will explain the key characteristics and challenges of HPHT Planning and Well Control. This includes: Differences between HPHT and standard (conventional) wells and what this entails for well design. The challenges unique to HPHT and the impact of Pore Pressure Prediction (PPP). Static and Dynamic Equivalent Mud Density and the factors that influence the ultimate Bottom Hole Pressure (BHP). Control practices such as 'fingerprinting' to identify what's happening downhole. HPHT shut-in procedures and practices. Specific HPHT equipment and drilling tool requirements and advantages of Managed Pressure Drilling (MPD). Well control on/off bottom, bull-heading and dealing with kick-loss situations. Mud management, tolerance on mud properties and challenges in cementing. Case history on emergency control. Drills, team effort, checklists, human factor and 'getting everybody on board'. Training Objectives By the end of this course, participants will be able to: Recognize the main differences in planning/design between HPHT and standard (conventional) wells as well as the challenges that will have to be faced. Explain drilling and tripping operational challenges and practices as well as how to manage these effectively. Identify wellbore breathing (a.k.a. ballooning) and how to safely deal with this within the narrow window for mud density selection. Apply practices of consistent fingerprinting and how to develop procedures for this to benefit the rig team. Measure and understand bottom hole pressure and the effect of influencing factors such as temperature, rotation and flow rate. Understand the critical mud properties to alleviate barite sag, general mud density control techniques and specify the essentials in cementing. Manage losses and low fracture gradients with well bore strengthening methods. Execute sound HPHT shut-in procedures. Understand how MPD can assist in the safe and efficient drilling and hole cleaning of HPHT wells. Understand the use of MPD Influx Management Envelopes. Identify critical Early Kick Detection Systems (EKDS) and HPHT well control equipment. Execute safe secondary well control practices in a H2S environment, bull-heading, on and off bottom and handling of gas at surface, using MGS and hydrate mitigation measures. Target Audience The course is intended for: Office-based staff engaged in HPHT well planning and day-to-day operations Field-based rig staff working as front-line supervisors - from Assistant Drillers to Senior Toolpushers Field-based rig staff working for service companies supporting the execution of HPHT wells (MPD, mud and mudlogging services etc.) Trainer Your expert course leader has over 45 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in the well engineering domain. After being employed in 1974 by Shell, one of the major oil & gas producing operators, he worked as an apprentice on drilling rigs in the Netherlands. After a year, he was sent for his first international assignment to the Sultanate of Oman where he climbed up the career ladder from Assistant Driller, to Driller, to wellsite Petroleum Engineer and eventually on-site Drilling Supervisor, actively engaged in the drilling of development and exploration wells in almost every corner of this vast desert area. At that time, drilling techniques were fairly basic and safety was just a buzz word, but such a situation propels learning and the fruits of 'doing-the-basics' are still reaped today when standing in front of a class. After some seven years in the Middle East, a series of other international assignments followed in places like the United Kingdom, Indonesia, Turkey, Denmark, China, Malaysia, and Russia. Apart from on-site drilling supervisory jobs on various types of drilling rigs (such as helicopter rigs) and working environments (such as jungle and artic), he was also assigned to research, to projects and to the company's learning centre. In research, he was responsible for promoting directional drilling and surveying and advised on the first horizontal wells being drilled, in projects, he was responsible for a high pressure drilling campaign in Nigeria while in the learning centre, he looked after the development of new engineers joining the company after graduating from university. He was also involved in international well control certification and served as chairman for a period of three years. In the last years of his active career, he worked again in China as a staff development manager, a position he nurtured because he was able to pass on his knowledge to a vast number of new employees once again. After retiring in 2015, he has delivered well engineering related courses in Australia, Indonesia, Brunei, Malaysia, China, South Korea, Thailand, India, Dubai, Qatar, Kuwait, The Netherlands, and the United States. The training he provides includes well control to obtain certification in drilling and well intervention, extended reach drilling, high pressure-high temperature drilling, stuck pipe prevention and a number of other ad-hoc courses. He thoroughly enjoys training and is keen to continue taking classes as an instructor for some time to come. 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

InDesign is the professional choice for creating brochures, posters, magazines, e-books and apps. Through this Zoom delivered, online introductory course, you will receive expert InDesign training in how to create documents and prepare them for print or export as a PDF. Professional colour management, typography and advanced graphics and effects are all explored. This course covers all you need to know to get started with the application.

ISO 30401 sets requirements and provides guidelines for establishing, implementing, maintaining, reviewing and improving an effective management system for knowledge management in organizations. All the requirements of this standard are applicable to any organization, regardless of its type or size, or the products and services it provides. Knowledge management is the intentional process of defining, structuring, retaining, and sharing an organization’s employees’ knowledge and experience.

Enhance your knowledge in coal power plant life cycle management and flexible operations with EnergyEdge. Learn about decommissioning, preservation, repurposing, and recommissioning.

Being safe at the workplace should be a priority for any business. Come to Knight Training to train with us and start working safe with our IOSH Managing and Working Safely Course!

Who is this course for? Mastering 3ds Max: Complete Basic to Advanced Training. Looking to learn 3D modelling and animation? Look no further than our comprehensive 3ds Max beginner course! Gain a strong foundation in 3ds Max and learn essential skills for creating stunning 3D models and visualizations. Check our Website Training Duration: 40 hours Method: 1-on1 Sessions and Customized Content. Schedule: Choose your preferred time slot between 9 am and 7 pm, Mon to Sat, tailored to fit your schedule. Course Title: 3ds Max and V-Ray Comprehensive Training Program (40 Hours) Course Overview: Dive deep into the world of 3D visualization and rendering with our intensive 3ds Max and V-Ray training program. Over the course of 40 hours, you'll master the fundamental concepts, advanced techniques, and practical applications of both 3ds Max and V-Ray, empowering you to create stunning, photorealistic visualizations for various industries. Course Outline: Module 1: Introduction to 3ds Max (8 hours) Understanding the 3ds Max interface and tools Basic 3D modeling techniques and workflows Material creation and texture mapping Lights and cameras setup for scenes Module 2: Advanced 3ds Max Techniques (8 hours) Character modeling and animation Particle systems and dynamics Advanced lighting and shading techniques Scene composition and camera animation Module 3: V-Ray Fundamentals (8 hours) Introduction to V-Ray rendering engine V-Ray materials and texture mapping Lighting with V-Ray lights and HDRI maps V-Ray camera settings and depth of field Module 4: Advanced V-Ray Rendering (8 hours) Global illumination and image-based lighting V-Ray proxies and instancing Advanced V-Ray shaders and displacement maps Render elements and post-production techniques Module 5: Architectural Visualization with V-Ray (8 hours) Interior and exterior scene setup Realistic materials for architectural elements Lighting strategies for different times of the day Creating lifelike environments and atmospheric effects Course Features: Hands-On Learning: Engage in practical exercises and real-world projects to reinforce your skills and knowledge. Industry-Standard Tools: Work with the latest versions of 3ds Max and V-Ray, widely used in the professional 3D visualization industry. Expert Instruction: Learn from certified trainers and industry professionals with extensive experience in 3D modeling and rendering. Project-Based Assessments: Apply learned techniques to comprehensive projects, receiving feedback and guidance to refine your skills. Flexible Learning: Choose between in-person and online sessions, accommodating various schedules and learning preferences. Upon completing this 40-hour course, you will be equipped with the expertise to create visually stunning 3D renderings and animations, making you proficient in both 3ds Max and V-Ray for a successful career in architectural visualization, gaming, film production, and more. Upon completion, participants will: Master 3ds Max & V-Ray: Acquire advanced skills in 3ds Max and V-Ray for creating realistic 3D visualizations. Expert in Architectural Visualization: Specialize in architectural visualization techniques, ideal for interior designers and architects. Project-Based Proficiency: Apply learned skills to real projects, developing a professional portfolio. Recommended Jobs: Architectural Visualization Artist 3D Animator Product Visualization Specialist Interior Designer VR Developer Freelance 3D Artist Game Environment Artist Visualization Consultant This training opens doors to diverse roles in architecture, gaming, design, and more. Duration: 40 Hours Focus: Master 3ds Max and V-Ray for advanced 3D visualizations and architectural rendering. Learning Format: One-on-One Training for personalized attention. Availability: Book your sessions Monday to Saturday, 9 am to 7 pm, tailored to your schedule. Outcome: Expertise in 3ds Max, V-Ray, and specialized architectural visualization skills. Practical Focus: Hands-on projects and real-world applications for skill reinforcement. Certification: Upon completion, receive a certificate showcasing your advanced 3D modeling and rendering skills. This one-on-one course offers tailored training sessions from Monday to Saturday, 9 am to 7 pm, ensuring personalized attention and flexibility to suit your schedule. Download 3ds max Ongoing Email Support: We offer continuous email assistance, ensuring your queries are promptly addressed even after the course completion. Comprehensive Resources: Access extensive handouts and valuable documents designed to reinforce your learning experience. Flexible Financial Options: Explore adaptable financial support options, including installment plans and assistance through job center plus and DWP. Reach out to us for specific details. Satisfaction Guarantee: Although it's highly improbable given our exceptional quality and skilled tutors, if you find dissatisfaction after your initial session, we will promptly address your concerns. If necessary, a refund may be provided (Terms and conditions apply). Optimized Software Experience: Receive guidance on optimizing your computer for enhanced software performance in applications like Autocad, 3ds Max, and Photoshop, whether you're on MAC or PC platforms. Industry Connections: Leverage our industry ties as we actively showcase your portfolio to potential employers. Many of our students have secured jobs through our recommendations, offering valuable career opportunities.

Autocad face to face training customised and bespoke.

Facilitated by Registered Clinicians with extensive experience

NPORS Crane / Lift Supervisor (N405)