1938 Courses in Manchester

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

A thorough account of the UK and European legal framework and its requirements as regards managing environmental performance. This course will help staff to understand: The framework of UK and European legislation and its enforcement The principal features of the legislation as they apply to your organisation's activity/product/service The benefit of having an Environmental Management System such as ISO 14001 How their own actions and decisions can either expose or protect the organisation in relation to its legal obligations 1 Introduction and objectives 2 Introduction to environmental law and enforcement Sources of law (European and UK) Structure and enforcement Key legislation 3 Integrated Pollution Prevention and Control (IPPC) and Local Air Pollution and Control (LAPC) Pollution and Prevention Control Act 1999 EC Directives on PPC The meaning of BAT Transitional provisions Fit and proper persons Control of emissions to air National Air Quality Strategy 4 Packaging and producer responsibilities Who, what and how The Producer Responsibility Obligations (Packaging Waste) Regulations Obligations and exemptions Registration Recycling and recovery obligations Records Duties of the Environment Agency Offences Developments 5 Waste management National Waste Strategy Waste minimisation (re-use/recycling) Waste definition Disposal and recovery Controlled waste management Hazardous waste management 6 Proposed Legislation and EC Directives EU Commission's waste and resources strategies Implementation of ELV (End of Life Vehicles) Directive WEEE (Waste Electrical and Electronic Equipment) Directive transposition into UK legislation Other producer responsibility initiatives Other proposals from the EU 7 Conclusion Open forum Summary Close

About this Course This 5 full-day course provides a comprehensive understanding of all the commissioning procedures for combined cycle power plants. The Commissioning Management System (CMS) of combined cycle power plants is covered in detail in this course. This includes all the commissioning procedures and documents, purpose of commissioning, responsibilities, system description, organization, working parties, test teams, documentation, testing and commissioning schedules, test reports, safety, plant certification, and plant completion report. The course provides also a thorough understanding of all the commissioning requirements for gas turbines, steam turbines and auxiliaries, generator and auxiliaries, electrical equipment, switchgear equipment, switchgear and transformers. All the stages of the commissioning procedure are covered in-depth in this course. This includes preparation - planning various activities, pre-commissioning checks and tests, typical commissioning schedule, detailed tests and commissioning procedures and instructions for every component in a combined cycle power plant, instrumentation, trial run of the equipment, safety and precautions, commissioning of combined cycle power plant systems, safety rules clearance certificates, procedure for the control and handling of defects, commissioning reports, operational testing, first fire, generator synchronization, performance testing, heat rate testing, emission testing, contract testing, CO2 concentration tests, electrical full-load rejection test, duct burner testing, partial load stability test, and reliability test. This course is a MUST for anyone who is involved in the pre-commissioning or commissioning of any combined cycle power plant equipment because it provides detailed pre-commissioning checks and tests, and detailed tests and commissioning procedures and instructions for every component in a combined cycle power plant. In addition, the seminar provides an in-depth coverage of all preparation, planning activities, commissioning schedules, trial run of each combined cycle power plant equipment, safety and precautions, safety rules clearance certificates, procedures for handling defects, and commissioning reports. Training Objectives Pre-commissioning Checks and Tests, Detailed Tests and Commissioning Procedures and Instructions for Every Equipment in Combined Cycle Power Plants: Gain a thorough understanding of all pre-commissioning checks and tests, and all commissioning procedures and instructions for every equipment in combined cycle power plants Commissioning Management System (CMS) of Combined Cycle Power Plants: Discover the benefits of the CMS of combined cycle power plants including all commissioning procedures and documents, purpose of commissioning, responsibilities, system description, organization, working parties, test teams, documentation, testing and commissioning schedules, test reports, safety, plant certification, and plant completion report Commissioning Procedures and Instructions for Heat Recovery Steam Generators, Air Blow and Steam Blow of Steam and Gas Piping in Combined Cycle Power Plants: Learn about the commissioning procedures and instructions for heat recovery steam generators, chemical cleaning of heat recovery steam generators, air blow and gas blow of steam and gas piping in combined cycle power plants, safety valve setting and soot blowers Commissioning Procedures and Instructions for Gas Turbines and Steam Turbines: Gain a thorough understanding of all the commissioning procedures and instructions for gas and steam turbines and auxiliaries including acid cleaning of oil pipelines, lubrication and governing system (oil flushing and hydraulic testing), jacking oil system, governing system, regenerative system, barring gear, vacuum tightness test, first rolling of turbine and data logging Commissioning Procedures and Instructions for Generator and Auxiliaries: Discover all the commissioning procedures and instructions for generator and auxiliaries including generator, seal oil system, hydrogen gas system, stator water system, rolling and start-up of generators Commissioning Procedures and Instructions for Electrical Equipment: Learn about all the commissioning procedures and instructions for electrical equipment including switchyard equipment, switchgear, transformers and motors Operational Testing, Performance Testing, Heat Rate Testing, Emission Testing of Combine Cycle Power Plants: Gain a thorough understanding of operational testing, first fire, generator synchronization, performance testing, heat rate testing, emission testing, contract testing, CO2 concentration tests, electrical full-load rejection test, duct burner testing, partial load stability test, and reliability test of combined cycle power plants Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Training Methods The instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all the delegates gain a complete understanding of all the 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. 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

Reliability Centred Maintenance (RCM) is commonly used to help establish safe minimum levels of maintenance, determine changes to operating procedures and help establish maintenance regimes and plans. Successful implementation can result in cost savings, machine uptime and improved risk management. But the devil's in the detail - how can you achieve these benefits and successfully implement RCM in your organisation? This programme will help you do just that. Note: this is a purely indicative outline. The content, duration, objectives and material used can all be adapted to match your specific requirements. To provide a better understanding of RCM, particularly: What, why, how and who? Opportunities and benefits Risks Cost effectiveness Note: this is a purely indicative outline. The content, duration, objectives and material used can all be adapted to match your specific requirements. 1 What is maintenance? Why maintain? Traditional maintenance methods Common current practices and trends 2 What is Reliability Centred Maintenance? Its history Its development Current usage Where can it be cost-effective? 3 How does it work? Basic features Key criteria Maintenance options Key outcomes 4 Making the business case and preparing the strategy Identifying and quantifying current risks Identifying and quantifying current costs Motivating decision-makers Identifying and empowering those who have to deliver the results Educating / gaining buy-in from interested parties 5 Implementation Identify business functions Prioritise functions Verify correct usage Identify failure modes Identify the consequences of failure Understand the failure process Specify the appropriate maintenance action(s) 6 Ongoing requirements Monitoring Recording Analysis Continuous re-evaluation 7 Open discussion Sharing experience and addressing specific issues of interest to participants Course review Close

Meetings are a fact of working life - both virtual and physical meetings. Recording the key points from meetings is critical to making sure that accurate information is captured, and action points are clearly identified and allocated. This virtual training session will support members of staff to develop their skills in recording the key points from meetings and discussions. This course will help participants: Describe the different levels of note taking and pick the appropriate style for the meeting Prepare to take minutes in the virtual and the physical environment Liaise and work in partnership with the meeting Chair Use a template to enable the capturing of key points Set up the room ready for the meeting Identify key points to record, versus what not to record Interrupt the meeting confidently to check key points Take neutral, accurate and concise records Produce a well-laid out set of minutes. 1 Introduction Objectives and overview Introductions and personal aims 2 An introduction to minutes Purpose and use Different levels of notetaking 3 Preparing to take minutes Identifying the purpose of the meeting Working with the Chair Tips and techniques to prepare effectively Case studies, review and discussion The physical environment: setting up for a meeting 4 Listening and recording Tips and techniques to make the process easier How to interrupt a meeting What to record; what to leave out Recording in short-form using playscript and bullet-points Listening neutrally Activity: Minuting a Meeting The tricky ones and how to overcome problems in the meeting 5 Preparing the minutes Producing a set of draft minutes Tips on grammar, punctuation and layout Stylistic variation Managing feedback from the Chair 6 Review Summary of key learning points Action planning

Paediatric First Aid Training – This QA Level 3 Award in Paediatric First Aid Training (RQF) qualification is ideal for those who work or intend to work in a childcare setting as it has been specifically designed to fulfil Ofsted’s first aid requirements for early years teachers, nursery workers and childminders (as defined within the Statutory Framework for the Early Years Foundation Stage 2014 and within the Child Care Register guide).

To provide a fundamental understanding of building services in the context of: The working environment The success of the core business The health and safety of the occupants Operating cost and environmental impact The optimisation of cost and value Strategies for continuous improvement DAY ONE 1 Building services fundamentals The function of services in commercial buildings and their importance to the core businessElectrical servicesLightingHeatingVentilation and air conditioningLiftsWater Understanding IT and communication systems Practical exercises 2 The provision of comfort and safety Statutory requirementsHealth and safety legislationControl of contractorsRisk assessmentFire precautionsLegionella, sick building and other risks Business requirementsUnderstanding user requirementsMatching systems to business needs Practical exercises 3 Getting the design right What the FM needs to know about design and its procurementSuccessful space planningRelationship between services, space planning and designGetting the brief rightSupplier selection and management Practical exercises DAY TWO 4 Operation and maintenance Why maintain?Maintenance contractsInput and output specificationsResource optionsContracts - principal elementsTendering - key stepsSelection criteriaOperational criteriaMaintenance trends Performance-based service provisionInput and output specificationsKPIs and thresholdsRisk containmentValue-add opportunitiesPerformance contract strategy Practical exercises 5 Contingency planning Being ready for the unexpected Identifying and reducing riskInternal risksExternal risksIdentifying threats at your site Managing riskProtective systemsOccupier obligationsFire managementTesting Practical exercises 6 Commissioning services systems Physical commissioning Common problems Typical costs Commissioning stages Continuous commissioning Energy efficiency and the scope for environmental improvement Practical exercises 7 Satisfying the occupants Obtaining and responding to feedbackWhen to get feedbackWhyHowWhat to do with it Practical exercises 8 'Air time' Sharing experience and addressing specific issues of interest to participants Course review Close

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

Designed to identify and discuss Personal Protective Equipment, correct hand hygiene, standard precautions when working with customers, dealing with sharps, COSHH and a brief look at specific infections.

Our Motivational Intelligence Executive Management course is targeted at transitional leadership development to adapt to market dynamics. AWARD WINNING LEADERSHIP DEVELOPMENT PROGRAMME Executive Diploma: Leading With Motivational Intelligence Leading your team or business through transitions or adapting to change is a vital leadership skill that most find challenging. The Power Within Training is dedicated to giving leaders, managers, and businesses throughout England and the UK the executive leadership skills needed to transform their businesses. Neuroscientists have now discovered why people perceive risk, resist change, and cling to the legacy ways they approach their role. With this discovery, we’ve found a practical approach for removing this resistance and fostering greater employee accountability, adaptability, and resilience. The answer was uncovered in the emerging field of Motivational Intelligence. This course has completely changed my outlook on my responsibilities as a manager/leader. To say I have a new perspective is an understatement; I now have the tools to make a massive difference in how I run my company and my life; it has put a new voice in my head that is now directing me in ways I had not thought of before. "If you want a better chance in life and business, do not hesitate to do this course." MANAGING DIRECTOR RBT UNDERFLOWING LIMITED The Role of Motivational Leadership Our motivational leadership courses are rooted in the science of Motivational Intelligence. Motivational Intelligence is designed as an individual’s ability to identify and manage negative thoughts and self-limiting beliefs to overcome obstacles and accomplish goals. Using motivational intelligence and our management development program provides you with the skills and tools needed to face high-level challenges and put thoughts into action while paving the way to a vision. Motivation relies on the learning process of an individual and their ability to observe the relationship between performance and outcome. Motivational leaders can evoke and see the best in their employees and inspire them to work toward a common goal. LEADING WITH MOTIVATIONAL INTELLIGENCE Objectives of our Motivational Leadership Courses The management development program we offer is the world’s first accredited Executive Diploma specifically designed to help progressive-minded leaders adapt to today’s business environment. We focus on issues and challenges created by disruption and turbulence. Our motivational leadership courses address topics ranging from leading/managing virtual teams to helping employees more readily orient to an ever-changing world. The Power Within focuses on imparting fundamental skills, tactical best practices, and powerful insights into the human side of the business. Leadership training provides valuable knowledge to leaders of all levels. The management portion of our leadership training teaches participants how to define the proper team goals, translate them into actionable plans and communicate them in a way that encourages buy-in. Lastly, the leadership portion focuses on developing people by shifting negative thoughts and self-limiting beliefs such that individuals give themselves permission to learn, grow, and execute new strategies and plans. Here are some additional objects of our motivational leadership courses: To Understand the Role of Motivation in the Workplace To Develop a Deep Understanding of the Different Types of Motivation and How They Can Be Applied to Improve Team Performance To Learn How to Use Motivational Intelligence to Create a Positive and Productive Work Environment To Develop the Skills Needed to Increase Employee Engagement and Drive Business Results To Practice Effective Leadership Techniques that Foster Motivation and Engagement LEADING WITH MOTIVATIONAL INTELLIGENCE Our Leading with Motivational Intelligence (MQ) Executive Diploma Programme is specifically designed to help participants create the “complete game” of leadership and management. Leveraged by more than 40% of the largest Fortune 500 companies and implemented around the world, the Leading with Motivational Intelligence (MQ) consistently receives a participant buy-in rate in excess of 97%. However, the most important statistic is: 12 months after completing the course more than 93% of participants continue to use the skills and techniques taught on a daily basis. ABOUT THE MQ EXECUTIVE DIPLOMA Are There Different Types of Motivational Leadership? Motivation is the fuel that drives the accomplishment of a goal; without any motivation, the goal becomes another difficult task. Motivational leadership means understanding that regardless of whether you’re leading a small group or an entire business, your leadership and motivational style can significantly impact the effectiveness of your effort. There are several leadership and motivation styles, but the challenge comes with finding the most appropriate for you and your team. In our leadership development program, we’ll discuss leadership motivational skills while working with you to find the best one. Motivational leadership either takes the form of intrinsic or extrinsic motivation. Intrinsic motivation motivates your team to be rewarded internally, and extrinsic motivation uses compensation as a driving force. Compensation can be salary, bonuses, goods, money, or even an appraisal. Here are some examples of different intrinsic and extrinsic motivational types: Competence Motivation – This style is driven by curiosity and a willingness to know more and cultivate additional skills. This style’s central pillar is building more expertise on a subject matter as a noncompetition among peers. Achievement Motivation – Achievement motivation is similar to competence, as it aims to achieve personal development goals. This could take the form of a title within the company. An example could be in your sales department, where a leaderboard or wall of fame is used to track sales. Reward-Based Motivation – This is probably the only motivational type most are aware of, as it’s the easiest way to get a fast motivational boost. The main issue with this type of motivation is that employees get used to it, and the effects don’t last long. Understand the Importance of Motivation Skills in Leadership Motivation drives nearly every action of our lives. Motivational leadership drives the why behind every business idea that’s ever been put into action. As a leader or manager, you must understand the importance of motivating team members, and being able to do this effectively is a requirement in every manager, leader, or business owner’s toolkit. Our management development program builds on best practices, strategic insights, and lessons learned over three decades of building leadership universities for Fortune 500 companies. Focusing on imparting fundamental skills to our executive development course offers powerful insights into the human side of the business. You’ll gain the skills needed to foster a growth mindset within your team. Here are some additional reasons why motivational leadership matters: Improved Performance – Motivated employees can drive the performance of your business. When your employees are motivated, you’ll find lower levels of absenteeism, improved relationships between managers and employees, and improved worker performance throughout your business. Enhanced Innovation – Motivation is a significant force behind innovative ideas. You’re more likely to identify workplace improvement opportunities when your team is motivated. Improved Workplace Culture – Employee motivation and your workplace culture are closely linked. When you take our leadership development program, you’ll discover that a motivated workforce brings commitment, and drive, which enhances your business’s overall morale and creates a positive work culture. Register your interest Motivational Leadership Techniques That Foster Engagement When employees are unmotivated or disengaged, it’s easy to blame tools, processes, or contributing factors. Often, disengagement comes down to a lack of effective leadership. Our leadership training program will help you unlock what leaders need to inspire their employees to do their job and find purpose within their roles. Here are some ways you can apply what you learned during your leadership development program to encourage collaborative leadership and inspire your team to do their very best work: Employees Trust Leaders Whom Both Lead and Follow – Good leaders don’t needlessly exhibit authoritative behaviour. Good leaders show their team that they are willing to roll up their sleeves and work with their team to improve the business. Passion and Positivity Increase Employee Performance – Effective motivational leadership combines finding meaning in work, leveraging connection and community, converting stress into opportunity, taking actions despite the risk, and lastly, maintaining the energy of others through motivation. Show enthusiasm in your business, which will convey your passion to others and can help increase performance and employee engagement. Effective Leadership Prioritizes Business – Successful leaders are more about short-term goals than reaching the next milestone and contributing to your overall business. Practical leadership qualities include providing growth opportunities, inspiring and motivating employees, being open and trusting, and assessing and managing risks. These decisions lead to more long-term success for your business. How To Register For Our Leadership Development Program   Our motivational leadership courses are open to leaders, managers, and business owners looking to quickly adapt their team to change and effectively mentor every team member. The modules in our leadership development program are live virtual instructor-led sessions that meet twice per month for about three and a half hours. These modules incorporate insightful discussions and engaging group conversations designed to shift limiting mindsets, isolate best practices and foster actionable strategies that can be applied immediately. To apply for the course, we ask that you register your interest. Once submitted, The Power Within will contact you to discuss options for fully-funded or partially-funded training opportunities. Register your interest today Book Your Motivational Leadership Course Today   The Power Within is the Motivational Intelligence company dedicated to helping your business become more accountable, resilient, adaptable, and capable of handling all the challenges they encounter. Our leading with Motivational Intelligence Executive Diploma course has been built leveraging Nobel Prize-winning research and the latest advancements to ensure everything necessary for meaningful change is in place. Our leadership development program is fully accredited and internationally recognized for its effectiveness in developing world-class leaders. We want to give you the tools, techniques, and knowledge to think bigger, be better, and achieve more. Don’t hesitate to contact us to learn more about our leadership development program.