1686 Guide courses in Sheffield delivered Live Online

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Learn how to carry out a Person Centred Review based on the values of person centred thinking. Course Category Person Centred Planning Inclusion Strategic Work Visioning and Problem Solving Description Person centred planning is a way of expressing a set of inclusive values through a unique range of tools and techniques. The most commonly used person centred tool is a Person Centred Review – and it shows these values in action. All person centred planning tools and processes are driven by a commitment to achieve inclusive outcomes for the person whose plan it is, and the young people involved are always present throughout their planning session. The focus of all person centred approaches is the whole person irrespective of the label they carry. Two people, a process facilitator and a graphic facilitator, typically facilitate plans. The role of the support service staff in this work is as a facilitator not as an expert participant, problem solver, assessor or provider of consultation. Person Centred Reviews like MAPS and PATH are especially effective tools in planning transitions and annual review processes for young people with additional support needs and for through-care planning for young people who are looked after or accommodated. Over time person centred working will reveal areas of unmet need in current provision and thereby inform the ongoing strategic planning within any particular region. Testimonials Be the first…. Learning Objectives To Explore the values underpinning person centred working To show how person centred planning with Person Centred Reviews naturally captures young people’s strengths and capacities A demonstration of how person centred reviews encourage meaningful consultation and participation with young people (particularly for those who cannot make their views known in typical ways To show how Person Centred Planning leads to the building of stronger parent/school partnerships To indicate how person centred planning can promote multi-agency teamwork and shared responsibilities To increase understanding the how of process and graphic facilitation in person centred work. Who Is It For ? Teachers and School Staff Education Services Social Care Staff Health Professionals Transition Coordinators Family Support Workers Link Workers Course Content An introduction to the person centred planning Person Centred Reviews – live demonstrations of process in action followed by real time coaching of facilitation skills. We would stress that this is an introductory day and that participants will be expected to make plans for their own follow up and further practice of the tools covered in the course of the day. If you liked this course you may well like: PERSON CENTRED PLANNING USING PATH AND MAPS

Begin a transformative career path with our exclusive First Time Supervisor / Caseworker Training Program View our First Time Supervisor / Caseworker training course dates below, available remotely via Microsoft Teams. Embark on a transformative journey with our First Time Supervisor / Caseworker Training course. Meticulously crafted for legal advisors stepping into their inaugural supervisory roles or transitioning into casework responsibilities. This course is designed to equip participants with the essential skills, knowledge, and insights needed to excel in their new leadership positions within the legal field. This comprehensive training program combines theoretical insights with practical applications, interactive discussions, and real-world scenarios. Elevate your leadership skills and excel in your role as a first-time supervisor or caseworker with our “First Time Supervisor / Caseworker Training.” Register now to unlock your potential for success in the legal advisory landscape.   Course joining links, materials and instructions are sent out 24hours before the course starts. Immigration Advice Service has been providing professional immigration services for over 10 years in the public, private and corporate sectors. Our fully qualified and OISC regulated trainer will guide you through the process and ensure you are competent in the area of Unaccompanied Minors. Who Should Attend: Designed for immigration Legal Practitioners, Lawyers, Solicitors, Immigration Advisors. Course Topics: Smooth transitions for legal advisors becoming supervisors or caseworkers. Understanding new responsibilities and expectations. Building effective communication skills for team leadership. Fostering a positive and collaborative work culture. Techniques for efficient time management in supervisory or casework roles. Providing constructive feedback and evaluations for team members. Setting and monitoring performance goals for optimal team performance. Balancing legal expertise with leadership responsibilities. Addressing ethical considerations in a supervisory role. Maintaining accuracy and attention to detail in handling legal cases. Problem-solving strategies for complex legal cases. Identifying continuous learning and growth opportunities.

This comprehensive online interior design course includes 12 self study modules, and weekly 1:1 telephone and or video consultations. I will personally guide and inspire you through your creative learning journey.

This is an exclusive handcrafted macramé Angel. It is the best gift for Christmases occasion for your loved once. Be a proud maker of your gift item.

This is an exclusive handcrafted macramé Angel. It is the best gift for Christmases occasion for your loved once. Be a proud maker of your gift item.

This is an exclusive handcrafted macramé Angel. It is the best gift for Christmases occasion for your loved once. Be a proud maker of your gift item.

SketchUp Course With Layout and V-Ray

Are you an assessor or a trainer looking to enhance your effectiveness and communication skills? Do you find it challenging to confidently express your thoughts, to get what you want from situations and to maintain control during training sessions or assessments?  If so, our “Assertiveness for Assessors and Trainers” live online workshop is made for you. Effective Communication: Assertiveness empowers you to communicate your ideas clearly, ensuring your message is understood by learners. You’ll learn techniques to express your thoughts confidently, leading to improved engagement and comprehension. Confidence Building: Learn techniques for appearing more confident when communicating with others.  Taking control: Take control of situations through your body language and the verbal / written language you use. Invest in Your Success This 2.5 hour session will help you gain the skills to lead with confidence, communicate effectively, and prioritise yourself in your life.  Further Information This 2.5 hour session held live online via Teams will give you the tools and techniques you need to be more assertive. Workshop Benefits Interactive Workshops: Engage in hands-on activities, role plays, and real-world scenarios to practice assertive communication techniques in a safe and supportive environment.Expert Facilitators: Our experienced trainers will guide you through proven strategies, drawing on their expertise in communication, psychology, and training methodologies.Tailored Content: The course content is specifically designed for assessors and trainers, addressing challenges and situations unique to your profession.Practical Tools: Walk away with a toolkit of practical techniques, scripts, and strategies that you can immediately apply in your assessments and training sessions.Networking Opportunities: Connect with fellow assessors and trainers, sharing insights, experiences, and best practices to further enhance your professional journey.

Join our Women in Insurance Leadership Workshop and gain insights from industry experts on how to succeed in the male-dominated insurance sector. This workshop is designed to empower women by providing valuable tools and resources to enhance leadership skills, build professional networks, and create a more inclusive workplace culture. Don't miss this opportunity to connect with other women in the industry and take your career to the next level. Register today!