11677 Environment courses in Rosyth delivered Online

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

4G training course description This course is designed to give the delegate an understanding of the technologies used within a 3G UMTS mobile network. During the course we will investigate the UMTS air interface and the use of Wideband-Code Division Multiple Access (WCDMA) to facilitate high speed data access, together with HSPA to offer mobile broadband services. We will describe the use of soft handover rather than hard handover procedures and soft capacity sharing. The course includes a brief exploration of the UMTS protocol stack and the use of PDP Context and QoS support features. What will you learn Explain the 3G UMTS architecture. Describe the role of a Drifting & Serving RNC. Explain the use of ARQ & HARQ for mobile broadband. Describe how IMS integrates into the architecture. Describe the use of Media Gateway Controllers. Identify the temporary identities used within 3G UMTS. 4G training course details Who will benefit: Anyone working within the telecommunications area, especially within the mobile environment. Prerequisites: Mobile communications demystified Telecommunications Introduction Duration 2 days 4G training course contents LTE Introduction The path to LTE, 3GPP. LTE to LTE advanced. LTE Architecture The core, Access, roaming. Protocols: User plane, Control plane. Example information flows. Bearer management. Spectrum allocation. LTE technologies Transmission, reception, OFDMA, multiple antenna, MIMO. LTE Air interface Air interface protocol stack. Channels, Resource Grid, cell acquisition. Up and downlink controls. Layer 2 protocols. Cell acquisition Power on, selecting networks and cells. RRC connection. Attach procedure. Mobility management Roaming, RRC_IDLE, RRC_CONNECTED, cell reselection, handover, interoperation with UMTS and GSM networks. Voice and text IMS, QoS, policy and charging.

Are you ready to embark on an enlightening journey of wisdom with the Botany, Arboriculture & Agricultural Science bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Botany, Arboriculture & Agricultural Science. Delve into eight immersive CPD Accredited courses, each a standalone course: Botany Agricultural Science Arboriculture Reproduction in Flowering Plants Horticulture Mushroom Growing Course Land Management Environment Management Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Botany, Arboriculture & Agricultural Science bundle illuminate your path to wisdom. The Botany, Arboriculture & Agricultural Science bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Botany, Arboriculture & Agricultural Science package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Botany, Arboriculture & Agricultural Science bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Botany, Arboriculture & Agricultural Science community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Botany, Arboriculture & Agricultural Science bundle. Establish robust bases across each course nestled within the Botany, Arboriculture & Agricultural Science bundle. Decipher intricate concepts through the articulate content of the Botany, Arboriculture & Agricultural Science bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Botany, Arboriculture & Agricultural Science bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Botany, Arboriculture & Agricultural Science bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Botany, Arboriculture & Agricultural Science bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Botany, Arboriculture & Agricultural Science bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Botany, Arboriculture & Agricultural Science bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Botany, Arboriculture & Agricultural Science journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Botany, Arboriculture & Agricultural Science bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Botany, Arboriculture & Agricultural Science bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Project Quality Management: Virtual In-House Training In today's environment, quality is the responsibility of everyone. Project success is no longer just the fulfillment of a project on schedule, on budget, and within the scope. Today, projects aren't successful unless the customer's needs are met at the highest level of quality at the lowest cost to the organization. Project Managers must know customer needs, and manage to them throughout the project lifecycle, in order to gain acceptance. Project Quality Management provides an interactive, hands-on environment for participants to practice identification of critical quality requirements (quality planning), fulfillment of those requirements through well-designed processes (Quality Assurance), and statistical awareness of technical specifications of project deliverables (Quality Control). What You Will Learn You'll learn how to: Plan for higher quality project deliverables Measure key performance indicators on projects, processes, and products Turn data into useful project information Take action on analyzed data that will drive down non-value-added costs and drive up customer acceptance and satisfaction Reduce defects and waste in current project management processes Foundation Concepts Quality Defined Customer Focus Financial Focus Quality Management Process Management Cost of Quality Planning for Quality Project Manager Role in Planning Voice of the Customer Quality Management Plan Measurement System Accuracy Data Gathering Data Sampling Manage Quality Process Management Process Mapping Process Analysis Value Stream Mapping Standardization Visual Workplace and 5S Error Proofing (Poka-Yoke) Failure Mode and Effect Analysis Control Quality The Concept of Variation Common Cause Special Cause Standard Business Reports Tracking Key Measurements Control Charts Data Analysis Variation Root Cause Analysis Variance Management Designing for Quality

Elevate your knowledge and skills in working at heights safely. Comply with regulations, implement risk assessments, and master the use of specialized equipment for fall protection. This course makes you adept at ensuring workplace safety in elevated environments.

Be prepared for the upcoming Hiring Season by enhancing your professional skillsets with Apex Learning! Save Up To £5,206 and get Hard Copy + PDF Certificate + Transcript + Student ID Card as a Gift - Enrol Environmental Engineering Now Tired of browsing and searching for the course you are looking for? Can't find the complete Environmental Engineering package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive Environmental Engineering bundle that has everything you need to succeed in Environmental Engineering and other relevant fields! This Environmental Engineering Bundle Consists of the following Premium courses: Course 01: Environment Management Course 02: Environmental Health Course 03: Environmental Law Course 04: Land Management Course Course 05: Town Planning Course 06: Architectural Studies Course 07: Agricultural Science Course 08: Forestry Course 09: Diploma in Water Chemistry Course 10: Carbon Literacy Knowledge | Course Course 11: Solving Climate Change Problems with Renewable Energy Course 12: Ultimate Geology Course Course 13: International Development Studies Course 14: Process Improvement: Reduce Waste Key features of this Environmental Engineering course: This Environmental Engineering bundle is CPD QS Accredited Learn from anywhere in the world Lifetime access Our Environmental Engineering is entirely online 24/7 Learner support The Environmental Engineering bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Environmental Engineering expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Environmental Engineering from any place in your own time without travelling for classes. Enrol now in Environmental Engineering to advance your career, and use the premium study materials from Apex Learning. The Environmental Engineering bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Environmental Engineering expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Course Curriculum of Environmental Engineering bundle: Course 01: Environment Management Environment and Ecology Environmental Issues Environmental Planning Environmental Management System Ecosystem Management Environmental Law and Policy Improving Environmental Performance Environmental Management Audit Situational Environmental Management Review and Performance Course 02: Environmental Health Intro to Environmental Health Waste, Pollution and Pollutants Environment, Pollution, Climate Change and Health Recovering Resources and Managing Waste Food Waste Plastic Air Pollution Water Environmental Sustainability Course 03: Environmental Law Legal System What is Environmental Law International Environment law Environmental Organisations National Environmental Legacy Act The Environment and Economics Part 1 The Environment and Economics Part 2 Climate Change Environmental Impact Assessment Nature Conservation Kyoto Protocol and Paris Agreement Sustainable Development Compliance and Governance of Law Right to Information, Participation and Justice Enforcement of Environmental Law -------------- 11 more Environmental Engineering related courses--------- How will I get my Environmental Engineering Certificate? After successfully completing the Environmental Engineering 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 £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Environmental Engineering bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this Environmental Engineering course. Students can take this course to gather professional knowledge besides their study or for the future. Disclaimer: Our comprehensive Environmental Engineering course will enhance your theoretical knowledge to help you explore your opportunities in relevant sectors. But please note that this course is not a professional qualification and will not allow you to work professionally. Requirements Our Environmental Engineering is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so that you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this Environmental Engineering course; it can be studied in your own time at your own pace. Career path Having this various Environmental Engineering expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Environment Management) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Environment Management) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Learn how to use D3.js (version 6.x) effectively in a React environment

CWDP training course description The CWDP course consists of instructor-led training applicable to the design of wireless LANs using the latest technologies including 802.11n and 802.11ac. The course goes in-depth into the design process and provides attendees with the knowledge needed to plan, deploy and test modern 802.11-based networks. It also prepares students for the CWDP examination. Students who complete the course will acquire the necessary skills for preparing, planning performing and documenting site surveys and wireless LAN design procedures. What will you learn Design enterprise WiFi networks. Select appropriate antennas and Access points. Perform site surveys. Describe the security requirements required for enterprise networks. Test, validate and troubleshoot installations. CWDP training course details Who will benefit: Anyone looking for the skills to analyze, troubleshoot, and optimize any enterprise level Wi-Fi network, no matter which brand of equipment your organization deploys. Anyone looking to become a CWNP. Prerequisites: CWNA Duration 5 days CWDP training course contents WLAN design overview Importance of good design, Impact of bad design, Design process, Design skills, Design toolkit. Requirements analysis Pre-planning, Customer interaction, Requirements gathering, Discovering existing systems, Documenting the environment, Defining constraints, Creating documentation. Designing for clients and applications Client Device types, Application types, Application-specific design, High density design issues. Designing for industry Standard corporate networks, Industry-specific designs, Government, Healthcare, Hospitality, Retail, Public hotspots, Transportation, Mobile offices, Outdoor and mesh, Remote networks and branch offices, Last-miles / ISP and bridging. Vendor selection processes Defining vendor issues, Operational planes, Design models, Understanding architectures. Radio Frequency (RF) planning RF spectrum, RF behaviors, Modulation and coding schemes, RF accessories, Throughput factors. WLAN hardware selection Antennas, 802.11n and antennas, Choosing Aps, Powering Aps. Site surveys Site survey tools, Site survey preparation, Predictive site surveys, Manual site surveys, Site survey principles and processes. Designing for Quality of Service (QoS) QoS overview, QoS application points, Roaming support. Designing for security Bad security, Authentication solutions, Encryption solutions, Security best practices, Intrusion prevention. Installation testing, validation and troubleshooting Network health status, Troubleshooting and validation process, Troubleshooting and validation tools, Common problems. Hands-on lab exercises Hands-on labs depend on the audience and can include use of: Spectrum analyzers, Protocol analyzers, Site Survey software, Diagramming software, Various wireless access points, Various wireless adapters and antennas.

In this course, you will explore the core principles of risk and risk management in the context of the financial services sector. This training programme will cover a wide range of topics, from the regulatory environment and risk identification to the three lines of defence model and the impact of risk on the broader business environment. By the end of this course, you’ll be equipped with the knowledge and skills necessary to navigate the complex world of financial risk management. This training programme will guide you through the intricacies of the financial services industry, providing real-world examples and practical insights. The course features a structured approach with end-of-chapter questions to test your understanding, ensuring that you’re well-prepared to tackle risk management challenges. Join us on this educational journey to enhance your understanding of risk management in financial services and to develop the expertise needed to thrive in this dynamic industry! Study method Online, self-paced Course format What's this? Reading material - PDF/e-book, article/plain text Duration 30 hours Access to content 90 days Certification Certificate in Risk Management Certificates Qualification Certificate - Free Description The AGRC Certificate in Risk Management is a comprehensive programme aimed at providing participants with a deep understanding of risk and risk management within the financial services sector. This course covers a wide array of topics, including the regulatory environment, risk identification, and the three lines of defence model. By the end of the program, participants will be equipped with the knowledge and practical skills required to navigate the intricacies of financial risk management. Whether you’re a student, professional, or simply interested in financial risk management, this course offers a solid foundation in this critical field. The expected learning outcomes encompass an array of skills, from understanding risk principles to conducting risk assessments and applying risk management frameworks in practical scenarios. This program is a valuable educational journey for those seeking to excel in the dynamic world of financial services. Some of the topics to be covered by this Certificate include: Principles of Risk and Risk Management The Financial Services Sector Impact of Risk in Financial Services The Regulatory Environment in Financial Services Establishing and Applying a Risk Management Framework Approaches Used to Identify, Assess, and Treat Risks The Three Lines of Defence Model Sources of Risk in Financial Services Risk Assessments in Financial Services Risk Treatment and Incident Response Who is this course for? This course is ideal for anyone wishing to be introduced to risk management in the financial services industry. Professionals carrying out the roles of directors, members of the Board, senior managers, lawyers, company secretaries, compliance and risk officers, and consultants may benefit from this course. It is also suitable to professionals pursuing regulatory CPDs in financial regulation. Requirements No previous knowledge or experience is required, although it is assumed that participants have good knowledge of English and a sound educational background.

CSCS: Level 1 Health and Safety in a Construction Environment course Online Have you calculated the number of deaths, serious injuries, and diseases caused by their jobs in the UK each year? If you want to minimise it, then take our level 1 health and safety in a construction environment course as precautionary awareness. This Level 1 Health and Safety in a Construction Environment course provides essential knowledge for individuals entering the construction industry. Also, this level 1 health and safety in a construction environment course teaches the potential hazards and safety procedures. Moreover, this level 1 health and safety in a construction environment course includes legal requirements to ensure a safe work environment. The level 1 health and safety in a construction environment course covers topics like risk assessment, accident prevention, and the proper use of personal protective equipment (PPE). Enrol in our level 1 health and safety in a construction environment course to gain the foundational understanding needed to contribute safely and effectively on construction sites. Special Offers Of this CSCS: Level 1 Health and Safety in a Construction Environment course This CSCS: Level 1 Health and Safety in a Construction Environment course includes a FREE PDF Certificate. Lifetime access to this CSCS: Level 1 Health and Safety in a Construction Environment Course. Instant access to this CSCS: Level 1 Health and Safety in a Construction Environment Course. Get FREE Tutor Support to this CSCS: Level 1 Health and Safety in a Construction Environment Course. [ Note: Free PDF certificate as soon as completing the CSCS: Level 1 Health and Safety in a Construction Environment course] CSCS: Level 1 Health and Safety in a Construction Environment course Online This Healthcare Support: Level 3 Healthcare Support course consists of 21 modules. Elevate your career with our CSCS: Level 1 Health and Safety in a Construction Environment course. This CSCS: Level 1 Health and Safety in a Construction Environment program provides essential training to excel in construction safety. Enroll in our CSCS: Level 1 Health and Safety in a Construction Environment course to master crucial skills. Our CSCS: Level 1 Health and Safety in a Construction Environment certification ensures you're prepared for any site. Choose the CSCS: Level 1 Health and Safety in a Construction Environment course for top-notch safety training and professional growth. Who is this course for? CSCS: Level 1 Health and Safety in a Construction Environment course Online This Healthcare Support: Level 3 Healthcare Support course qualification is ideal for those who want to work or are already working in various settings within the NHS and private care facilities. Requirements CSCS: Level 1 Health and Safety in a Construction Environment course Online To enrol in this CSCS: Level 1 Health and Safety in a Construction Environment course, students must fulfil the following requirements: CSCS: Good Command over English language is mandatory to enrol in our Safety in a Construction Environment course. CSCS: Be energetic and self-motivated to complete our Safety in a Construction Environment course. CSCS: Basic computer Skill is required to complete our Safety in a Construction Environment course. CSCS: If you want to enrol in our Safety in a Construction Environment course, you must be at least 15 years old. Career path CSCS: Level 1 Health and Safety in a Construction Environment course Online There are various jobs that will be available after finishing this level 1 health and safety in a construction environment course, such as: Labourer Apprentice, or Construction site assistant