385 Courses in Edinburgh

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

Level 2 Diploma NVQ in Drilling Operations - Land Drilling - Support Operative

Level 2 NVQ Certificate in Highways Maintenance - Kerbs and Channels

The five day National Vocational Beach Lifeguard Qualification (NVBLQ) will provide the learner with the knowledge and skills required in order to provide professional patrolling and water services, in surf conditions, with rescue skills and advanced fitness requirements. Many aspects of the course are physically demanding and WILL include running, swimming to set times and some lifting. This award is comprised of a variety of units and all must be successfully passed to attain the qualification.

Address negative behavioural patterns Treat anxiety and depression symptoms Resolve bad temper and aggression issues Teaching coping skills for dealing with different problems Stop negative cycles Manage anxiety better Help mental health and physical health problems Management of thoughts, emotions, actions Help with insomnia Address problematic thought patterns This package is for people with bad behaviour PTSD Alcohol misuse 6 sessions https://relationshipsmdd.com/product/cognitive-behavioural-therapy-package/

An overview of catheter care as an effective intervention in infection prevention and controlled continence care. Allowing participants to demonstrate theoretical and practical competencies within a classroom environment.

Relationship coaching for your relationship skills can be done individually or as a couple Emotional intelligence training Learn how to be a strong couple Love Language training Learn how to improve rapport and empathy Emotional validation and emotional civility training Consideration and patience training Conflict Resolution and self management Free check in calls in between sessions Choose one of our office locations to have your sessions 1 hour per week 3 sessions https://relationshipsmdd.com/product/relationship-coach-london-package/

Introducing Adjustment Counselling Package: Navigating Life Transitions and Embracing Change Are you facing challenges in adjusting to major life transitions and seeking support to cope with change? Miss Date Doctor’s Adjustment Counselling Package offers you a compassionate and understanding space to navigate through life’s adjustments and embrace positive transformation. Life transitions, such as moving to a new city, starting a new job, or going through significant life changes, can be overwhelming and emotionally taxing. Our experienced counsellors are here to help you navigate these adjustments, find coping strategies, and embrace change with resilience and optimism. Here’s how the Adjustment Counselling Package can support you: Understanding Transitions: Our counsellors will help you understand the nature of the life transition you are experiencing and its impact on your emotions and well-being. Coping with Change: Adjustment counselling equips you with coping strategies to manage stress, anxiety, and uncertainty during times of change. Supportive Environment: Our counsellors provide a safe and non-judgmental space where you can freely express your feelings and concerns related to the adjustment process. Finding Balance: We’ll work with you to find a balance between embracing change and maintaining stability in other areas of your life. Creating a Support System: Adjustment counselling helps you identify and build a support system to lean on during times of transition. Growth and Resilience: As you navigate through adjustments, our counsellors will help you discover strengths and develop resilience to embrace change positively. Setting Realistic Expectations: We’ll assist you in setting realistic expectations for yourself during the adjustment period, fostering self-compassion and patience. Embracing New Opportunities: Adjustment counselling can help you see transitions as opportunities for growth and new experiences. The Adjustment Counselling Package at Miss Date Doctor is designed to empower you to navigate life’s transitions with grace and confidence. Our compassionate counsellors provide guidance and support to help you find stability, embrace change, and thrive through life’s adjustments. Invest in your well-being and take the first step towards embracing change with the Adjustment Counselling Package. Embrace the opportunities for growth and transformation that life transitions bring. Let our skilled counsellors guide you towards a more resilient, positive, and fulfilling journey through life’s adjustments. 3 x 1 hour https://relationshipsmdd.com/product/adjustment-counselling-package/

Introducing Therapy for Trauma Package: Empowering Healing and Renewed Strength Have you experienced a traumatic event that continues to affect your life, leaving you with emotional wounds and distressing memories? Miss Date Doctor’s Therapy for Trauma Package offers you compassionate and specialized support to navigate the healing journey, fostering resilience, and reclaiming your life. Trauma can have a profound impact on your mental and emotional well-being, often leading to feelings of fear, anxiety, and helplessness. Our experienced therapists are dedicated to providing a safe and supportive space for you to process your trauma, empowering you to find strength and renewal in the face of adversity. Here’s how the Therapy for Trauma Package can support you: Safe and Non-Judgmental Environment: We offer a safe and non-judgmental space where you can share your trauma experiences without fear. Trauma-Informed Approach: Our therapists are trained in trauma-informed care, recognizing the unique needs and sensitivities of trauma survivors. Processing Traumatic Memories: Therapy will focus on helping you process and integrate traumatic memories in a healthy and manageable way. Emotional Regulation: We’ll work on emotional regulation techniques to help you cope with intense emotions related to trauma. Creating Coping Strategies: Therapy for trauma equips you with coping strategies to manage triggers and promote emotional well-being. Rebuilding Trust and Safety: If applicable, we’ll address issues of trust and safety, helping you feel more secure in your environment. Supportive Healing: Our therapists will guide you towards healing and recovery at a pace that feels comfortable for you. Post-Traumatic Growth: We’ll focus on fostering post-traumatic growth, empowering you to find strength and meaning from your experiences. The Therapy for Trauma Package at Miss Date Doctor is designed to support your healing journey and empower you to overcome the impact of trauma. Our compassionate therapists are committed to walking alongside you on this path of renewal and resilience. Invest in your emotional well-being and take the first step towards healing with the Therapy for Trauma Package. Embrace the opportunity to process your trauma, find renewed strength, and reclaim your life after adversity. Let our experienced therapists guide you towards emotional healing, growth, and a brighter future beyond trauma. 5 X 1 hour sessions https://relationshipsmdd.com/product/therapy-for-trauma-package/