Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk 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 Jenny Price - Acer ' 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. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office 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
Description: Find solace and support with grief counselling in London. Our compassionate therapists help you navigate the grieving process, offering a safe space to express your emotions and begin healing after a loss. With personalized strategies and empathetic care, we aim to support you through every stage of grief and help you find a path towards emotional recovery. Key areas: bereavement counselling, loss support, grief therapy, mourning support, emotional healing, grief support, bereavement therapy. 3 x 1 hour sessions
Help with anxiety Life guidance Objective led life coaching Help with ptsd Help with exam stress Student dating advice Discovering your purpose Combat trauma issues High performance coaching Introspection test and personality test Confidence building Gain understanding of self Help with combating negative behavioural patterns https://relationshipsmdd.com/product/student-life-coaching-package/
Dialectical Behaviour Therapy (DBT) Package: Master Emotional Regulation and Forge Lasting Connections Miss Date Doctor’s Dialectical Behavior Therapy (DBT) package is designed to help you navigate emotional turbulence, improve interpersonal effectiveness, and cultivate mindfulness. Drawing from cognitive-behavioral therapy and mindfulness practices, DBT equips you with the skills needed to manage distressing emotions and develop healthier relationships. Our expert therapists will guide you through practical exercises that promote emotional regulation, effective communication, and self-awareness. You’ll learn to identify and change negative behavioural patterns while building skills to manage challenging situations. By mastering emotional regulation and interpersonal effectiveness, you’ll forge lasting connections and create a life filled with meaning and joy. 3 X 1 HOUR SESSIONS https://relationshipsmdd.com/product/dialectical-behaviour-therapy-package/
Solution-Focused Brief Therapy (SFBT) Package: Unlock Your Strengths, Embrace Your Solutions Miss Date Doctor’s Solution-Focused Brief Therapy (SFBT) package is your ticket to positive change and growth. SFBT is a future-oriented, goal-directed therapy that focuses on exploring your strengths and resources to create practical solutions. Our expert therapists will work with you to identify your goals and design a roadmap for success. You’ll harness your innate abilities to overcome challenges and create lasting positive changes in your life. Experience the power of empowerment as you uncover your potential and embrace solutions that align with your values. The SFBT package offers a transformative experience, setting you on a path to a more fulfilling and purpose-driven life. 3 X 1 HOUR SESSION https://relationshipsmdd.com/product/solution-focused-brief-therapy-package-2/
The package includes the following: Exploring unconscious patterns in couples therapy Healing personal histories in relationships Understanding the influence of the past on the present Enhancing self-awareness in couples therapy Resolving unresolved emotions in relationships Transforming relationship dynamics through psychodynamic approach Foster lasting change with psychodynamic therapy Comprehensive couples therapy program Invest in the future of your relationship today and experience the power of Psychodynamic Couples Therapy. Our compassionate therapists are dedicated to guiding you and your partner towards deep insights, transformation, and lasting fulfillment. Take the first step towards transformative change by scheduling a session with us now. 3 x 1 hour session https://relationshipsmdd.com/product/psychodynamic-couples-therapy/
The package includes the following: Positive change in relationships with CBCT Breaking negative patterns in couples therapy Effective communication techniques for couples Problem-solving skills in relationships Enhancing empathy and understanding in partnerships Building trust through Cognitive-Behavioural Therapy Overcoming conflicts in relationships Promoting healthy behaviours in couples Improving relationship satisfaction with CBCT Transformative couples therapy program Invest in the future of your relationship today and experience the power of Cognitive- Behavioural Couples Therapy. Our compassionate therapists are ready to guide you and your partner towards a more fulfilling and harmonious connection. Take the first step towards positive change by scheduling a session with us now. 3 sessions x 1 hour https://relationshipsmdd.com/product/cognitive-behaviourial-couples-therapy-package/
Introducing Trauma-Informed Therapy Package: Healing, Empowerment, and Renewed Well-Being Have you experienced past traumas that continue to impact your daily life and relationships? Miss Date Doctor’s Trauma-Informed Therapy Package is designed to provide you with a safe and supportive environment to heal from trauma, regain a sense of empowerment, and foster renewed well-being. Trauma can leave deep emotional scars that affect your mental health, self-esteem, and capacity to form healthy connections. Our experienced and compassionate therapists are here to help you navigate the healing journey with trauma-informed care. Here’s how the Trauma-Informed Therapy Package can support you: Safe and Non-Judgmental Space: Our therapists create a safe, non-judgmental space where you can freely express yourself and explore the impact of trauma on your life. Trust and confidentiality are paramount as we work together on your healing journey. Trauma Processing: Through evidence-based techniques, we’ll gently guide you through trauma processing, helping you gradually process and release the emotions and memories associated with the traumatic experience. This process can reduce the emotional intensity of trauma and foster emotional healing. Empowerment and Resilience: Our trauma-informed therapy empowers you to reclaim your strength and resilience. By addressing the effects of trauma, you’ll find inner resources to cope with life’s challenges, enabling you to move forward with renewed hope. Coping Strategies: We’ll equip you with practical coping strategies to manage triggers and stressors that may arise from trauma-related memories. You’ll learn healthy ways to regulate emotions and navigate difficult situations. Rebuilding Self-Esteem: Trauma can significantly impact self-esteem. Our therapists will work with you to rebuild a positive self-concept and develop a healthy self-image, fostering self-compassion and self-acceptance. Strengthening Relationships: Trauma can affect how you relate to others. In the Trauma-Informed Therapy Package, you’ll explore relational patterns and develop healthier ways of connecting with others, nurturing fulfilling relationships. Mindfulness and Grounding: Practicing mindfulness and grounding techniques can help you stay present and connected to the here and now, reducing anxiety and hypervigilance associated with trauma. Understanding Triggers: We’ll help you identify triggers and understand their origins. By gaining insight into your triggers, you can better manage their impact on your emotional well-being. The Trauma-Informed Therapy Package at Miss Date Doctor prioritizes your healing and well-being. Our therapists have extensive experience in trauma recovery, ensuring that your therapy journey is individualized and tailored to your unique needs. Release the burden of trauma and embrace a future filled with hope and empowerment. Enroll in the Trauma-Informed Therapy Package today, and let our skilled therapists guide you towards healing and renewed well-being. You don’t have to face trauma alone; we’re here to walk with you on your journey to recovery and growth. 3 X 1 hour sessions https://relationshipsmdd.com/product/trauma-informed-therapy-package/
Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included
Level 2 NVQ Diploma in Drilling Operations - Land Drilling - Lead Driller