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

265 Operator courses in Manchester delivered Live Online

VBA in Excel - Part 1

By Underscore Group

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives  By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code

VBA in Excel - Part 1
Delivered in Horsham or OnlineFlexible Dates
Price on Enquiry

Transport And Warehouse Operations Supervisor Level 3

By Rachel Hood

Manage the day to day operations involved in supply chain.

Transport And Warehouse Operations Supervisor Level 3
Delivered OnlineFlexible Dates
Price on Enquiry

NVQ Level 2 Certificate in Plant Operations

5.0(29)

By Site Competence

Blue CSCS Card NVQ Level 2 Plant This qualification provides you with the opportunity to showcase their knowledge, skills and understanding in their chosen specialism. You will have the relevant experience in one of the specific areas. You will be operating on one of the following machines: Forward Tipping Dumper Ride on Roller Excavator Telehandler Induction As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor, you will get to decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion, and witness testimonials. On completion Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with your assessor the certificate will be applied for. To download our PDF for this course then please click here.

NVQ Level 2 Certificate in Plant Operations
Delivered OnlineFlexible Dates
Price on Enquiry

Example

5.0(1)

By Profi

Example

Example
Delivered OnlineFlexible Dates
FREE

Introduction to Swift - Mobile App Development

By Nexus Human

Duration 3 Days 18 CPD hours Discover and explore how to use the fundamental building blocks of the Swift programming language. class will teach you the basic concepts of Swift programming, including syntax, logic, structures, functions, and patterns. It also includes detailed explanations of language syntax and coding exercises. Introduction to Swift Constants, Variables, and Data TypesOperatorsControl FlowStrings & FunctionsStructures & ClassesOptionalsCollectionsLoopsType CastingGuard StatementsScope & EnumerationsProtocolsClosuresExtensions

Introduction to Swift - Mobile App Development
Delivered OnlineFlexible Dates
Price on Enquiry

Educators matching "Operator"

Show all 10
defibshop

defibshop

Manchester

Defibshop was born in 2005. At this point people really did not know what a defibrillator was, despite it being common place in countries like America. If it was going to happen here in the UK we’d need to educate people about what an AED was, when they should be used, how important they were in the event of a sudden cardiac arrest, the impact of using one to the casualty and how easy they are to use whether you are trained or not. For many years it has been an uphill struggle to educate people about defibrillators. Common objections include “Is it law to have one?” and “we’ve never needed one so far so why should I buy one?”, but, after years of education in the importance of early CPR and defibrillation in the event of sudden cardiac arrest (SCA), some changes in legislation, high profile incidents and saves by defibs such as Fabrice Muamba in 2012 and Christian Erikson in 2021, as well as the introduction of defibrillator training within workplace first aid courses, these units are now a natural extension of first aid provision. Today we have a highly knowledgeable team working to ensure the correct defibrillator is placed in the correct environment. All defibs deliver a shock of course, but it is important to take the environment into account as models vary and offer different functions. We have also been working with the British Heart Foundation to promote The Circuit, the UK’s national defibrillator network that is linked directly to the 999 ambulance response service and enables the operator to send a caller to the nearest available registered defibrillator, so potentially saving valuable minutes and saving more lives. Please register your unit if you have not done so already. We continue to put pressure on the Government to pass the proposed Automated External Defibrillator Public Access Bill to legislate defibrillators that are accessible to all in public places. Without this, people are going to continue to die from sudden cardiac arrest because there wasn’t a unit close enough to hand. That could happen to any one of us. After you've purchased your life-saving AED, our commitment doesn't end there. As part of our FREE pad and battery reminder service, we will contact you when your consumables are due to expire, so you have plenty of time to replace them and ensure your device is always ready for use.