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

265 Operator courses in Coventry 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 9
Onebus

onebus

England

OneBus is a unified collective of commercial bus operators in Greater Manchester. OneBus was launched in 2018 to enable bus companies to speak with one voice and drive a shared commitment to improve public transport across the Greater Manchester region. High-quality, good-value and easy-to-use public transport is critical to delivering better connectivity and improved mobility for local people. Most importantly, it underpins the region’s drive to create a thriving economy, ensure good jobs and opportunity for all, provide access to affordable housing, and deliver safe, healthy and inclusive communities. The OneBus partnership represents bus operators in Greater Manchester, committed to improving travel as part of an integrated network that gets Greater Manchester moving. Buses are central to the future of Greater Manchester and our positive package of proposals can make a real difference to tackling the biggest challenges facing our communities; road congestion and air quality. Building on the significant investment already made by operators, we believe there is a window of opportunity for everyone to work together to deliver a revolution in the region’s bus network that puts customers first and offers excellent value for both passengers and public investment. Our blueprint for a partnership model in Greater Manchester is consistent with the new powers in the Bus Services Act and proposes: 450 new low emissions buses over the next three years to boost the region’s air quality, with the first 150 delivered by 2020 More flexible and simplified tickets, recommendation of two-year price freeze on multi-operator bus fares, and more affordable travel for people of all ages An action plan for Transport for Greater Manchester and other agencies to tackle congestion hotspots, speed up journeys and cut gridlock A single unified brand identity for all bus services, with individual operator buses clearly identifiable as part of a partnership Improved integration of bus, tram and rail services Joint bus network review to maximise connectivity for passengers, including the evaluation of the potential for off-peak, limited stop, night time or 24 hour services Better on-board customer experience, including extension of free WiFi across the bus fleet A fully coordinated, central approach to traffic management, customer contact and travel information