- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
Certified Kanban System Design – KMP I - 24-26 September
By Tom Reynolds
Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company
Certified Kanban System Design – KMP I - 19-21 November
By Tom Reynolds
Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company
Certified Kanban System Design – KMP I - 17-19 December
By Tom Reynolds
Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company
VBA with Microsoft Excel
By Nexus Human
Duration 1 Days 6 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 Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 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 so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. 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 Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) 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 VBA with Microsoft Excel (v1.2) 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.
Podiatry: Foot Health Practitioner & Physiotherapy - CPD Certified
(47)By Academy for Health and Fitness
24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Every step we take tells a story, but for many, that story is marred by discomfort, pain, or embarrassment due to foot issues. Foot health is more than just aesthetics; it's integral to our overall well-being. In the UK, around 2.7 million people suffer from foot pain at any given time. With our Podiatry: Foot Health Practitioner (FHP) & Physiotherapy bundle, you won't just be treating feet - you'll be transforming lives, one step at a time. Whether it's advising on the right footwear, addressing specific foot issues, or preventing potential future problems, you'll be at the forefront of foot health. This unique podiatry programme combines four valuable qualifications: foot health practitioner training, physiotherapy, pain management techniques, and acupressure massage therapy. You'll gain a deep understanding of the foot and ankle, learn to diagnose and treat common foot conditions, and explore effective pain management strategies. Additionally, you'll master acupressure techniques to provide relief and promote overall well-being. This Podiatry: Foot Health Practitioner & Physiotherapy Diploma Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Diploma in Foot Health Practitioner Training at QLS Level 5 Course 02: Physiotherapy Course Course 03: Diploma in Pain Management at QLS Level 5 Course 04: Acupressure Massage Therapy Course So, why wait? Step into this enriching journey and be the change that feet everywhere have been waiting for. Enrol today in Podiatry: Foot Health Practitioner & Physiotherapy and make strides towards a brighter foot health future! Learning Outcomes for the Podiatry: Foot Health Practitioner (FHP) Diploma: Understand foot dermatology fundamentals and diagnosis techniques. Familiarise yourself with advanced podiatry tools and equipment. Address diverse foot disorders and nail diseases. Gain insights into various physiotherapy treatments. Master pain management, especially in acute cases. Learn acupressure techniques for pain and stress relief. Explore alternative therapies like cupping and hydrotherapy. Delve into wound care best practices and procedures. Understand nutrition's role in foot and skin health. Emphasise the importance of comprehensive personal hygiene. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Podiatry: Foot Health Practitioner & Physiotherapy Get a free student ID card with Podiatry: Foot Health Practitioner & Physiotherapy Training program (£10 postal charge will be applicable for international delivery) The Podiatry: Foot Health Practitioner & Physiotherapy is affordable and simple to understand This Podiatry course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Podiatry: Foot Health Practitioner & Physiotherapy course materials The Podiatry: Foot Health Practitioner & Physiotherapy comes with 24/7 tutor support Start your learning journey straightaway with our Podiatry: Foot Health Practitioner & Physiotherapy bundle! *** Course Curriculum *** Course 01: Diploma in Foot Health Practitioner Training at QLS Level 5 Module-1: A Comprehensive Introduction to FHP Module-2: Anatomy and Physiology of Foot Module-3: Systems in the Foot Module-4: Foot Dermatology Module-5: Examination and Diagnosis in Clinical Management Module-6: Podiatry Equipment and Instrument Module-7: Foot Disorders Module-8: Treating Foot Disorders Module-9: Diseases of the Nail and Their Treatment Module-10: Management of High-Risk Patients Module-11: Diabetic Foot Module-12: Pedicure Module-13: Reflexology Course 02: Physiotherapy Course Module 01: Introduction To Physiotherapy Module 02: The Standards For Physiotherapists Module 03: The Physiotherapy Interventions Module 04: Sports Physiotherapy Module 05: Neurological Physiotherapy Module 06: Musculoskeletal Physiotherapy Module 07: Respiratory Physiotherapy Module 08: Paediatric Physiotherapy Module 09: Evidence-Based Physiotherapy (EBP) Module 10: Building A Career As A Physiotherapist Course 03: Diploma in Pain Management at QLS Level 5 Module 01: Introducing Pain Management Module 02: Pain Theories Module 03: Types Of Pain Module 04: Physiology And Psychology Of Acute Pain Module 05: Pain As A Long-Term Condition Module 06: Back And Neck Pain Module 07: Headache Module 08: Neuropathic Pain And Its Management Module 09: Cancer Pain Module 10: Assessment Of Pain Module 11: Relaxation For Pain Management Course 04: Acupressure Massage Therapy Course Getting Started Introduction Download the summary of this section from the resources here What is Traditional Chinese Medicine and why is it so incredible? The meridians and the points in more detail How to perform acupressure correctly Your 10 'Go To' Potent Acupressure Points Welcome To Section 2! The Master Point Of The Head The Energy Booster Point The Cooling Point The Nausea Point The Happiness Point The Chill Out point The Gynaecological Point The Neck and Shoulder Tension Reliever Point Look how much you can already do! Powerful Point Combinations For Common Ailments Welcome To Section 3! How to do acupressure for better emotional and physical health Acne, Eczema and other skin disorders Hay fever ( Allergic Rhinitis) Arthritis Asthma/Breathing problems Poor Energy Levels Using acupressure to help with emotional wellbeing Colds and Flus Constipation Diarrhea Insomnia How will I get my Certificate? After successfully completing the Podiatry: Foot Health Practitioner & Physiotherapy course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*4 = £51) CPD Hard Copy Certificate: £29.99 CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Podiatry: Foot Health Practitioner & Physiotherapy Diploma - CPD Certified bundle is suitable for everyone. This bundle is ideal for: Aspiring FHPs Physio enthusiasts Pain management specialists Massage therapists Career changers Requirements You will not need any prior background or expertise to enrol in this Podiatry: Foot Health Practitioner & Physiotherapy bundle. Career path This Podiatry: Foot Health Practitioner & Physiotherapy - CPD Certified bundle will allow you to kickstart or take your career in the related sector to the next stage. Podiatrist Physiotherapist Pain management therapist Sports therapist Mobile foot health practitioner Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this Podiatry: Foot Health Practitioner & Physiotherapy bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.
Windows PowerShell training course description This course is intended for IT Professionals who are already experienced in general Windows Server and Windows Client administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of Windows PowerShell, or any scripting language, is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Exchange Server, SharePoint Server, SQL Server, System Center, and others. What will you learn Work with Windows PowerShell pipeline. Query system information by using WMI and CIM. Work with variables, arrays, and hash tables. Write advanced scripts in Windows PowerShell. Administer remote computers. Use advanced Windows PowerShell techniques. Windows PowerShell training course details Who will benefit: IT professionals. Prerequisites: Supporting Windows Server Duration 5 days Windows PowerShell training course contents Getting started with Windows PowerShell Overview and background of Windows PowerShell, Understanding command syntax, Finding commands. Hands on Configuring Windows PowerShell console & ISE application. Hands on Finding and running basic commands, Using the About files. Cmdlets for administration Active Directory administration cmdlets, Network configuration cmdlets, Other server administration cmdlets. Hands on Windows Administration. Creating and managing Active Directory objects, Configuring network settings on Windows Server, Creating a web site. Working with the Windows PowerShell pipeline Understanding the pipeline, Selecting, sorting, and measuring objects, Filtering objects out of the pipeline, enumerating objects in the pipeline, Sending pipeline data as output. Hands on Using the pipeline. Selecting, sorting, and displaying data. Hands on Filtering objects. Hands on Enumerating objects. Hands on Sending output to a file. Exporting user information to a file. Understanding how the pipeline works Passing the pipeline data, Advanced considerations for pipeline data. Hands on Working with pipeline parameter binding. Predicting pipeline behaviour. Using PSProviders and PSDrives Using PSProviders, Using PSDrives. Hands on Using PSProviders and PSDrives Creating files and folders on a remote computer, Creating a registry key for your future scripts, Create a new Active Directory group. Querying system information by using WMI and CIM Understanding WMI and CIM, Querying data by using WMI and CIM, Making changes with WMI/CIM. Hands on Working with WMI and CIM. Querying information by using WMI, Querying information by using CIM, Invoking methods. Working with variables, arrays, and hash tables Manipulating variables, arrays and hash tables. Hands on Working with variables, Using arrays, Using hash tables. Basic scripting Introduction to scripting, Scripting constructs, Importing data from files. Hands on Basic scripting. Setting a script, Processing an array with a ForEach loop, Processing items by using If statements, Creating a random password, Creating users based on a CSV file. Advanced scripting Accepting user input, Overview of script documentation, Troubleshooting and error handling, Functions and modules. Hands on Accepting data from users. Querying disk information from remote computers, Updating the script to use alternate credentials, Documenting a script. Hands on Implementing functions and modules. Creating a logging function, Adding error handling to a script, Converting a function to a module. Administering Remote Computers Using basic Windows PowerShell remoting, Using advanced Windows PowerShell remoting techniques, Using PSSessions. Hands on Using basic remoting. Enabling remoting on the local computer, Performing one-to-one remoting, Performing one-to-many remoting. Hands on Using PSSessions. Using implicit remoting, Managing multiple computers. Using background jobs and scheduled jobs Using background jobs, Using scheduled jobs. Hands on Using background jobs and scheduled jobs. Starting and managing jobs, Creating a scheduled job. Using advanced Windows PowerShell techniques Creating profile scripts, Using advanced techniques. Hands on Practicing advanced techniques. Creating a profile script, Verifying the validity of an IP address, Reporting disk information, Configuring NTFS permissions, Creating user accounts with passwords from a CSV file. Hands on Practicing script development (optional)
