93 Numbers courses in London

Discover the highly effective psychological techniques that are helping people overcome all kinds of addictions and compulsive behaviours… Accredited CPD Certificate : 6 hours Length 1 day (9.30am - 4.00pm) Hugely informative - one of the best addiction training daysADDICTIONS COUNSELLOR NEXT available date: Tuesday 27th February, London – join Emily Gajewski for this popular addiction recovery training workshop – to ensure your place, book online now or call our friendly team on 01323 811690. Other dates and venues available. When combined with key insights into the addictive process and what drives it, the techniques covered on this day prove effective at helping people successfully quit a wide range of addictions. They also help to reduce withdrawal symptoms, minimise relapses and give people the best chance at effective, long-lasting recovery… What will you learn New insights into the addictive process and why people become addicted Common traps to avoid when treating addictions A range of psychological techniques for overcoming addiction How to develop a treatment plan and deepen a client’s commitment to change Ways to overcome resistance – and prevent relapses Also covered: Demonstrations – by a leading expert in addiction counselling – of the powerful skills that help to quickly break the patterns of addictive behaviour Guidance and practise in using some of these yourself How to break the cycle of shame involved in addictions, using self-compassion and generation of hope Essential motivational interviewing techniques – and how to incorporate them into the ‘cycle of change’ Up-to-date knowledge of the most useful ways to beat a wide variety of addictions – and prevent relapse Increased understanding of the addictive trance and its false promises How to use harm-reduction techniques Why the social-based model of addiction is more helpful than the disease-based model An understanding of the importance of guided imagery in overcoming addictions and substance abuse (particularly ‘counter-conditioning’ which is taught on Guided Imagery 2: additional techniques) Co-morbid conditions – the link with addiction and how to deal with them as effectively and quickly as possible A total revelation – very upliftingMENTAL HEALTH WORKER Why take this course The numbers of people affected by addictions and substance abuse continue to rise – causing immense mental, physical and financial suffering to individuals, their families and colleagues – while the resources to help are dwindling. But thankfully it is possible to help most addicts transform their lives – often in only a few sessions – as you will discover on this practical day which draws together, from various schools of solution-focused therapy, the most effective and proven techniques for treating addictions (including motivational interviewing and self compassion techniques) with essential neuroscientific insights into the addictive process to create powerful interventions. You will leave the day with renewed confidence knowing how it is possible to help most people with addictions, enabling them to transform their lives, often in a small number of sessions. The skills covered are essential to have (along with guided imagery) if you wish to improve your effectiveness when helping people quit any addiction, including: alcohol addiction, smoking, gambling addiction, shopping, social media addiction, sex, substance abuse, self-harm and eating disorders. Please note You will leave this workshop with essential information and a variety of skills that you can implement straight away. However, the key concepts and most effective ways of treating addictions, which you will see demonstrated and explained, incorporate guided imagery skills. We therefore recommend, if you aren’t proficient in these already, that you attend the Guided imagery and visualisation for therapeutic change workshop (either before or after this one). The counter-conditioning technique that you will see demonstrated and explained on ‘Stopping Addictions’, is taught in detail and practiced by workshop participants on Guided Imagery Day 2: additional techniques. ‘Stopping Addictions’ complements our online course Tackling Addiction and what you will learn on it will also be very useful if you support or work with people who self-harm. Course Programme The ‘Stopping Addictions: effective treatment and recovery’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am How and why people develop addictions 11.00am Discussion over tea/coffee 11.30am Dealing with resistance 1.00pm Lunch (included) 1.45pm How to create the optimal environment for positive change 2.45pm Discussion over tea/coffee 3.00pm Utilising the imagination 4.00pm Day ends Who is this course suitable for? All members of the caring professions, including: psychotherapists, addiction counsellors, drug workers, youth workers, nurses and detox support specialists, doctors, sober companions and drug and alcohol workers, therapists, vocational counselors, clinical psychologists, occupational therapists, psychiatrists, cognitive behavioural therapists, teachers and education professionals, social workers, supervisors, physiotherapists, support workers and anyone wishing to improve their understanding of addictive behaviour and how to treat it. 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.

Severe allergic reactions (anaphylaxis) can kill without immediate first aid. The UK is one of the top countries in the world for incidence of allergies. This course covers the management of anaphylaxis and the use of auto-injectors for the initial treatment of anaphylaxis.

Discover practical ways you can help using the core skills and concepts of human givens therapy – early intervention and ‘treating the whole person’ can be crucial… Accredited CPD: 6 hours Length: 1 day (9.30am - 4.00pm) Excellent trainer, very engaging, invaluable insights and knowledge This new course for HG therapists builds on the online Understanding Eating Difficulties introductory webinar. It will deepen your understanding of working with clients experiencing eating difficulties and give you practical guidance on the most appropriate ways to support them, whether they have an official diagnosis or not. You will leave the workshop with a much better understanding of how to apply the skills and concepts encompassed in human givens therapy in this area. Jo Baker has a wealth of experience in this area; she has previously worked as a volunteer for BEAT and other local eating disorder charities and helped people with eating difficulties in both private practice and university settings. NEXT DATE:  This course is part of our new range of recommended CPD for HG therapists. We don’t currently have another date for it, if you are interested in attending please register here so we can let you know when one becomes available. Why take this course The numbers of people experiencing eating difficulties are hitting an all time high – in the UK, 1.25 million people are estimated to have a diagnosable eating disorder¹ with hospital admissions more than doubling from 10,318 to 22,000 in the four years between 2016 and 2020². The early stages (or ‘subthreshold’ stages i.e. when symptoms do not meet full diagnostic criteria for an eating disorder as defined by the DSM-5 or the ICD-11) have been identified as a critical period for preventing progression of an eating disorder³. However, stigma directed towards those experiencing eating difficulties that aren’t believed to be ‘serious enough’ to warrant support⁴ can present a barrier to seeking help. With its deliberate use of non-clinical language Jo Baker’s new workshop for HG therapists considers all difficulties around eating worthy of help, understanding and support, irrespective of whether or not these difficulties have been diagnosed or meet the criteria for a diagnosable eating disorder. In this regard, the human givens approach takes a step forward towards early intervention, and treating the whole person. As well as having been a practising Human Givens therapist for 12 years, and teaching the HG Diploma, Jo has previously worked as a volunteer for BEAT and other local eating disorder charities and brings to the day a wealth of practical experience of working with eating difficulties both in private practice and in university settings. What will you learn The nuance of language – how to avoid causing unintentional distress The causes of most eating disorders and difficulties Creating space for the client’s story How to help your client identify and challenge destructive thought processes Therapeutic tools to get to the root of the problem – we look at which techniques can be useful, and what to be careful of The barriers created by clinical language and diagnostic criteria Diversity in eating difficulties – a greater understanding of the impact of cultural and contextual factors around eating How to help your client meet their needs and use their resources in a healthy way Eating difficulties and neurodiversity An increased awareness of complicating conditions – such as alcohol / substance abuse and medical conditions The important role of sleep in recovery Accessing resources and helping the individual to develop a nurturing self Ethical practice Understanding the boundaries of your role and your own limitations And more… Course Programme The ‘The Mind-Body Connection in depth: Movement, Emotion and Calm’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am Eating difficulties: an overview 11.00am Discussion over tea/coffee 11.30am Understanding and resolving difficulties 1.00pm Lunch (included) 1.45pm Group discussion – questions from the day so far 3.00pm Discussion over tea/coffee 3.15pm Bringing it all together 4.00pm Day ends Who is this course suitable for? This course is for experienced, qualified HG therapists and counsellors who would like to understand more about eating difficulties, eating disorders and the different ways they can affect people. It is an invitation to recognise that all experiences of eating difficulties are equally valid and worthy of care and support. It is hoped that the learner develops further depth and breadth to their understanding and feels an increased confidence to support clients with eating difficulties however they present. The course combines trainer input, discussion and small group activities. All training is limited by time constraints and whilst we have done our utmost to include a diversity of perspectives there will inevitably be topics that have not been covered. This course is an invitation to recognise that all experiences of eating difficulties are equally valid and worthy of care and support. It is hoped that the learner develops further depth and breadth to their understanding and feels an increased confidence to support clients with eating difficulties however they present. 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.

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

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs. This course will help participants: Create, manage and save documents, files and folders Create paragraph lists, bulleted and numbered paragraphs Edit, modify and format paragraphs Create and format tables Use shortcuts to navigate documents Format the layout of documents Manage page headers and footers Insert and managing pictures and diagrams within a document Learn time saving tips and tricks to obtain a professional finish to documents Use printing options 1 Creating documents Getting help Creating and saving documents Accessing recently used documents Managing files and folders 2 Entering and editing text Inserting and editing paragraph text Cutting, copying and pasting text Using tool tips to manage content Applying and removing text formatting Correcting spelling and grammar 3 Creating paragraph lists Creating bulleted paragraphs Creating numbered paragraphs Managing bulleted and numbered lists 4 Modifying paragraphs Changing paragraph alignment Indenting a paragraph Adding borders and shading to paragraphs Formatting paragraphs using styles 5 Navigating documents Using shortcuts for navigating documents Using 'Go To' to navigate documents Finding and replacing text Changing to read view 6 Document layout Inserting page breaks Changing page orientation Adjusting page margins Adding borders to pages 7 Page headers and footers Inserting page headers and footers Using header and footer commands Inserting page numbers Using different first page 8 Inserting pictures and diagrams Inserting pictures from your computer Inserting online pictures Flowing text around a picture Changing a picture Inserting SmartArt diagrams Entering text into SmartArt 9 Inserting tables Using tabs to create tables Resizing and repositioning tables Inserting and deleting rows and columns Using a table's commands Changing a tables text direction Formatting tables 10 Printing documents Previewing and printing documents Using the printing tools Printing parts of a document

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

– in yourself and others Research shows that exercising self-compassion creates more resilience against stress, greater ability to focus, increases happiness and optimism, improves relationships and more. This live online course explains why and gives you a range of effective techniques you can use straight away…  Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm BST) Absolutely brilliant live workshop from beginning to end!CARMEL AUSTIN Many people struggle with showing themselves compassion – they may be highly critical of themselves, or wracked with feelings of shame, self-doubt or self-worth – but with the right approach it is possible to help them develop this key component of recovery and wellbeing. This new online self-compassion course provides you with all you need to know to bring self-compassion into your practice, your personal life and the lives of others – with plenty of time to try out the techniques for yourself. Join our expert tutor Julie Johnson live online on Tuesday 4th June 2024 for this helpful CPD training delivered via Zoom. When you book, we’ll email your booking confirmation – your link for joining the Zoom workshop will be sent the day before the event – numbers are limited so book soon to ensure your place. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties, so you’ll also get a recording afterwards for a limited time to maximise your learning. Why take this course Being compassionate towards ourselves when things go wrong, or we are struggling to cope, is not self-pity – it is an essential skill that can be learnt and developed, giving people the strength to move forward. When things don’t go our way or we feel we can’t cope – or something bad has happened to us – we may feel ashamed or blame ourselves for not being good enough, capable enough, strong enough and so on. This negative self-criticism can be highly damaging and hold us back. It is far more empowering to turn towards ourselves with compassion (which is what self-compassion literally means). Helping people to find the best ways to draw out their self-compassion is a skill that needs to be learned. Different from empathy (the ability to appreciate what another person is experiencing) and from self-pity (which is self-focused, exaggerates personal suffering and is disempowering and draining), self-compassion enhances resilience, allowing us to recognise our personal failings while appreciating that we are all human and make mistakes – thus helping us to move on past them. Learning how to use self-compassion from a human givens perspective makes it an extra-valuable tool for supporting our clients in getting their innate needs met and making best use of their innate resources. It may also help you in your own life. This indepth 1-day live online self-compassion experiential training day shows you how. A wonderful online learning experience, jam-packed full of useful teaching and loads of references to resources for further self study and development...KARSTEN ALVA-JORGENSEN, EXECUTIVE COACH What will you learn What self-compassion is and isn’t Research findings that demonstrate the positive effects on the body and mind of exercising self-compassion Why some people find self-compassion difficult The roots of self-compassion A new empowering perspective on making mistakes How practising self-compassion helps our ability to problem solve An important adjunctive tool for working with harsh self-criticism, trauma, emotional pain; bereavement, loss, change, and chronic-conditions Why self-compassion increases resilience Simple techniques for self-soothing and self-care How to apply these new understandings in therapy The especial value of using these techniques with parents and children How to bring these technique seamlessly into everyday life Ways that self-compassion helps with meeting emotional needs The impact of self-compassionate practice on organisations How self-compassion can help children become happier and kinder Why compassion for oneself enhances sense of status Ways that exercising self-compassion lowers emotional arousal and unhelpful thinking How self-compassion differs from both compassion and empathy The dangers of too much self-compassion How self-compassion helps focus the imagination positively Creative applications of self-compassion How self-compassion maps onto every human need and innate emotional resource, making it an essential tool in every HG practitioner’s toolbox Practical examples and case histories to learn from Who is this course suitable for? Anyone interested for personal or professional reasons Including anyone working as a practitioner helping those in mental distress or with chronic physical conditions Anyone interested in skills to help promote their own wellbeing and that of others Anyone working or living with children, or young and older people Anyone working with parents Anyone working within a caring context, such as carers, teachers, NHS workers, foster carers, social workers etc Therapists, counsellors and mental health professionals Course Programme The ‘Developing Self-Compassion’ live online training day starts at 9.15am and runs until 4.00pm. (BST). 9.15am Join the Zoom meeting 9.00am Introduction to self-compassion 11.00am Comfort break and discussion 11.30am Unpacking self-compassion 1.00pm Lunch break 1.45pm Self-compassion skills 2.45pm Comfort break and discussion 3.00pm Pulling it all together 4.00pm End days 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.