314 Courses in London

Overcome social awkwardness and social anxiety the fast, fun and easier way. DO YOU find yourself drying up or going blank when under pressure, or get tongue-tied when someone makes a smart remark? One of the reasons that you dry up or get tongue-tied – is because you are programmed to go into your head and try to think of something to say. Most of us have become left-brain dominant because of the way we’ve been educated and we don’t know how to activate our powerful and more creative right-brain. This is why the "I Don't Know what to Say" Improvisation Course is so effective at overcoming social difficulties. It gives you access to your spontaneous right-brain, and in fact, enables you to operate from both right and left-brain together. It is probably one of the fastest and most effective ways of building verbal confidence as well as liberating you on all sorts of levels.

This programme has a simple objective: to help a sales team create and implementa comprehensive account development plan. If you want to earn strategic partner or preferred supplier status with your clients and customers then you need to add value to their business, consistently, and you can only do this if you have a plan - a key account management plan. This programme will help participants: Discover opportunities - through a deeper understanding of the customer's business Develop partnership - through a better 'value proposition' for the customer Increase repeat business - based on higher customer satisfaction Improve synergy - by getting everyone to 'sing from the same hymn sheet' Develop a collaborative account plan - validated by the customer and their own management Secure resources - management will align resources to execute soundly based account plans Win an increased share of 'customer wallet' - through systematic account development 1 The six principles of strategic account development Introduction to the PROFIT account development model:- Performance- Relationships- Objectives and goals- Feedback- Integration- Teamwork Practical account development strategies: overview and case studies 2 Performance Use practical tools to help you manage and measure account performance and success Design and build a monthly account dashboard for all sizes of account Prioritise and manage accounts and customers pro-actively and successfully, using proven planning tools Develop a cross-selling strategy to integrate products or solutions into the customer's business as closely as possible 3 Relationships How to build and manage key relationships within an account Qualifying and managing key influencers accurately Producing a 'relationship matrix' for each account quickly and easily Approaching and developing new contacts strategically Tools and techniques for successful tracking of contacts and call-backs Developing a coach or advocate in every customer organisation pro-actively 4 Objectives and goals Where are you now? - how to establish your competitive position within an account Know how to set, monitor and track key objectives for accounts over the short, medium and long term Selling against the competition - developing both long- and short-term sales strategies 5 Feedback - building loyal and satisfied customers The correct way to manage customer expectations and create listening loops within an account How to monitor and track your customer's perception and satisfaction with your organisation Building a personalised satisfaction matrix for each account Customer review meetings - best practice in building loyalty by regular joint planning events Understanding the concept of long-term customer value and the importance of adapting a customer-focused attitude 6 Integration How to integrate your products or solutions with the customer's business needs and processes Spot and react to early warning signals that may cause an account's loyalty to fade, reduce revenue or switch to a competitor Developing a loyalty strategy for key accounts or groups of smaller accounts Getting your message and strategy across to C-level contacts 7 Teamwork Working with others to achieve your account goals Gaining internal commitment from your organisation Managing and working with a virtual team Creating cross-departmental communication loops 8 Putting it all together Personal account reviews Personal learning summary and action plans

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet 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 use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.

EA/PA Excellence Workshop Live from London on the 25th of April 2024. Featuring Keynote speaker Reggie Love, former Special Assistant to 44th President of the USA, Barrack Obama. Panel featuring Sophie Chapman, assistant to Steven Bartlett entrepreneur, author, host of the diary of a CEO and youngest ever dragon on BBC's Dragon's Den, Victoria Wratten, CEO of the Executive & Personal Assistants Association. The workshop contains, panel talk, keynote talk and facilitation over key topics from Kate Wood over the course of the day.

This course will help you to gain a better knowledge of the policy which underpins end of life care. It will help you to learn about the delivery of great end of life care and improve your communication skills to strengthen working relationships during this period. You will also feel you have a better understanding on how to support the friends and family of the person that you are caring for.

Join Dr Andrew Morrice for a deep dive into what the latest mind-body research tells us about the impact of sleep, the microbiome, nutrition, culinary practices and more on our mental and physical health, and recovery … Length: 1 day (9.30am - 4.00pm) A brilliant framework to understand the neurobiology of our needs and how to manage stressDR ALLY JAFFEE, NHS DOCTOR Why take this course Sleep and sound nutrition are widely recognised to be essential to mental health – this day gives you an opportunity to learn about these two areas in depth, including the role of the Microbiome. A greater understanding of these two areas can be vital in freeing ourselves from the ‘mind-only mindset’ to help us quickly and effectively resolve many of our difficulties in life. Sleep has always been integral to the human givens approach and this course is a chance to catch up on recent advances in understanding and evidence as to which approaches best help with poor sleep. We will explore how sleep allows for the physical recuperation, learning and emotional regulation that are key to improving many mental health problems. The role of food and the microbiome in mental health is seldom part of managing the immediate challenges we face, yet is so important in preventing difficulties, or maintaining recovery, that it is an area in which we can benefit from feeling greater confidence when guiding and advising our clients (or ourselves!). Throughout the day, tutor and GP Andrew Morrice draws on the latest research and his decades of experience managing the complex combination of mental and physical health problems in General Practice (20 of those years, using the Human Givens model), to take us on a deep dive into two of the key interfaces between mind and body: sleep and food, and their effects on our health. Andrew is a most inspiring teacher who is passionate about his subject. Furthermore, his experience as a doctor was invaluable...PSYCHOTHERAPIST / COUNSELLOR What will you learn The structure of sleep – and the functions of the different stages of sleep, including Non-REM and Slow Wave/Deep sleep The fundamental conditions required to promote healthy sleep The challenges of assessing sleep properly both for ourselves and others The complex relationships between sleep disturbances and depression, anxiety, pain syndromes and fatigue states, plus Simple organising ideas for navigating all this complexity What we can do to help resolve sleep difficulties so that we can wake feeling refreshed and emotionally prepared for the next day The fundamental science of the Microbiome – and its links to inflammation, mental health and physical health The eating patterns that worsen or help in mental and emotional health How and why processed foods undermine and confuse our innate guidance systems An understanding of the many other factors impinging on our ability to ‘forage’ well in the modern ‘food environment’ The basis on which foods or eating can become addictive, and how this can point to ways to address these difficulties Why we should consider the implications of the fasting state for our work How Human Givens tools can help clarify many of the confusions around food How to spot diet cults, tribes, and misleading claims Eating patterns we can confidently recommend to support health and wellbeing A review of how depression can be seen as a mind-body state rather than a ‘mental health disorder’ You will also have time to ask our expert tutor questions and benefit from group discussions 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 Microbiome and Diet – Finding our Food: how did this get so complicated and confusing? 10.45am Discussion over tea/coffee 11.15am Understanding Processing, Addiction and Tribalism 12.45pm Lunch (included) 1.30pm Getting a good night's sleep 2.45pm Discussion over tea/coffee 3.00pm Sleep, depression and inflammation 4.00pm Day ends Who is this course suitable for? The Mind-Body Connection In Depth series is open to anyone interested in deepening their understanding of mental and physical health. If you previously attended Andrew Morrice’s Mind-Body Connection course, and would like to spend more time on practical applications, the microbiome, the interface between diet and mental health and to thoroughly review the topic of sleep – this course is for you. Please note: you don’t need to have attended the previous Mind-Body Connection course to come on this one, or its sister course ‘Movement, Emotion and Calm’. 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 excellent Power BI covers the Query Editor and Dax Calculations in detail Online Instructor-led Classroom sessions available on request Practical, Hands-on, Interactive

– the practical skills you need High levels of anxiety can be very debilitating – this workshop gives you important insights and a wide range of proven techniques to help reduce long-term anxiety, panic attacks, GAD and much more… Accredited CPD Certificate : 6 hours Length 1 day (9.30am - 4.00pm) Jo is incredibly adept at teaching this important subject, backed up with evidence and so many useful techniques. Thank youCATHERINE, FAMILY SUPPORT WORKER What will you learn Tried and tested psychological techniques for dealing with over-anxiety Why it’s important to distinguish between two fundamental kinds of anxiety – and methods for dealing with both How to recognise panic attacks and deal with them effectively The genetic factors that make some people more vulnerable to anxiety Ways to change a poor sleep pattern caused by anxiety New perspectives on what drives anxiety – including when its basis lies in trauma Why some people may dissociate (appear to ‘tune out’ or not be present) when very stressed, and what to do about it The three different components of anxiety – and why anxiety can get out of control How anxiety affects the body – and how the body affects anxiety Why people become hypervigilant – and how this can be reduced How to separate a person from their anxiety Five effective methods for bringing down physiological arousal very quickly – and safely Why social anxiety occurs and how to handle it Tips for reducing anxiety in those with additional conditions, such as autistic spectrum disorder, ADHD, bipolar and borderline personality disorder What happens in the brain when we become anxious – insights from neuroscience How guided imagery speeds up treatment for high anxiety plus special tips for using it with clients suffering from over-anxiety How stories can complement therapy for anxiety A range of new skills and techniques for reducing severe anxiety, with plenty of opportunity to practise them yourself on the day Very useful - lots of practical new anxiety management techniquesCOUNSELLOR Why take this course More and more people’s lives are being blighted by anxiety, causing distress to all involved. The anxiety may have initially been focused on realistic, understandable concerns – such as financial difficulties, health, job insecurity or unemployment, relationship problems (particularly complex in blended families) or fears about the future in an increasingly uncertain world – but has spiralled out of control. Or it may have no clear cause and manifests as an ever-present feeling of being ‘wired’, tense or vulnerable, very often accompanied by out-of-control thoughts. The person may be hypervigilant, unable to relax and highly miserable. Left unaddressed, chronic anxiety can also badly affect sleep and physical, as well as mental, health. The good news is there’s much that we can do to reduce this suffering. This highly practical course focuses on giving you the key information and practical skills you need to lower anxiety levels and help people manage their own anxiety better. It concentrates on generalised anxiety (including generalised anxiety disorder – GAD), social anxiety and panic attacks, but also addresses how to handle anxiety that is a feature of conditions such as autistic spectrum disorder, ADHD and bipolar and borderline personality disorder. Good to know This day complements the Online Course: ‘Understanding anxiety – and managing it without drugs’ Trauma, phobias and obsessive compulsive disorders are dealt with on separate practical skills training days (see “The Rewind Technique – Effective treatment for trauma (PTSD) and phobias” and “Obsessive compulsive disorder – understanding OCD and how best to treat it.”) Course Programme The ‘How to Control Chronic Anxiety’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am Understanding the causes, indications and impacts of chronic anxiety 11.00am Discussion over tea/coffee 11.30am Approaches to help overcome difficulties with anxiety 1.00pm Lunch (included) 1.45pm Anxiety and associated conditions 3.00pm Discussion over tea/coffee 3.15pm Using guided imagery and mental rehearsal 4.00pm Day ends Who is this course suitable for? Anyone who works with or treats people who may be highly anxious – such as psychotherapists, counsellors, health and social care professionals, educators and individuals working in a variety of capacities in any number of organisations. The course will also provide valuable understanding and practical help for anyone struggling to deal with their own chronic anxiety or for those in relationships or families affected by chronic anxiety.* The day offers the chance to gain life skills of benefit to everyone. * Please Note: This course is not a substitute for individual therapy but there are lots of techniques that anyone suffering from anxiety can take away and use themselves. 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.

"Enhance your love life with our Professional Dating Coach in London. Gain confidence, master online dating, and find meaningful connections with expert guidance tailored to your needs. Start your journey to lasting love today!