765 Environment courses in Gerrards Cross

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

Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com

Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com

Manicure is one of the most widely practiced beauty rituals. This course covers the entire manicure procedure using the Spa Ritual line of products. The course is focused on the natural nail, hand and lower forearm anatomy and physiology for a comprehensive understanding of the manicure process. THE REQUIREMENTS No experience is necessary to attend this course. Salon attire must be worn during the course. Student must have clean nail without enhancements. To ensure maximum practice students will be required to work on each other throughout the day. Student need to bring own model for the day 3. COURSE CONTENT Theoretical part: Day 1 /time 10am-18pm Methods of working safely & hygienically and the principles of avoiding cross-infection. Client consultation / record keeping The structure of the natural nail / Contra indications Nail Diseases / Disorders/ Importance of Sanitising and Sterilising Importance of a professional work area and environment / How to organise a workspace Nail treatment preparation Nail Shapes & shine effect Procedure for Manicure (demonstration) Polish Techniques (French & Dark Colour - demonstration) Hand and Nail Treatment (Spa Ritual, Paraffin Wax, Warm Oil ritual) Home care & aftercare advice Practical Part Day 2 / time 10am – 18pm Tool and Product Introduction Manicure Procedures Hand and Nail Treatment Spa Ritual, Paraffin Wax, Warm Oil ritual Hand Massage Nail Painting Professional Advice and tips on fixing mistakes Common problems Exam Day 3 Students need to come with own model. Practical exam duration is 2 hours. Certificates will be issued after the completion of the exam. Price included Kit for work, upon successful completion an course certificate will be awarded

Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com

Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com

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/

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/

Elevate your understanding of relay protection in power systems with EnergyEdge's specialized classroom training course and gain valuable insights.

PRINCE2® Foundation and Practitioner are process-based project management approaches that can be easily customised and scaled. PRINCE2® Foundation and Practitioner course aim to provide delegates with a comprehensive knowledge of project management methodologies. Course Overview PRINCE2 Foundation and Practitioner are process-based project management approaches that can be easily customised and scaled. PRINCE2® Foundation and Practitioner course aim to provide delegates with a comprehensive knowledge of project management methodologies. At the end of this PRINCE2® Foundation and Practitioner course, delegates will be able to delegate tolerances and report actual and forecast progress effectively. They will also be able to quickly prepare the risk management, change control, quality management, and communication management approaches. Attaining this PRINCE2® certification enables candidates to demonstrate and enhance their project management proficiency – contributing to elevated business acumen and career prospects. Concepts covered: • Project management • Levels of management • Authorise initiation • Tailoring the IP process • Project and stage plans • Analysing risks to a plan • Escalate issues and risks PRINCE2® Foundation Training: This introductory PRINCE2® certification will help candidates understand the fundamentals of the PRINCE2® project management methodology and develop an appreciation of the constituents that contribute to a project’s success – underpinned by the PRINCE2® principles, processes, and themes. The foundation element of the combined course lasts for 3 days. During the course, candidates will gain a basic understanding of how to work in part of a PRINCE2® team. PRINCE2® Practitioner Training: The PRINCE2® Practitioner element of the combined course forms the final part of the training where the candidate learns to apply their acquired knowledge. Candidates will be educated on how to apply the methodology to a set of scenarios and how to efficaciously lead a project. What’s Included in this PRINCE2® Course? The following is included in this PRINCE2® Course: • The PRINCE2® Foundation Examination • The PRINCE2® Practitioner Examination • Pre-course material • PRINCE2® Workbook • PDUs • Experienced PRINCE2® Instructor • Certificate • Refreshments • PRINCE2 Homework – Set by your PRINCE2 Instructor at the end of each day. Prerequisites for PRINCE2® Course: In this PRINCE2® Foundation and Practitioner course, there are no formal prerequisites. This PRINCE2® Course is designed for anyone who wants to gain in-depth knowledge about project management methodologies. This Course is more beneficial for: • Project Managers • Aspiring Project Managers • Team Leaders • Directors • Senior Responsible Owners PRINCE2® Foundation and Practitioner 6th Edition Training Course Outline: Module 1: Introduction to Projects and the PRINCE2® Methodology: • PRINCE2® “Project” Definition • Project Characteristics • Project Management • What is PRINCE2®? • Four Integrated Elements • What PRINCE2® Does Not Provide • What Makes a Project a PRINCE2® Project? Module 2: Project Manager Activities: • Customer/Supplier Environment • Projects in Context • Commercial Environment • Applying PRINCE2® • Delivery Approaches • Measuring Success • Organisational Capability • Seven Processes Module 3: Seven Themes: • Business Case • Organisation • Quality • Plans • Risk • Change • Progress Module 4: Seven Principles: • Continued Business Justification • Learn from Experience • Defined Roles and Responsibilities • Manage by Stages • Manage by Exception • Focus on Products • Tailor to Suit the Project Module 5: Organisation Theme: • Four Levels of Management • PRINCE2® Organisation Requirements • Project Management Team • Project Management Team Roles • Project Board • Project Assurance • Change Authority • Project Support • Communication Management Approach Module 6: Starting Up a Project (SU): • Process Overview • Feasibility Study and Mandate • Appoint the Executive and the Project Manager • Capture Previous Lessons • Design and Appoint the Project Management Team • Prepare the Outline Business Case • Project Product Description • Select the Project Approach and Assemble the Project Brief • Plan the Initiation Stage • Tailoring the SU Process Module 7: Directing a Project (DP): • Authorise Initiation • Authorise the Project • Authorise a Stage or Exception Plan • Authorise Project Closure • Give Ad Hoc Direction • Tailoring the DP Process • Theme Overview • Balance of Justification • Continued Business Justification • PRINCE2® Requirements • Contents of a Business Case • Business Case Development • Benefits Management Approach • Key Responsibilities Module 8: Initiating a Project (IP): • Agree to the Tailoring Requirements • Prepare the Risk Management Approach • Prepare the Change Control Approach • Prepare the Quality Management Approach • Prepare the Communication Management Approach • Set up the Project Controls • Create the Project Plan • Prepare the Benefits Management Approach • Assemble the Project Initiation Documentation • Tailoring the IP Process Module 9: Risk Theme: • Risk Definition • Effective Risk Management • PRINCE2® Risk Requirements • Risk Management Approach • Probability/Impact Grid • Risk Register • Risk Management Procedure • Identify Step • Risk Budget • Key Responsibilities Module 10: Quality Theme: • Quality Definitions • Quality Management • Quality Planning and Control • What is Quality Assurance? • PRINCE2® Quality Requirements • PRINCE2® Quality Documentation Requirements • Quality Management Approach • Quality Audit Trail • Project Product Description • Product Description • Quality Review Technique • Quality Review Roles/Responsibilities • Quality Review Meeting • Off-Specifications and Concessions • Review Follow-Up • Quality Review Benefits • Key Responsibilities • Communication Management Approach Module 11: Plans Theme: • Dealing with the Planning Horizon • PRINCE2® Planning Requirements • Documentation Requirements • Project and Stage Plans • Team Plans and Work Packages • Plans Relationship • What is in a Plan? • PRINCE2® Approach to Plans • Designing a Plan • Delivery Approaches • Defining and Analysing the Products • Product Breakdown Structures • Product Description • Product Flow Diagram • Identify the Activities and Dependencies • Preparing Estimates • Preparing a Schedule • Documenting the Plan • Analysing Risks to a Plan • Gantt Chart and Tailoring • Key Responsibilities Module 12: Progress Theme: • Progress Definition • PRINCE2® Requirements • Progress Control • Management by Exception • Delegating Tolerances and Reporting Actual and Forecast Progress • Types of Control • Management Products and Progress Control Module 13: Change Theme: • Issue Definition • PRINCE2® Approach to Change • PRINCE2® Change Documentation • Issue Register • Change Control Approach • Change Budget • Issue and Change Control Procedure • Issue Report • Exception Report Module 14: Controlling a Stage (CS): • Activity Breakdown • Authorise a Work Package • Work Package • Review Work Package Status • Receive Completed Work Packages • Review the Management Stage Status • Report Highlights • Highlight Report • Capture and Assess Issues and Risks • Escalate Issues and Risks • Take Corrective Action • Tailoring CS Module 15: Managing Product Delivery (MP): • Accept a Work Package • Execute a Work Package • Checkpoint Report • Deliver a Work Package • Tailoring MP Module 16: Managing a Stage Boundary (SB): • Plan the Next Management Stage • What is in a Plan? • Update the Project Plan • Update the Business Case • Report the Management Stage End • End-Stage Report • Produce an Exception Plan • Tailoring SB Module 17: Closing a Project (CP): • Prepare Planned Closure • Hand Over Products • Evaluate the Project • End Project Report • Recommend Project Closure • Tailoring CP Module 18: Considerations for Organisational Adoption: • Creating a PRINCE2® Based Project Management Method • Creating Tailoring Rules and Guidelines • Rating the Complexity of Projects • Embedding PRINCE2® • Tailoring • What Should Be Tailored? • Tailoring Constraints and Influences • Creating an Organisation’s Method DURATION 6 days WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate