Pivot tables are really very easy to create, but very powerful. By using Excel pivot tables, one can get very interesting and valuable business intelligence from your data in very little time. This short session aims to give you the techniques to use this valuable Excel tool creatively. It is enough time to learn a lot about Excel Pivot Tables, but there is very little time for other questions.
Maximise your potential with bespoke individual development
dvanced Course This MS Project Advanced course is an intensive, hands-on, one-day training course, concentrating on complex calendars, complex costs, multiple baselines, multiple projects and other advanced MS Project features. This is a one day course, one a one-to-one basis, attending to individual questions and issues. Group bookings could be requested
Java Threads Course Duration: 1 Day Who would find this course useful? Java coders Level: Not quite basics level. It specifically concentrates on Threads Principles (Threads) in Java. Download: Download Java JDK and Eclipse IDE. For classroom courses: Bring your own device. Java Threads Course description General Threads Concepts Java Threads Course Description General Threads Concepts Multithreading Cycle of a Thread Create a Thread by Implementing a Runnable Interface Create a Thread by Extending a Thread Class Major thread operations Processes and Threads, Thread Objects Thread Methods getName, getId, setName, etc Pausing Execution with Sleep Interrupts, Joins Thread Priorities Thread Pools Executors, Executor Interfaces, Thread Pools, Fork/Join Synchronozation What is thread synchronization? Thread Interference, Memory Consistency Errors, Synchronized Methods, Lock Objects, Intrinsic Locks and Synchronization, Handling interthread communication, Handling thread deadlock, Liveness, Starvation and Livelock, Atomic Access. Concurrent Collections Guarded Blocks, Immutable Objects. Strategy for Defining Immutable Objects, High Level Concurrency Objects, Java Threads Course, 1 Day What is included PCWorkshops Course Certificate on completion Java Threads Course Notes Java Threads Code Examples Practical exercises, Java Course Revision work After the course: 1-Hour personalised online revision session About us Our experienced trainers are award winners. More about us FAQ's Client Comments
A masterclass in devising therapeutic metaphors This inspiring online training day gives you powerful, non-intrusive ways to help distressed young people – and others – overcome difficulties in their lives – the skills you will learn can also be used with adults Accredited CPD: 6 hours Length: 1 day (9.15am - 4.00pm GMT) LIVE ONLINE – Join Pamela Woodford live online on Tuesday 18th June 2024 for this enjoyable, experiential CPD accredited training day – you will have plenty of opportunities to ask questions, take part in exercises to practice the steps involved, come up with pertinent metaphors and create your own story. Limited numbers. BONUS RECORDING – you will also get a recording of the tutor sessions for a limited time afterwards to maximise your learning. >> If you can’t make this date please register your interest below and we’ll let you know as soon as a new date is available. Fantastic online training, engaging and thought-provoking throughout. The confidence Pamela has given me will impact positively on my everyday practice, I am truly inspired...PSYCHOTHERAPIST Why take this course Children’s natural affinity with stories gives us an incredibly powerful, non-directive way to help emotionally distressed and abused young people, who can sometimes be hard to reach in any other way. On this practical live training event you will learn how to tap into your own metaphorical brain to create therapeutic stories and metaphors ‘in the moment’ that are appropriate to each individual’s circumstances and experiences. Throughout the day Pamela – a master storyteller and highly experienced psychotherapist – draws on her own case histories, metaphor and story examples as she guides you through the steps involved in ‘thinking on your feet’ and creating a story yourself in the moment. By the end of the day you will have lots of new, innovative ways to engage with and help distressed children deal with the experiences they have had – whilst also offering them hope, understanding, and new ways of thinking and feeling about life and themselves. Indeed, you may well be surprised at how quickly positive psychological changes occur as a result of the stories you will create and tell ‘in the moment’. Stories also play a crucial role in child development – through the ways the different characters think, act and overcome difficulties, children gain important templates for understanding the world and dealing with the challenges and situations they will meet in life – both now and in the future. They are a wonderful way to help build resilience. Storytelling and the careful use of therapeutic metaphor are crucial elements of successful counselling and psychotherapy – they help bypass assumptions and rigid thinking to offer a new, broader way of looking at things, awaken innate resources and offer crucial hope – just what struggling children need… Wonderful, interactive online course. Pamela is a joy to listen to – I learnt so muchCOUNSELLOR What will you learn A clear understanding of how to address emotional issues in children Simple ways to calm and relax children – “it’s the way you tell ‘em” Tips for igniting your own imagination and creativity How to ‘think metaphor’ to find the right one for each situation A step-by-step guide to creating your own stories – the 6 steps for creating short stories with metaphors specifically tailored to quickly bring about positive psychological changes in children and young people Breathing life into inanimate objects and taking inspiration from nature – how to tune into your metaphorical mind Valuable experience in creating your own therapeutic story from scratch How to use your stories and metaphors The importance of paying attention to the words children use when telling you something Case histories which illustrate the effectiveness and flexibility of stories – and show why they are such powerful therapeutic tools, even with difficult cases How to find your own metaphors and connect them emotionally to distressing situations Using embedded suggestions in stories – exercise Different ways to use therapeutic stories, such as those in Pamela’s acclaimed Brighter Little Minds series, to develop emotional literacy The importance of incorporating all of our senses How to adapt stories to use with adolescents and adults Tips for thinking creatively ‘on your feet’ to come up with suitable metaphors and ideas there and then in the moment Flexible skills that can easily be adapted to working with adults Why subtly entwining a child’s interests into a story makes its impact stronger How to introduce a story or therapeutic metaphor naturally into your conversation Feedback on the story you create and time to ask questions of the tutor – a highly experienced and creative psychotherapist who has spent decades working therapeutically with distressed children and young people A greater appreciation of the subtle power of metaphor, imagination and embedded suggestions and how to use them to help the young people you care for Increased confidence in creating and telling therapeutic stories yourself A variety of story examples and ‘scripts’ Lots of new ideas from Pamela Woodford’s ‘treasure chest of healing spells’ to spark your own creativity Tips for improving your own storytelling abilities Such a helpful live online training day – the use of metaphor via story form is a powerful toolHEAD OF BEHAVIOUR SUPPORT SERVICE – EDUCATION Course Programme The ‘How to create healing stories for distressed children’ live online workshop starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am What can go wrong for children? How stories can help 11.00am Comfort break and discussion 11.10am Using metaphor, relaxation, imagination and embedded suggestions 1.00pm Lunch break 1.40pm Setting the scene and creating the story 3.10pm Comfort break and discussion 3.20pm Sharing the stories you have created 4.00pm Day ends Who is this course suitable for? Anyone working with emotionally distressed children or young people, including: Psychotherapists, therapists and counsellors Teachers and educational professionals Childcare and healthcare professionals (and students) Foster carers Adoptive parents – and perspective adoptive parents Social workers Parents and carers Interested friends or family who wish to help a young person they know And anyone who would like to attend for personal reasons 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 MS Access Advanced Course mostly covers creating advanced MS Access reports, forms, and macros. Create and amend Advanced Forms and Advanced Reports. Macro buttons. This assists you to build user-friendly forms to facilitate effective navigation, effective data capture and effective viewing and querying data This course will help you to structure MS Access tables, import, and manage your data effectively.
Come join us for a fun day of dancing and nature walking in Happy Valley with Shégitu Dance X She Runs It! - 8km adventure awaits! Shégitu Dance X She Runs It! Nature Walk 8km - Happy Valley Come join us for a fun-filled day of dancing and nature walking at Coulsdon South! This event is perfect for those who love to move their bodies and enjoy the great outdoors. Get ready to groove to the beats of Shégitu Dance and then hit the trails for an 8km nature walk with the She Runs It! community. It's a great way to stay active, connect with nature, and meet new friends. Don't miss out on this exciting event - sign up now! Get your 10,000+ steps with us as we take in Sunset and the breath-taking, versatile surroundings of Farthing Downs and Happy Valley. We will be teaching some engaging and aligning dance methods as well as fun training games from the 'She Runs It!' team This short, circular walk is the perfect opportunity to connect, explore, strengthen, and enhance your well-being. Here's what you can expect: Beginner-Friendly: Ideal for beginners who may be unsure of their mileage capabilities or new to bodyweight exercises. We'll provide a supportive environment where you can comfortably complete the distance and learn the fundamentals of bodyweight training. Whether you're a beginner, getting back into training, or advanced, our walks cater to all fitness levels. Playfulness: Expect laughter, conversation, music, and a chance to embrace the joy of being active in nature while challenging yourself with fun exercise. Come along to improve your fitness, explore nature, and meet incredible individuals while incorporating new forms of training into your routine. Suitable for 18y+ (If you are under 18 and would like to attend, you must be accompanied by a responsible adult) SUNDAY 17TH MARCH 2024 This is a circular route starting and ending at Coulsdon South Station Meeting Point: Coulsdon South Railway Station, Brighton Rd, Coulsdon CR5 3EA (There is a car park on site) Meeting Time: 14:45pm (We do appreciate your punctuality as we are aiming to align our walk with the sunset) There are regular direct trains to Coulsdon South from London Victoria and London Bridge We will be starting the walk by 15:00pm Distance: 8KM // 4.9 Miles Duration: 3.5 hours (approx. 2 1/2 hours walking time) What to bring: - Water - Wear light layers of clothing - A light rucksack if you are carrying anything - Scarf (satin or similar, to put around your hips) - Please wear waterproof shoes/hiking boots (Remember to bring a spare pair of trainers to change into at the end of the session, in case it's muddy) Please note; - If you can no longer attend after you book, please cancel your space so somebody else can fill in. - If you have any injuries or suffer from any conditions that may affect you while training, please drop us an email and we will do our best to accommodate you. Website: www.shegitu-dance.com Email us : info@shegitu-dance.com Like us on FB: https://www.facebook.com/shegituDance Follow us Instagram: @shegitudance @sherunsitldn @tashakeating @lidiaanamusic If you have any questions or would like to reschedule, get in touch. Looking forward to see you!
Java OOP Course Duration: 1 Day Who would find this course useful? This is useful if you have some coding skills already. This course is fast paced, not quite basics level. It specifically concentrates on Object Oriented Programming Principles (OOP) in Java. Download: Download Java JDK and Eclipse IDE. For classroom courses: Bring your own device. Java OOP Course description Session 1: General Concepts Revision: Scanner, Input from stdin, Print to stdout. Descision, While and For Loops Arrays Session 2: Packages, Methods, Encapsulation Using packages Creating and calling methods, parameters, method overloading Data protection through encapsulation Session 3: Classes, object construction Inheritance, method overload and override Polymorphism or runtime binding Session 4: Constructors, parameterised constructors Create abstract classes and methods Create and use an interface Session 5: Use the access modifiers protected and the default (package-friendly) Create static variables, methods, and initialisers Create final classes, methods, and variables Session 6: Nested Classes, Local Classes, Anonymous Classes, and Lambda Expressions, Enum Types Nested and inner classes; A stack class. What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java OOP Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments
Essential skill for all mental health professionals This 2-day workshop gives you the opportunity to see demonstrated, experience, and practice the steps of this powerful technique in a small group under the careful guidance of our expert tutor… Accredited CPD Certificate : 12 hours Length 2 days (9:30am - 4:00pm) Excellent course. A brilliantly encouraging and supportive environment in which to learnHARRIET, WORKSHOP PARTICIPANT Life-changing! A great weight has been lifted off my shoulders.NURSE (PREVIOUSLY TRAUMATISED BY A CAR ACCIDENT) Why take this course We have over 20 years of experience in teaching the rewind technique to health and welfare professionals – we’ve drawn on that experience to develop a course which gives you enough time to thorough absorb and practice the technique, understand why it works and to experience it yourself, so that you leave confident in your ability to use the rewind safely and effectively. The Rewind Technique* is an effective psychological intervention for successfully treating trauma and phobias and one of the most important skills you need to master to be able to work successfully with any anxiety disorder or condition which may have developed as a result of unresolved trauma. Even the most severe phobic and post-traumatic stress (PTSD) symptoms can be successfully addressed using the the rewind technique taught on this 2-day course, which has been refined* in line with understandings from neuroscience to make it as safe and reliably effective as possible. An essential therapeutic technique to have in your therapeutic ‘toolkit’, it is important to learn and practice it under the careful guidance of our expert tutor – you will leave the course knowing how to use the rewind technique safely and effectively having watched live demonstrations, had plenty of time to practice the steps involved with fellow students, the opportunity to experience the technique yourself and more. Our workshop has limited numbers so you will have plenty of opportunities for asking questions and the tutor, who has extensive clinical experience. Using the rewind technique you can, often surprisingly quickly, detraumatise bad memories, stop flashbacks and other PTSD symptoms, cure phobias, banish nightmares and reduce anxiety so you can help the victims of abuse, rape, violence, car accidents, fire, terrorism and panic attacks, heart attacks and other life-threatening experiences. Another key benefit of this technique is non disclosure – there is no need for people to repeatedly revisit or talk about specific details of the events that have traumatised them. This helps avoid embedding the trauma further and making the situation worse – as can sometimes inadvertently happen in other therapeutic approaches to treating trauma – and helps prevent the therapist or counsellor being vicariously traumatised by what they might hear. It is also invaluable when working therapeutically with people who have suffered persistent physical or sexual abuse, and people with OCD. People suffering from other conditions, such as depression, addictions or uncontrollable anger, may have experienced a traumatic event, which needs to be successfully detraumatised in order for them to move on with their lives. As a result of our training in the rewind technique – which we have been delivering for over 20 years – our graduates have brought relief to literally thousands of people (eg. case history / PTSD Resolution). Please note This is a powerful technique, which needs to be implemented with care – we recommend you take the time to learn it in person in a small group with a skilled and highly experienced tutor who can guide you through the important steps involved, oversee you as you practise them, answer your questions and give you crucial direct feedback. The version of the rewind technique* you will learn on this course has been refined in line with understandings from neuroscience to make it as safe and reliably effective as possible. The course is taught over two days to ensure you have enough time to thoroughly absorb and practice the steps involved so that you are confident in using it and know how to do so safely and effectively with clients. You will also learn when it is NOT appropriate to use this technique and how to ensure you avoid embedding any trauma further, or making a phobia worse. Guided imagery and visualisation skills form an essential part of the rewind technique, which is why they are a requirement for attending this course. This has huge potential to change people's lives for the better. I can't wait to put what I've learnt here to good usePSYCHIATRIC SUPPORT WORKER What will you learn How to detraumatise people quickly and safely The necessary skills to treat even severe phobias Why this version of the rewind technique is so effective, and how it works Under careful guidance from the tutor, you will: revisit key skills for relaxing clients in order to successfully work using the technique walk and talk through a step-by-step breakdown of the rewind technique see a live demonstration of working with a phobia or trauma practice each stage of the rewind technique in pairs practice the entire process, with other course participants, under supervision You will also gain: Vital tools for psycho-education – both adding to your own understanding and to pass on to clients A clear understanding of the fear response and how PTSD and phobias develop The detrimental impact traumas and phobias can have on a person’s life The crucial role of the pattern-matching processes in the brain in triggering phobic responses and post traumatic stress symptoms How the main treatment techniques for treating post traumatic stress disorder (PTSD), sub-threshold trauma and phobias (including EMDR, EFT and CBT) work – their advantages and disadvantages Why the rewind technique draws on the innate ability we all have to recover from trauma Pre-disposing factors for suffering a problematic post-traumatic response (or developing a phobia) Why critical incident debriefing increases the incidence of PTSD How this version of the rewind technique has been modified to make it safer and more reliable Trauma-focused rewinding: the psycho-biological reason why this refined rewind technique works so consistently well A step-by-step breakdown of the essential stages of the rewind technique The chance to see a live demonstration of working with a phobia or trauma You will leave with: The confidence to begin using the technique ethically and safely A clear understanding of the advantages of using a non-intrusive psychological technique to treat trauma, PTSD and phobias (where the client does not have to go into details about or repeatedly ‘revisit’ what has traumatised them) What to do if a client as an abreaction Important information about when not to use this technique – and what can be done instead An understanding of how the rewind technique can be used to work with Complex Trauma and cases involving ‘freeze’, shutdown or dissociative responses How you can carefully apply this technique to relieve a huge range of anxiety disorders Greater confidence in dealing with anxiety disorders and distress caused by trauma, phobias and flashbacks An understanding of how rapidly transformative this technique can be; on the last afternoon we view a filmed therapy session (and follow up) in which Joe Griffin uses the rewind technique to relieve a young man of his severe shark phobia There is also plenty of opportunity for you to ask questions and to experience and practice, under careful guidance, the various stages of the rewind technique yourself. Who is this course suitable for? Anyone working with distressed, phobic or traumatised people, who has already taken our Guided Imagery and Visualisation workshop (and ideally the Therapeutic Power of Language workshop too) as these skills are essential components of the rewind technique. If you help traumatised people (including children) or people suffering from any form of phobia or anxiety disorder – this includes: psychotherapists, counsellors, mental health nurses, OTs, health visitors, social workers, psychiatrists, GPs, clinical psychologists, midwives, welfare officers, youth workers, hypnotherapists and those working with traumatised members of public services, such as: firefighters, police, paramedics and military personnel – you will find the rewind technique and associated skills hugely helpful. Course requirements Guided imagery, relaxation and visualisation are an integral component of the Rewind Technique – if you don’t already have experience in using these skills therapeutically with others you must complete our Guided Imagery and Visualisation for Therapeutic Change workshop before attending this course (this is always run the day before our rewind technique training). This is to ensure you get the most out of this 2-day course and also have the necessary skills for practising the rewind technique safely and effectively. You would also find it useful to attend the Therapeutic Power of Language workshop beforehand if you can. All 3 workshops count towards Part 1 of the HG Diploma. Ros Townsend’s live online training Trauma: Patterns of the past is also useful for anyone working with or supporting someone suffering from unresolved trauma, or who would like to understand their own experiences of trauma better. She also runs a workshop on working with Complex Trauma. *About the Rewind Technique The Rewind Technique originated from one developed by Richard Bandler, one of the founders of NLP, when it was called the Visual/Kinaesthetic Dissociation protocol. A variant of this was developed by Dr David Muss, who called it the Rewind Technique. The version of the Rewind Technique you will learn on this 2-day course was refined by Joe Griffin and Ivan Tyrrell, co-founders of the human givens approach, to make it as reliably effective and safe as is possible by aligning the method with their insights into how trauma and phobias are processed in the brain. HG Therapists now follow a specific Rewind Protocol which follows the essential steps of the process that Griffin and Tyrrell set out. Course format This intense 2-day training proceeds through a blend of talks, live demonstrations, skill-developing exercises, practice sessions (under careful guidance) and deconstruction of filmed examples of the technique being used, including one with a severely traumatised young woman. There is also plenty of opportunity for networking and discussion during the breaks. The course was previously entitled: The fast phobia and trauma (PTSD) cure – a 2-day workshop in the rewind technique This course has been independently accredited by the internationally recognised CPD Standards Office for 12 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.