1300 BA courses in Bradford

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

Find culturally sensitive Islamic marriage counselling in London. Our experienced counsellors provide faith-based guidance to help couples navigate marital issues within an Islamic framework. With a deep understanding of Islamic values and principles, our therapists offer tailored support to help you strengthen your marriage while honouring your faith and traditions. Key areas: Muslim marriage counselling, faith-based counselling, Islamic therapy, culturally sensitive counselling, religious counselling, faith-oriented therapy, Islamic relationship support. 3 x 1 hour sessions 

Experience transformative relationship counselling tailored specifically for singles with our exceptional package: “Relationship Counselling for Singles with Miss Date Doctor.” Discover the power of self-discovery, personal growth, and fostering healthy connections under the expert guidance of Miss Date Doctor, a renowned relationship coach. In this comprehensive package, you’ll embark on a journey of self-exploration and gain invaluable insights to enhance your dating life and prepare yourself for meaningful relationships. Our specialized approach focuses on addressing the unique challenges faced by singles in their pursuit of love and companionship. Here’s what our “Relationship Counselling for Singles with Miss Date Doctor” package Self-Discovery and Relationship Readiness Assessment: Gain a deep understanding of yourself, your values, and your relationship goals. Explore topics like self-reflection, self-awareness, and relationship readiness to align your desires with your personal growth journey. Building Confidence and Self-Esteem: Boost your confidence and develop a positive self-image. Discover strategies for overcoming insecurities and self-doubt while embracing your unique qualities. Learn and gain insight on “self-confidence exercises,” “building self-esteem,” and “self-empowerment techniques.” Effective Communication Skills: Master the art of communication to establish meaningful connections. Learn active listening techniques, assertiveness, and non-verbal communication skills. In depth coaching on the following areas “effective conversation skills,” “empathetic listening,” and “non-verbal cues in dating.” Understanding Relationship Patterns: Uncover patterns that may be hindering your dating success. Gain insights into attachment styles, relationship dynamics, and common pitfalls in dating. Explore related topics like “attachment theory,” “relationship patterns,” and “identifying toxic relationships.” Overcoming Dating Challenges: Tackle common dating obstacles with resilience and grace. Learn how to navigate rejection, deal with online dating fatigue, and manage expectations. We also teach you how to be better at “handling dating rejection,” “managing online dating burnout,” and “maintaining realistic dating expectations.” Developing Healthy Boundaries: Establish clear boundaries to protect your emotional well-being. Understand the importance of self-care, setting limits, and maintaining a healthy work-life-dating balance. Explore the following areas such as “self-care practices,” “boundary-setting in relationships,” and “maintaining work-life balance.” With our “Relationship Counselling for Singles with Miss Date Doctor” package, you’ll gain the tools and guidance necessary to navigate the dating world with confidence, authenticity, and a deeper understanding of yourself and your desires. Invest in your personal growth, enhance your dating experiences, and set the foundation for fulfilling relationships. Enroll in our transformative “Relationship Counselling for Singles with Miss Date Doctor” package today and embark on a journey toward lasting love and happiness. 3 sessions x 1 hour https://relationshipsmdd.com/product/relationship-counselling-for-singles-package/

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

The Gottman Method is a research-based approach to couples therapy that enhances intimacy and friendship while constructively addressing conflicts. Developed by Drs. John and Julie Gottman, this method includes practical exercises to improve communication and strengthen relationships. Key areas: intimacy, friendship, conflict resolution, communication skills, John Gottman, Julie Gottman 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

Your New Age London hypnotherapy includes as many as 3 powerful techniques that are used in the : Advanced Hypnosis, EFT Tapping (now made famous by the Nick Ortner books on EFT Tapping), and NLP (Neuro-Linguistic Programming). The trance-based hypnotherapy part helps to get messages through to your subconscious mind enabling you to succeed, NLP helps you think and feel from a positive perspective, and the EFT releases blocks in the path of your success. Without the underlying blocks in your path, you no longer have any reason to have bad habits or emotions, and so you can let go of them with ease.

Are you tired of feeling defeated and demotivated by rejection? Our Rejection Therapy Miss Date Doctor program is here to help you overcome your fear of rejection and take control of your life. Rejection can be a powerful force that holds us back from achieving our goals and realizing our full potential. Our program is designed to help you face your fears and develop the confidence and resilience you need to tackle any challenge that comes your way. With our Miss Date Doctor Rejection Therapy program, you’ll learn how to: Understand the root causes of your fear of rejection and develop strategies to overcome them Embrace rejection as a natural part of life and use it as a tool for personal growth Build your confidence and self-esteem through a series of exercises and challenges designed to push you out of your comfort zone Develop a growth mindset that will help you see every failure as an opportunity to learn and grow Become more resilient and adaptable in the face of adversity Our program is led by experienced coaches who have helped countless people overcome their fear of rejection and achieve their goals. With our expert guidance and support, you’ll be well on your way to developing the skills and mindset you need to succeed in all areas of your life. The Miss Date Doctor Rejection Therapy Package helps with the following areas: Rejection Therapy, fear of rejection, personal growth, confidence, self-esteem, growth mindset, failure, resilience, adaptability, experienced coaches. Improving the following areas in your life: defeated, demotivated, overcome, challenges, comfort zone, opportunity, adversity, skills, mindset, succeed. https://relationshipsmdd.com/product/rejection-therapy-package/

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 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/