1661 Management courses in Ewell

Understanding Safe Clinical Practice Professional Development and Competence/Resilience/Mental Health and Wellbeing Interprofessional Communication Reflective Practice Health Promotion and Motivational Interviewing Clinical Skills and Chronic Disease-Asthma COPD/B12/Wound Care/Diabetes/Cardiovsacular/ECG's

Microsoft Excel® in Depth The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Microsoft Excel® in Depth (In-Person) This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

This programme concentrates on the core planning skills needed to develop sound practical project plans in a team environment. This enables the plan to be modified should requirements change or difficulties arise. The programme also gives participants the confidence to practise those skills and apply them in the work environment and deliver their projects more successfully in the future. Participants learn fundamental project management concepts and terminology, demystifying the project management process, and, in particular, how to: Break a project down into manageable sections and ensure nothing is left out Understand and apply estimating techniques to develop realistic estimates Sequence work effectively and carry out critical path analysis to determine project duration and which tasks to pay closest attention to Manage project risk effectively to protect project value Monitor, control and re-plan the project to best keep it on track Close out the project and ensure the project comes to an orderly end 1 Introduction Self-introductions and personal objectives Course objectives Sharing of project issues 2 Project management concepts Characteristics of a project and what should be kept as operational responsibilities Understanding the triple and quadruple constraints - and their limitations Prioritising requirements through the MOSCOW technique Product v project life cycle Key project roles and responsibilities - the importance of sponsorship and clarity of roles 3 Starting a project, and the importance of the terms of reference / project brief Avoiding the pressure to 'just do it'! The importance and benefits of planning The best time to learn! Initial project documentation - the BOSCARDI approach 4 Breaking the work down Understanding alternative breakdown structures such as the product breakdown structure and work breakdown structure Guidelines for creating a work breakdown structure to ensure the full work scope is identified 5 Estimating Alternative estimating techniques and associated confidence levels Further considerations - loss and resource factors 6 Organising the work Use of network diagrams to develop a clear sequence of work Critical path analysis and calculating the project duration and task float - and usage 7 The management of project risk Understanding the nature of project risk The risk analysis and risk management processes How to best manage threats and opportunities Running a risk workshop Using the risk register 8 Scheduling the work The importance of the Gantt chart and understanding its limitations The Gantt chart layout and using alternative views such as the tracking Gantt Using alternative dependencies 9 Resource issues Assigning resources and resolving resource overloads Crashing and fast-tracking your project and potential issues to look out for 10 Controlling the project The control cycle and alternative feedback mechanisms Alternative progress reporting Assessing the impact The importance of re-planning The benefits of control Change control - the importance of impact analysis The steps of change control and the use of the issue register 11 Closing the project The project closure checklist Reviewing the project - things to avoid Developing meaningful lessons and ensuring they are applied effectively The post-project review - its importance to the organisation

Essential self-care for helping professionals New research gives us practical ways to prevent overwhelm or burnout in ourselves and others, manage workplace stress, avoid ‘compassion fatigue’ and much more… Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm GMT) Really interesting and engaging online course with lots of tips to support ourselves and our clientsCOMPLEMENTARY THERAPIST Live Online Training – Join Emily Gajewski on Thursday 11th April 2024 to take some important time out for yourself, or to help those you support. Once you’ve booked your place we will email you confirmation and you will receive details of how to join the Zoom workshop the day before the event. 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. Can’t make this date? Then please register your interest below – and we’ll email you when a new date is available. To help others effectively, we need to have enough ‘spare capacity’, which means looking after our own wellbeing too – new research shows us how… Why you should take this course When our day-to-day jobs involve continually listening to other people’s emotional difficulties, how do we avoid being overwhelmed by them ourselves or succumbing to compassion fatigue? We are the ‘tool’ of our trade. It could be argued that we have a duty to those we work with to prioritise our own mental health and wellbeing so that we can give them the best possible service. This live online training events shows you how. ‘Burnout’ is commonly defined as a physical and emotional state caused by excessive or overwhelming workplace stress. This is often specifically related to work but of course feelings of burnout can be impacted or compounded by other life events and caring roles too. Even if we know good stress management techniques, this often isn’t enough. Burnout is a very common phenomena in the ‘helping professions’, A 2018 research review paper published in the Journal of Clinical Psychology analysed 30 years of research on this topic, involving 9,000 psychotherapists. Over half of the therapists they sampled reported “moderate-high levels of stress and burnout”. The good news is that burnout, overwhelm and empathy fatigue are not a given of working in roles where we are consistently exposed to others’ emotional pain. New research and insights into ‘buffering’ the impact of this work mean that we can consciously choose to put in safeguards to our own mental wellbeing, whilst also remaining connected and present with our clients. Emily Gajewski’s online course draws on her extensive experience of working as a therapist and clinical supervisor, in the NHS and privately, for over 20 years. Throughout the day she examines the many ways working in the caring professions can impact us personally and gives you a wealth of practical steps you can take to mitigate them. She also covers the most up-to-date guidance on keeping ourselves well and thriving in caring roles and will help you develop a realistic plan for your own continuing wellbeing. Excellent online training…. very insightful and thought provokingHILARY KEARNS, ACUPUNCTURIST What you will learn The latest research on how to prevent burnout in your working life How to identify burnout in ourselves and others – the warning signs you need to look out for Easy, practical steps to protect yourself in stressful work situations How to avoid ‘compassion fatigue’ Evidence based ‘top tips’ for optimal working practices to maintain your own wellbeing The Cycle of Stress – how to ‘work with it’ for optimal health An understanding of vicarious trauma – and how to avoid it Techniques to calm yourself in client sessions when you are ‘triggered’ by something they bring up Understanding the difference between compassion fatigue and empathy fatigue Reducing your own risk of depression when you’re worried about your clients The joy of creating ‘flow’ in our working life Constructive ways to manage difficult feelings that arise as a result of your work Practical techniques for grounding and ‘letting go’ of clients How to safely explore our own areas of vulnerability Useful tips for ongoing stress management What you need to maintain your own mental health How to re-ground yourself if you’re feeling overwhelmed or derailed by a client An opportunity for you to reflect on your own practice and wellbeing, take some time to step back, learn what works for you and how you can create more spare capacity Time to relax, try out techniques and refresh your tools to support your wellbeing and build resilience How to utilise what you’ve learnt to create your own realistic wellbeing plan. Very useful and practical. The term ‘burnout’ is become as over-used as ‘wellbeing’ and ‘stress’. This online course provides clarity on what the term ‘burnout’ means in reality ... with strategies to counter the effectsHEADTEACHER SUPPORT SERVICE COUNSELLOR Course Programme The ‘How to avoid burnout’ live online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am Understanding Burnout and how to halt the journey towards it 11.00am Comfort break and discussion 11.30am Exploring practical self-care steps that can work for YOU! 1.00pm Lunch break 1.45pm How to manage difficult feelings that arise as a result of our work 2.45pm Comfort break and discussion 3.00pm Creating a plan for your own wellbeing 4.00pm Day ends Who this workshop is suitable for Anyone who works within a role that involves caring for others – including: medical professionals – including GPs and nurses health and social care professionals therapists and mental health workers counsellors educators, teachers professional carers (foster carers and non-paid carers) social workers occupational therapists outreach workers volunteers holistic practitioners etc. 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.

FourSquare Training specialise in private, corporate Microsoft Excel courses delivered at your premises and tailored to your needs.

Running a successful project requires skills in planning, budgeting, tracking deliverables and stakeholder management. An area that can be neglected by project managers is the 'people side' - not the project team themselves but the end-users, those who will be affected by the project. Too often there is a single line at the end of the project plan that says 'Comms and Training'. If people are going to have to work differently and learn some new processes, then there is work to be done by the project team to help them through the emotional side of the change. This session explores why it's important to bring people along when a change is being made. It will provide project teams with the skills and knowledge either to manage the people change plan themselves or to secure the right resources for their project. Understand the importance of the 'people side' of change 8 'Golden Rules' of change management - overview How to create a simple but effective change plan Adoption Benefits of good change management 1 Introduction Objectives and agenda People and projects - why is it important? The Change Curve - the emotional side of change 2 8 'Golden Rules' of change management - including... Role of the sponsor Communication Resistance to change 3 Change plan Elements of a change plan Change impact assessment Alignment with the project plan 4 Adoption Who owns the change? The vital role of the manager Feedback and action loops 5 Benefits Estimating the costs / benefits 6 Next steps Summary of key learning points Reflection on next steps 7 Close

This course is designed to help give you a sound understanding of the role and benefits of well...

Ruralink Training the home of The Rural Facilitator and the only source of professional learning for Integrated Local Delivery (ILD) practitioners.