2255 BA courses in London

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

Introducing Therapy for Rumination Package: Breaking Free from Overthinking and Cultivating Mindful Awareness Are you struggling with rumination, finding it challenging to break free from repetitive and intrusive thoughts that lead to stress and anxiety? Miss Date Doctor’s Therapy for Rumination Package offers you expert support and guidance to manage overthinking and cultivate a more mindful and present-focused mindset. Rumination involves getting caught in a cycle of obsessive thoughts and excessive self-reflection, often leading to emotional distress. Our experienced therapists are dedicated to helping you understand and address rumination, enabling you to regain control of your thoughts and emotions. Here’s how the Therapy for Rumination Package can support you: Understanding Rumination: Our therapists will help you understand the nature of rumination and its impact on your emotional well-being. Cognitive Restructuring: We’ll work on cognitive restructuring techniques to challenge negative thought patterns and replace them with more constructive and balanced thinking. Mindfulness Practices: Therapy for rumination includes mindfulness exercises to help you cultivate present-focused awareness and reduce excessive thinking. Emotional Regulation: Our therapists will guide you in developing effective strategies to manage and regulate emotions triggered by rumination. Breaking the Cycle: We’ll assist you in breaking free from the cycle of rumination, preventing its negative effects on your mental and emotional health. Positive Coping Mechanisms: Therapy will focus on helping you develop positive coping mechanisms to manage stress and anxiety more effectively. Self-Compassion: We’ll encourage self-compassion and self-care practices to promote emotional healing and well-being. Goal Setting: Together with your therapist, you’ll set achievable goals to work towards reducing rumination and fostering a more balanced thought process. The Therapy for Rumination Package at Miss Date Doctor is designed to empower you to manage overthinking and create a more mindful and present-oriented mindset. Our compassionate therapists provide a safe and supportive space to explore your thought patterns, allowing you to work towards emotional healing and inner peace. Invest in your mental well-being and take the first step towards breaking free from rumination with the Therapy for Rumination Package. Embrace the opportunity to cultivate mindfulness, reduce stress, and foster a more balanced and positive thought process. Let our experienced therapists guide you towards a brighter and more emotionally fulfilling future, free from the burden of rumination. 4 x 1 hour sessions https://relationshipsmdd.com/product/therapy-for-rumination-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

Business Relationship Management Fundamentals: In-House Training Business Relationship Management (BRM) Fundamentals introduces BRM as a capability, role, and discipline. What you will Learn Participants can expect an interactive and lively one-day session, with a high-level introduction to successfully navigate the complexity of BRM. Topics include: Defining BRM as a capability, role, and discipline Understanding what a BRM does and does not do Providing the language needed to change perceptions and perspectives Learn how the BRM discipline interacts with other disciplines (project management, architecture, Business Analysts, Business functions, strategy, etc.) inside an organization Basic introduction to the different frameworks, processes, and models to bring structure and guidance to BRM Introductions Why BRM? BRM defined BRM in action BRM value Reflection and next steps Resources

Business Relationship Management Fundamentals Business Relationship Management (BRM) Fundamentals introduces BRM as a capability, role, and discipline. What you will Learn Participants can expect an interactive and lively one-day session, with a high-level introduction to successfully navigate the complexity of BRM. Topics include: Defining BRM as a capability, role, and discipline Understanding what a BRM does and does not do Providing the language needed to change perceptions and perspectives Learn how the BRM discipline interacts with other disciplines (project management, architecture, Business Analysts, Business functions, strategy, etc.) inside an organization Basic introduction to the different frameworks, processes, and models to bring structure and guidance to BRM Introductions Why BRM? BRM defined BRM in action BRM value Reflection and next steps Resources

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/

VoIP and IP Telephony training course description A concise overview course for management covering voice communications using IP networks. The course focuses on how VoIP works at a simplified level enabling delegates to recognise the key decisions to be made when implementing VoIP. What will you learn Describe the key buzzwords used in the VoIP arena. Explain how VoIP and IPT work (at a simplified level). Describe the issues of providing a converged architecture. Recognise the key decisions to be made when implementing VoIP VoIP and IP Telephony training course details Who will benefit: Anyone, although the course is particularly aimed at non-technical personnel needing some knowledge of VoIP. Prerequisites: Network fundamentals Duration 1 day VoIP and IP Telephony training course contents Introduction What is VoIP, brief review of IP, brief review of telephones, voice and signalling. VoIP issues Bandwidth, Delay, Jitter. Voice coding and compression, packetising voice, comparison of techniques, MOS.IP performance and QoS. The need for QoS, prioritising voice. Architectures Hard phones, soft phones, video phones, desktop, backbone, gateway, integrating analog phones and PCs, carriers, Softswitches. VoIP protocol stack RTP, RTCP. H.323 vs SIP, other signalling protocols. H.323 Architecture, Call setup, Gatekeepers. SIP Comparison with H.323, SIP proxy, proxy servers, redirect servers, location servers. MGCP and MegaCo Carrier networks, PSTN breakout, SS7 gateways, MGCP, Megaco. IP PBXs Integrating IP into 'normal' PBXs, IP PBXs, Asterisk. UM, other telephony applications.

Peering demystified training course description A concise overview course covering The Internet and peering. Particular emphasis is placed on the structure of the Internet, how IXs benefit the Internet, IX architectures, peering and the technical buzzwords behind the IX services. What will you learn Describe the structure of the Internet Explain the role of RIPE, ARIN and IXs in the Internet Explain how IXs connect ISPs and the benefits of using IXs. Describe peering from a technical perspective including the role of BGP and AS's. Peering demystified training course details Who will benefit: Non technical staff working for Internet companies. Prerequisites: None. Duration 1 day Peering demystified training course contents IP and routers IP as glue. What is a router? How routers join networks, benefits and disadvantages of routers, default gateways, routing tables, routing protocols. Addressing IP address format, rules of IP addressing, where to get IP addresses. Subnetting and groups of IP addresses. The Internet What is the Internet? The big picture, IP basics, registering IP addresses, DNS and registering domain names, whois, The IAB, IANA, ICANN, RIPE and other Internet organisations. ISPs Top ISPs, Tier 1, Tier 2 and Tier 3 ISPs, backbone providers, circuit providers, content providers, virtual ISPs, the internal network of ISPs. Customer connections to ISPs (DSL, Leased lines, MPLS…) ISP to ISP connections: Peering points Public peering versus private peering, NAPs, Internet Exchanges, Metropolitan Area Exchanges, LINX, other major peering points, the geography of the Internet. BGP and ASNs. How to peer. IRRs. IX architecture Ethernet switching.

BGP training course description A study of BGP for non engineers working in the Internet. The course starts with a review of the basics of routers and routing tables and then moves on to a simple overview of how BPG works with a focus on BGP metrics influencing the route traffic takes through the Internet. Hands on with routers follow the major sessions to reinforce the theory. Note these hands on sessions are more demonstrations by the trainer but some can be followed along and done by delegates (e.g. looking at Internet routing tables.) What will you learn Explain how routing tables influence Internet traffic. Describe how BGP works. Explain the methods BGP can use to influence Internet traffic. Use traceroute, peeringdb, route collectors and looking glasses to analyse traffic flows. Explain the difference between bi lateral and multilateral peering using a route server. BGP training course details Who will benefit: Non technical staff wishing to know more about BGP. Prerequisites: None. Duration 1 day BGP training course contents Networks, routers and routing tables What is a network, what is a router, routing tables, static routes, routing protocols. When an ISP uses static routes and when they use BGP. IP addresses, subnet masks, groups of IP addresses. IPv6. Hands on: Showing a full routing table. Seeing traceroute being used. Basic BGP What's BGP? BGP versus other routing protocols, ASs, AS numbers. RIPE database, peeringdb. Hands on: Finding AS numbers. Showing simple BGP configuration and routing tables in an EVENG example. How BGP works Simple walk through of BGP incremental updates and how routes change when links go down. Hands on: Showing packets and route changes when a link goes down/comes up. BGP path selection Transit, peering, routing policy and route filtering. Longest matching rule in routing tables, route selection order, Local preference, AS prepend, MEDs. Hands on: Seeing BGP influencing traffic. Looking at peering policies in RIPE and peeringdb. Route servers What are route servers? LINX route servers, route server policy control and communities, What are route collectors, Looking glasses. Hands on: Seeing the LINX route server details in peeringdb, using a looking glass.