• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

869 Courses delivered Live Online

Our School Child Sleep Workshop

By Millpond Childrens Sleep Clinic

Our one-day interactive workshop for the school aged child is suitable for all staff working in the school setting. We explore a wide range of common sleep difficulties and sleep disorders in school children and young people including children with SEND and neuro diversities. Based in the most up-to-date evidence and science, we discuss responsive gentle sleep strategies to enable professionals to develop their theoretical and practical understanding of how to assess, manage and adapt techniques for a range of sleep difficulties Following the workshop, participants will be able to offer preventative intervention and share practical strategies to support sleep, with both parents and young people. Millpond Training’s sleep awareness day has been fully accredited for 6 CPD Hours by The CPD Certification Service; “This is a good course delivering clear learning value. It has a well-written and engaging presentation and a variety of activities and tasks to aid interactivity and learner engagement.” Workshop Aims To provide community staff with up-to-date evidence-based knowledge to develop their theoretical and practical understanding of sleep needs; sleep patterns; sleep cycles and common difficulties. To support community staff to enhance their confidence, skills and knowledge base in providing guidance to parents and young people regarding sleep difficulties. To provide an overview of evidence-based interventions used to help behavioural sleep difficulties in the school aged child and young people. Learning Outcomes By the end of the day delegates will be able to: Understand typical sleep regulations, sleep needs and sleep cycles. Understand common sleep difficulties in the school aged child. Provide education to families on establishing good sleep hygiene, and provide anticipatory advice in the prevention of sleep difficulties. Understand how to undertake sleep assessments, incorporating a sleep history and the use of a sleep diary. Gain an understanding of common sleep interventions used to help behavioural sleep difficulties.

Our School Child Sleep Workshop
Delivered OnlineFlexible Dates
£168

MD-102T00 Microsoft 365 Endpoint Administrator

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for The Microsoft 365 Endpoint Administrator is responsible for deploying, configuring, securing, managing, and monitoring devices and client applications in a corporate setting. Their duties include managing identity, access, policies, updates, and apps. They work alongside the M365 Enterprise Administrator to develop and execute a device strategy that aligns with the requirements of a modern organization. Microsoft 365 Endpoint Administrators should be well-versed in M365 workloads and possess extensive skills and experience in deploying, configuring, and maintaining Windows 11 and later, as well as non-Windows devices. Their role emphasizes cloud services over on-premises management technologies. In this course, students will learn to plan and execute an endpoint deployment strategy using contemporary deployment techniques and implementing update strategies. The course introduces essential elements of modern management, co-management approaches, and Microsoft Intune integration. It covers app deployment, management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Microsoft Entra ID, Azure Information Protection, and Microsoft Defender for Endpoint are explored to protect devices and data. Prerequisites The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 11 and later, and non-Windows devices. 1 - Explore the Enterprise Desktop Examine benefits of modern management Examine the enterprise desktop life-cycle model Examine planning and purchasing Examine desktop deployment Plan an application deployment Plan for upgrades and retirement 2 - Explore Windows Editions Examine Windows client editions and capabilities Select client edition Examine hardware requirements 3 - Understand Microsoft Entra ID Examine Microsoft Entra ID Compare Microsoft Entra ID and Active Directory Domain Services Examine Microsoft Entra ID as a directory service for cloud apps Compare Microsoft Entra ID P1 and P2 plans Examine Microsoft Entra Domain Services 4 - Manage Microsoft Entra identities Examine RBAC and user roles in Microsoft Entra ID Create and manage users in Microsoft Entra ID Create and manage groups in Microsoft Entra ID Manage Microsoft Entra objects with PowerShell Synchronize objects from AD DS to Microsoft Entra ID 5 - Manage device authentication Describe Microsoft Entra join Examine Microsoft Entra join prerequisites limitations and benefits Join devices to Microsoft Entra ID Manage devices joined to Microsoft Entra ID 6 - Enroll devices using Microsoft Configuration Manager Deploy the Microsoft Configuration Manager client Monitor the Microsoft Configuration Manager client Manage the Microsoft Configuration Manager client 7 - Enroll devices using Microsoft Intune Manage mobile devices with Intune Enable mobile device management Explain considerations for device enrollment Manage corporate enrollment policy Enroll Windows devices in Intune Enroll Android devices in Intune Enroll iOS devices in Intune Explore device enrollment manager Monitor device enrollment Manage devices remotely 8 - Execute device profiles Explore Intune device profiles Create device profiles Create a custom device profile 9 - Oversee device profiles Monitor device profiles in Intune Manage device sync in Intune Manage devices in Intune using scripts 10 - Maintain user profiles Examine user profile Explore user profile types Examine options for minimizing user profile size Deploy and configure folder redirection Sync user state with Enterprise State Roaming Configure Enterprise State Roaming in Azure 11 - Execute mobile application management Examine mobile application management Examine considerations for mobile application management Prepare line-of-business apps for app protection policies Implement mobile application management policies in Intune Manage mobile application management policies in Intune 12 - Deploy and update applications Deploy applications with Intune Add apps to Intune Manage Win32 apps with Intune Deploy applications with Configuration Manager Deploying applications with Group Policy Assign and publish software Explore Microsoft Store for Business Implement Microsoft Store Apps Update Microsoft Store Apps with Intune Assign apps to company employees 13 - Administer endpoint applications Manage apps with Intune Manage Apps on non-enrolled devices Deploy Microsoft 365 Apps with Intune Additional Microsoft 365 Apps Deployment Tools Configure Microsoft Edge Internet Explorer mode App Inventory Review 14 - Protect identities in Microsoft Entra ID Explore Windows Hello for Business Deploy Windows Hello Manage Windows Hello for Business Explore Microsoft Entra ID Protection Manage self-service password reset in Microsoft Entra ID Implement multi-factor authentication 15 - Enable organizational access Enable access to organization resources Explore VPN types and configuration Explore Always On VPN Deploy Always On VPN 16 - Implement device compliance Protect access to resources using Intune Explore device compliance policy Deploy a device compliance policy Explore conditional access Create conditional access policies 17 - Generate inventory and compliance reports Report enrolled devices inventory in Intune Monitor and report device compliance Build custom Intune inventory reports Access Intune using Microsoft Graph API 18 - Deploy device data protection Explore Windows Information Protection Plan Windows Information Protection Implement and use Windows Information Protection Explore Encrypting File System in Windows client Explore BitLocker 19 - Manage Microsoft Defender for Endpoint Explore Microsoft Defender for Endpoint Examine key capabilities of Microsoft Defender for Endpoint Explore Windows Defender Application Control and Device Guard Explore Microsoft Defender Application Guard Examine Windows Defender Exploit Guard Explore Windows Defender System Guard 20 - Manage Microsoft Defender in Windows client Explore Windows Security Center Explore Windows Defender Credential Guard Manage Microsoft Defender Antivirus Manage Windows Defender Firewall Explore Windows Defender Firewall with Advanced Security 21 - Manage Microsoft Defender for Cloud Apps Explore Microsoft Defender for Cloud Apps Planning Microsoft Defender for Cloud Apps Implement Microsoft Defender for Cloud Apps 22 - Assess deployment readiness Examine deployment guidelines Explore readiness tools Assess application compatibility Explore tools for application compatibility mitigation Prepare network and directory for deployment Plan a pilot 23 - Deploy using the Microsoft Deployment Toolkit Evaluate traditional deployment methods Set up the Microsoft Deployment Toolkit for client deployment Manage and deploy images using the Microsoft Deployment Toolkit 24 - Deploy using Microsoft Configuration Manager Explore client deployment using Configuration Manager Examine deployment components of Configuration Manager Manage client deployment using Configuration Manager Plan in-place upgrades using Configuration Manager 25 - Deploy Devices using Windows Autopilot Use Autopilot for modern deployment Examine requirements for Windows Autopilot Prepare device IDs for Autopilot Implement device registration and out-of-the-box customization Examine Autopilot scenarios Troubleshoot Windows Autopilot 26 - Implement dynamic deployment methods Examine subscription activation Deploy using provisioning packages Use Windows Configuration Designer Use Microsoft Entra join with automatic MDM enrollment 27 - Plan a transition to modern endpoint management Explore using co-management to transition to modern endpoint management Examine prerequisites for co-management Evaluate modern management considerations Evaluate upgrades and migrations in modern transitioning Migrate data when modern transitioning Migrate workloads when modern transitioning 28 - Manage Windows 365 Explore Windows 365 Configure Windows 365 Administer Windows 365 29 - Manage Azure Virtual Desktop Examine Azure Virtual Desktop Explore Azure Virtual Desktop Configure Azure Virtual Desktop Administer Azure Virtual Desktop Additional course details: Nexus Humans MD-102T00 : Microsoft 365 Endpoint Administrator training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the MD-102T00 : Microsoft 365 Endpoint Administrator course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

MD-102T00 Microsoft 365 Endpoint Administrator
Delivered OnlineFlexible Dates
£2,975

Diploma in Visual Effects for Film and Television Animation

By ATL Autocad Training London

Who is this course for? The Diploma in Visual Effects for Film and Television Animation is tailored for individuals aspiring to work in the Visual Effects, TV, Film, and 3D animation industry. Gain essential skills necessary for a successful career in these fields. Click here for more info: Website Duration: 120 hours of 1-on-1 Training. When can I book: 9 am - 4 pm (Choose your preferred day and time once a week). Monday to Saturday: 9 am - 7 pm (Flexible timing with advance booking).  Course Overview for a 120-Hour Diploma Program in Game Design and Development Term 1: Introduction to Game Design and 3D Modeling (40 hours) Module 1: Introduction to Game Design (1 hour) Understanding the game development industry and current trends Exploring game mechanics and fundamental design principles Introduction to the game engines and tools utilized in the program Module 2: 3D Modeling with 3ds Max (25 hours) Familiarization with 3ds Max and its user interface Mastering basic modeling techniques like box modeling and extrusion Advanced modeling skills including subdivision and topology Texturing and shading techniques tailored for game development Module 3: Character Design and Animation (10 hours) Introduction to character design and its developmental process Creating and rigging characters specifically for games Keyframe animation techniques for character movement Term 2: Game Development and Unity 3D (40 hours) Module 4: Unity 3D Basics (20 hours) Navigating Unity 3D and understanding its interface Grasping fundamental game development concepts within Unity Creating game objects, writing scripts, and designing scenes Introduction to scripting using C# Module 5: Advanced Game Development with Unity 3D (10 hours) Constructing game mechanics including UI, scoring, and game states Working with physics and collision systems in Unity Crafting intricate game environments and level designs Module 6: Game Assets with Photoshop (10 hours) Exploring Photoshop tools and features for game asset creation Crafting game elements such as textures, sprites, and icons Optimizing assets for seamless integration into game development Term 3: Advanced Game Design and Portfolio Development (40 hours) Module 7: Advanced Game Design (20 hours) Delving into advanced game design concepts like balancing and difficulty curves Understanding player psychology and methods for engaging audiences Implementing game analytics and user testing for refinement Module 8: Portfolio Development (24 hours) Building a comprehensive portfolio showcasing acquired skills Effective presentation techniques for showcasing work Establishing a professional online presence and networking strategies Final Project: Creating and presenting a collection of best works in collaboration with tutors and fellow students Please note: Any missed sessions or absence without a 48-hour notice will result in session loss and a full class fee charge due to the personalized one-to-one nature of the sessions. Students can request pauses or extended breaks by providing written notice via email. What can you do after this course: Software Proficiency: Master industry-standard design tools for architectural and interior projects. Design Expertise: Develop a deep understanding of design principles and spatial concepts. Visualization Skills: Acquire advanced 2D/3D rendering and virtual reality skills for realistic design representation. Communication and Collaboration: Enhance communication skills and learn to collaborate effectively in design teams. Problem-Solving: Develop creative problem-solving abilities for real-world design challenges. Jobs and Career Opportunities: Architectural Visualizer Interior Designer CAD Technician Virtual Reality Developer 3D Modeler Project Coordinator Freelance Designer Visualization Consultant Students can pursue these roles, applying their expertise in architectural and interior design across various professional opportunities. Course Expectations: Maintain a dedicated notebook to compile your study notes. Schedule makeup sessions for any missed coursework, subject to available time slots. Keep meticulous notes and maintain a design folder to track your progress and nurture creative ideas. Allocate specific time for independent practice and project work. Attain certification from the esteemed professional design team. Post-Course Proficiencies: Upon successful course completion, you will achieve the following: Develop confidence in your software proficiency and a solid grasp of underlying principles. Demonstrate the ability to produce top-tier visuals for architectural and interior design projects. Feel well-prepared to pursue positions, armed with the assurance of your software expertise. Continued Support: We are pleased to offer lifetime, complimentary email and phone support to promptly assist you with any inquiries or challenges that may arise. Software Accessibility: Access to the required software is available through either downloading it from the developer's website or acquiring it at favorable student rates. It is important to note that student software should be exclusively utilized for non-commercial projects. Payment Options: To accommodate your preferences, we provide a range of payment options, including internet bank transfers, credit cards, debit cards, and PayPal. Moreover, we offer installment plans tailored to the needs of our students. Course Type: Certification. Course Level: Basic to Advanced. Time: 09:00 or 4 pm (You can choose your own day and time once a week) (Monday to Friday, 09 am to 7 pm, you can choose anytime by advance booking. Weekends can only be 3 to 4 hrs due to heavy demand on those days). Tutor: Industry Experts. Total Hours: 120 Price for Companies: £3500.00 (With VAT = £4200) For Companies. Price for Students: £3000.00 (With VAT = £3600) For Students.

Diploma in Visual Effects for Film and Television Animation
Delivered in London or OnlineFlexible Dates
£4,320

Developing Mental Health Awareness

By Starling

Boost your knowledge of mental health and gain insights to enable you to understand the stigma, recognise common issues, learn self-care strategies for wellbeing, and build confidence to assist those facing mental health challenges.

Developing Mental Health Awareness
Delivered OnlineFlexible Dates
£95

Sketchup and Stable Diffusion Rendering Course

By Real Animation Works

1-2-1 bespoke training course

Sketchup and Stable Diffusion Rendering Course
Delivered in London or OnlineFlexible Dates
£1,200

Using Canva to Create Content

5.0(1)

By Let’s Do Business Group

Want to learn how to create eye-catching and engaging graphics for your business? Join our Using Canva workshop to find out how to utilise the online graphic design platform Canva to make everything from your company branding to social media posts and more! Event details: Time: 10am – 11:30am Location: Online (ZOOM) Cost: £25pp In this course, we’ll cover everything from: How to sign up and get set up on the platform How to navigate Canva as a beginner Creating a brand kit for your business Creating a new graphic together for a campaign for a business Walkthrough of all the basic features of Canva Resizing designs to make posters and leaflets  As part of the live event of this workshop, we will also have a Questions and Answers session to finish this online workshop, where participants can ask specific questions about how to use Canva for their business. Meet the Host: Kerry Madge | Marketing Executive, Let's Do Marketing Kerry Madge is a dynamic Marketing Executive at Let's Do Marketing, bringing nearly six years of diverse experience collaborating with businesses of all sizes. Holding a BA in Marketing Management, Kerry excels in social media advertising, graphic design, and copywriting. Her passion lies in crafting creative solutions and developing comprehensive marketing strategies that empower small businesses to visualise and achieve their overarching goals. Privacy Notice By registering for this event, you agree to Let’s Do Business Group processing and managing your personal data in accordance with our Privacy Policy. Your data will only be used for the purposes of managing your event registration and any relevant communications.

Using Canva to Create Content
Delivered Online
£25

Dermatology Update

By BBO Training

Dermatology focused days have been offered by BBO Training since 2017; we are delighted to be work together with Dermatology Education Partnership Ltd as training providers. The Dermatology Update for Primary Care is particularly relevant for GPs and primary care nurses (and pharmacists) who wish to update knowledge on dermatology care, including evidence-based practice and guidance. You will see the programme moves you through from knowledge and guidance/guidelines updates to patient and practical aspects to then seeing how you can incorporate this knowledge into practice at a local level. The new skills you will learn will enhance patient care and may reduce secondary care referrals. The importance of dermatology care and promotion of skin health is essential in general practice. The Primary Care Dermatology Society states that 10-15% of the primary care workload involves dermatology and that many common skin conditions are managed entirely within the practice setting. This workload continues to increase as on-going changes in funding and the NHS structure move more patient care into the community. Chronic skin conditions have a psychological impact on life and healthy living. Supporting and helping patients with self-management is often the key to treatment success. The Dermatology Update for Primary Care programme is attached together with tear off application slip, which should be returned to me at the above address. The day will be led by Julie Van Onselen, a dermatology adviser, trainer and educator who has 25 years experience as a dermatology nurse practitioner. Frankie Brown will be organising and facilitating the day. Learning Outcomes for 'Dermatology Update' Day for Primary Care Practitioners By the completion of the 'Dermatology Update' Day, attendees, who are experienced and registered healthcare professionals, should be able to: 1. Enhanced Clinical Knowledge and Guidelines Understanding: - Demonstrate a comprehensive understanding of the latest evidence-based information regarding facial skin conditions, including eczema, psoriasis, and other common dermatological concerns. - Synthesize and apply updated clinical guidelines to effectively diagnose and manage facial skin conditions in primary care settings. 2. Application of Evidence-Based Practices: - Apply the acquired knowledge to make informed and evidence-based decisions in the treatment and management of eczema, psoriasis, and other facial skin conditions. - Utilize current guidelines to guide the prescription of appropriate treatment modalities, taking into consideration patient-specific factors  3. Advanced Treatment and Management Strategies: - Assess a wide range of treatment and management options for acne, eczema, and psoriasis, and demonstrate an improved ability to tailor interventions to individual patient needs. - Enhance clinical confidence in recommending suitable therapeutic approaches that align with the latest medical advancements. 4. Enhanced Recognition of Skin Lesions: - Differentiate between various types of benign skin lesions, showcasing improved proficiency in identifying and classifying these conditions accurately. - Display a heightened ability to identify potential indicators of pre-cancerous and skin cancer lesions, enabling timely referrals and appropriate patient management. 5. Introduction to Dermoscopy and Practical Application: - Describe the fundamental principles of dermoscopy and its role in enhancing diagnostic accuracy for various skin conditions. - Participate in a practical dermoscopy session, applying learned techniques to recognize key dermoscopic patterns and features.   6. Confidence in Practical Dermatology Skills: - Demonstrate an increased level of confidence in approaching cases involving facial skin conditions, benign skin lesions, and potential skin cancer concerns. - Employ acquired practical skills, such as dermoscopy, to improve diagnostic accuracy and patient outcomes. 7. Effective Communication and Patient Education: - Communicate effectively with patients regarding diagnosis, treatment plans, and potential outcomes for various facial skin conditions. - Exhibit improved skills in educating patients about self-care strategies, treatment adherence, and monitoring their condition over time. 8. Holistic Patient Care: - Understand the psychosocial impact of facial skin conditions on patients and their quality of life, and integrate this knowledge into patient-centered care strategies. - Approach patient care with a holistic mindset, addressing medical, emotional, and psychological aspects of dermatological conditions. By actively engaging in the 'Dermatology Update' Day, attendees will not only augment their clinical knowledge and skills but also enhance their ability to provide comprehensive and evidence-based care to patients with various dermatological concerns in primary care settings.

Dermatology Update
Delivered OnlineFlexible Dates
£180

M.D.D REJECTION THERAPY PACKAGE (SELF IMPROVEMENT)

4.9(27)

By Miss Date Doctor Dating Coach London, Couples Therapy

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/

M.D.D REJECTION THERAPY PACKAGE (SELF IMPROVEMENT)
Delivered in London or UK Wide or OnlineFlexible Dates
£600

SINGLE PARENT COACHING PACKAGE (SINGLES)

4.9(27)

By Miss Date Doctor Dating Coach London, Couples Therapy

Talk through problems Check up call Help with single parenting dating issue Dating advice Your own coach for 3 weeks Mini sessions Depression and stress relief strategies 30 mins x 2 per week for 3 weeks Support and anxiety issues addressed Time convenience coaching Phone sessions Dating advice for singles https://relationshipsmdd.com/product/single-parent-coaching-package/

SINGLE PARENT COACHING PACKAGE (SINGLES)
Delivered in London or UK Wide or OnlineFlexible Dates
£250

Programming and Data Wrangling with VBA and Excel

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Programming and Data Wrangling with VBA and Excel
Delivered OnlineFlexible Dates
£885