1611 Courses in Cardiff delivered Live Online

The UK has set an ambitious 2050 Net Zero Carbon target. A fundamental part of the Net Zero Carbon strategy is to change from gas heating systems to cleaner electrified heat. This course aims to equip those involved in forming energy strategies, planning developments, new building projects, refurbishment projects on how electrified heat can be correctly applied. Whilst a major focus of the course is on heat pumps the course also considers other options for electrified heating and what the components are for all these heating system options. The course also details building fabric considerations, electrical system requirements and addresses the issue of using electrified heat to generate hot water for domestic purposes.

Who is this Level 3 NVQ aimed at? The experienced worker qualification is for practising electricians with at least 5 years experience but have never formally completed an industry apprenticeship or equivalent Level 3 NVQ Qualification. This is suitable for self-employed and employed electricians. This is the Level 3 pathway for practising electricians to obtain your ECS Gold Card and JIB Grading. To complete the full qualification you will also need to: Have completed an AM2e Assessment Have a current Wiring Regulations Qualification BS7671 Have an initial verification qualification such as a C&G 2391-50 What’s involved in the qualification? After an initial Skills Scan, we will discuss the gaps that need to be filled and you will be assessed using a range of methods to complete the evidence gathering process.There will also be Professional Discussions to discuss areas of expertise and you can choose either an installation or maintenance route based on the work you carry out.There are seven Performance Units to be assessed for the qualification, these are: Apply Practices and Procedures for Maintenance Apply Health, Safety and Environmental Considerations Organise and Oversee the Electrical Work Environment Apply Design and Installation Practices and Procedures Terminate and Connect Conductors Inspect, Test and Commission Electrical Systems Apply Fault Diagnosis and Rectification On completion of the Experienced Worker assessment you will be able to use the qualification to apply for a JIB Gold Card. This qualification is for experienced electricians who can demonstrate over 5 years experience.It is not suitable for new entrants or those currently on an apprenticeship.

Who is this Level 3 NVQ aimed at? The electrical NVQ is designed for those with five or fewer years of experience in the electrical industry, and who have completed their City & Guilds 2365 Level two and three diplomas. Prior to joining, candidates will be assessed on their readiness for the Level 3 NVQ. What does this Electrical NVQ cover? This Level 3 Diploma covers Domestic, Commercial, and Industrial sectors – it will include a range of units of New Installations such as: Health and Safety Overseeing and organising work environment Applying environmental legislation Inspection and Testing Fault finding Professional discussions with assessors AM2 (this is a separate course and has an additional cost.) This is not a training course; it is an assessment of competence. Unlike other courses, this will not be based in a classroom or workshop – instead, candidates will complete this qualification on work placement. Candidates will complete electrical installations on-site, and they will then be assessed by a qualified assessor, building their portfolio. Only a small amount of this will involve going to a training centre. Before entering a workplace, your assessor will go over and help you understand: How to build a portfolio What range of evidence is required to meet the qualification criteria What assessors are looking for in order for candidates to demonstrate full professional competence Assessors will use a range of methods to evaluate candidate’s electrical installations such as; witness testimony, photographic evidence, direct observation, and reflective accounts. How long does the NVQ take to complete? The length differs for each candidate as it depends on how quickly they take to cover the types of work required to complete all units. If you have been working in the industry, previous jobs can be used as evidence to hurry the process up. What qualifications will I gain? Once candidates have completed their portfolio and other assessments, they will gain a formal City & Guilds Level 3 NVQ certificate. When candidates have completed their NVQ, they must move on to the AM2 end point assessment, which must be completed at an AM2 approved centre, such as our Sheffield centre.

Introducing our Local Relationship Counselling Services Package – a comprehensive solution designed to strengthen and nurture your relationship. At Miss Date Doctor, we understand that every couple’s needs are unique, which is why we offer a range of tailored services to cater to your specific requirements. With the flexibility to choose any of our offices, we ensure convenience and accessibility for all our valued customers. Our team of expert relationship coaches is dedicated to helping you navigate through the challenges and complexities of modern relationships. Our Local Relationship Counselling Services Package covers a wide array of areas, addressing common concerns and providing guidance in the following key areas: Communication Enhancement: Effective communication is the cornerstone of any successful relationship. Our coaching package equips you with valuable tools and techniques to improve communication, fostering greater understanding and connection between you and your partner. Conflict Resolution: Conflicts are inevitable in relationships, but how we handle them can make all the difference. Our relationship coaching services provide you with valuable insights and strategies to resolve conflicts amicably, promoting harmony and mutual growth. Trust Building: Trust forms the foundation of a healthy relationship. Our experienced coaches will guide you through exercises and discussions aimed at rebuilding trust, overcoming past issues, and cultivating a stronger bond. Intimacy and Emotional Connection: Enhancing intimacy and fostering emotional connection are vital for a fulfilling relationship. Our package offers guidance on building intimacy, reconnecting on a deeper level, and reigniting the spark that initially brought you together. Goal Setting and Future Planning: Together, we’ll help you and your partner identify shared goals, clarify individual aspirations, and work towards building a shared vision for the future. Our relationship coaching services provide a roadmap for aligning your ambitions and creating a fulfilling life together. By choosing our Local Relationship Counselling Services Package, you’re investing in a supportive and confidential environment where you and your partner can explore your relationship dynamics and work towards a happier, healthier future. Our commitment to personalized care, coupled with the freedom to select the most convenient office location for your sessions, ensures that you receive the best possible support for your unique relationship journey. Don’t let the challenges of maintaining a fulfilling relationship overwhelm you. Take the first step towards a more harmonious partnership by opting for our Local Relationship Counselling Services Package today. Trust in our expertise, and let us guide you towards a happier, more fulfilling relationship. 1 hour 3 sessions https://relationshipsmdd.com/product/local-relationship-counselling-services-package/

face to face training customised and bespoke. Online or Face to Face

Autocad face to face training customised and bespoke. In-person

Course Overview: The "Floristry and Principles of Design Level 4" course offers an in-depth exploration of the art of floristry and design principles. Aimed at learners seeking to deepen their understanding of floral arrangements and design techniques, this course covers everything from the fundamental design principles to advanced floristry techniques. By combining theoretical knowledge with design principles, students will gain a comprehensive understanding of floral composition, colour theory, and the essential skills required to create stunning floral displays. Learners will complete the course with a stronger foundation in floristry, equipped to apply their skills to a variety of professional settings. Course Description: This course delves into the core aspects of floristry and design principles, providing a structured learning path that covers a range of essential topics. Learners will explore the history of floristry, the principles of design, and the use of colour, texture, and form in creating floral arrangements. The course is designed to develop an appreciation for both traditional and contemporary floristry, highlighting design techniques that enhance visual appeal. Learners will also gain a deep understanding of flower care, sustainability in floristry, and how to adapt designs to different events or settings. This comprehensive course equips learners with the knowledge and expertise to succeed in the floristry industry, whether in a creative or managerial role. Course Modules: Module 01: Introduction to Floristry Module 02: Principles of Design in Floristry Module 03: Colour Theory and Floral Compositions Module 04: Flower Care and Maintenance Module 05: Event and Seasonal Floristry Module 06: Advanced Floral Design Techniques Module 07: Sustainable Practices in Floristry Module 08: Floral Design for Different Settings (See full curriculum) Who is this course for? Individuals seeking to specialise in floristry and floral design. Professionals aiming to advance their career in event management or creative industries. Beginners with an interest in the art of floristry and floral design. Aspiring florists looking to establish a career in the floral industry. Career Path Florist Floral Designer Event Coordinator Wedding Planner Retail Florist Floral Business Owner Event Designer

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored training courses: In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

The course is run over 2 days you will learn about and how to teach and assess the following key areas: Policies. Legislation. CQC The course is run over 2 days you will learn about and how to teach and assess the following key areas: Policies. Legislation. CQC Medication. Routes. Formulation. Types. Absorption. MDT. Roles and Responsibilities. Levels of support. Boundaries and agreed ways of working. Order. Receive. Store. Record. Transfer. Dispose. 7 R’s. Sources of info. Practical session including MAR charts. Risk assessments. Person Centred Care. Review. Covert. Consent. Refuse. Errors and action. Infection Control and Technique.