Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data
We all tend to have challenges throughout our lives that cause varying levels of pressure. It is healthy and essential that people experience such challenges because up to a certain point an increase in pressure improves performance and quality of life. Too much pressure can be harmful and affect our health and wellbeing. This participative half-day workshop will explore the causes and impact of stress and provide an opportunity to learn some new ideas and techniques to cope with it. Practical tasks and exercises will be used to promote discussion and participants will be encouraged to share their own experiences and approaches. By the end of the workshop participants will be able to: Understand the causes and symptoms of stress and how to spot them Become more aware of personal habitual behaviours and approaches that get in the way of dealing with stress productively Learn ideas and approaches that help you to cope with the thoughts, emotions and physical feelings that happen in stressful and difficult situations Review and evaluate learning and have an action plan to take back and put into practice at work 1 Welcome, introductions and objectives Breaking the ice 2 Stress Its sources and effects on you Defining stress, its signs and symptoms 3 Exploring your 'default' habits Their consequences in stressful situations 4 Dealing with perception Strategies and approaches for coping with stress 5 Setting goals with positive outcomes Review and evaluation of learning Action planning
This is an essential programme for members of staff whose role involves external meetings, including seeing members of the public in their own home. Based around advice from agencies including the Suzy Lamplugh Trust and the police, this programme takes a sensible look at how to remain safe in the role. 1 What's happening? Issues around us Risks in context 2 Safety fundamentals Risk assessment Dynamic risk assessment Identifying and minimising risks Sensible precautions Use of technology and personal safety Lone working Visits and travelling 3 Harassment and stalking What constitutes harassment and definition of stalking Early warning signals 4 Reporting principles Importance of incidence reporting Taking care of us What next?
This is an essential programme for all Council Members, particularly those who are newly elected, who need to review their personal safety and lone working arrangements. 1 What's happening? Issues around us Risks in context 2 Safety fundamentals Identifying and minimising risks Sensible precautions Use of technology and personal safety Lone working and the Council's policy 3 Harassment and stalking What constitutes harassment and definition of stalking Early warning signals 4 Reporting principles Importance of incidence reporting Council procedure What next?
The three-day FAW course is our most thorough First Aid course. It is designed for you if you are a nominated First Aider in a hazardous environment, such as a factory or a construction site, as well as providing you with complete training for any other work situation.
This one-day course will help you meet your regulatory requirements if your risk assessment indicates that first aid training covering emergency protocols only, is sufficient for your workplace.
This course is suitable for operatives required to Work at Height, and will give operatives a sound foundation on the requirements of the Work at Height Regulations 2005 and other relevant regulations. Also highlights the principles of how fall protection systems / equipment should be selected and used. This course will provide delegates with the knowledge and practical experience to enable them to work safely at height using a variety of basic systems and techniques. Book via our website @ ESS | Working at Height Module 2 - Safe Work at Height (General Operative) | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346
This course is suitable for operatives required to Work at Height, providing a sound foundation on the requirements of the Work at Height Regulations 2005 in conjunction with a basic understanding of the types of fall protection systems and equipment available, its use, its limitations and unsafe practices. Suitable for individuals working around but not directly Working at Height. It allows the delegate to identify a working at height area and understand the procedures and regulations that control it. Book via our website @ ESS | Working at Height Module 1 - Safe Work at Height Awareness | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346
Support culture change by giving line managers the skills to look at practices within their areas, role model appropriately and address unacceptable behaviours. Our dynamic, assertive trainer for EDI has a very practical approach, with plenty of real-life examples to help participants view the subject from a new angle
Course Outline: What is “Diversity and Inclusion”? The Cultural Contact Lens - understanding different people's experiences The Social Ecological Model - understanding how individual elements sit within and impact upon social change Finding your ‘why’, and the Business Case for D&I Going above and beyond the Law - the Equality Act (2010) and protected characteristics Becoming comfortable with feeling uncomfortable Privilege, power, and the Cycle of Oppression An introduction to allyship Summary and questions