1620 Property courses delivered Online

Learning Objectives Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion   Pre-Requisites Intermediate Microsoft Excel training or equivalent experience is recommended.   Description This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code. Course Introduction Introduction 00:03:00 Section 01 Lesson 1-Adding the Developer Toolbar 00:05:00 Lesson 2-Understanding the VBA Editor 00:11:00 Lesson 3-Recording a Macro in Personal 00:10:00 Lesson 4-Understanding the Elements of the VBA Language 00:07:00 Lesson 5-Understanding Methods 00:05:00 Lesson 6-Understanding Comments 00:06:00 Lesson 7-Working with the Range Property and Worksheet Object 00:07:00 Lesson 8-Adding a Macro Button to a Spreadsheet 00:03:00 Lesson 9-Working with the ActiveCell Object 00:02:00 Lesson 10-Working with the Offset Property 00:08:00 Section 02 Lesson 1-Understanding Variables 00:07:00 Lesson 2-Working with Integer Variables 00:03:00 Lesson 3-Understanding Option Explicit 00:05:00 Lesson 4-Working with Other Variable Types 00:07:00 Section 03 Lesson 1-Working with IF Statements 00:04:00 Lesson 2-Working with ELSE 00:03:00 Lesson 3-Working with ELSEIF 00:03:00 Lesson 4-Understanding Conditional Operators 00:06:00 Lesson 5-Working with NOT, AND, and OR 00:07:00 Lesson 6-Working with Nested IF 00:04:00 Lesson 7-Working with Select Case 00:06:00 Lesson 8-Working with WITH and END WITH 00:05:00 Section 04 Lesson 1-Working with Text Strings 00:05:00 Lesson 2-Working with LCASE and UCASE Functions 00:05:00 Lesson 3-Working with LEN and TRIM Functions 00:07:00 Lesson 4-Working with LEFT, RIGHT, and MID Functions 00:07:00 Section 05 Lesson 1-Understanding Loops 00:02:00 Lesson 2-Working with For Next Loops 00:07:00 Lesson 3-Working with For Each Loops 00:06:00 Lesson 4-Working with Cells Property 00:08:00 Lesson 5-Working with Do Until Loops 00:09:00 Lesson 6-Working with Do While Loops 00:05:00 Section 06 Lesson 1-Calling Sub Procedures 00:05:00 Lesson 2-Working with Exit Sub 00:04:00 Lesson 3-Working with Message Boxes 00:08:00 Lesson 4-Working with Input Boxes 00:08:00 Lesson 5-Working with VBA Functions 00:12:00 Lesson 6-Working with Object Variable and Set 00:06:00 Section 07 Lesson 1-Understanding and Creating a User Form 00:08:00 Lesson 2-Adding Controls to a User Form 00:16:00 Lesson 3-Adding Code for a User Form 00:10:00 Lesson 4-Launching a User Form from Excel 00:05:00 Section 08 Lesson 1-Getting Started with Debugging 00:10:00 Lesson 2-Stepping Through Your Code 00:06:00 Lesson 3-Working with Breakpoints 00:03:00 Lesson 4-Working with the Immediate Window 00:05:00 Lesson 5-Working with the Locals Window 00:05:00 Lesson 6-Working with the Err Object 00:06:00 Lesson 7-Getting Help-v2 00:07:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 VBA Expert 00:00:00 Final Exam Final Exam - Excel 365 VBA Expert 00:20:00

Give a compliment to your career and take it to the next level. This Construction Industry Scheme (CIS) bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Construction Industry Scheme (CIS) bundle will help you stay ahead of the pack. Throughout the Construction Industry Scheme (CIS) programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Construction Industry Scheme (CIS) course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Construction Industry Scheme (CIS) Bundle Consists of the following Premium courses: Course 01: Construction Industry Scheme (CIS) Course 02: Construction Management and Procurement Course 03: Construction Estimation using RSMeans Course Course 04: Land Surveying Course 05: Project Management Course 06: Contract Law UK Level 3 Course 07: Property Law and Legislation Course 08: Working at Height Awareness Diploma Course 09: Manual Handling Level 2 Course 10: Health and Safety at Work & Risk Control Course 11: Time Management The curriculum of Construction Industry Scheme (CIS) Module 01: Construction Industry Scheme (CIS) Module 02: Coverage of the Scheme Module 03: Contractors and Registration for the Scheme Module 04: Verification Process Module 05: The CIS Returns Module 06: Record Keeping and CIS Certificates Module 07: Penalties Involved in CIS Module 08: Miscellaneous Information Course 2: Construction Management and Procurement Module 01: Introduction to Construction Management Module 02: Project Life Cycle and Success Module 03: Cost Management Module 04: Preliminary Site Investigation and Site Organisation Module 05: Site Management Module 06: Planning and Management of Equipment And Much More... Course 3: Construction Estimation using RSMeans Course Module 01: Introduction Module 02: Quantity Take-Off Module 03: Cost Estimation using RSMeans Course 4: Land Surveying Introduction to Land Surveying Land Surveying Basics Land Surveying Instrumentation Land Surveying Methods and Techniques Topographic Surveying and Mapping Boundary Surveying Surveying Health and Safety Course 5: Level 3- Project Management Module 01: Key Concepts (I) Module 02: Key Concepts (II) Module 03: Initiation (I) Module 04: Initiation (II) Module 05: Planning (I) Module 06: Planning (II) Module 07: Planning Tools Module 08: Executing the Project Maintaining and Controlling the Project Module 09: Closing Out Course 06: Contract Law UK Level 3 Course 07: Property Law and Legislation Course 08: Working at Height Awareness Diploma Course 09: Manual Handling Level 2 Course 10: Health and Safety at Work & Risk Control Course 11: Time Management How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery inside the U.K. is Free. International students have to pay a £3.99 postal charge. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone with an interest in the construction industry scheme (CIS) will find this course ideal for them. If you are working/ aiming to work as a contractor, payroll coordinator, payroll Manager & finance professional who is responsible for processing and reporting CIS payments and returns, then this programme is absolutely perfect for you. Requirements Our course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Certificates Certificate of completion Digital certificate - Included

About this Training Course Geomechanical evaluations are about the assessment of deformations and failure in the subsurface due to oil & gas production, geothermal operations, CO2 storage and other operations. All geomechanical evaluations include four types of modelling assumptions, which will be systematically addressed in this training, namely: 1. Geometrical modelling assumption: Impact of structural styles on initial stress and stress redistribution due to operations 2. Formation (or constitutive) behaviour: Linear elastic and non-linear behaviour, associated models and their parameters, and methods how to constrain these using 3. Initial stress: Relation with structural setting and methods to quantify the in-situ stress condition 4. Loading conditions: Changes in pore pressure and temperature on wellbore and field scale This 5 full-day course starts with the determination of the stresses in the earth, the impact of different structural styles, salt bodies, faulting and folding on the orientation of the three main principal stress components. Different (field) data sources will be discussed to constrain their magnitude, while exercises will be made to gain hands-on experience. Subsequently, the concepts of stress and strain will be discussed, linear elasticity, total and effective stress and poro-elasticity in 1D, 2D and 3D, as well as thermal expansion. Participants will be able to construct and interpret a Mohr-circles. Also, different failure mechanisms and associated models (plastic, viscous) will be discussed. All these concepts apply on a material point level. Next, geomechanics on the wellbore scale is addressed, starting with the stress distribution around the wellbore (Kirsch equations). The impact of mudweight on shear and tensile failure (fracturing) will be calculated, and participants will be able to determine the mudweight window stable drilling operations, while considering well deviation and the use of oil-based and water-based muds (pore pressure penetration). Fracturing conditions and fracture propagation will be addressed. Field-scale geomechanics is addressed on the fourth day, focussing on building a 3D geomechanical model that is fit-for-purpose (focussing on the risks that need evaluation). Here, geological interpretation (layering), initial stress and formation property estimation (from petrophysical logs and lab experiments) as well as determining the loading conditions come together. The course is concluded with interpretation of the field-wide geomechanical response to reservoir depletion with special attention to reservoir compaction & subsidence, well failure and fault reactivation & induced seismicity. Special attention is paid to uncertainties and formulating advice that impacts decision-making during development and production stages of a project. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Upon completing of this course, the participants will be able to: Identify potential project risks that may need a geomechanical evaluation Construct a pressure-depth plot based on available field data (density logs, (X)LOT, FIT, RFT) Employ log-based correlation function to estimate mechanical properties Produce a simplified, but appropriate geometrical (layered, upscaled) model that honours contrasts in initial stress, formation properties and loading conditions, including Construct and interpret a Mohr-circle for shear and tensile failure Calculate the mud weight that leads to shear and tensile failure (fracturing conditions) Identify potential lab experiments to measure required formation properties Describe the workflow and data to develop a field-wide fit-for-purpose geomechanical model Discuss the qualitative impact of pressure and temperature change on the risk related to compaction, well failure, top-seal integrity and fault reactivation Target Audience This course is intended for Drilling Engineers, Well Engineers, Production Technologists, Completion Engineers, Well Superintendents, Directional Drillers, Wellsite Supervisors and others, who wish to further their understanding of rock mechanics and its application to drilling and completion. There is no specific formal pre-requisite for this course. However, the participants are requested to have been exposed to drilling, completions and production operations in their positions and to have a recommended minimum of 3 years of field experience. Course Level Intermediate Trainer Your expert course leader has over 30 years of experience in the Oil & Gas industry, covering all geomechanical issues in the petroleum industry for Shell. Some of his projects included doing research and providing operational advice in wellbore stability, sand failure prediction, and oil-shale retortion among others. He guided multi-disciplinary teams in compaction & subsidence, top-seal integrity, fault reactivation, induced-seismicity and containment. He was also involved in projects related to Carbon Capture Storage (CCS). He is the founding father of various innovations and assessment tools, and developed new insights into the root causes seismicity induced by Oil & Gas production. Furthermore, he was the regional coordinator for technology deployment in Africa, and Smart Fields (DOFF, iField) design advisor for Shell globally. He was responsible for the Geomechanical competence framework, and associated virtual and classroom training programme in Shell for the last 10 years. He served as one of the Subject Matter Expert (SME) on geomechanics, provided Technical Assurance to many risk assessments, and is a co-author of Shell's global minimun standard on top-seal integry and containment. He has a MSc and PhD in Civil Engineering and computational mechanics from Delft University of Technology, The Netherlands. Training experience: Developed and delivered the following (between 2010 and 2020): The competence framework for the global geomechanical discipline in Shell Online Geomechanical training programs for petroleum engineers (post-doc level) The global minimum standard for top-seal integrity assessment in Shell Over 50 learning nuggets with Subject Matter Experts Various Shell virtual Geomechanical training courses covering all subjects Developed Advanced Geomechanical training program for experienced staff in Shell Coaching of KPC staff on Geomechanics and containment issues on an internship at Shell in The Netherlands, Q4 2014 Lectured at the Utrecht University summer school (The Netherlands, 2020) on induced seismicity among renowned earthquake experts (Prof. Mark Zoback, Prof. Jean-Philippe Avouac, Prof. Jean-Pierre Ampuero and Prof. Torsten Dahm) (https://www.nwo.nl/onderzoeksprogrammas/deepnl/bijeenkomsten/6-10-juli-2020-deepnl-webinar-series-induced-seismicity) Lectured at the Danish Technical University summer school (Copenhagen, 2021) summer school on Carbon Capture and Storage (https://www.oilgas.dtu.dk/english/Events/DHRTC-Summer-School) Virtual Carbon Capture and Storage (CCS): Project Risks & How to Manage Them training course (October and November 2021) 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

Residential Lettings Advanced Diploma Online Training This Residential Letting Course aims to provide learners with a solid understanding and insight into the field of property, focusing on the management side of residential lettings. With practical examples throughout the course, this Residential Letting Course will provide a great insight into your role. The Residential Letting Course covers all duties and responsibilities that a good Residential Letting Agent must uphold and follow. By the end of this Residential Letting Course, you'll be familiar with every UK regulation and protocol you'll need to succeed in this market. Enrol on our exclusive Residential Letting Course today to learn everything you need to know about being an excellent letting agent or running a successful letting agency. Courses are included in this Residential Letting Course Course 01: Residential Letting Course 02: Level 1 Construction Cost Estimation Course 03: Property Management Others Benefits of this Residential Letting Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate will provide as soon as completing the Residential Letting course ] Course curriculum of Residential Letting Industry Specialists developed this Residential Letting Course into 10 user-friendly modules/ lectures. Assessment Method of Residential Letting After completing each module of the Residential Letting Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification Method of Residential Letting After completing the MCQ/Assignment assessment for this Residential Letting course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. Who is this course for? This Residential Letting course is appropriate for- Students Job Seekers Recent graduates Requirements There are no specific requirements for this Residential Letting course because it does not require any advanced knowledge or skills. Career path This Residential Letting course certification and skills can help you advance your career and gain expertise in a variety of fields, allowing you to apply for top jobs in related fields. Certificates Certificate of completion Digital certificate - Included

Residential Letting: Residential Letting Agent Online If you want to learn about Residential Letting: Residential Letting course and become an expert in the field, you have arrived at the right place. Learn everything you need to know about being an outstanding letting agent or running a successful letting agency. This Residential Letting: Residential Letting course covers all of the duties and responsibilities that a good Residential Letting Agent must maintain and follow. Through this Residential Letting: Residential Letting Agent course you understand every UK regulation and protocol you'll need to succeed in this sector. With the use of practical examples throughout the Residential Letting: Residential Letting course, this Residential Letting: Residential Letting Agent course will provide you with a thorough understanding of your role. Whether you are already familiar with key lettings management skills, want to begin working in lettings management, want more training, or are simply interested in this field of study, this Residential Letting: Residential Letting course will cover a variety of modules and provide multiple examples for assessment. Enrol on our comprehensive Residential Letting: Residential Letting course and allow us to guide you into a valuable and ever-growing business field. Main Course: Residential Letting Course Free Courses included with Residential Letting: Residential Letting Course: Along with Residential Letting Course you will get free Level 5 Personal Development Along with Residential Letting Course you will get free Anger Management Along with Residential Letting Course you will get free Negotiation Skills Special Offers of this Residential Letting: Residential Letting Course; This Residential Letting: Residential Letting Course includes a FREE PDF Certificate. Lifetime access to this Residential Letting: Residential Letting Course Instant access to this Residential Letting: Residential Letting Course 24/7 Support Available to this Residential Letting: Residential Letting Course Residential Letting: Residential Letting Online The Residential Letting Course aims to equip learners with a solid understanding of the property industry, with a focus on the management side of residential lettings. This Residential Lettingprovides practical examples throughout to give you a better insight into your role. It covers all the duties and responsibilities that a good Residential Letting must adhere to. Who is this course for? Residential Letting: Residential Letting Online This Residential Letting: Residential Letting Course is designed for anyone interested in pursuing a career in Residential Lettings. Requirements Residential Letting: Residential Letting Online To enrol in this Residential Letting: Residential Letting Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Residential Letting: Residential Letting Course. Be energetic and self-motivated to complete our Residential Letting: Residential Letting Course. Basic computer Skill is required to complete our Residential Letting: Residential Letting Course. If you want to enrol in our Residential Letting: Residential Letting Course, you must be at least 15 years old. Career path Residential Letting: Residential Letting Online Completing this Residential Letting: Residential Letting Course may lead you to high paying jobs in Residential Lettings-related sectors.

Explore the complexities of Family Law, covering divorce, child custody, and child support. Gain insights into legal procedures and parental rights in family court. Dive into this essential course for understanding family law dynamics.

Are you ready to transform your living space and enhance your home's value with your own hands? Join our comprehensive DIY Home Improvement course and gain the skills and confidence you need to tackle any home project, from minor fixes to major renovations. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access This DIY Home Improvement course teaches you how to enhance your living space safely and effectively. You'll start by understanding basic home improvement principles and safety measures to prevent accidents. You'll learn how to repair and maintain walls, install and fix doors and windows, and handle simple electrical tasks like changing fixtures and outlets. The course covers basic plumbing, including fixing leaks and maintaining pipes. You'll also discover how to paint rooms professionally, making your home look fresh and new. Additionally, you'll learn to identify and address issues like dampness, rot, and pest infestations. Finally, the course will guide you through various outdoor projects to improve your home's exterior. By the end, you'll have practical skills to tackle common home improvement tasks confidently and safely. Course Curriculum Module 01: Introduction to Home Improvement Module 02: Home Safety Module 03: Walls Module 04: Doors and Windows Module 05: Electrical Fixtures Module 06: Plumbing Module 07: Paint Job Module 08: Damp, Rots, and Pests Module 09: Outdoor Projects Learning Outcomes Master essential techniques for safe and effective home improvement. Identify and mitigate common home safety hazards and risks. Execute repairs and upgrades for walls, doors, and windows. Install and maintain basic electrical fixtures confidently and safely. Address plumbing issues and perform routine maintenance. Combat damp, rot, and pests to protect your home. CPD 10 CPD hours / points Accredited by CPD Quality Standards DIY Home Improvement 1:58:09 1: Module 01: Introduction to Home Improvement 12:59 2: Module 02: Home Safety 12:50 3: Module 03: Walls 12:14 4: Module 04: Doors and Windows 14:42 5: Module 05: Electrical Fixtures 14:25 6: Module 06: Plumbing 11:21 7: Module 07: Paint Job 14:13 8: Module 08: Damp, Rots, and Pests 10:36 9: Module 09: Outdoor Projects 13:49 10: CPD Certificate - Free 01:00 Who is this course for? Homeowners wanting to upgrade their living spaces. Renters interested in minor home improvements. DIY enthusiasts seeking new skills and projects. Beginners looking to understand home maintenance basics. Individuals preparing for property renovation projects. Career path Handyperson Property Maintenance Worker Renovation Specialist Home Improvement Consultant Facilities Maintenance Technician Self-Employed DIY Specialist Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Embark on a journey to become a Legal Advisor in the UK! Acquire comprehensive knowledge of legal principles, procedures, and case management.

Register on the Estate Agent Training today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Estate Agent Training is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Estate Agent Training Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Estate Agent Training, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Estate Agent Training Module 01: Estate Agent- An Introduction 00:04:00 Module 02: Different Types of Estate Agents 00:04:00 Module 03: Getting Started on the Job 00:04:00 Module 04: Listing Property- Finding the Sellers 00:05:00 Module 05: Valuation Process 00:05:00 Module 06: Negotiating as Estate Agent 00:05:00 Module 07: Selling Property- Finding the Buyers 00:05:00 Module 08: Letting Property 00:06:00 Module 09: Technology for Estate Agents 00:07:00 Module 10: Regulation of Estate Agents 00:05:00 Mock Exam Mock Exam- Estate Agent Training 00:20:00 Final Exam Final Exam- Estate Agent Training 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.