8880 Power courses

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

Join us for an inspiring online event where we'll explore the power of purpose in our lives. Discover how finding your purpose can bring clarity, fulfillment, and direction. Reduce stress and gain balance and perspective as you focus on what really matters to you and aligns with your core values.

Dive deep into the mesmerising world of scents with the 'Aromatherapy: The Healing Power of Scents Diploma'. Discover the intricate details of essential oils, their unique properties, and their role in promoting emotional and physical well-being. From mastering the art of blending to understanding the importance of ethical practices, this diploma provides a comprehensive insight. Moreover, for those with a keen business acumen, our modules on business strategies in this realm will guide you to confidently carve a niche in the market. Learning Outcomes Understand the foundational principles and history of aromatherapy. Identify various essential oils, their properties, and their uses in holistic healing. Develop proficiency in blending techniques, creating custom formulations for diverse needs. Recognise the importance of safety protocols and ethical considerations in aromatherapy practices. Grasp the nuances of aromatherapy applications for specific populations and its business aspects. Why buy this Aromatherapy: The Healing Power of Scents Diploma? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success Who is this Aromatherapy: The Healing Power of Scents Diploma for? Individuals keen to explore holistic healing methods. Wellness enthusiasts desiring to incorporate aromatherapy into their practices. Aspiring aromatherapists aiming to gain a thorough grounding in the subject. Health professionals interested in broadening their therapeutic toolkit. Entrepreneurs eager to delve into the aromatherapy market. Career path Aromatherapist: £25,000 - £40,000 Wellness Coach incorporating Aromatherapy: £30,000 - £50,000 Aromatherapy Product Developer: £28,000 - £45,000 Aromatherapy Workshop Facilitator: £25,000 - £42,000 Aromatherapy Retail Specialist: £24,000 - £38,000 Prerequisites This Aromatherapy: The Healing Power of Scents Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 1: Introduction to Aromatherapy Introduction to Aromatherapy 00:17:00 Module 2: Essential Oils and Their Properties Essential Oils and Their Properties 00:16:00 Module 3: Aromatherapy Techniques and Applications Aromatherapy Techniques and Applications 00:16:00 Module 4: Common Aromatherapy Blends and Recipes Common Aromatherapy Blends and Recipes 00:18:00 Module 5: Blending Techniques and Custom Formulations Blending Techniques and Custom Formulations 00:17:00 Module 6: Emotional Well-being and Aromatherapy Emotional Well-being and Aromatherapy 00:11:00 Module 7: Physical Well-being and Aromatherapy Physical Well-being and Aromatherapy 00:13:00 Module 8: Safety and Ethical Practices in Aromatherapy Safety and Ethical Practices in Aromatherapy 00:18:00 Module 9: Aromatherapy for Special Populations Aromatherapy for Special Populations 00:17:00 Module 10: Business and Marketing in Aromatherapy Business and Marketing in Aromatherapy 00:14:00

About this training course This 5 full-day course will provide a comprehensive understanding of the design of circulating fluidized bed (CFB) boilers. The design of all CFB boiler components and equipment including furnace, cyclones, economizers, superheaters, reheaters, loop seals, expansion joints, refractory, and L-valves will be covered in detail. All potential operating problems and major operating problems, corrective actions and maintenance required for CFB boilers will be covered thoroughly. This course will focus on designing CFB boilers that have the highest efficiency, and maximum longevity and capacity factor. All the common problems encountered in CFB Boilers will be discussed in detail.This includes thermally induced failures, anchor system induced failures, water walls tube failures, NMEJ damages, clinker formation, refractory damages, APH tube chock-up, erosion and corrosion. The solutions to each of these problems will be presented. All repair and refurbishment methods, preventive and predictive maintenance required for CFB boilers will be covered in-depth. Several studies have confirmed that CFB boilers are the best method for power generation.This is due to their fuel flexibility, and lowest electricity cost among all types of boilers. This technology is in great demand due to various other advantages such as lower emissions as compared to other types of boilers and has a carbon footprint well below the norms laid down by the World Bank emission requirements. This course is a MUST for anyone who is involved in the design, operation or maintenance of circulating fluidized bed boilers, because it covers how these boilers are designed and provides guidelines and rules that ensure the CFB boilers have great performance. This course will also provide up-dated information in respect to the design of supercritical once-through CFB boilers and ultra supercritical CFB boilers. Training Objectives Circulating Fluidized Bed Boiler Design: Gain a thorough understanding of the best design methods of circulating fluidized bed boilers. Design of Circulating Fluidized Bed Boiler: Components and Systems: Learn all the techniques used to design CFB boiler equipment and systems including furnace, cyclones, economizers, superheaters, reheaters, loop seals, expansion joints, refractory, and L-valves. Design of Circulating Fluidized Bed Boiler to Achieve Highest Efficiency, and Best Performance and Economics: Gain a thorough understanding of all the methods used to design CFB boilers having the highest efficiency, longevity and capacity factor as well as best economics. Circulating Fluidized Bed Boiler Equipment: Learn about various equipment of circulating fluidized bed boilers including: furnaces, cyclones, economizers, superheaters, reheaters, ammonia injection systems, electrostatic precipitators, polishing dry scrubbers, fuel and sorbent feeding systems, bottom ash handling and extraction systems and materials. Circulating Fluidized Bed Boiler Environmental Emissions: Learn about the monitoring and control of environmental emissions from circulating fluidized boilers. Circulating Fluidized Bed Boiler Instrumentation and Control Systems: Learn about the latest instrumentation and control systems of circulating fluidized bed boilers. Circulating Fluidized Bed Boiler Reliability and Testing: Increase your knowledge of predictive and preventive maintenance, reliability and testing of circulating fluidized bed boilers. Circulating Fluidized Bed Boiler Selection and Applications: Gain a detailed understanding of the selection considerations and applications of circulating fluidized bed boilers. Circulating Fluidized Bed Boiler Maintenance: Learn all the maintenance activities required for circulating fluidized bed boilers, to minimize their operating cost and maximize their efficiency, reliability, and longevity. Circulating Fluidized Bed Boiler Refurbishment, and Life Extension Methods: Learn about life cycle cost, profitability, refurbishment, and life extension methods for all types of circulating fluidized bed boilers. Circulating Fluidized Bed Boiler Commissioning: Understand all the commissioning requirements of circulating fluidized bed boilers. Circulating Fluidized Bed Boiler Codes and Standards: Learn all the codes and standards applicable for circulating fluidized bed boilers. Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: 'POWER GENERATION HANDBOOK' published by McGraw-Hill in 2012 (800 pages) Design of Circulating Fluidized Bed Boiler manual (600 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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

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.

Law of Attraction Course - The Power of Attraction Mantras Overview Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this law of attraction - the power of attraction mantras course will set you up with a solid foundation to become a confident life coach or therapist and develop more advanced skills. This comprehensive law of attraction - the power of attraction mantras course is the perfect way to kickstart your career in the field of law of attraction. This course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. Who should take this course? This comprehensive law of attraction - the power of attraction mantras course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of law of attraction. Entry Requirement There are no academic entry requirements for this law of attraction - the power of attraction mantras course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Method of Assessment On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Career path This law of attraction - the power of attraction mantras course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Law of Attraction Beginning Concepts & Ideas Self-Enhancement Mantras Unlock Your Ultimate Potential Empty Your Mind Attract Your True Calling Getting The Universe to Give Wealth Attraction Mantra Health Attraction Mantra Assessment Assessment - Law of Attraction Course Online - The Power of Attraction Mantras Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

10 Soft Skills You Need 1 Day Training in Canterbury

10 Soft Skills You Need 1 Day Training in Sunderland

10 Soft Skills You Need 1 Day Training in Kingston upon Hull

10 Soft Skills You Need 1 Day Training in Dublin