5278 Courses in Cardiff delivered Live Online

In this course we explore how we have attempted to build inclusive circles of support around individuals and contrast this with a radical approach to problem solving with parents – the Parent Solutions Circle. Parent Solutions is a brand new approach to problem solving with parents based on our live group work in schools. A focus on challenging behaviour brings interest, energy and commitment.  Course Category Inclusion Peer Support Parents and Carers Behaviour and relationships Description In this course we explore how we have attempted to build inclusive circles of support around individuals and contrast this with a radical approach to problem solving with parents – the Parent Solutions Circle Parent Solutions is a brand new approach to problem solving with parents based on our live group work in schools. A focus on challenging behaviour brings interest, energy and commitment. Essentially the approach involves gathering a group of parents and carers together who recognise how challenging their own children are and would like some help to figure out how to be with them or how to manage an aspect of their behaviour. The process is facilitated but majors on the parents offering each other their wisdom and ideas. The directness that only peers can provide to each other makes the work both powerful and effective. Mobilising the wisdom and experiences of parents in a safe way is a delicate art. In this training we will explore how this can best be done. Parents who have been on all the courses and had all the professional advice in world love this way of working because they get to offer each other their experience, ideas and wisdom. The approach is capacity focused, person centred approach to working with parents rather than the dominant deficit oriented and ‘medical model’ of viewing and planning for parents. We work with rather than do things to a group of parents. This training can be modelled with a group of parents or can be demonstrated with a group of professionals. We prefer mixed groups. Learning Objectives For participants to learn how to set up a Parent Solutions Circle For participants to understand the underlying rationale and ethos of this way of working To learn the facilitation process and stages of the Circle process Who Is It For? Anyone interested in working with parents and carers in a way that builds and makes use of their capacities rather than focus on their challenges and difficulties. School leaders and managers Social Care teams Community organisers Psychologists Course Content True parent empowerment Facilitating groups Problem solving process Handling group communication Allowing direct feedback and challenge between participants in a safe way Building relationships Creating natural circles of support that can provide peer support and mutual problem solving If you liked this course you may well like: Creating Community Circles

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

This training is aimed at developing Person Centred Planning – for Local Authority, School or Multi Academy Trust professional teams. Parents and carers can also participate in this training. One day introduction to underlying values and practicalities of approach in schools – 100 people 2 Day skill training for 30 participants to learn PATH planning skills 1 day follow up after 3 months to problem solve issues and celebrate what achieved. Person Centred Planning (PCP) is a way of expressing a set of inclusive values through a unique range of tools and techniques. The most commonly used person centred tool with children is a PATH – and it shows these values in action. Why now? The Children and Families Act 2014 sets out clear principles for supporting and involving children and young people in all aspects of the support and planning of their special educational need. The Special Educational Needs and Disability Code of Practice: 0 – 25 years provides the statutory guidance relating to part 3 of the Children and Families Act 2014. Embedded in its principles is the need for a stronger focus on the participation of children, young people and their parents/carers in decision making at both individual and strategic levels. The use of Person Centred Approaches provides the opportunity to fulfil those principles. Working in this way ensures the CYP and their parents/carers are at the centre of all decision making and future planning. It provides an opportunity to engage directly with children and young people to discuss their needs, and plan how they can achieve the best possible outcomes. This should be integral to all planning for children and young people with Special Educational Need and Disability (SEND) throughout their lives. Education Health Care Planning processes are required to be truly person centred at every stage, including annual reviews, so understanding this way of working has never been more essential. Is this different to what we do already? This person-centred way of working offers a radical new approach to visualising planning, empowering and directly involving children and those that care about them throughout planning meetings and allowing for inclusive, creative methodology which builds on and challenges existing practice in schools. Core principles The focus of inclusive, person-centred working is first and foremost on ordinary needs and not solely on special needs. – Being somebody – Contributing by sharing gifts and capacities – Knowing people and having relationships – Having choice and control – Sharing ordinary places – being present in local spaces and having a valued role there The training is delivered by Inclusive Solutions who are Educational Psychologists with a national reputation for training and person centred planning with schools over the last 16 years. In this training, you will learn how to facilitate with a child, family, team or an organisation to think together around their preferred future or about a challenge or issue. Here is an opportunity to experience first-hand the person centred, futures planning tool – PATH (Pearpoint, Forest et. al. 1989). This course will provide participants with a practical introduction to person centred planning and approaches, including examples of best practice in using person centred approaches in schools. The course will explore the underlying values of person centred approaches, provide an introduction to the person centred planning tools and link this to national policy and guidance. Participants will gain: 1 Knowledge of person centred planning and approaches 2 An understanding of how person centred approaches can be used in schools 3 A basic knowledge of the person centred review process and where to find out more information 4 The skills to gather information about what is important to and for the children and young people they support 5 An understanding of PATH and situations in which this process could be used in school The course answers these questions: • What are person centred approaches? • How can we use person centred approaches in our school? • What is person centred thinking and how can it be used in schools? • How can we learn about what is important to and for the child or young person and share this information? • How can we make sure that the child is at the centre of their annual/transition review?

Person centred rehabilitation is designed to create a better life for an individual by the provision of an intense input designed to being about social change. This usually entails a series of visits focused on getting the person out and about to increase confidence, social skills and presence in their local community and to pursue goals and dreams. Usually, the work is carried out under the close clinical supervision of a practicing psychologist. Course Category Inclusion Person Centred Planning Visioning and Problem Solving Peer Support Description Person Centred Rehabilitation Person centred rehabilitation is designed to create a better life for an individual by the provision of an intense input designed to being about social change. This usually entails a series of visits focused on getting the person out and about to increase confidence, social skills and presence in their local community and to pursue goals and dreams. Usually, the work is carried out under the close clinical supervision of a practicing psychologist. PERSON CENTRED PLANNING A Person Centred Planning event would be carried out using the PATH or MAP process – majoring on dreams and goal setting leading to precise action planning. Facilitators would carry out the PATH or other person centred process. A large graphic will be one of the outcomes of the meetings this is a great visual record and a shared memory of the event. This will also inform the priorities for the later follow up inclusion facilitation work. Following the PATH event a ‘scoping report’ is created outlining what Inclusion Facilitation could offer and highlighting what dreams and goals the individual has. INCLUSION FACILITATION The PATH is also provides a good opportunity for the Facilitator to meet the focus person in a comfortable positive environment. Agreed visits from the Inclusion Facilitator are then carried out over a 3 month period. After this intensive input the Inclusion Facilitator will hand over to the existing family, carers and PA team to carry on where he or she has left off. This transition time is planned from the outset. An experienced psychologist needs to be there to support the facilitator at all times and will guide all work done by the inclusion facilitator. Is this just Support work? No! This is proactive engagement – doing whatever is required. This is not passively or reactively providing what is asked for – we are actively pursuing a good life for the individual. The work is built on careful research around a person’s interests and what opportunities exist locally There is community mapping There is work to tackle an individual’s own resistance and reluctance to engage more socially There is a need to engage with people in social settings that the individual attends to build bridges and connections – we are bridge builders You will need to build circles around a person There is a need to create the conditions in which friendships can flourish There is a need for direct psychological supervision and support throughout This work is short term and intense. The facilitator’s main aims will vary depending on the dreams and goals of the focus person. The basic aim of the inclusion facilitator is to better the focus person’s quality of life. Learning Objectives 1 To create a better life for the Individual. 2 Give Individual and family a clear vision of a good life and to support first steps towards this 3 To maximise individuals inclusion and connection with the wider community. 4 To help with friendship, social connection and education 5 To increase confidence, social skills and presence in their local community and to pursue goals and dreams. Who Is It For? Anyone who is involved in the rehabilitation of children or adults who have become disabled through accident or trauma and who is committed to helping them get their life back on track. Course Content Understanding ordinary needs – the dimensions of social inclusion Pursuing the dreams and goals of the individual Improving social skills Community Mapping Being comfortable in social environments Developing conversational skills Having a positive mindset Staying physically active Building relationships Help in meeting new people Create natural circles of support Creating a community circle Having positive body language Employment of support staff Pursuing personal interests   If you like this you will almost certainly enjoy: Person Centred Planning using PATH and MAPs

Relationship coaching for your relationship skills can be done individually or as a couple Emotional intelligence training Learn how to be a strong couple Love Language training Learn how to improve rapport and empathy Emotional validation and emotional civility training Consideration and patience training Conflict Resolution and self management Free check in calls in between sessions Choose one of our office locations to have your sessions 1 hour per week 3 sessions https://relationshipsmdd.com/product/relationship-coach-london-package/

Overview This 2 day course provides a practical introduction to Interest Rate Derivatives, equipping participants with the skills to price, trade, and manage risk across financial markets. Participants will explore key pricing concepts like bootstrapping, zero-coupon curves, and forward curves, while developing risk management techniques to navigate various market scenarios. The course also covers using derivatives to express macroeconomic views, bridging theory with real-world applications. By the end, participants will have the tools and insight to confidently engage with Interest Rate Derivatives in professional settings Learning Objectives Understand how to use Interest Rate Derivatives in different roles Grasp major pricing concepts like bootstrapping, zero-coupon curve, forward curve Develop risk management techniques to manage multiple scenarios Express Macro views using derivatives Who the course is for Anyone seeking practical insights into interest rate derivatives which include: Bank traders, market makers, sales, structurers, market risk Portfolio managers, execution traders Corporate treasurers, private bankers Operations, mid and back office personnel, brokers Graduate students and aspiring professionals aiming for careers in financial markets Course Content To learn more about the day by day course content please click here To you are interested in speaking with a course specialist, you can book a meeting here

Higher Education Women's Leadership Workshop is for academics looking to learn new skills with like-minded academics and further or advance their academic career.

Historical Association webinar series: Making GCSE history accessible: supporting all learners at Key Stage 4 Presenters: Gemma Hargraves  This session explores some of the hidden barriers faced by neurodivergent pupils in the history classroom, including anxiety and low self-confidence. It offers practical strategies to create an inclusive and supportive environment that enables all learners to engage meaningfully with historical learning. Key topics: • Recognising common anxiety triggers in history education • Building learner confidence through inclusive pedagogical approaches • Understanding and responding to the needs of neurodivergent pupils in GCSE history To use your corporate recording offer on this webinar please fill in this form: https://forms.office.com/e/bdNUSwLNrL Image: A Squire "Old English" padlock on a gate latch in Devon (Image: Partonez/Wikimedia Commons)

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS Introduction to Data Science Create and Modify Tables Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL Visualize Data with Charts Modify and Format Charts Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS Analyze Data with Formulas and Named Ranges Analyze Data with Functions Implement Data Validation, Forms, and Controls Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES Create a PivotTable Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL Visualize Data with PivotCharts Filter Data Using Slicers and Timelines Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL Create Map Charts in Excel Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS Visualize Trendlines and Sparklines with Excel Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA Connect to Data with Queries Clean and Combine Data Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT Install Power Pivot in Excel Create Data Models with Power Pivot Create Power Pivots Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) Plan a Report Create a Report

NEBDN Certificate in Dental Radiography for Qualified Dental Nurses