3077 Courses delivered Live Online

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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Career path Career path Excel 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 Certificates Certificates Certificate of completion Digital certificate - Included

https://www.facebook.com/virtualeducators.co.uk/ https://www.instagram.com/virtualeducators.co.uk https://www.linkedin.com/groups/8980893/ https://www.tiktok.com/@virtualeducatorsltd https://www.tiktok.com/@virtualeducatorsltd https://www.youtube.com/@virtualeducatorsltd6561

Why Learn Vectorworks Spotlight Training Courses? VectorWorks Spotlight Course offers strong 2D drawing tools and lighting skills. while. Spotlight goes beyond fundamentals, offering solution for designing, modeling, and sharing entertainment projects. It's the industry standard for lighting, scenery, sets, corporate events, theater, and exhibits. Click here for more info: Website When can I book this course? 1-on-1 training. Duration: 16 hrs, Flexible scheduling (Mon to Sat, 9 am - 7 pm). Choose your own day and time. Training Course: Vectorworks Spotlight Duration: 16 hours Course Overview: I. Introduction to Vectorworks (1 hour) Overview of Vectorworks software and its diverse applications Familiarization with the user interface and navigation Customizing preferences and settings to optimize workflow II. 2D Drawing Tools (2 hours) Utilizing basic drawing tools for creating lines, rectangles, circles, and polygons Implementing text and dimension tools for annotations Applying modify tools for object editing and transformation Organizing elements using layers and classes III. 3D Modeling Tools (3 hours) Introduction to extrude, revolve, sweep, and loft tools for 3D modeling Creating 3D objects from 2D shapes for spatial representation Modifying and refining 3D models Exploration of the 3D modeling environment IV. Advanced 3D Modeling Tools (2 hours) Utilization of solid modeling tools for complex geometry creation Performing Boolean operations to combine or subtract shapes Creation and use of symbols for efficient workflow V. Introduction to Spotlight (1 hour) Overview of the Spotlight workspace and its features Adding and configuring lighting devices for stage and event design Creation and modification of lighting positions for precise placement VI. Spotlight Tools and Techniques (3 hours) Creation and editing of lighting instruments for customized setups Use of visualization tools for lighting simulations Creation and application of labels and legends for documentation Generation of worksheets and reports for lighting analysis VII. Advanced Spotlight Techniques (2 hours) Utilization of video and projection tools for multimedia presentations Incorporation of audio and sound systems for immersive experiences Understanding rigging and hoisting for stage setup Management of paperwork and documentation for effective planning VIII. Integration with Other Software (1 hour) Importing and exporting files for collaborative work with other software Utilizing Vectorworks in CAD and BIM workflows for seamless interoperability Exploration of plugins and add-ons for expanded functionality IX. Project-based Exercises (1 hour) Application of learned techniques to real-world scenarios Creation of a lighting plan for a concert or theater production Designing a 3D model of a building or interior space Free 30-day BIM & CAD Software Trial Request: Vectorworks After completing Vectorworks 2D | 3D and Spotlight Training Course? Vectorworks Proficiency: Master Vectorworks software, including interface and tools. 2D Drafting: Create precise technical drawings using fundamental 2D tools. 3D Modeling: Develop skills in 3D modeling, modification, and spatial representation. Spotlight Expertise: Learn stage and event design tools, focusing on lighting setups. Advanced Techniques: Explore complex 3D modeling and Spotlight features. Interdisciplinary Integration: Integrate Vectorworks with other software in CAD and BIM workflows. Project Application: Apply skills to real-world scenarios, creating plans and models. Job Opportunities: CAD Technician: Draft detailed plans for architecture and engineering firms. Stage Designer: Plan lighting, sound, and multimedia setups for events. Event Planner: Design event layouts with lighting and audio-visual setups. Architectural Drafter: Create accurate architectural plans and models. Interior Designer: Visualize interior spaces in 2D and 3D for clients. Lighting Designer: Specialize in various lighting applications, from buildings to stages. BIM Specialist: Work with architectural firms on Building Information Modeling projects. Freelance Designer: Offer services in 2D/3D modeling, event planning, or architectural visualization. What is Vectorworks Spotlight? Vectorworks Spotlight is a specialized package tailored for entertainment design professionals, offering both 2D and 3D capabilities. It is the industry-standard CAD software for entertainment design, ideal for lighting, scenery, sets, events, theater, and exhibits. Training Details: Duration: 16 hrs (flexible scheduling) Method: Personalized 1-on-1 training (In-person or Live Online over Zoom) Tailored content, adaptable pace, individual support Differences from Vectorworks Fundamentals: Vectorworks Fundamentals serves general modeling and drawing needs, while Spotlight provides comprehensive solutions for design, modeling, documentation, and collaborative project sharing, catering specifically to industry experts. Applications of Spotlight: Spotlights have diverse uses, including emergency situations and when a powerful light source surpassing a flashlight is required. Interior Designers and Vectorworks: Yes, interior designers use Vectorworks software, particularly Vectorworks Architect, for efficient workflow and effective realization of creative visions. Course Structure: Individualized Instruction (1-2-1) Customized Content Adaptable Learning Pace Flexible Scheduling: Monday to Saturday, 9 am to 7 pm Get Vectorworks: For more information and to download Vectorworks, visit Vectorworks Website. Individualized Training: Get personalized attention and tailored guidance during your training sessions. Flexible Timings: Select your preferred schedule and training days to fit your convenience. Post-Training Assistance: Access complimentary online support even after course completion. Comprehensive Resources: Receive detailed PDF notes and handouts for effective learning. Certification of Completion: Receive a recognition certificate upon successfully finishing the course. Affordable Pricing: Take advantage of budget-friendly training rates. Software Setup Support: Receive assistance in configuring the software on your device. Referral Benefits: Recommend a friend and enjoy discounts on upcoming courses. Group Training Offers: Benefit from special discounts for group training programs. Convenient Hours: Attend sessions from Monday to Sunday, with extended operating hours. Tailored Learning: Experience customized training designed to meet your specific requirements.

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk 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. Tailored in company 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. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. 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

If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on delivering the best customer care.

If you work with adults and young people and wish to gain a knowledge of the principles and practice of assessment as well as the practical aspects of carrying out assessment, then Level 3 Certificate in Assessing Vocational Achievement is for you.

This is a practical and immersive course for people managers which provides you with the skills, knowledge, and confidence to have effective conversations with staff about mental health and wellbeing.

Become a proficient assessor with our Level 3 Assessor CAVA course, designed to equip you with the essential skills to assess vocational competence effectively. Whether you're evaluating skills in a workshop, classroom, or training environment, this comprehensive course prepares you to guide learners through their learning journey with precision and feedback. Course Outline: Unit 301: Understanding the Principles and Practices of Assessment Unit 302: Assess Occupational Competence in the Work Environment Unit 303: Assess Vocational Skills, Knowledge, and Understanding Entry Requirements: No formal prerequisites are needed, but candidates should work in or aspire to quality assurance roles. This course is a solid foundation for those venturing into quality assurance responsibilities. Access to two learners is required for the full Award. Course Assessment: Under the guidance of your assessor, you'll compile a portfolio of evidence throughout the course. Your assessor will mark this portfolio, which will be internally quality-assured by the centre and authority. Course Fee: Online/Distance Learning: £359.99 Zoom Classroom-based Course: £479.99 Corporate or Group Booking: Benefit from special discounts on corporate or group bookings, allowing our experienced trainers to deliver tailored training at your location. How to Book: Book online via PayPal, debit/credit card, invoice, or bank transfer. You can also book over the phone or visit our office for assistance. Instant booking confirmation will be sent via email. Need Assistance? For any queries or assistance, our dedicated team is just a phone call or email away. We're here to support you every step of the way. Contact us today to embark on your journey towards becoming a certified assessor. Book Now

Introducing Private Counselling Package: Personalized Support for Your Mental and Emotional Well-Being Are you looking for private and confidential support to address personal challenges, improve your emotional well-being, and enhance your overall quality of life? Miss Date Doctor’s Private Counselling Package offers you individualized sessions with experienced therapists who are dedicated to helping you navigate life’s difficulties and achieve personal growth. Private counselling provides you with a safe and supportive environment to explore your thoughts, feelings, and concerns without judgment. Our skilled therapists are committed to understanding your unique needs and providing you with personalized guidance to promote healing and positive change. Here’s how the Private Counselling Package can support you: Personalized Assessment: Our private counsellors will conduct a thorough assessment to gain a comprehensive understanding of your unique challenges and aspirations. Individualized Approach: Your counselling sessions will be tailored to address your specific concerns, ensuring that you receive the most relevant and effective support. Emotional Support: Our therapists provide a compassionate and empathetic space where you can freely express your feelings and experiences. Confidentiality: Private counselling ensures complete confidentiality, allowing you to discuss sensitive topics with confidence and peace of mind. Coping Strategies: We’ll equip you with practical coping strategies to manage stress, anxiety, and other emotional difficulties. Self-Exploration: Private counselling encourages self-discovery and personal growth, helping you gain insights into your thoughts, behaviours, and motivations. Goal Setting: Together with your counsellor, you’ll set achievable goals to work towards positive change and improved well-being. Flexible Sessions: Private counselling offers flexibility in scheduling sessions, making it convenient for your busy lifestyle. The Private Counselling Package at Miss Date Doctor is designed to provide you with personalized support and guidance on your journey to emotional well-being and personal growth. Our skilled therapists are committed to helping you overcome challenges, enhance your resilience, and lead a more fulfilling life. Invest in your mental and emotional health and take the first step towards positive change with the Private Counselling Package. Embrace the opportunity to explore your thoughts and feelings in a confidential and supportive environment. Let our experienced counsellors guide you towards a brighter and more empowered future. 3 x 1 hour https://relationshipsmdd.com/product/private-counselling-package/

Introducing Therapy for Relationship Issues Package: Strengthening Bonds and Nurturing Healthy Connections Are you and your partner facing challenges in your relationship and seeking professional support to improve communication, resolve conflicts, and strengthen your bond? Miss Date Doctor’s Therapy for Relationship Issues Package offers you expert guidance to navigate difficulties, foster intimacy, and build a healthier, more fulfilling partnership. Relationships can encounter various obstacles that impact communication, trust, and emotional connection. Our experienced therapists specialize in working with couples and are dedicated to helping you and your partner overcome challenges and cultivate a more loving and harmonious relationship. Here’s how the Therapy for Relationship Issues Package can support you: Effective Communication: Our therapists will help you and your partner improve communication skills, fostering a deeper understanding of each other’s needs and emotions. Conflict Resolution: Relationship therapy addresses conflict resolution strategies, assisting you in navigating disagreements constructively and preventing recurring conflicts. Rebuilding Trust: If trust has been compromised, our therapists will guide you in rebuilding trust and creating a more secure emotional bond. Emotional Intimacy: We’ll explore ways to enhance emotional intimacy and create a more fulfilling emotional connection between you and your partner. Addressing Past Issues: Relationship therapy can address unresolved issues from the past that may be affecting your present relationship dynamics. Identifying Patterns: Our therapists will help you and your partner identify negative patterns of behaviour or communication, fostering healthier interactions. Shared Goals: We’ll assist you in exploring and aligning your shared goals and aspirations, ensuring that you are on the same page about your future together. Renewing Affection: Therapy for relationship issues can help rekindle affection and emotional closeness between you and your partner. The Therapy for Relationship Issues Package at Miss Date Doctor is designed to empower you and your partner to build a stronger foundation for your relationship. Our skilled therapists provide a safe and supportive space for open and honest dialogue, allowing you to work towards a more fulfilling and harmonious partnership. Invest in the well-being of your relationship and take the first step towards a healthier and more loving connection with the Therapy for Relationship Issues Package. Embrace the opportunity to strengthen your bond, improve communication, and create a lasting and satisfying relationship. Let our experienced therapists guide you and your partner towards a brighter future filled with love, understanding, and mutual support. 3 x 1 hour sessions https://relationshipsmdd.com/product/therapy-for-relationship-issues-package/