11870 Courses delivered Online

Getting underneath behaviour - and the dangerous long term implications of not processing feelings.

In this workshop we'll delve into the intersection of cognitive and sports science methodologies, exploring how hypnotherapy can elevate your sporting abilities to new heights.

Learn practical ways of nurturing friendships in a neurodiverse world

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

An interesting aspect of job knowledge is that the majority of people believe they understand their job until they are asked to explain it. This course sets out to examine your professional, specialist or expert knowledge and understanding that are especially required in your job.

Prerequisite: PECS Level 1 Training This two-day training focuses on creating lessons and activities to promote communication throughout the day. Beginning with a review of the Pyramid Approach to Education as it relates to PECS, we guide you in refining your PECS implementation and discuss current challenges you have experienced within the six phases. As you acquire teaching strategies on expanding vocabulary and syntax combined with new ideas for materials, we will discuss how to increase communication opportunities for your learner. Throughout the training, you will be provided with presenter demonstrations, video examples and opportunities to role-play. With innovative ideas, increased confidence and renewed enthusiasm, you will leave the PECS Level 2 Training ready to move PECS users to more sophisticated levels of communication. WATCH VIDEO WHAT YOU WILL LEARN Identify the six phases of the PECS protocol Analyse common difficulties with PECS implementation Generate solutions to common challenges with implementing PECS Provide communication opportunities across the day in all activities Implement specific strategies for teaching advanced language concepts WORKSHOP DETAILS Agenda: 9:00 AM - 4:30 PM Registration Time: 8:30 AM - 9:00 AM CPD Points: Continued Professional Development Points CEUs: 7.5 BACB CEUs / 7.5 IBAO CEUs. Satisfactory completion of this course requires participants to be present for the duration of the course and to participate in all student responding activities (e.g. questions, role play, quizzes, and surveys). Tuition Includes: detailed handout with space for note taking, delegate practise bag and certificate of attendance. *Participants are encouraged to bring the PECS Training Manual (Frost and Bondy, 2002) that they received at their PECS Level 1 Training, as this workshop may reference some pages in the manual. This course is certified by the CPD certification service (the leading independent CPD accreditation institution) as conforming to continuing professional development principles. All delegates will receive a certificate of attendance detailing eligible CPD hours which can be used as verifiable documentary evidence when submitting CPD recording forms. Pyramid Educational Consultants is an approved BACB ACE Provider for Learning (Type 2) Continuing Education Credits. The BACB does not warrant, endorse, sponsor, approve, or partner with the event, organisation, or instructor. Pyramid Educational Consultants is an approved IBAO Provider for Continuing Education Credits.

A crash course in understanding a company’s report and accounts, this programme is ideal for anyone wanting to get more comfortable with the art of dissecting balance sheets and accounts more generally.

Demystifying ESG Environmental, Social and Governance (ESG) is a set of principles that assist a firm in becoming socially responsible. Applied across a number of industries, its popularity has grown rapidly, with an ESG framework now considered essential for many businesses. Embedding ESG in your organisation helps identify risks and opportunities, maintain regulatory compliance, gain the trust of stakeholders, invite investment and attract and retain talent. This timely short course, written by subject matter experts, will help you: understand ESG and its importance globally apply key lessons learned from those firms neglecting ESG identify where ESG fits within your organisation, and develop best practice to promote strong ESG engagement. On completing this course, you will understand key ESG concepts, as well as how to explain them to your colleagues. You'll also discover the steps required to embed ESG within your firm. This course covers: How does ESG work? Where does ESG sit within a business? Business benefits Current position audit Benchmarking Metrics and reporting Horizon scanning Bringing ESG to life

Our one-day interactive workshop for the school aged child is suitable for all staff working in the school setting. We explore a wide range of common sleep difficulties and sleep disorders in school children and young people including children with SEND and neuro diversities. Based in the most up-to-date evidence and science, we discuss responsive gentle sleep strategies to enable professionals to develop their theoretical and practical understanding of how to assess, manage and adapt techniques for a range of sleep difficulties Following the workshop, participants will be able to offer preventative intervention and share practical strategies to support sleep, with both parents and young people. Millpond Training’s sleep awareness day has been fully accredited for 6 CPD Hours by The CPD Certification Service; “This is a good course delivering clear learning value. It has a well-written and engaging presentation and a variety of activities and tasks to aid interactivity and learner engagement.” Workshop Aims To provide community staff with up-to-date evidence-based knowledge to develop their theoretical and practical understanding of sleep needs; sleep patterns; sleep cycles and common difficulties. To support community staff to enhance their confidence, skills and knowledge base in providing guidance to parents and young people regarding sleep difficulties. To provide an overview of evidence-based interventions used to help behavioural sleep difficulties in the school aged child and young people. Learning Outcomes By the end of the day delegates will be able to: Understand typical sleep regulations, sleep needs and sleep cycles. Understand common sleep difficulties in the school aged child. Provide education to families on establishing good sleep hygiene, and provide anticipatory advice in the prevention of sleep difficulties. Understand how to undertake sleep assessments, incorporating a sleep history and the use of a sleep diary. Gain an understanding of common sleep interventions used to help behavioural sleep difficulties.

People are a vital element in any organisation and managing and leading people is critically important for every manager. This course describes the key people management skills that contribute fully to organisational effectiveness.