1746 Courses in Liverpool

Level 3 Diploma in Supervising Licensed Asbestos Removal

Build confidence & capability and engage in meaningful dialogue about race.

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

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

Level 2 NVQ Certificate in Highways Maintenance - Excavation and Reinstatement Operations

ITIL® 4 Leader: Digital and IT Strategy: In-House Training The ITIL® 4 Leader: Digital and IT Strategy (DITS) is one of the two modules in the ITIL® 4 Strategic Leader (SL) certification scheme. The other module in the SL designation is the ITIL® 4 Strategist: Direct, Plan & Improve. Accredited training for the ITIL® 4 Strategic Leader modules is mandatory to enable full understanding of the core material. The ITIL ® 4 Digital and IT Strategy certification focuses on enabling business success through the creation of digital and IT strategies. The IT and Digital Strategy certification adds a new perspective to the ITIL suite and elevates the discussion around ITIL concepts to a strategic level among business leaders and aspiring leaders. The ITIL® 4 Digital and IT Strategy course is based on the ITIL® 4 Digital and IT Strategy exam specification from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, you will acquire relevant knowledge to pass the certification exam. The core learning material in the course is supported by interactive case study, discussions and activities. What You Will Learn The ITIL ® 4 Digital and IT Strategy course covers the content in relation to the following learning outcomes of the exam specification for ITIL ® 4 Digital and IT Strategy: Demonstrate the use of the ITIL guiding principles in Digital and IT Strategy decisions and activities Understand how to leverage digital strategy to react to digital disruption Understand the relationship between the concepts of Digital and IT Strategy, the service value system and the service value chain, and explain how to utilize them to create value Understand how an organization uses Digital and IT Strategy to remain viable in environments disrupted by digital technology Understand strategic approaches made possible by digital and information technology to achieve customer/market relevance and operational excellence Understand the risks and opportunities of Digital and IT Strategy Understand the steps and techniques involved in defining and advocating for a Digital and IT Strategy Understand how to implement a Digital and IT Strategy Key Concepts of Digital and IT Strategy Digital, Information, and Communication Technology Digital Transformation Services, Products, and Competitive Advantage Tiers of Strategy Business Models Operating Models Strategy and the Service Value System Opportunity and Demand Value Governance ITIL® Guiding Principles Continual Improvement ITIL® Practices What is Vision? Disruptions Vision Digital Disruptions Balanced Strategic Focus Positioning Tools for Digital Organizations Assignment 1: Digital Disruption and Digital Positioning Where Are We Now? Environmental Analysis Opportunity Analysis Digital Readiness Assessment How Do We Get There (Strategic Planning) Strategy Planning Financial Aspects of Digital and IT Strategy Business Models for Strategy Planning Portfolio Optimization How Do We Get There (Strategic Approaches) Strategic Approaches for Digital Organizations Strategic Approaches for Operational Excellence Strategic Approaches to Evolution Strategic Approaches to Social Responsibility and Sustainability Assignment 2: Strategic Approaches for Digital Organizations Take Action (Managing Strategic Initiatives) How Strategies are Implemented Coordinating Strategy and Strategic Initiatives Leading Digital Transformation Digital Leadership Assignment 3: Strategy Planning and Communication Did We Get There? (Measuring Strategy) Key Facts About Measurement Measuring a Strategy Instrumenting Strategy How Do We Keep the Momentum Going Long-Term Momentum: Ensuring Organizational Viability Short-Term Momentum: Parallel Operation Assignment: Digital Strategy in VUCA Environment Managing Innovation and Emerging Technologies Managing Innovation Formal Approach to Innovation Management Culture that Supports Innovation Approaches to Innovation Evaluating and Adopting Emerging Technology Managing Strategic Risk Risk Management Risk Identification Risk Posture Risk Treatment

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

Leadership is about 'getting stuff done'. This course concentrates on just that. In a complicated world, it helps leaders to ensure that the right stuff gets done at the right time and in the right way.

6 sessions of Couples Therapy at Miss Date Doctor the multi award winning relationship coaching and life coaching platform 1 hour per week With a qualified professional Call 03333443853 today

Our 2 day course will enable students who have successfully completed a Level 3 Award in First Aid at Work (QCF or RQF) to re-certify. This first aid at work course is ideal for organisations whose needs assessment has identified a requirement for additional first aid training, such as having employees with a disability or a medical condition. In addition to the topics covered on an emergency first aid at work course, this course covers treatment for a variety of injuries and medical conditions. 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 Understand the role and responsibilities of a first aider. Be able to administer first aid to a casualty with injuries to bones, muscles and joints. Assess an incident. Be able to administer first aid to a casualty with suspected head and spinal injuries. Manage an unresponsive casualty who is breathing normally. Be able to administer first aid to a casualty with suspected chest injuries. Manage an unresponsive casualty who is not breathing normally. Be able to administer first aid to a casualty with burns and scalds. Be able to recognise and assist a casualty who is choking. Be able to administer first aid to a casualty with an eye injury. Be able to manage a casualty with external bleeding. Be able to administer first aid to a casualty with sudden poisoning. Be able to manage a casualty who is in shock. Be able to administer first aid to a casualty with anaphylaxis. Be able to manage a casualty with a minor injury. Be able to provide first aid to a casualty with suspected major illness. Be able to conduct a secondary survey. Who should attend? This qualification is for people who deal with first aid at work. Enabling them to be workplace first aiders under the Health and Safety (First Aid) Regulations 1981. This qualification is also for people who have a specific responsibility at work, or in voluntary and community activities. This will allow them to provide basic first aid to people in a range of situations. Pre-requisites Students must be at least 14 years old on the first day of training. Students must be in possession of an in date First Aid at Work Certificate. Assessment and Certifications Assessment of this course is continuous and includes two theory/multiple choice question papers. Successful students will receive an Immerse Training Certificate, which is valid for three years. This certificate will be issued by Qualsafe, the awarding body for Immerse Training. Additional Information Completion of the Level 3 Award in First Aid at Work includes 3 credits at Level 3 of the Regulated Qualifications Framework (RQF). 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.