146 Courses

Complete VBA programming training course description This course helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience, you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. We start at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language in Word, Excel, Outlook, and PowerPoint. What will you learn Record, write and run macros. Work with VBA Editor. Use the huge library of built-in functions. Create simple dialog boxes and complex forms. Customize Word, Excel, PowerPoint, Outlook, and Access. Program the Office 2016 ribbon. Complete VBA programming training course details Who will benefit: Anyone looking to extend the capabilities of the entire Office suite using VBA. Prerequisites: None. Duration 5 days Complete VBA programming training course contents Macros and getting started in VBA VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Working with VBA 1 VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Decisions, loops and functions Built-in functions, creating your own functions, making decisions in your code, using loops to repeat actions. Using message boxes, input boxes, and dialog boxes Getting user input with message boxes and input boxes, creating simple custom dialog boxes, creating complex forms. Creating effective code Building modular code and using classes, debugging your code and handling errors, building well-behaved code, exploring VBA's security features. Programming the Office applications The Word object model and key objects, working with widely used objects in Word, the Excel object model and key objects, working with widely used objects in Excel, the PowerPoint object, model and key objects, working with shapes and running slide shows, the Outlook object model and key objects, working with events in Outlook, the Access object model and key objects, manipulating the data in an Access database via VBA, accessing one application from another application, programming the Office 2016 ribbon.

Delegates will develop knowledge of the requirements for the design, installation and commissioning of Fire Detection and Fire Alarm systems within domestic properties in compliance with the requirements of BS 5839-6 and other codes of practice.

In this class you will learn the Yang 10-Step Tai Chi Form. This is a 'standardised' routine, in other words it is performed in the same way throughout the world. We are also doing a set of Qigong exercises for the health of the internal organs. This is a 13-week term.

In this class we are doing the Wu style Competition Routine. This is a 45-move set of movements using all the features that make Wu style tai chi different to other styles of tai chi. We also do a set of Qigong exercises in this class. This is a 13-week term.

In this class you will learn the Yang 10-Step Tai Chi Form. This is a 'standardised' routine, in other words it is performed in the same way throughout the world. We are also doing a set of Qigong exercises for the health of the internal organs. This is a 13-week term.

This IMI qualification is designed for those personnel who in the course of their daily work may encounter damaged electric/hybrid vehicles. It contains the knowledge required to work safely around the electric/hybrid vehicles high and low voltage electrical system and electric drive train systems. On completing this qualification those personnel will have gained knowledge of both low and high voltage technologies and an understanding of their dangers. The content of this qualification has been designed to give learners the knowledge and skills required to work safely around Electric/Hybrid vehicles during emergency and recovery situations.

NPORS Crane / Lift Supervisor (N405)

Try a beginners pole taster lesson out before joining on to our 6 week course For complete beginners, you will learn some spins, gyrations, steps, linking moves and put together a short routine in this 1 hour lesson. Ideal if you'd like to give pole a try first before committing to a 6x week course with us then this is the ideal option for you!

Boost your expertise in this EnergyEdge's cost control and budgeting for exploration and production course. Enroll now and enhance your career!

This IMI qualification is an introduction to electric/hybrid vehicle technology and is intended to provide learners with an awareness of electric/hybrid vehicle operation. This programme is particularly useful for people involved in the automotive retail industry as the growth in electric/hybrid vehicle market continue to increase. The content of this qualification has been designed to give learners the knowledge required to work safely around Electric/Hybrid vehicles.