• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

175 Educators providing Courses delivered Online

Ty-Mawr Lime

ty-mawr lime

Brecon

Established in 1995, by husband and wife, Nigel and Joyce Gervis, Ty-Mawr Lime Ltd has made an enormous contribution to resurrecting the use of traditional building materials in Wales. Ty-Mawr Lime Ltd has gone on to become a market leader in the design, manufacture, and distribution of environmentally-friendly building materials and systems, providing a 'one-stop' shop to clients throughout the UK. To see our range of suppliers please click here Products now include: Quicklime (for slaking to make your own lime products and hot mixes) Ready slaked lime putty ready to use ‘non-hydraulic’ lime (putty) mortars and plasters limewash hydraulic limes – Singleton Birch (Secil) and St Astier Agricultural Use Airtightness Products aggregates – suitable for use with lime putty and hydraulic limes for plastering, pointing, building etc natural and breathable paints for walls and woodwork natural insulation materials including wool, hemp, woodfibre, cork and wood wool recycled foamed glass gravel tools Systems using the above materials and registered with Local Authority Building Control include: External Wall Insulation Internal Wall Insulation Sublime Insulated Limecrete Floor Sylfaen Insulated Foundation System Warm Roof New Build Timber Frame Part of their success is a founding principle to work closely in partnership with a small handful of like-minded suppliers with shared passions and ethics including: Singleton Birch Secil St Astier Schneider Celenit Eden Renewables Natural Building Technologies Glapor Beecks and Aglaia Graphenstone Earthborn Other applications include Civil Engineering Acoustic Management Landscaping Ty-Mawr is renowned for the quality of the products and services which include Presales telephone support, how-to videos, application guides, data sheets to accompany all products Courses – at our training centre or on your site Site visits and recommendation report Technical calculations – u-value, condensation risk analysis etc to support your project Mortar and paint analysis and matching In that time, they have received numerous awards and accolades for their work in this sector. Ethical Company Award - Tŷ-Mawr is delighted to announce its successful accreditation for 2020 by The Ethical Company Organisation; We are really pleased to be listed in the top Ethical Ranking Companies of 2016 in the world; Sustain Wales Awards - In 2016, we were delighted to be shortlisted in the Sustainable Venue Category of the Sustain Wales Award and pleased to be announced as runner up (winner was Principality Stadium). The Leading Wales Awards 2016: In June 2016 our MD, Joyce, was announced as the 'Leadership for the Future' Winner at the 2016 Leading Wales Awards. Ashden Award finalist: In March 2016 we heard that we'd been shortlisted with 9 other UK companies for a prestigious Ashden Award; Responsible Business Champion 2015 - We were extremely pleased to have been presented with the All-Party Parliamentary Award for "The Responsible Business Champion 2015" by Roger Williams CBE MP; Powys Business Awards - Tŷ-Mawr was delighted to be presented with the Overall Winner for Development of New Markets at the 2014 Powys Business Awards; LABC Excellence Awards - Tŷ-Mawr Lime's sublime® floor system - a breathable slab-less insulated lime screed flooring system - was awarded the Overall Winner (Best Technical Innovation) in the Powys Building Control 2013 Excellence Awards, as well as the LABC South Wales Awards; World Architecture Awards - We were thrilled to hear that our glaster® was short listed for the World Architecture News (WAN) awards and was Highly Commended in the “Product of the Year 2012” category; Marsh Award for Traditional Building Skills - On the 14th March 2012, we were delighted to be invited to attend an award ceremony at Kenwood House, London where Nigel Gervis, founder and technical director of Tŷ-Mawr Lime Ltd, was presented with the prestigious Marsh Award for Traditional Building Skills by Mr Brian Marsh OBE; Online Retail Awards - ORA Prix 'd'Or - Tŷ-Mawr Lime Ltd was a winner at the 2011 Online Retail Awards (ORA e-commerce category); Wales Green List - In 2009 Nigel and Joyce Gervis were extremely proud to have been named as one of the 52 sustainable development champions in Wales’ first annual Green List; A Champion of Champions Award - Tŷ-Mawr were announced as winners of a “Champion of Champions” 2009 Agri-environment Award at Royal Welsh Show. Go Green Awards - The best in Welsh business and entrepreneurship were honoured at the Chambers of Commerce Business Awards 2009 in Cardiff. National Energy Efficiency & Healthy Homes Awards - Tŷ-Mawr were delighted to hear that their Sublime Insulated Limecrete Floor was named as runner up in the 'Product of the Year' category at the prestigious 2017 National Energy Efficiency and Healthy Home Awards. Sustain Wales Awards - Ty-Mawr were delighted to receive two awards at The Sustain Wales Awards, the first was as a runner up in the 'Sustainable Business' category. They were particularly pleased to receive the 'Special Recognition Award' awarded by Cynnal Cymru in recognition of the outstanding contribution made by individuals to sustainability in Wales - awarded to Nigel and Joyce for "sustained effort to a make a cleaner, greener, safer, healthier and more equitable world today and for future generations!" South Wales Chamber of Commerce Awards - Excellence in Environmental Management - Ty - Mawr is delighted to announce they were named as the winner of the Excellence in Environmental Management category at an event held in Cardiff's City Hall.

RW Consulting Solutions Ltd/ Controlled Events

rw consulting solutions ltd/ controlled events

Buckinghamshire

Please read the terms and conditions of this agreement (the “Agreement” or “Terms” or “Terms of Service”) before logging into ECR Manager, Accreditation software or other systems provided by RW Consulting Solutions Limited (trading as Controlled Events). By completing the registration process, accessing the Service, using the Site or adding a log entry, you agree that you have read and understood these terms and conditions of this Agreement and you agree to be bound by them. We may periodically update these terms and conditions. Your continued use of this site will constitute your acceptance of any new or amended terms and conditions. 1. DEFINITIONS “Account” means access to the Service. “Agreement” means these customer Terms of Service and all materials referenced or linked. “Data” means all information that Customer adds or views on the log. “Documentation” means online user guides, documentation and help and training materials published by Controlled Events or accessible through the Service, as may be updated by Controlled Events from time to time. “Service” means our cloud-based application you have subscribed to and developed, operated and maintained by us. “Site” means www.controlledevents.com/log – known as ECR Manager “Third-Party Sites” means third-party websites linked from within the Service. “Users” means your employees, representatives, consultants, contractors or agents who are authorized to use the Service for your benefit and have unique user identifications and passwords for the Service. “You”, “your” or “Customer” means the person or entity using the Service and identified in the applicable registration process, billing statement, online subscription process or Order Form as the customer. 2. WHO WE ARE 2.1. www.controlledevents.com/log and the Controlled Events Service are provided by RW Consulting Solutions Limited (RWCS), a registered private limited company in England and Wales, which has its registered office at New Burlington House, 1075 Finchley Road, London NW11 0PU with Company Registration Number: 7493058 (collectively, “we”, “us”, “Controlled Events”). 3. DESCRIPTION OF THE SERVICE 3.1. The Service gathers and transfers log data to a cloud based system which is provided by a User of the Service. Customer who successfully subscribes will be given an Account to have its Data relating to an event, exercise or incident visualized, analyzed and stored. 3.2. Details of the Client’s service level (one off, retained, 24/7) and associated charges are provided at the point of purchase; any additional terms or conditions contained on those pages are incorporated into this Agreement by reference. 3.3. Additional functionality and services may be offered or provided by us from time to time and these will be described on the Site. 4. STORAGE SPACE AND USAGE LIMITS 4.1. Customer can upload a certain volume of log and document data, dependent on the Service level selected, which is referred to as the “Usage Limit.” Project admins can manage their Account by archiving logs no longer needed. 4.2. An email alert or alternative notification by Controlled Events will be provided when Customer is near or over its Usage Limit. 5. OUR CLOUD-BASED SOLUTION 5.1. Controlled Events will maintain commercially appropriate administrative, physical, and technical safeguards to protect Data. Controlled Events hosts and stores data on Amazon Web Services’ cloud platform and on other cloud platforms as necessary. The level of security provided in Amazon’s cloud platform is described in more detail on http://aws.amazon.com/security/. Our Data Protection and Cyber Security Manual is available upon request. 5.2. Controlled Events provides you with the option to encrypt the transmission of your Data. You acknowledge that it is your responsibility to encrypt the transmission of your Data should you wish to protect it. In the event you decide to transmit your Data unencrypted to the Service, You assume all related risks for doing so. Controlled Events will not be liable for any liabilities arising from your transmission of Data over the Internet or other network. 6. REGISTRATION 6.1. Upon registering for the Service, Users will have a username, password and email address associated with their account for password resets, which is Customer’s and its Users’ responsibility to keep secure and may not be shared with any other party. Customer agrees to immediately notify Controlled Events of any unauthorized use or any other breach of security or breach of this Agreement of which the Customer becomes aware. Controlled Events will not be liable for any loss or damage resulting from Customer’s failure to maintain proper security of its account or for unauthorized access to the Service. 7. CHARGES AND PAYMENT 7.1. Fees. The Service is made available to Customer at the price indicated in the accepted quotation. Fees are non-cancellable and non-refundable during the Term. Controlled Events reserves the right to change its price list and to institute new charges at any time, upon notice to You, which may be sent by email or posted on the Site. Your use of the Services following such notification constitutes your acceptance of any new or increased charges. Additional Charges may apply for additional services requested by Customer such as supporting data analysis of logs and usage or the transfer of data after closing the Account. Customer will be notified of services requiring additional Charges which have not been previously agreed upon before any such additional Charge will be applied. 7.2. Payment for Subscriptions is required to be paid in full at the beginning of each billing period by BACS transfer. If Controlled Events extends credit to Customer, all Charges must be paid within 30 days of issue of invoice. Payment of Charges for metered billing is required at the end of each month by credit or debit card and is based on the volume of Data uploaded and stored during the month. 7.3. In addition to the Charges, Customer must pay to Controlled Events, or to the relevant taxing authority, as appropriate, all applicable sales, use, goods and services, value added or other taxes payable under this Agreement (other than taxes levied or imposed on our income). In all cases, the amounts due under this Agreement will be paid by Customer to us in full without any right of set-off or deduction. 8. TRIAL ACCOUNTS 8.1. Customers who are provided with a free or trial Controlled Events Account or who are otherwise provided with any other promotional Controlled Events Service(s) for which they have not paid a Charge acknowledge and agree that such services are provided “as is” and so, to the fullest extent permitted by law, those services are provided without any warranties or representations whatsoever and the Customer agrees to avail of such services entirely at its own risk. 9. TERM AND TERMINATION 9.1. The subscription term shall begin on the effective date of your subscription and expire at the end of the period selected during the subscription process (“Subscription Term”). 9.2 The Subscription and Agreement will automatically renew at the published rates on a monthly, annual or otherwise mutually agreed upon period of time, unless one party notifies the other party in writing of its intent not to renew at least thirty (30) days in advance of the expiration of the Subscription Term. 9.3 Customer may terminate the Service at any time, however, fees are non-refundable except in the event of Controlled Events’ incured material breach as set forth below. 9.4. Either party may terminate this Agreement at any time, effective immediately, upon written notice to the other party, if such other party: (i) breaches any of its material obligations hereunder and fails to cure such breach within thirty (30) days of written notice thereof; (ii) becomes insolvent or has a receiver, administrator, liquidator or examiner appointed over all or part of its assets or (iii) becomes the subject of a resolution, petition or order for winding up or bankruptcy. We may terminate this Agreement if, at any time, we cease providing the Service. 9.5. On termination or expiry of this Agreement for any reason, Customer will remain liable to Controlled Events for any outstanding Charges owed, Customer’s rights under this Agreement will immediately terminate, You will lose all access to the Service, including access to Your account and to Your content, and We will delete Your content and the data stored in or as part of Your account. 9.6. Without limitation of the foregoing, we may suspend or terminate the Service without notice if Customer shall fail to pay any amounts when due, if the Services are used for other purposes including but not limited to tampering, hacking, modifying or otherwise corrupting the security or functionality of Controlled Events Services, if the Services are used in a manner contrary to the law or the terms of this Agreement or if Controlled Events experiences unexpected technical or security issues. 9.7. Customer shall provide notice of termination of the Service to Controlled Events at support@controlledevent.com 10. ACCEPTABLE USAGE POLICY 10.1. The Controlled Events Acceptable Usage Policy prohibits the processing of data which are deemed by us in our sole discretion as being inappropriate or unlawful. We aim to ensure that we are not associated with any website content (including linked content) which is illegal, fraudulent, offensive, embarrassing, sexually explicit, obscene, threatening, defamatory or otherwise inappropriate. We prohibit the processing of data using the Service where the processing would breach the laws or rights of third parties and the Customer represents, warrants and undertakes to us that no such transactions will be processed via the Services. 10.2. Customer agrees not to use the Site or the Service or cause or permit the Site or the Service to be used: 10.2.1. so as to jeopardize or prejudice the operation, quality or integrity of the Site, the Service or the operation, quality or integrity of any telecommunications network; 10.2.2. for any commercial purpose including screen shots and copying feature information from the log, nor to go against the spirit of the log platform by sharing data outside of the agreed user base for the project; 10.2.3. to harvest or otherwise collect information about others, including e-mail addresses, without their consent; 10.2.4. to distribute, download, upload or transmit any material that contains viruses, trojan horses, worms, time bombs, cancelbots, or any other harmful or deleterious programs; 10.2.5. contrary to the terms and conditions of any Internet Service Provider whose services you may use. 11. SERVICE AVAILABILITY AND CUSTOMER SUPPORT 11.1. The Service is available 24 hours a day, 7 days a week, except for: (a) planned downtime (of which Controlled Events shall endeavor to give at least 8 hours’ notice and which Controlled Events shall schedule to the extent practicable outside of any event or user peak times), or (b) any unavailability caused by circumstances beyond Controlled Events’ reasonable control, including without limitation, Internet and telecommunications service provider failures or delays, failures of independent service providers, or denial of service attacks. Customer support is provided through the online and email channels: support@controlledevents.com and 020 3286 6392 12. DISCLAIMERS; LIMITATION OF LIABILITY 12.1. The service including any software included in or provided as part of the software is provided on an “as is” and “as available” basis, and Controlled Events expressly disclaims any warranties and conditions of any kind, whether express or implied, including but not limited to the warranties of merchantability, fitness for a particular purpose, title, accuracy, or non-infringement. without limiting the foregoing, Controlled Events does not warrant that the service will meet your specific requirements, that the service will be uninterrupted, timely, secure, or error-free, that the results that may be obtained from the use of the service will be complete, accurate, or reliable, that the quality of any products, services, information, or other material purchased or obtained by you through the service will meet your expectations, or that any errors in the service will be corrected. 12.2. Although this site is accessible worldwide, not all products or services discussed or referenced herein are available to all persons or in all geographic locations. we reserve the right to limit, in our sole discretion, the provision and quantity of any product or service to any person or geographic area it so desires. any offer for any product or service made in or through this site is void where prohibited. 12.3 Because it is not possible to guarantee data security, you acknowledge unauthorized access to your data may occur and you agree in such event that any loss you may suffer is subject to the limitation of liability provisions of this agreement. under no circumstances will Controlled Events be liable in any way for any data, including, but not limited to, any errors or omissions in any data, or any loss or damage of any kind incurred in connection with use of or exposure to any data posted, emailed, accessed, transmitted, or otherwise made available via the service. 12.4. Notwithstanding anything to the contrary contained herein, Controlled Events’ liability to customer for any direct damages, losses, expenses and causes of action (whether in contract or tort) arising from or relating to the service (for any cause whatsoever and regardless of the form of the action) will at all times be limited to the amount you paid Controlled Events in the three (3) months immediately preceding the incident giving rise to the claim. 12.5. You expressly understand and agree that Controlled Events (including its affiliates, subsidiaries, officers, directors, employees, agents, partners, and licensors) shall not be liable for any indirect, incidental, special, consequential or exemplary damages, including but not limited to damages for loss of profits, goodwill, use, data or other intangible losses (even if Controlled Events has been advised of the possibility of such damages. 13. DATA SECURITY 13.1. If Customer processes personal data using the Service, Customer shall comply with its obligations as a data controller and data processor under all applicable laws. 13.2. Customer is solely responsible for the lawful collection, delivery, obtaining of consents and use of all Data. All personal data and log data that we collect from you will be processed in accordance with Controlled Events’ Privacy Policy. You should review our Privacy Policy, which is incorporated into this Agreement by this reference and made a part hereof. Click here to read our Privacy Policy. 13.3. We do not have any obligation to review or scan any Customer data for any purpose, including without limitation for measuring quality, filtering content, or detecting the presence of malware. 14. INTELLECTUAL PROPERTY 14.1. Customers own their own log data. 14.2. Subject to this Agreement, Controlled Events grants Customer a non-exclusive, revocable, non-transferable, limited right to access and use the Service and the material displayed thereon. However, no right, title, or interest in any such materials will be granted or transferred to you as a result of any permitted use of such materials. 14.3. Customer hereby grants Controlled Events a worldwide, irrevocable, perpetual, non-exclusive, transferable, royalty-free license: (a) to process and use their data for the purposes of delivering the Service to Customer; (b) to access the client’s project internally within Controlled Events for the purposes of improving, developing and marketing the Service; and (c) to disclose anonymized and/or aggregated versions of log data to third parties in connection with the development, improvement and marketing of the Service, provided that such anonymized or aggregated log data shall not identify Customer. This license continues after the termination of this Agreement. Controlled Events’ rights under the license in this Section may be exercised by Controlled Events’ officers and employees and by contractors engaged to provide services to Controlled Events. 14.4. All materials incorporated in or accessible through the Site or the Service, including, without limitation, text, photographs, images, graphics, illustrations, trademarks, service marks, logos, button icons, audio clips, video clips, software, and other content, and the compilation, collection, arrangement, and assembly thereof (including the look and feel of the Site and the Service), are protected by applicable national and international trademark and copyright laws, and are owned, controlled or licensed by Controlled Events, or by the original creators of such materials or their permitted licensors. Such materials may be used only for viewing the Site in the ordinary course or as a resource for purchasing the products offered through the Site. Any other use of such materials, including any copying, reproduction, modification, sale, distribution, extraction, re-utilization, transmission, republication, downloading, display, posting, performance, or other exploitation thereof by any means or medium without the prior written permission of the copyright owner is strictly prohibited. 14.5. Where any software is supplied by us for use by Customer on its computer(s), Controlled Events grants Customer a limited, personal, non-exclusive, non-transferable license to install and use the software for use solely for the purpose of enabling you to use the Service in the manner permitted by this Agreement and for no other purpose whatsoever. Customer may not copy, modify, distribute, sell, or lease any part of the Services or any software supplied in connection with the Services, nor may Customer reverse engineer or attempt to extract the source code of that software, unless laws prohibit those restrictions or you have our written permission. To the extent that the Customer is provided with access to open source software in the course of receiving or using the Service, Customer shall be responsible for complying with the open source license associated with that open source software. 14.6. Except as expressly set forth herein, Controlled Events alone (and its licensors, where applicable) will retain all intellectual property rights relating to the Service or the Software or any suggestions, ideas, enhancement requests, feedback, recommendations or other information provided by you or any other party relating to the Service and/or the Software, which are hereby assigned by You. Customer will not copy, distribute, reproduce or use any of the foregoing except as expressly permitted under this Agreement. 15. CONFIDENTIALITY 15.1. Each party (the “Receiving Party”) understands that the other party (the “Disclosing Party”) has disclosed or may disclose information relating to the Disclosing Party’s technology or business (hereinafter referred to as “Proprietary Information” of the Disclosing Party). The Receiving Party agrees: (i) not to divulge to any third person (except as set forth below) any such Proprietary Information, (ii) to give access to such Proprietary Information solely to those employees and third parties with a need to have access thereto for purposes of this Agreement, and (iii) to take the same security precautions to protect against disclosure or unauthorized use of such Proprietary Information that the party takes with its own proprietary information, but in no event will a party apply less than reasonable precautions to protect such Proprietary Information. 15.2. The Disclosing Party agrees that the foregoing will not apply with respect to any information that the Receiving Party can document (a) is or becomes generally available to the public without any action by, or involvement of, the Receiving Party, or (b) was in its possession or known by it prior to receipt from the Disclosing Party, or (c) was rightfully disclosed to it without restriction by a third party, or (d) was independently developed without use of any Proprietary Information of the Disclosing Party. Nothing in this Agreement will prevent the Receiving Party from disclosing the Proprietary Information pursuant to any judicial or governmental order, provided that the Receiving Party gives the Disclosing Party reasonable prior notice of such disclosure to contest such order. Customer acknowledges that Controlled Events does not wish to receive any Proprietary Information from Customer that is not necessary for Controlled Events to perform its obligations under this Agreement, and, unless the parties specifically agree otherwise, Controlled Events may reasonably presume that any unrelated information received from Customer is not confidential or Proprietary Information. Both Parties will have the right to disclose the existence but not the terms and conditions of this Agreement, unless such disclosure is approved in writing by both Parties prior to such disclosure, or is included in a filing required to be made by a Party with a governmental authority (provided such party will use reasonable efforts to obtain confidential treatment or a protective order) or is made on a confidential basis as reasonably necessary to potential investors or acquirers. 16. INDEMNIFICATION 16.1. Customer shall defend, indemnify, and hold harmless Controlled Events and each of its, and its affiliates, employees, contractors, directors, suppliers and representatives, from and against any liabilities, losses, claims, and expenses, including reasonable attorneys’ fees, arising from or related to your Data, or Customer’s actions in connection with any unauthorised use of the Service, including any claim that such actions violate any applicable law or third party right. 16.2. Controlled Events will notify Customer in writing thirty (30) days of becoming aware of any such claim; give you sole control of the defence or settlement of such a claim; and provide you, at your expense, with any and all information and assistance reasonably requested by you to handle the defence or settlement of the claim. Customer shall not accept any settlement that (i) imposes an obligation on us; (ii) requires us to make an admission; or (iii) imposes liability not covered by these indemnifications or places restrictions on us without prior written consent. 17. CONTENT RESPONSIBILITY 17.1 You are solely responsible for a) Your content and Data (meaning Content You post or otherwise submit to the Site or Service), b) the accuracy, quality, and legality of Your content and of Your submissions, c) the means by which You acquired Your content, including ensuring that Your content and Your submissions do not infringe upon or violate the rights of any person, d) claims relating to Your content and Your submissions, and e) responding to any person claiming Your content and/or Your submissions violate such persons rights, including notices pursuant to the Data Protection Act and General Data Protection Regulations. 18. GENERAL 18.1. The headings to the clauses in this Agreement are for reference only and shall not affect the interpretation of this Agreement. 18.2. The waiver or failure of either party to exercise any right provided for herein shall not be deemed a waiver of any further right hereunder. 18.3. This Agreement shall not constitute any party, the legal representative, partner or agent of the other parties or any of them nor shall any party or any successor of any party have the right or authority to assume, create or incur any liability or obligation of any kind express or implied against or in the name of or on behalf of any other party. The parties hereto enter this Agreement as principals for and on their own behalf. 18.4. This Agreement or the benefit hereof may not be assigned by Customer in whole or in part without the prior written consent of Controlled Events. Customer may not re-sell or make available the Services to any third parties. Controlled Events may assign this Agreement to any purchaser of, or successor in interest to, the Controlled Events business. 18.5 Except for failure to make payments when due, neither party shall be liable to the other by reason of any failure in performance of this Agreement by either party if the failure arises out of any cause beyond the reasonable control of that party, including, but not limited to, the unavailability or faulty performance of communication networks or energy sources, any act of God, any act or omission of governmental or other competent authority, fires, strikes, industrial dispute, riots, war, inability to obtain materials, embargo, refusal of license, theft, destruction, denial of service (DoS) attacks, unauthorized access to computer systems or records, programs, equipment, data, or services. 18.6. You grant us the right to add your name and company logo to our customer list and website. 18.7. This Agreement represents the entirety of the understanding of the parties concerning the subject matter hereof and overrides and supersedes all prior promises, representations, undertakings, understandings, arrangements, agreements, side letters or heads of agreement concerning the same which are hereby revoked by mutual consent of the parties. The Customer is not relying on any warranties or representations which are not expressly set out in this Agreement. 18.8. Questions about the Terms of Service should be sent to support@controlledevent.com. 18.9. Survival. The following sections shall survive the expiration or termination of this Agreement: Definitions, Fees and Payments, Intellectual Property, Confidentiality, Indemnification, Disclaimers, Limitations of Liability, Termination and General.

Courses matching "Distribution"

Show all 915

Excel - Automating Excel with Macros and Analysis Tools

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data. This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. Working with Multiple Worksheets and Workbooks Working with Named Ranges Link Cells Across Worksheets and Workbooks Use 3D References to Calculate Across Worksheets Consolidate Data Use Formula Auditing and Error Checking Reveal Formulas Trace Cell Precedents and Dependents Locate Errors in Formulas Watch and Evaluate Formulas Reviewing and Protecting Workbooks Control Data Entry via Data Validation Protect Workbook Access Protect Worksheets and Cell Content Add and Edit Comments Prepare a Workbook for Distribution Modify Excel's Default Settings Using Macros to Automate Workbook Functionality Create Macros via Recording Run Macros via Buttons and Shortcuts Assign Macros to the Quick Access Toolbar and Ribbon Assign Macros to Objects View Macro Code Forecasting and Analysis Data Use Conditional Formatting to Highlight, Sort and Filter Key Data Advanced Conditional Formatting using Formulas Create Sparklines to Visualise Data Add Trendlines to Charts to Visualise and Forecast Trends Use Data Tables and Scenarios to Project Potential Outcomes Use Goal Seek to Calculate Outcomes Forecast Data Trends Using Solver

Excel - Automating Excel with Macros and Analysis Tools
Delivered Online
£197

Certified Data Centre Professional (CDCP)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and who has the responsibility to achieve and improve the availability and manageability of the data centre. Overview After completion of the course the participant will be able to:? Choose an optimum site for mission-critical data centre based on current and future needs? Describe all components that are important for high availability in a data centre and how to effectively setup the data centre? Name and apply the various industry standards? Describe the various technologies for UPS, fire suppression, cooling, monitoring systems, cabling standards, etc, and to select and apply them effectively to cost-efficiently enhance the high-availability of the data centre.? Review the electrical distribution system to avoid costly downtime? Enhance cooling capabilities and efficiency in the data centre by using existing and new techniques and technologies for the increased cooling requirements of the future? Design a highly reliable and scalable network architecture and learn how to ensure installers apply proper testing techniques? Create effective maintenance contracts with equipment suppliers ensuring the best return on investment? Setup effective data centre monitoring ensuring the right people get the right message? Ensure proper security measures, both procedural and technical, are established to safeguard your company's valuable information in the data centre The course will address how to setup and improve key aspects such as power, cooling, security, cabling, safety, etc., to ensure a high available data centre. It will also address key operations and maintenance aspects. The Data Centre, it?s Importance and Causes for DowntimeData Centre Standards and Best PracticesData Centre Location, Building and Construction Selecting appropriate sites and buildings and how to avoid pitfalls Various components of an effective data centre and supporting facilities setup Raised Floor/Suspended Ceiling Uniform, concentrated and rolling load definitions Applicable standards Raised Floor guidelines Signal Reference Grid, grounding of racks Disability act and regulations Suspended ceiling usage and requirements Light Standards Light fixture types and placement Emergency lighting, Emergency Power Supply (EPS) Power Infrastructure Power infrastructure layout from generation to rack level ATS and STS systems Redundancy levels and techniques Three-phase and single-phase usage Power distribution options within the computer room Power cabling versus bus bar trunking Bonding versus grounding Common Mode Noise and isolation transformers Distribution boards, form factors and IP-protection grades Power quality guidelines Real power versus apparent power How to size and calculate load in the data centre Generators Static and dynamic UPS systems, selection criteria, how they operate and energy efficiency option Battery types, correct selection and testing Thermo-graphics Electro Magnetic Fields Electrical fields and magnetic fields definitions and units of measurements Sources of EMF Effects of EMF on human health and equipment (H)EMP Standards EMF shielding solutions Equipment Racks Rack standards, properties and selection criteria Security considerations Power rail/strip options Cooling Infrastructure Temperature and humidity recommendations Cooling measurement units and conversion rates Sensible and latent heat definitions Differences between comfort and precision cooling Overview of different air conditioner technologies Raised floor versus non-raised floor cooling Placement of air conditioner units and limitations to be observed Supplemental cooling options Cold aisle/hot aisle containment Water Supply Importance of water supply and application areas Backup water supply techniques Designing a Scalable Network Infrastructure The importance of a Structured Cabling System Planning considerations Copper and Fiber cable technology and standards ANSI/TIA-942 Cabling hierarchy and recommendations Testing and verification SAN storage cabling Network redundancy Building-to-building connectivity Network monitoring system requirements Fire Suppression Standards for fire suppression Detection systems Various total flooding fire suppression techniques and systems, their benefits and disadvantages Handheld extinguishers Signage and safety Regulatory requirements and best practices Data Centre Monitoring Data centre monitoring requirements EMS versus BMS Water leak detection systems Notification options and considerations Operational Security and Safety Practices Data centre security layers Physical, infrastructure and organisational security Safety measures and essential signage Labelling Choosing a labelling scheme Recommended labelling practices Network labelling Documentation How to setup proper documentation Document management policies and procedures Cleaning Cleaning practices for the data centre MTBF/MTTR Standards and definitions Calculation models The ?real? value Maintenance Contracts/SLA/OLAEXAM: Certified Data Centre Professional Additional course details: Nexus Humans Certified Data Centre Professional (CDCP) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Certified Data Centre Professional (CDCP) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Certified Data Centre Professional (CDCP)
Delivered Online
£1,500

Certified Data Centre Specialist (CDCS)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is an IT, facilities or data centre operations professional working in and around the data centre and having the responsibility to achieve and improve high-availability and manageability of the data centre. Overview After completion of the course the participant will be able to:? Understand the design life cycle of data centres and the stages involved? Discuss the data centre requirements in great level of detail with vendors, suppliers and contractors to ensure that these requirements are met? Validate design plans, quotes and offers proposed by vendors/contractors? Understand redundancy levels for both the data centre design/setup and maintenance? Understand the various building considerations such as bullet proofing, mitigation of seismic activity, fire ratings and thermal stability? Understand how to install a raised floor that meets requirements, avoiding misalignment, level differences and leakage? Understand how to read a Single Line Electrical Diagram to identify and avoid the most common design issues? Choose the correct UPS and parallel configuration, learn and avoid classic parallel installation mistakes? Understand how to calculate battery banks, validate offered configurations to ensure they meet requirements? Understand what distance to keep to avoid EMF issues for human safety and equipment disturbances? Understand the fundamental cooling setup, CFM, Delta-T and other important factors? Understand contamination factors and limitations? Understand full details of fire suppression options, how to calculate gas content and verify installations? Understand how to measure data centre energy efficiency and how to improve it The course will bring participants to the level of a suitable sparring partner with suppliers. They will be able to verify offers provided by vendors for correctness, effectiveness and efficiency. Data Centre Design/Life Cycle Overview Overview of the phases of a data centre life cycle Planning, re-alignment and continuous improvement Standards and Rating Level Definitions Rating level history Difference between Uptime and TIA-942 Rating level definitions Redundancy options (N+1), 2N, 2(N+1) Concurrent Maintainability/Compartmentalisation Example configurations Substation and feed requirements Maintenance options Operational processes guidelines/standards Skill development Building Considerations Building location considerations Floor and hanging loads requirements Fire rating for walls and glass Blast protection Bullet proofing Forced entry protection Advanced Raised Floor & Suspended Ceiling Raised floor installation guidelines Techniques to install a proper and leveled raised access floor Common mistakes Choosing the right tiles and their locations Seismic-mitigating floor constructions Choosing the correct suspended ceiling Advanced Power Power infrastructure layout; Formulas which you should know for the data centre Single Line Electrical diagrams; how to read to ensure key components are present for protection Over current protection devices (MCB/MCCB/VCB/ACB/Fuses) definitions and what to use where Earth Leakage devices (RCB/RCD/ELCB/GFCI/ALCI/RCBO), definitions and what to use where Sizing of protective components Lightning strikes and surge protection devices (TVSS/SPD), how they operate, where to use and how to install Power cabling and cable run considerations PDU/DB setup and minimum requirements Generators; Generator types: Standy/Prime/Continuous Component make up and functions Fuel storage and calculation Paralleling of gen-sets Generator room/area requirements UPS Systems; Required specifications for UPS systems How to read data sheets and select the correct UPS Requirements for parallel configurations and avoid pitfalls such as single point of failures How parallel installation should be done, classic mistakes made by installers and how to avoid these Harmonic Filters; Active/Passive filters and their application Battery Banks; Battery bank terminology Designing battery banks, how to calculate, and double check the battery bank to be installed Battery charging pitfalls and ensuring the right charger is being installed and used Using parallel battery banks; how to properly install them, limitations and risks when using batteries in parallel How to test batteries correctly and make decisions on cell/block or string replacement Battery casing choices; ABS, V0, V1, V2 Alternative energy storage; flywheel, re-usable cell, compressed air UPS, etc. Advanced Electro Magnetic Fields Sources of EMF Difference between single, three phase and bus-bar EMF Options available to measure EMF and how to interpret the results from single-axes and composite measurements Guidance on safe distance for equipment and humans Calculation of EMF attenuation factor for shielding material permeability and saturation factors Advanced Cooling Important definitions; dry-bulb, wet-bulb, dew-point, RH, sensible and latent heat Psychometric chart and ASHRAE recommendations Environmental class definitions and thermal specifications Temperature/humidity measurements guideline Heat dissipation methods Altitude impact on temperature intake to ICT equipment Floor plan setup for effective cooling Differences in tile surface and supporting structure and the air-flow performance impact Rack door construction and the flow performance impact Equipment Delta-T and its impact Optimising air flow Thermal units conversions Calculations for air volume displacement (CFM/CMH) Cooling capacity calculations Air-conditioning selection De- / humidifying options Air conditioning efficiency SHR impact on cost saving Efficiency indicator New cooling principle and techniques (Submerged, VSD/VRF/ECF/water- and air side economisers) Redundancy guidelines for air-conditioners avoiding classic misconceptions and mistakes for meeting ANSI/TIA-942 compliant designs Installation requirements Connections to fire panel and EPO Commissioning of air conditioners Set points and calibration CFD (Computational Fluid Dynamics) Advanced Fire Protection The fire triangle and elements to stop a fire Detection systems in detail (VESDA, VIEW, smoke sensors) Considerations for installation of sensors Proper testing of smoke sensors Water based systems i.e. deluge, wet-pipe, dry-pipe, pre-action and why most of them don't work and how to detect this Details on Inert and Halocarbon systems and how to select the correct system for your data centre How to calculate the gas content ensuring the appropriate level is installed to suppress the fire including safety considerations Other requirements for gas systems such as release times, hold times, pipe install requirements and other important factors Requirements for the fire detection panel Installation verification, methods, what to check and how New advanced fire suppression technologies Design and Install Scalable Networking Cabling System ANSI/TIA942 cabling structure topology ToR, EoR Design Intelligent patching systems Installation best practice such as routing, bending radius, separation from power, containment fill ratio, fiber link loss calculator, bonding and grounding requirement Standard for telecommunications labeling and administration Environmental Specifications and Contamination Control Acoustic noise effects, regulations, specifications and limits Data centre contaminations and classifications Measurements, standards and limits Preventive measures and avoidance Data Centre Efficiency Business drivers to go Green High-availability or Green? Green guidelines and standards How to measure it and what are acceptable numbers compared to the general industry PUE classes defined by Green Grid and issues with PUE Techniques for saving energy in all parts of the data centre i.e. application/system level, cooling, power distribution Mock ExamEXAM: Certified Data Centre Specialist

Certified Data Centre Specialist (CDCS)
Delivered Online
£2,050

SCM650 SAP Cross-Functional Customizing in Sales and Distribution

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this class are Application Consultants, Business Process Architects, Business Process Owners/Team Leads/Power Users, and Program/Project Managers Overview Explore settings to map requirements in the area of Sales and Distribution (S&D) that require knowledge of cross-application Customizing functionsUnderstand and consider complex relationships in mapping organizational structuresConfigure and adapt special functions like copy control, text control, output controlUnderstand system modification options and personalization techniques This course is ideal for students who are requiring detailed cross-application configuration knowledge to map requirements integrated to sales and distribution. Copy Control Modifying Copy Control Text Control Identifying Text Sources Configuring Text Control Output Adjusting Output Determination Adjusting Output Types Using PDF-Based Forms in the Sales Process Enhancements & Modifications Using Enhancement Technology Adjusting the Screen Setup of a Transaction Using Table Controls Adjusting Lists in Sales and Distribution Controlling Customer Master Data Using Account Groups Adjusting the Screen Setup of a Transaction Using Transaction Variants Adding New Fields Performing System Modifications Using Classic Enhancement Technology Performing System Modifications Using the Enhancement Framework Additional course details: Nexus Humans SCM650 SAP Cross-Functional Customizing in Sales and Distribution training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SCM650 SAP Cross-Functional Customizing in Sales and Distribution course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

SCM650 SAP Cross-Functional Customizing in Sales and Distribution
Delivered OnlineFlexible Dates
Price on Enquiry

BRCGS Storage & Distribution Sites Issue 4 (4 Half-Day Sessions)

5.0(36)

By Ask Sonia Limited

Official BRCGS Storage & Distribution Issue 4: Sites course. Delivered online (Zoom) by a live BRCGS Approved Training Partner. Exam and Certificate fee included in the price.

BRCGS Storage & Distribution Sites Issue 4 (4 Half-Day Sessions)
Delivered Online + more
£570

SCM620 SAP Pricing in Sales and Distribution

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Project team members In this course, students learn how to successfully set up functions and customizing settings for pricing in Sales and Distribution. Course Outline Condition technique for definition and maintenance of prices, surcharges and discounts Creating condition tables, access sequences, and condition types Using prices and other conditions in sales documents Promotions and sales deals Introduction to rebate processing

SCM620 SAP Pricing in Sales and Distribution
Delivered OnlineFlexible Dates
Price on Enquiry

BRCGS Storage & Distribution Auditor Issue 4 (6 Half-Day Sessions)

5.0(36)

By Ask Sonia Limited

Official BRCGS Storage & Distribution Issue 4: Auditor course. Delivered online (Zoom) by a live BRCGS Approved Training Partner. Exam and Certificate fee included in the price.

BRCGS Storage & Distribution Auditor Issue 4 (6 Half-Day Sessions)
Delivered Online + more
£840

BRCGS Storage & Distribution Sites Issue 4 (2 Days)

5.0(36)

By Ask Sonia Limited

Official BRCGS Storage & Distribution Issue 4: Sites course. Delivered online (Zoom) by a live BRCGS Approved Training Partner. Exam and Certificate fee included in the price.

BRCGS Storage & Distribution Sites Issue 4 (2 Days)
Delivered Online
£570

BRCGS Storage & Distribution Auditor Issue 4 (3 Days)

5.0(36)

By Ask Sonia Limited

Official BRCGS Storage & Distribution Issue 4: Auditor course. Delivered online (Zoom) by a live BRCGS Approved Training Partner. Exam and Certificate fee included in the price.

BRCGS Storage & Distribution Auditor Issue 4 (3 Days)
Delivered Online
£840

50255 Managing Windows Environments with Group Policy

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Enterprise network staff responsible for help desk support, system administration, and network design. Overview At Course Completion: - Features and functions of Group Policy - Use Group Policy management tools to manage security policies - Design a Group Policy infrastructure - Group Policy processing architecture - Back up, restore, import, and copy Group Policy Objects through the Group Policy - Management Console - Use Windows PowerShell to manage Group Policy - Implement security using Group Policy - Configure the desktop environment with Group Policy - Configure roaming profiles and Folder Redirection - Assign and publish software packages - Implement AppLocker and software restriction policies - Create and deploy Administrative Templates - Configure Group Policy preferences In this course, you will learn how to reduce costs and increase efficiencies in your network. You will discover how to consolidate the administration of an enterprise IT infrastructure with Group Policy, and you will learn to control and manage computer systems and domain users running Windows Server 2016 and Windows clients. Create Group Policies, implement administrative and security templates, and determine best practices when deploying software packages. Walk away with the experience and tools needed to optimize your enterprise systems and networks, implement administrative and security templates, and determine best practices when deploying software packages. 1 - Introduction to Configuration Management Configuration Management Overview Configuration Management Using Group Policy Group Policy Features Introduced with Later Versions of Windows Using Windows PowerShell in the Configuration Management Process 2 - Using Group Policy Management Tools Local and Domain Policies Using Group Policy Management Console Understanding Group Policy Refresh 3 - Designing a Group Policy Infrastructure Design Stages for a Group Policy Infrastructure Planning your Group Policy Design Designing Your Group Policy Solution Deploying Your Group Policy Solution Managing Your Group Policy Solution 4 - Understanding the Architecture of Group Policy Processing Group Policy Components in AD DS Understanding the Group Policy Deployment Order Modifying Group Policy Processing 5 - Troubleshooting and Backing Up GPOs Using Group Policy Troubleshooting Tools Integration of RSoP Functionality Group Policy Logging Options Backing Up, Restoring, Importing, and Copying GPOs Building Migration Tables 6 - Securing Windows Using Group Policy Exploring the Windows Security Architecture Securing User Accounts Exploring Security Policies Windows Firewall with Advanced Security Implementing Domain Security Security Policy Options for Window Client and Windows Server 7 - Implementing Application Security Using Group Policy Managing UAC Settings Defending Against Malware Using AppLocker to Restrict Software Implementing Windows App Security Settings 8 - Configuring the Desktop Environment with Group Policy Exploring Script Types and Controlling Script Execution Defining the Desktop, Start Menu, and Taskbar Settings Defining the Control Panel Settings Defining the Windows Components Settings Configuring the Printer Management and Pruning Settings Defining the Network Settings Discovering the new Group Policy Settings 9 - Implementing User State Virtualization Configuring Folder Redirection Managing Offline Files Implementing User Experience Virtualization OneDrive for Business 10 - Assigning and Publishing Software Packages Using MSI Packages to Distribute Software Using Group Policy as a Software Deployment Method Deploying Software Setting Up Distribution Points Using the Systems Center Configuration Manager to Distribute Software 11 - Configuration Management with Windows PowerShell Introducing Windows PowerShell Using Windows PowerShell Writing PowerShell Scripts Windows PowerShell Library for Group Policy Windows PowerShell-Based Logon Scripts 12 - Implementing PowerShell Desired State Configuration Introducing Group Policy Preferences Comparing Preferences and Policy Settings Options for Applying Preferences Configure Preference Settings 13 - Configuring Group Policy Preferences Introducing Group Policy Preferences Comparing Preferences and Policy Settings Options for Applying Preferences Configuring Preferences Settings Additional course details: Nexus Humans 50255 Managing Windows Environments with Group Policy training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 50255 Managing Windows Environments with Group Policy course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

50255 Managing Windows Environments with Group Policy
Delivered Online
£2,975