1307 Courses

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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

How to Fix Lower Back Pain in Just 21 Days  When back pain strikes, it can ruin your life. Reaching for painkillers or having surgery can be ineffective and even dangerous for your health. Chronic pain affects 100 million people each year, and low back pain is the most common complaint. When the body's pain signals keep firing in the nervous system, it can have a draining effect on the quality of life-physically, mentally, and spiritually. In the United States, 8 out of 10 people will experience low back pain at some time in their lives. Low back pain is the second most frequent reason for doctor visits, next to the common cold, and it is the leading cause of job-related disabilities. What you'll learn You will learn the 9 worst back exercises for back pain (with better alternatives) You will learn a highly effective 21-day, 30-minutes or less, back pain exercise routine You will learn a 15-minute, Doctor-recommended back pain exercise routine You will learn 6 foam rolling moves to conquer back pain You will learn a 6-minute emergency back pain treatment that's safe for both herniated and bulging discs You will learn 7 exercises you need to be doing to prevent back spasms and herniated discs You will learn 7 resistance-band exercises that will help strengthen your low back and hips And You will learn 4 moves to do before you roll out of bed in the morning Requirements You should have basic computer skills and access to a wifi connection No fancy gym equipment is needed. All you need is a comfortable surface like a carpet, rug or yoga mat. You will need to 15-30 minutes a day to do this at home back pain relief exercise routine. You will also need the will and determination to do the exercises. I did them for 21 days and BOOM - my back pain vanished! So can yours if you follow my program. Low Back Pain Relief Secrets Welcome to Low Back Pain Relief FREE 00:02:00 4 Most Common Reasons for Lower Back Pain FREE 00:02:00 9 Worst Back Exercises for Back Pain 00:04:00 21 Day Low Back Pain Relief 00:15:00 15 Minute Doctor 00:08:00 Top 7 Exercises To Prevent 00:05:00 6 Minute Emergency Back Pain Treatment 00:03:00 7 Resistance Band Exercises for Low Back Pain 00:06:00 6 Foam Rolling Moves to Conqier Back Pain 00:03:00 4 Moves To Do Before You Roll Out of Bed 00:02:00 Bonus Better Posture Reports Prolonged Sitting and Back Pain 00:10:00 Stand The Right Way in 8 Moves 00:10:00 6 Exercises to Reverse Bad Posture 00:10:00

Course Description Get instant knowledge from this bite-sized Cattery Management Part - 1 course. This course is very short and you can complete it within a very short time. In this Cattery Management Part - 1 course you will get fundamental ideas of cattery management, the key understanding of designing your cattery, equipment required and so on. Enrol in this course today and start your instant first step towards learning about catteries. Learn faster for instant implementation. Learning Outcome Familiarise with catteries Understand the planning and designing of your cattery Gain in-depth knowledge of the equipment required and daily routine Learn about licences and legislation How Much Do Cattery Managers Earn? Senior - £135,000 (Apprx.) Average - £69,000 (Apprx.) Starting - £36,000 (Apprx.) Requirement Our Cattery Management Part - 1 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Cattery Management Part - 1 Module 01: Introduction to Catteries 00:14:00 Module 02: Licences and Legislation 00:18:00 Module 03: Planning and Designing your Cattery 00:24:00 Module 04: Equipment Required and Daily Routine 00:19:00 Assignment Assignment - Cattery Management Part - 1 00:00:00

Course Description Get instant knowledge from this bite-sized Phlebotomist Training Part - 1 course. This course is very short and you can complete it within a very short time. In this Phlebotomist Training Part - 1 course you will get fundamental ideas of phlebotomy, the key understanding of blood circulation, function and so on. Enrol in this course today and start your instant first step towards learning phlebotomy. Learn faster for instant implementation. Learning Outcome Understand phlebotomy Gain in-depth knowledge of the blood circulation, function, and composition Deepen your understanding of phlebotomy equipment Understand routine venipuncture Learn about venipuncture complications and pre-examination variables How Much Do Phlebotomists Earn? Senior - £39,000 (Apprx.) Average - £25,000 (Apprx.) Starting - £16,000 (Apprx.) Requirement Our Phlebotomist Training Part - 1 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Phlebotomist Training Part - 1 Introduction to Phlebotomy 00:17:00 Blood Circulation, Function, and Composition 00:27:00 Phlebotomy Equipment 00:16:00 Routine Venipuncture 00:24:00 Venipuncture Complications and Pre-Examination Variables 00:26:00 Assignment Assignment - Phlebotomist Training Part - 1 00:00:00

Description Pilates Trainer Professional Diploma Pilates is a physical fitness system developed in the early 20th century by Joseph Pilates. Pilates improves flexibility, strength and develops control of the entire body. It emphasises on alignment, breathing, building a strong core and improving coordination and balance of the body. Pilates helps alleviate lower back pain and helps the elderly live a healthy life. Pilates helps practitioners have better posture, makes them less prone to injury and lets them experience good health. Routine following Pilates builds flexibility of the body, strength, endurance and coordination without bulking up the person. It has been widely used by dancers, gymnasts as well as actors to maintain a healthy body. The course helps to train oneself to be a professional Pilates trainer. It can be taken up without affecting the daily routine, course of study or job. The course will also benefit those who are already engaged in the fitness industry. An additional diploma in Pilates will enhance the opportunities to train a wide range of people and add variety to the fitness regime. The course offers insights from the fundamentals of the Pilates system and guides the learner to run his/her own classes. The eight units will give the learner knowledge that he/she can integrate into a variety of disciplines, such as yoga or dance. The learner can also apply it as his/her specialised area. It is also desired that a Pilates teacher is a good communicator, patient, persistent, organised, creative, sociable and an effective motivator. To motivate the trainees, he/she should lead a healthy lifestyle and be a role models for them. This course will help the learner to be well-versed in the science of human body movement and its adaptations to different situations. It will enable the learner to develop and apply solutions in varying circumstances and according to the requirement of each individual. The ones taking the course will find employment in Pilates studios, health centres, fitness centres, and community centres and can also become personal trainers. What you will learn 1: DEVELOPING YOURSELF AS A PILATES TRAINER 2: THE BENEFITS OF PILATES 3: THE EIGHT PRINCIPLES OF PILATES 4: BASIC ANATOMY 5: PREVENTING INJURY 6: PILATES IN PREGNANCY 7: PILATES ON THE BALL 8: RELAXATION AND IMAGERY Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Build your foundation on Phlebotomy Training. Explore the ins and outs of venipuncture. Learn Routine Venipuncture, Special Blood Collection Procedures, and Venepuncture for Blood Donation.

Learn the foundation to colour analysis with this 5 day live and online, interactive course

The 'No Blade Facelift' is the new trend made popular by numerous celebrities recently and it is an excellent and effective non-surgical technique to lift and tighten skin. In the right hands, it has the potential to re-define facial contours and induces collagen production. The treatment forms part of an integrated support structure for the tissue of the face by encouraging natural collagen synthesis with immediate results that peak at 6 months and last between 2-3 years. ​On this course, we aim to help you master a technique that will set you apart from most routine cosmetic treatment providers and enable you to step into the future of advanced cosmetic procedures. We will cover all you need to know in order for you to treat your patients confidently and safely; including anatomy, use of local anaesthetic, consultation and assessment, managing complications and aftercare. You will perform this procedure on live models under the supervision and guidance of highly experienced aesthetic practitioners Course prerequisites This course is suitable for those with or without a medical background. It is designed to provide the student with the ability to seek employment or start their own business upon qualification. At a minimum, students will be required to be qualified for at least one of the following: Medically qualified as a nurse, doctor or dentist with current registration with the NMC, GMC or GDC. NVQ Level 3 in Beauty Therapy, ITEC or HND 12 months of needling experience 6 Months of micropigmentation experience and Anatomy & Physiology Level 3 If your qualification does not appear above, we offer a fast track access course for those completely new to the industry.  Course agenda Background of PDO Threads Health & safety In-depth anatomy and physiology Emergency protocols Product knowledge Sourcing clinical oversight (Prescriber) Complications prevention Client suitability Equipment use Needle stick injury protocol Pain management with the use of injectable anaesthetic Adverse effects Complications management Emergency Protocols Anaphylaxis Aftercare Consent forms Consultation process Client selection Live demonstrations Live model experience Recommended treatment charges Insurance Legalities Advance your training with our complete PDO Threads training package Take your training to the next level by enrolling on our complete PDO Thread training package. Included within this package: PDO COG Threads PDO Mono Threads Fox Eye Thread Lifts Pixie Nose Tip Lifts Check out the package here

ABT Accredited 5 day Swedish Massage course Home learning required.

Learn how to make the most of your time by implementing guidelines that is smart, measurable, achievable, relevant and time based. With accurate goal setting, you will maximize your efficiency as well as your effectiveness and in doing so, learn how to record and track your progress throughout the duration of a specific task, or even merely throughout your normal routine day. You will be able to schedule recurring activities without having anxiety about where you'll have to find the time. Learning Objectives Schedule goals and activities, Find hidden time Target Audience Managers, Team Leaders, Young Professionals, Sales Professionals, Customer Service Teams