Integrative Behavioral Couple Therapy (IBCT) combines strategies for acceptance and change, helping couples manage their differences and improve their relationship dynamics. This approach focuses on both emotional acceptance and practical changes. Key areas: acceptance, change, relationship dynamics, manage differences, practical changes 3 x 1 hour sessions
Reflective Listening improves communication by having partners take turns being active listeners. This technique enhances understanding and empathy, fostering healthier and more productive conversations within the relationship. Key areas: communication skills, active listening, empathy, understanding, productive conversations 3 x 1 hour sessions
Emotionally Focused Therapy (EFT) is a highly effective form of couples counseling that addresses emotional needs and attachment styles. EFT is ideal for resolving issues such as anger, loss of trust, and emotional injuries. This therapy helps couples form secure bonds, fostering long-term relationship stability. Key areas: emotional needs, attachment styles, anger issues, trust loss, secure bonds 3 x 1 hour sessions
Navigate your grief with expert bereavement counselling in London. Our caring therapists offer support and guidance to help you cope with the loss of a loved one, providing a safe space to process your emotions and begin healing. With a focus on empathetic care and personalized strategies, we aim to support you through every stage of your bereavement journey. Key areas: grief counselling, loss therapy, mourning support, bereavement therapy, emotional support, grief support, loss counselling. 3 x 1 hour sessions
Access affordable mental health support with low-cost counselling in London. Our qualified counsellors offer budget-friendly therapy sessions to help you through difficult times, including stress, anxiety, depression, and more. We believe that financial constraints should not be a barrier to receiving quality mental health care, and our services are designed to provide effective support at a manageable cost. Key areas: affordable therapy, budget counselling, cheap counselling, cost-effective therapy, economical mental health support, low-cost therapy, financial counselling support. 3 x 1 hour sessions
Description: Discover free counselling services in London to support your mental health. Our compassionate counsellors offer no-cost therapy sessions for individuals facing financial difficulties, ensuring that everyone has access to the help they need. From stress and anxiety to depression and grief, our free counselling services are designed to provide essential mental health support without the financial burden. Key areas: no-cost counselling, free therapy, mental health support, free mental health services, accessible therapy, community counselling, pro bono therapy. 3 x 1 hour sessions
Find professional counselling services in London for comprehensive mental health support. Our qualified counsellors offer personalized therapy sessions to help you overcome life's challenges, including stress, anxiety, depression, and more. With a focus on your well-being, our compassionate therapists provide the tools and support you need to lead a fulfilling life. Key areas: therapy in London, mental health counselling, psychological counselling, therapy services, London therapists, mental health support, individual therapy. 3 x 1 hour sessions
Enhance your relationship with professional relationship counselling in London. Our expert therapists offer personalized guidance to help you and your partner navigate challenges, improve communication, and strengthen your bond. Whether you're facing conflict, intimacy issues, or just need to reconnect, our supportive environment can help you achieve a healthier and happier relationship. Key areas: couples therapy, relationship therapy, relationship guidance, relationship issues, couples support, partnership counselling, conflict resolution. 3 x 1 hour sessions
This 1 day course is designed for the end user who is using or will use Office 365. This course will provide delegates with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Delegates will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course delegates will be able to effectively navigate Office 365 and make use of all of the features of Office 365 Office 365 Overview Introducing Cloud Computing Identify and Outline the Component Products in Office 365 including Outlook Web App, Office Online Apps, OneDrive and Skype for Business Navigating around Office 365 Customising the Office 365 Nav Bar Updating your Profile in Office 365 Using the Outlook Online Application Overview of Outlook Online Working with Email and Folders Outlook People and IM Contacts Using the Calendar Shared Calendars Outlook Tasks in the Web App Setting Outlook Options, Signatures, Automatic Replies and Rules Using Skype for Business Overview of Skype for Business Viewing and Setting Presence Status Using Instant Messages in Business Understanding the Interactive Contact Card in Microsoft Office Applications Integration with Outlook Using Skype for Business for Online Presentations including Content Sharing, Polls and a Virtual Whiteboard Working with OneDrive for Business What is OneDrive for Business? Navigating around OneDrive Accessing Content in OneDrive Using the Office Online Apps Sharing Documents and Collaborating Connecting Microsoft Office to OneDrive Creating Office Documents and Saving Directly to OneDrive Using Groups and Delve Introduction to Groups Collaborating using Groups Getting to Content using Delve Requirements Requirements Before attending this course, students must have: Basic understanding of Microsoft Office Basic understanding of Microsoft Windows Operating systems
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