1670 Environment courses in Barnoldswick delivered Live Online

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored training courses: In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

A personalised resilience profile and 60 minute coaching and exploration session for those who want to develop their capacity to adapt positively in an ever changing world.

COURSE INTRODUCTION  The purpose of this course is to introduce / refresh participants’ knowledge and skills in the essential aspects of diabetes management in their practice setting.  AIMS AND OBJECTIVES  Identify their current knowledge of diabetes care and how confident they feel about offering advice to a patient with diabetes and or their family. Purpose and outcomes of the main treatment options for people with diabetes . Discuss the importance of addressing the person’s needs and how regular clinic visits impact on the management of diabetes All course materials and certificate of attendance Accreditation 6 CPD points awarded completion. Accredited by One Awards (*Certificate £30) and CPD Standards (*Certificate free) Discuss how to build relationships and establish an environment that enables the person with diabetes to take an active role in their diabetes management  COURSE CONTENTS OVERVIEW  Aetiology and diagnosis of type 1 and type 2. Difference between type 1 and type 2 diabetes  Implications for practice  Management goals TYPE 1  Treatment and management options  Carbohydrate awareness  Challenges in self-management  Hypoglycaemia and hyperglycaemia  Screening and the annual review TYPE 2  First line treatment and step-wise options  Food choices and relation to risk  Activity and type 2 diabetes  Cardiovascular disease and type 2 diabetes  Screening and annual review  SUPPORTING PEOPLE WITH DIABETES AND THEIR FAMILY  Seeing the person not the disease  Consultation skills  Ongoing support needs .  Food and lifestyle messages for diabetes  Annual review and screening including foot care advice  Blood glucose monitoring  Consultation skills and relationship building  Complications and treatment options  WHO SHOULD ATTEND?  Nurses HCAs

Introducing Divorce Therapy Package: Navigating the Challenges, Healing, and Finding Renewed Purpose Are you going through the difficult process of divorce and seeking support to cope with the emotional challenges and transitions? Miss Date Doctor’s Divorce Therapy Package offers you a compassionate and understanding space to navigate the complexities of divorce, heal from the emotional wounds, and find renewed purpose in life. Divorce is a life-altering event that can lead to a wide range of emotions, including grief, anger, sadness, and uncertainty about the future. Our experienced therapists are here to help you process these emotions, gain clarity, and develop coping strategies to move forward positively. Here’s how the Divorce Therapy Package can support you: Emotional Healing: Our therapists provide a safe and non-judgmental space where you can freely express your emotions related to the divorce. We’ll help you process grief and loss, anger, and other challenging emotions to facilitate healing. Navigating Transitions: Divorce often involves significant life changes. We’ll guide you in navigating these transitions, such as adjusting to single life, co-parenting, or re-entering the dating scene. Coping Strategies: Divorce therapy equips you with coping strategies to manage stress, anxiety, and uncertainty during this period of change. Gaining Clarity: Our therapists will work with you to gain clarity about your goals and aspirations, helping you find a new sense of purpose and direction in life. Communication Skills: Divorce therapy can also address communication issues, helping you effectively communicate with your ex-partner and children during the divorce process and beyond. Building Resilience: Divorce therapy fosters resilience, empowering you to bounce back from challenges and embrace a new chapter in life with strength and determination. Self-Discovery: Divorce can be an opportunity for self-discovery and personal growth. We’ll help you explore your values, strengths, and interests, creating a foundation for a fulfilling future. Supportive Environment: Our therapists provide unwavering support throughout your divorce journey, offering guidance and empathy as you work towards healing and renewal. The Divorce Therapy Package at Miss Date Doctor offers you a transformative experience during a challenging time in your life. Our therapists understand the complexities of divorce and are committed to helping you navigate this transition with grace and resilience. Invest in your emotional well-being and take the first step towards healing and renewal with the Divorce Therapy Package. Embrace the opportunity for growth and self-discovery as you embark on a journey of healing and empowerment. Let our skilled therapists guide you towards finding strength, purpose, and a brighter future beyond divorce. 3 X 1 hour https://relationshipsmdd.com/product/divorce-therapy-package/

In this course you will understand what mentoring is about, understand your roles in the process. Gain self-insight into your own interpersonal style and way of relating to others that may affect mentoring interactions.

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Master 2 (PSM II). This is an advanced scrum master training course - designed for experienced Scrum Masters seeking professional growth. Course Description This advanced Professional Scrum Master (PSM II) qualification is designed to elevate you to a level of total Scrum mastery. Deepen your understanding of the Scrum framework and Agile practices while transforming your team into an Agile powerhouse. Gain the skills to teach Agile and support your organisation, regardless of your role. Whether you aim to lead Agile transformation within your organisation or progress your Agile career, this advanced Scrum mastery course is your ideal opportunity. Our Scrum.org certified advanced professional scrum master training course is delivered by industry experts with unrivalled interactivity. We combine real world experience with industry leading practicals that embed key principles. The PSM 2 course if focussed on developing practical skillsets and best practice implementation to achieve tangible results. Through these tried and tested learning techniques, Fractal Systems delivers a 98% first-time pass rate. Learn how to become an advanced Scrum Master: Understand how Scrum principles and values guide decision-making. Enhance servant-leadership abilities. Support Development Teams and Product Owners to improve effectiveness. Foster a conducive environment for successful Scrum Teams with greater agility. Gain tips and techniques for collaboration with the organisation. Improve overall organisational impact as a successful Scrum Master. Address team conflict and remove impediments. Communicate the significance of a "Done" Increment. Grasp how to support the Scrum Team and navigate middle management challenges. Why Train With Us? This immersive two day PSM II course prioritises your growth and success in the industry. We believe in hands-on learning experiences that deliver practical applications that are specific to your individual workplace challenges. This not only helps to frame key principles of an advanced Scrum Master but also enables you to have a more immediate impact in your role. The PSM II training course is led by our Scrum Trainers, all of which have real world industry experience. Gain a deep understanding of advanced Scrum theory, empower your Scrum teams with best practices and be supported by industry professionals throughout - from passing test to implementing learnings into your role. Who Should Attend This Course? The Professional Scrum Master II course is an advanced program tailored for experienced Scrum Masters with a deep understanding of the Scrum framework. We recommend this to individuals with at least one year of Scrum Master experience. Your Professional Scrum Trainer Meet Jay, the founder of Fractal Systems and an experienced Professional Scrum Trainer. With over 20 years in leadership and team roles, Jay excels in delivering practical value. He adopts an interactive teaching style, avoiding PowerPoint in favour of engaging, experience-based learning, using techniques from Liberating Structures and Neuro-Linguistic Programming. Jay specialises in business transformations, providing training, mentoring, coaching, and consulting to drive success through teamwork. For those pursuing the Professional Scrum Master II (PSM II) certification, Jay and the Fractal team are committed to supporting your learning journey with a range of valuable resources: Complimentary Scrum Resource Bundle Access to a PSM Exam Simulator Free PSM II Exam Coaching Sessions Personalised 1:1 Coaching At Fractal Systems, our goal is to ensure you have the support and resources needed for a successful PSM II learning experience. Our Clients Our Testimonials

Introducing In-Person Couples Therapy Package: Strengthening Relationships Through Personalized Guidance and Connection Are you and your partner facing challenges in your relationship, longing for effective communication, intimacy, and mutual understanding? Miss Date Doctor’s In-Person Couples Therapy Package offers you and your partner the opportunity to engage in face-to-face therapy sessions, fostering a deeper connection and personalized guidance to enhance your relationship. Relationships can experience ups and downs, and sometimes external guidance is needed to navigate through difficult times. Our experienced couples therapists are committed to providing you and your partner with a safe and supportive space to address concerns, improve communication, and strengthen your bond. Here’s how the In-Person Couples Therapy Package can support you: Personalized Couples Assessment: Our therapists will conduct a thorough assessment to understand your relationship dynamics, strengths, and areas that need improvement. Tailored Therapy Sessions: In-person couples therapy offers personalized sessions that cater to your unique needs and relationship goals. Communication Enhancement: We’ll provide effective communication tools and techniques to promote healthy and open dialogues between you and your partner. Conflict Resolution Skills: Our therapists will guide you in developing constructive conflict resolution strategies to navigate disagreements. Reigniting Intimacy: In-person therapy can help you and your partner reconnect emotionally and physically, fostering a deeper sense of intimacy. Emotional Connection: We’ll focus on building emotional connection and understanding between you and your partner. Navigating Transitions: Whether it’s a life change or milestone, therapy can help you navigate transitions while maintaining a strong relationship. Shared Growth: The In-Person Couples Therapy Package promotes shared growth, allowing you and your partner to evolve together as a couple. The In-Person Couples Therapy Package at Miss Date Doctor is designed to strengthen your relationship through face-to-face interaction and expert guidance. Our experienced couples therapists provide a secure environment for open conversation and collaborative problem-solving. Invest in the growth and well-being of your relationship and take the first step towards enhanced connection with the In-Person Couples Therapy Package. Embrace the opportunity to improve communication, address challenges, and build a resilient and loving partnership. Let our skilled therapists guide you and your partner towards a stronger and more fulfilling relationship journey. 1 hour session x3 https://relationshipsmdd.com/product/in-person-couples-therapy/

Learn the processes, practices and principles of project management described in the PRINCE2® approach and prepare for the Foundation and Practitioner examinations on this accredited programme. Duration: 5 days (32.5 hours) Our PRINCE2® Foundation and Practitioner Qualification course is designed to teach the processes, practices and principles of project management described in the PRINCE2® approach and to prepare delegates for the Foundation and Practitioner examinations, held as part of the course. This course is designed for existing and potential Project and Team Managers who would like to gain a comprehensive understanding of the PRINCE2® method of managing projects and will provide those responsible for planning and managing projects with a structure that will help, without imposing inflexible processes or stifling creative thinking. The PRINCE2® Foundation and Practitioner Course is based on the “Managing Successful Projects with PRINCE2® 7th Edition”, which describes the structured project management method. These are intensive modules and require delegates to undertake some evening work in their own time. Objectives  By the end of the course you will be able to be: Describe the background, principles, structure and terminology used in the PRINCE2® 7th Edition project management method Prepare for and take both the PRINCE2® Foundation and Practitioner Exams Please note that examinations are the responsibility of the examination board, PEOPLECERT and must be organised separately by each person attending. Content Introduction Introduction to projects and project management Structure Of PRINCE2® 7th Edition The seven Principles –the basis of what defines a PRINCE2 project People – leading successful change, teams and communication The seven Practices – to be addressed throughout the project The seven Processes - the activities to direct, manage and deliver a project successfully Practices Business case – establishing mechanisms to decide whether project is desirable, viable and achievable Organizing – establishing accountabilities and responsibilities Quality – defining mechanisms to ensure that products are fit for purpose Plans – the product based approach to planning Risk – identifying, assessing and controlling uncertainty Issues – identifying, assessing and controlling changes to the baseline and other issues Progress – monitoring actual achievements against estimate and controlling deviations Processes Starting up a Project - is there a viable and worthwhile project Directing a Project – enabling key decision making by the Project Board Initiating a Project – establishing solid foundations Controlling a Stage –assigning and monitoring work and keeping within stage tolerance Managing Product Delivery – controlling the link between the Project Manager and Team Manager(s) Managing a Stage Boundary – current stage review and next stage planning Closing a Project – confirmation of acceptance and project review Tailoring PRINCE2® - to the project environment Foundation Examination and results Practitioner Workshop and Examination PRINCE2® Practitioner Examination Objectives and Guidance PRINCE2® Review PRINCE2® Practitioner Examination Workshops PRINCE2® Practitioner Examination PRINCE2® Foundation and Practitioner Examinations The PRINCE2® Foundation Exam is of 1 hour duration and consists of 60 multiple choice questions. A Pass is 36 correct answers, 60%. The PRINCE2® Practitioner Exam is a written paper of 2.5 hours duration. There are 70 Objective Test style questions to be answered in the 2.5 hours and the candidate may use an annotated manual. The candidate must score 42/70 to be successful, 60%.   Presented in association with aims4change, a PEOPLECERT Accredited Training Organisation. PRINCE2® is a Registered Trade Mark of AXELOS Limited.

MindBreath Coaching offers a confidential environment to explore where you currently are personally or professionally and to move forward at your own pace.

Who is this for? InDesign Evening Classes. Refine your Adobe InDesign skills with expert tutors. Master layout creation, typography, and image manipulation. Design captivating brochures, magazines, and more. Choose between in-person or live online sessions. Earn a Certificate of Completion and enjoy lifetime email support. Explore our complimentary trial session. Check our Website Duration: 10 hours Approach: 1-on-1 sessions with tailored content. Schedule: 1-on-1 sessions, available Mon to Sat from 9 am to 7 pm. Course Title: Mastering Adobe InDesign Course Duration: 10 Hours Session 1: Introduction to Adobe InDesign (1 hour) Overview of Adobe InDesign interface Understanding tools and panels Setting up new documents and document properties Basic navigation and shortcuts Session 2: Mastering Page Layouts (1.5 hours) Working with master pages Creating and managing text frames and image placeholders Managing multiple pages and spreads Using grids and guides for precise layouts Session 3: Typography and Text Formatting (1.5 hours) Working with fonts, styles, and text formatting options Understanding text threading and linking Advanced text composition techniques Utilizing paragraph and character styles for consistency Session 4: Advanced Image Manipulation (1.5 hours) Importing and manipulating images and graphics Understanding image resolution and color modes Working with clipping paths and transparency Applying image effects and filters Session 5: Interactive Documents and Digital Publishing (2 hours) Creating hyperlinks and interactive buttons Embedding multimedia elements (audio, video) in documents Exporting documents for digital platforms (eBooks, PDF forms) Introduction to responsive design for various devices Session 6: Advanced Techniques and Special Effects (1 hour) Utilizing advanced drawing tools and shapes Applying special effects like drop shadows, transparency, and blending modes Working with tables and charts Introduction to data merge for personalized content Session 7: Printing and Prepress (1 hour) Understanding print terminology and specifications Preflighting documents for print readiness Color management and preparing files for different printing processes Exporting files for professional printing Session 8: Project Work and Review (0.5 hour) Participants work on a practical project applying learned skills Instructor-guided project review and feedback Session 9: Tips, Tricks, and Best Practices (0.5 hour) Time-saving shortcuts and productivity hacks Best practices for efficient workflow and file management Troubleshooting common issues and errors Session 10: Q&A and Certification (0.5 hour) Addressing participant queries and concerns Certificate distribution and course completion celebration This comprehensive 10-hour course aims to equip participants with advanced skills in Adobe InDesign, covering essential aspects of design, typography, interactivity, and print preparation. Participants will engage in hands-on activities, projects, and discussions to reinforce their learning throughout the course. By the end of this 10-hour advanced InDesign course, you will: Gain a comprehensive understanding of InDesign's most powerful features and advanced techniques. Create sophisticated page layouts with eye-catching special effects for professional-level designs. Efficiently manage fonts, colors, and shapes to enhance the visual appeal of your documents. Develop interactive PDFs with navigation, page transitions, and embedded video for engaging presentations. Master the use of character styles, paragraph styles, and word styles to streamline text formatting. Utilize advanced object styles and anchored objects for efficient layout design. Work effectively with Adobe Stock, Photoshop, Illustrator, and other Creative Cloud applications for seamless integration. Create PDF forms and implement interactive button-triggered animations for interactive documents. Optimize workflow with keyboard shortcuts, scripts, and advanced preferences for a smoother design process. Learn valuable tips and best practices from industry experts to boost your productivity and efficiency. Enhance your mastery of InDesign through our advanced program, meticulously designed to hone your skills. Explore intricate page layouts and seamlessly integrate captivating special effects into your projects. Our seasoned Adobe trainers, renowned for their approachable teaching style, will guide you through InDesign's powerful features, sharing invaluable insights derived from years of practical experience. This interactive course provides ample opportunities for hands-on practice, ensuring your confidence in harnessing InDesign's diverse technical capabilities. Key Course Highlights: In-depth exploration of InDesign's advanced functionalities. Individualized attention, fostering open discussions and encouraging questions. Expert trainers, small class sizes, and a supportive and collaborative learning environment. Comprehensive learning materials and resources, all inclusive. Continuous support for any post-course inquiries or concerns, ensuring your ongoing success. Enhance your InDesign proficiency, crafting polished designs effortlessly. Elevate your skills with our advanced course, ensuring: Thorough coverage of InDesign's technical capabilities. Personalized attention and ample opportunity for questions. Supportive, knowledgeable trainers in a comfortable learning environment. Comprehensive materials and resources for your learning journey. Continued assistance for post-course queries and concerns. Download InDesign