539 Basic courses in Bradford

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

This 4 hour course outlines a range of knowledge and practical skills in providing basic life support (BLS) and using an automated external defibrillator (AED) safely. Learners will practise assessing and managing a casualty who needs BLS and the safe use of an AED. Our course outlines a range of knowledge and practical skills in providing basic life support (BLS) and using an automated external defibrillator (AED) safely. Learners will practise assessing and managing a casualty who needs BLS and the safe use of an AED. For more information click on the tabs below, or get in touch, we’d be more than happy to answer any queries. At Immerse Training we pride ourselves on offering First Aid and Pre-Hospital Care Training that meets your specific needs. All our courses meet the requirements of the relevant awarding body. On top of that, we are more than happy to create bespoke elements that tailor each programme to suit your first aid or care responsibilities. Qualification Information This qualification and learning outcomes are based on the recommendations of: The Resuscitation Council (UK) Skills for Health Assessment Principles for First Aid Qualifications Course Content Following this course students will: Be able to manage an unresponsive casualty who is breathing normally. Be able to manage an unresponsive casualty who is not breathing normally. Know how to safely use an automated external defibrillator. Be able to safely use an automated external defibrillator. Who should attend? This qualification is for people who have a specific interest or responsibility at work, or in voluntary and community activities, in being able to provide BLS when dealing with an emergency situation which may involve using an AED. Pre-requisites Students must be at least 16 years old on the first day of training. Assessment and Certifications Assessment for this course is continuous. Successful students will receive an Immerse Training Certificate, which is valid for one year. This certificate will be issued by Qualsafe, the awarding body for Immerse Training. Additional Information Completion of the Level 2 Award in Basic Life Support and Safe Use of an Automated External Defibrillator includes 1 credit at Level 2 of the Qualification Credit Framework (QCF). The Level 2 Award in Basic Life Support and Safe Use of an automated External Defibrillator is also recommended as an annual refresher for student who have successfully completed the QA Level 3 Award in First Aid at Work (QCF). Workplace First Aid Courses First Aid courses for employers and employees. Our workplace courses are fully accredited, registered and meet Health and Safety Executive (HSE) guidelines. From 1 day Emergency First Aid at Work (previously appointed person) to 3 day First Aid at Work courses. We specialise in on-site courses at your workplace, tailored to the specific risks associated with your business.  All courses can be delivered at our training centre in Poole, Dorset or we can deliver on-site across Bournemouth, Poole, Dorset, Hampshire and the South of England.

Teaching basic number skills to children with Down syndrome and other learning difficulties using the Numicon approach. Basic number skills are vital to enable everyday social inclusion and independence. The training will commence with an overview of the learning profile of a child with Down syndrome; exploring working memory and how this impacts on learning numbers. It will detail how children learn basic number skills – recognising numbers, saying number names, counting to find ‘how many?’ and early hands on addition. It will explore the challenges faced by children who have Down syndrome and other learning disabilities and demonstrate how the use of Numicon as a visual representation of number can help to overcome these difficulties and lead to increased understanding and confidence.

Anaphylaxis is a severe and life-threatening allergic reaction, which requires immediate medical attention. With the number of sufferers increasing each year, it is extremely important to know what to do when faced with this acute emergency condition.  The QA Level 2 Award in Basic Life Support and Management of Anaphylaxis (RQF) qualification has been designed for those who have a specific responsibility at work, at home or in voluntary and community activities, to provide basic life support and manage anaphylaxis when dealing with an emergency. Successful candidates will be able to recognise the signs and symptoms of anaphylaxis, and will be equipped with the vital skills needed to administer safe, prompt and effective treatment.

Basic Life Support (BLS) Course

About the technique: The Kusum Modak Method, previously referred to as Ayurvedic Yoga Massage (AYM), Traditional Ayurvedic Massage, or simply Ayurvedic Massage, is now named in honor of its creator. This change was introduced with the establishment of the Modak Institute, founded by Kusum Modak to preserve her legacy with integrity and authenticity for future generations. This contemporary method combines traditional Ayurvedic Massage with Yoga, developed through Kusum Modak’s studies with her teachers, Limaye and B. K. S. Iyengar, in Pune, India. The therapy focuses on activating breath, circulation, and vital energy through deep touch using hands and feet, along with tractions and stretching maneuvers. Treatments are conducted on an orthopedic mat using vegetable oil and a natural powder called Vekhand, derived from a root known in the West as Calamus. Course Information: Course Structure: Over 10 days, students will gain the knowledge and skills to practice the Kusum Modak MethodSM and become officially certified as bodywork therapists by the Modak Institute. The program includes: Students will cultivate a therapeutic perspective and build confidence in applying the technique. This course follows the updated guidelines set forth by Kusum Modak through the Modak Institute. Content: Total Hours: 80 hours of practical classes + 4 hours online + 12 hours assessment Duration: 10 days (in person classes) Dates: June 3rd to 7th and June 10th to 14th, 2025 Schedule: 9:00 AM to 1:00 PM and 2:00 PM to 6:00 PM Course Location: Roots of Respect, 16 Blenheim Terrace Woodhouse LS2 9HN United Kingdom Hands-on practical exercises Detailed technical understanding of the 118 maneuvers Dedicated time for questions, reviews, and session exchanges Introduction to the basics of the technique (structure & practice); Kusum Modak MethodSM history and influential contributors; Introduction of Ayurveda Principles; The elements of the Kusum Modak MethodSM - AYTM The steps of the therapy sequence; Learning to warm up the muscles; Use of hands and feet (walking on the back); Understanding the quality of the touch to perform Kusum Modak MethodSM; Using therapy props (why and when to use them); Manoeuvres and stretching – how to apply and its variations; Synchronisation of the pressure and breath; Learning to set up a 1-hour sequence (which is the original duration) that will serve the needs of each client; Applied anatomy to the technique and subtle anatomy, pathology and application of the studied content; Client Assessment protocols. Why the medical history form is essential?; Contraindications; Postural correction and student welfare practices (preparing the body for delivery) Assessment: We offer complementary activities designed to provide a deeper understanding of the Method and to help you develop a more precise approach to your practice. To be approved and certified, you must: You will receive clear instructions and guidance to help you succeed, as well as detailed information about the evaluation criteria. The 4 hours of online activities include complementary lectures and related assignments. - Anatomy - Demystifying the Kusum Modak Method - Holistic Medical Systems - SOAP notes and Health History form Certification: You have two options: Review with Q&A Supervised Practice (individual correction, gaining accuracy) How to maintain health + wellbeing as a bodywork therapist. Attend 100% of the in person classes. Submit 10 case studies on the same person, including reports for 10 SOAP notes. Provide a video recording of the final session. MODAK INSTITUTE CERTIFICATE: The Modak Institute certificate is awarded to students upon successful completion of the course, which includes final assessment activities to be submitted within 60 days after the in person training. This certificate is issued by the Modak Institute, the only institute officially authorized and endorsed by Master Kusum Modak to represent her method. It validates that students are fully qualified to work professionally with Prerequisites: While no formal prerequisites are required, physical, mental, and emotional health are essential to participate in the intensive activities. Students will also develop awareness to their clients’ needs and enhance their own mindfulness during practice. Training Price: Modak Institute Certificate: 1650 GBP Level 3 Diploma Kusum Modak Method: + 295 GBP Payment Plan 1 - 100% Payment upfront with discount (50 GBP off) until March 15th 2 - 50% deposit - 50% until May 20th 3 - 4x (Feb, Mar, Apr, May) 4 - 5x (Feb, Mar, Apr, May, Jun) Please feel free to reach out if you need to arrange your payments differently. Cancellation Policy the Kusum Modak MethodSM and ensures their eligibility to obtain therapist insurance, providing recognition and support to practice as certified therapists. Once your final assessment is evaluated and approved, your certificate will be issued and sent directly to your email. Each certificate includes a unique digital code, enabling easy verification of your credentials and affiliation worldwide through Modak Institute website. MODAK INSTITUTE CERTIFICATE + LEVEL 3 DIPLOMA KUSUM MODAK METHOD: Same process as described above + Students may request the UK Level 3 Diploma Kusum Modak Method Certificate for an additional fee of 295 GBP, which requires completing three additional online courses (150 hours) to meet accreditation requirements. The student must request this certificate option at the time of registration. What’s Included: About the teachers: Purnima Full refundable with in two months in advance Partial refundable 50% in a month before starting the training After that is a non-refundable payment. 84 hours of structured and methodically designed training (80 in person + 4 online). Note: the student need to reserve plus 12 hours for assessment. Modak Manual, including photos of all maneuvers and additional insights into the method’s history and references. Official Modak Institute Certification. Access to video lectures. Oil and powder for use during the course. One year of membership in the Modak Institute, including: Participation in an online plataform Access to official graphic materials for promotional use Inclusion in the Modak Institute’s agenda for work promotion Exclusive Q&A WhatsApp group moderate by Purnima and Julia.

Did you know that following a cardiac arrest, every minute without CPR and defibrillation reduces a casualty’s chance of survival by 10%?  Sudden cardiac arrest is one of the UK’s biggest killers, and yet statistics show that most of the British public are unaware of the life-saving difference they can make by performing CPR and defibrillation.  The QA Level 2 Award in Basic Life Support and Safe Use of an Automated External Defibrillator (RQF) qualification has been designed to provide candidates with the skills needed to administer safe, prompt and effective basic life support and use an AED safely in emergency situations.  With an estimated 60,000 out of hospital cardiac arrests occurring every year in the UK alone, make sure you are prepared!

Complete VB.Net training course description A hands on introduction to programming in Visual BASIC .Net. What will you learn Build Visual BASIC applications. Build simple components Debug Visual BASIC programs. Examine existing code and determine its function. Complete VB.Net training course details Who will benefit: Anyone wishing to program in Visual BASIC. Anyone wishing to build Windows based applications. Prerequisites: None although experience in another high level language would be useful. Duration 5 days Complete VB.Net training course contents Writing your first program Visual Studio, forms designer, running VB programs, the UI, properties, writing the code. Toolbox Controls Basic use, input controls, ActiveX controls. Menus and Dialog Boxes Menus, Dialog Box controls, event procedures. Visual Basic .NET variables and operators Variables, I/O, data types, constants, operators, Math Methods, precedence. Decision Structures and Loops and Timers Event-Driven programming, If…Then, Select Case, For…Next Loops, Timer Control. Debugging Visual Basic .NET Programs Break Mode, watch & command windows. Structured Error Handling Try...Catch, Finally, Err Object, retry periods. Modules and Procedures Standard modules, public variables, procedures. Arrays and Collections to Manage Data Fixed-Size & dynamic Arrays, ReDim Preserve, object collections, Controls Collection. Text Files and String Processing Text Box object, Text String methods, sorting. Automating Office Applications Application objects, automation in VB, the Object Browser, the Process Component. Deploying Visual Basic .NET Applications Planning a deployment, ways to deploy an application, deployment projects, options. Managing Windows Forms Forms, positioning, manipulation, adding controls, organizing controls, Startup Object. Adding Graphics and Animation Effects System.Drawing namespace, coordinates, SystemPaint Event, animation, transparency. Inheriting Forms and Creating Base Classes Inheriting forms, inheritance picker, base classes and inheritance, classes in projects. Working with Printers PrintDocument class, Text Box object, Print Preview and Page Setup Dialog Boxes. Database programming with ADO.NET Databases, ADO.NET, Data Adapters, Datasets, Bound & Navigation Controls. Displaying database records, formatting DataGrid cells, updating the database. Displaying HTML Documents Using IE IE Object, Internet Controls, IE Events. Web Forms for Interactive Web Applications ASP.NET, Web Forms vs. Windows Forms, HTML controls, web applications, event procedures for web forms controls.

CCNA training course description The Implementing and Administering Cisco Solutions (CCNA) course gives you a broad range of fundamental knowledge for all IT careers. Through a combination of lecture, hands-on labs, and self-study, you will learn how to install, operate, configure, and verify basic IPv4 and IPv6 networks. The course covers configuring network components such as switches, routers, and wireless LAN controllers; managing network devices; and identifying basic security threats. It also gives a foundation in network programmability, and software-defined networking What will you learn Install, configure, and operate a small to medium sized network Gain a foundation in the essentials of networking, security, and automation Prepare for the 200-301 CCNA exam, which earns CCNA certification CCNA training course details Who will benefit: Network support help desk technicians involved in the basic installation, operation, and verification of Cisco networks. Anyone seeking CCNA certification. Prerequisites: Introduction to Data communications & networking Duration 5 days CCNA training course content After taking this course, you should be able to: Identify the components of a computer network and describe their basic characteristics. Understand the model of host-to-host communication. Describe the Cisco IOS software. Describe LANs and the role of switches within LANs. Describe Ethernet and describe the operation of switches. Install a switch and perform the initial configuration. Describe the TCP/IP Internet layer, IPv4, its addressing scheme, and subnetting. Describe the TCP/IP Transport and Application layers Explore functions of routing. Implement basic configuration on a Cisco router. Explain host-to-host comms across switches and routers. Identify and resolve common switched network issues and common problems associated with IPv4 addressing. Describe IPv6 main features and addresses, and configure and verify basic IPv6 connectivity. Describe static routing. Describe, implement, and verify VLANs and trunks. Describe inter VLAN routing. Explain the basics of dynamic routing protocols and describe components and terms of OSPF. Explain how STP and RSTP work. Configure link aggregation using EtherChannel. Describe the purpose of Layer 3 redundancy protocols. Describe basic WAN and VPN concepts. Describe the operation of access control lists (ACLs) and their applications in the network. Configure Internet access using DHCP clients and explain and configure NAT on Cisco routers. Describe basic QoS concepts. Describe the concepts of wireless networks, which types of wireless networks can be built, and how to use Wireless LAN Controllers (WLCs). Describe network and device architectures, introduce virtualization, network programmability and SDN and describe smart network management solutions such as Cisco DNA Center™, SD-Access, and SD-WAN. Configure basic IOS system monitoring tools. Describe the management of Cisco devices. Describe the current security threat landscape. Describe threat defence technologies. Implement a basic security configuration of the device management plane. Implement basic steps to harden network devices. Detailed course outline Exploring the Functions of Networking. The Host-to-Host Communications Model. Operating Cisco IOS Software. Introducing LANs. Exploring the TCP/IP Link Layer. Starting a Switch. The TCP/IP IP layer, IPv4 Addressing, and Subnets. The TCP/IP Transport Layer and Application Layer. Exploring the Functions of Routing. Configuring a Cisco Router. Exploring the Packet Delivery Process. Troubleshooting a Simple Network. Introducing Basic IPv6. Configuring Static Routing. Implementing VLANs and Trunks. Routing Between VLANs. Introducing OSPF. Redundant Switched Topologies with EtherChannel. Explaining Basics of ACL. Enabling Internet Connectivity. Explaining the Evolution of Intelligent Networks. Introducing System Monitoring. Managing Cisco Devices. Securing Administrative Access. Implementing Device Hardening. Self-Study: Building Redundant Switched Topologies. Exploring Layer 3 Redundancy. Introducing WAN Technologies. Introducing QoS. Explaining Wireless Fundamentals. Introducing Architectures and Virtualization. Examining the Security Threat Landscape. Threat Defense Technologies.

Basic Life Support Workshop: What will you learn? You have two options: 2-hour workshop — The all-important basics 3-hour workshop — Includes how to use a defibrillator, how to treat someone who’s choking and advice about calling 999 With both options there will be practical demonstrations, role playing and some activities to keep things engaging and interesting. I’m happy to tailor the content. If you’d like me to cover something that isn’t listed below, just ask. During the course, you’ll be trying out your newly-learned techniques with a whole range of equipment, including mannequins. And… this course includes the CPD-accredited Bra Off, Defib On. Did you know that women are less likely than men to survive when a defibrillator is used on them in a medical emergency? Proper pad placement is crucial, and you’ll learn this life-saving skill. Here’s the full course content: The primary survey — Checking the scene, checking response and breathing The recovery position How to resuscitate someone using CPR How to use a defibrillator (includes the CPD-accredited Bra Off, Defib On) At the 3-hour workshop, you ALSO learn: What to do when someone is choking Everything you need to know about first aid kits Information about calling 999 By the end of the workshop, you’ll be as cool as a cucumber, knowledgeable and confident in a medical emergency. In short, you’ll be a superhero.