297 Courses in London

If you're looking for a short, sharp high-impact intervention that will help motivate and inspire your sales team then a 'bite-sized' session could be just what you're looking for. We have a range of sessions that can be delivered on an 'off-the-shelf' basis, or they can be tailored to your specific requirements or, of course, we can develop something specifically for you on an entirely bespoke basis. And the length of the session is entirely up to you - 45-minutes, an hour, a half-day - whatever you prefer. Sessions can be run for small groups as part of your regular team meetings or they can be delivered for larger audiences, conference-style - the choice is yours. The session outlines below are just to give you an idea of the possibilities. If one of them whets your appetite please just give us a call on 01582 463463 to talk through what we can do for you - we're here to help!

Discover effective new ways to: find out what the problem is, communicate with reluctant teens, discover their hidden strengths, promote positive behaviour change, improve their mental health – and much more… Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm GMT) The best live online I have attended so far and I’ve done eight! Everything was relevant – completely spot onTEACHER / TUTOR Live Online – Join Richard Brook on Tuesday 19th March for this live online training event via Zoom. Simply book your place and we will email you details of how to join the Zoom workshop the day before. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Why take this course This live online training event gives you the essential knowledge, tips and practical skills you need to help troubled teenagers unlock their potential and begin to build lives for themselves that work well. Tutor Richard Brook has a wealth of hands-on practical experience in adolescent mental health and social work which he draws on throughout the day – you will have plenty of time to ask questions and discuss how you can implement the skills and techniques in your own work or with the teens you care for.   The programme is varied and intensive, yet lively with a strong focus on gaining skills. It clarifies what healthy teenage development looks like, why things can go wrong and the best ways to help young people overcome obstacles and begin to create lives for themselves that work well. Richard also shows how, by working with the ‘givens’ of human nature, and ensuring that sound knowledge of how people really function is applied intelligently to teenagers, you can speed up progress, reduce anti-social behaviour and teen depression, and bring young people real benefits. At the end of the day you will find yourself more empowered to respond effectively to each individual’s needs and temperament, whilst avoiding yourself the emotional pitfalls of working in stressful situations. Such a realistic and logical approach – it's given me lots of ideas for working with a variety of people, not just teenagers!PROBATION OFFICER What will you learn An increased understanding of what drives most problematic behaviour, including anti-social behaviour Essential knowledge and skills to deliver effective interventions to young people, both individually and in groups A deeper understanding of the causes of adolescent mental health problems Simple yet effective techniques for engaging uncommunicative young people, building rapport and promoting behavioural changes Constructive ways to help prevent teenage depression, anxiety and stress Four vital guiding principles that ensure your work with young people is relevant and effective Ways to motivate young people and help them set achievable goals How to discover and build upon a young person’s strengths and engage them in practical problem-solving Knowledge of how the insights from the human givens approach can dramatically improve interventions and their outcomes The opportunity to discuss how you could implement these in your own work with a highly knowledgeable tutor who has years of hands-on experience Also covered: The common misconceptions about adolescence What healthy teenage development looks like – this may bring you some surprises! A clear and logical foundation upon which to structure creative and effective interventions Ways to respond effectively to each individual’s needs, temperament and learning style How to avoid the emotional pitfalls of working in stressful situations An expanded repertoire of skills and a refined understanding of what works and – most importantly – why Course Programme The ‘How to help troubled and troublesome teenagers’ course starts at 9.15am and runs until 4.00pm. 9.15am Join the Zoom meeting 9.30am What’s the trouble? 11.00am Comfort break and discussion 11.30am How to communicate with teenagers 1.00pm Lunch break 1.45pm Practical problem solving 2.45pm Comfort break and discussion 3.00pm How to help them create a life that works well 4.00pm Day ends This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

A high-impact programme designed to be fun and to get people fully involved. The first-class, jargon-free content is based on what people need to know in practice, not off-putting legal language. This introductory course covers: Introducing Working Safely: Accidents can happen to anyone. The realities of the human suffering behind the statistics. The importance of personal responsibility. Defining hazard and risk: Focusing on the six broad hazard groups, participants are asked to think about the hazards and risks they come across in their own work. 'Risk assessment' demystified. Identifying common hazards: All the main issues - aggression and violence, asbestos, bullying, chemicals and harmful substances, computer workstations, confined spaces, drugs and alcohol, electricity, fire, getting in and out, height, housekeeping, lighting, manual handling, noise, personal hygiene, plant and machinery, slips and trips, stress, temperature, vehicles and transport, and welfare facilities. Improving safety performance: Bridging the gap between management and workforce, encouraging participants to play their part. Also covered: contract work, inspections, safe systems and permits, protective equipment, signage, emergency procedures, reporting and health checks.

This course enables providers and their staff to develop an understanding of the responsibilities and duties around the Mental Capacity Act 2005 (MCA). This essential training is for workers involved in the care, treatment and support of adults who may lack capacity in making life decisions. This training offers vital support for social care providers, so they comply with the Mental Capacity Act and Care Quality Commission requirements and promote human rights.

Belonging & Connection

I offer private immersive sound journey & gong bath sessions for groups of up to 19 people. These can be completely tailored to your specific requirements.   We can work with a theme of your choice, or I am happy to make helpful suggestions. Popular themes tend to be complete relaxation sessions, stress relief, recharge & re-energizing, and events around the time of a new moon (perfect for setting new intentions) or a full moon (a great opportunity to let go of things that no longer serve us). I have two beautiful venues that I regularly use in Bournemouth and in Southbourne. I often use these for private group sessions and provide everything that is needed for you and your friends to enjoy a magical sound and vibration journey like no other. For all enquiries, please contact me.

Early Years Room Leader Training.

This course is suited to those who are involved in the planning, provision, and assistance of meals for those in care. It provides a solid insight into the basics of good nutrition as well as providing practical guidance for how to put these into practice within a care setting. Learners will also look briefly at Food Hygiene. This subject forms standard 8 in The Care Certificate.

This course is aimed at anyone working in the Care Sector to improve awareness and knowledge of dignity and how workers can help protect it. Learners will understand their roles and responsibilities, a clear understanding of the 7 principles of dignity, and show an increased understanding of best practice for communicating with service users. Explore how dignity starts at the very top of the organisation with the manager and owner taking responsibility for ensuring their staff provide a dignified service. It will describe how care staff provide and the way they provide it, are the standard by which service users will measure whether they have been treated with dignity and respect.