4448 Trainer courses in Birmingham delivered Online

Managing people and teams is consistently the biggest challenge raised by new managers (and even many experienced managers). This short 3-hour course is aimed at introducing new and existing supervisors and managers to key supervisory skills, allowing them to develop their competence as supervisors. The course covers: Understanding your role as a supervisor SRA obligations and competence expectations Setting expectations and effective delegation Monitoring progress and quality Managing performance in difficult situations Top tips for impactful feedback By the end of this course participants will have had an opportunity to consider their current skills; develop new skills; and think about further development needs. Target Audience This online course is aimed at managers, team leaders and other supervisors. Please note that this course does NOT meet the LAA requirements as a Supervisor Course. If you need a Legal Aid Supervisor course, then please check out our 6 hour 30 minutes Supervision & Managing Performance Course. Resources Course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Matthew Howgate, Consultant, DG Legal Matt is a non-practising solicitor who has considerable experience in regulatory issues and advising on complex issues of compliance and ethics. He is also an expert in data protection, UK GDPR and on the civil legal aid scheme. Matthew is a lead trainer on and co-developed the LAPG Certificate in Practice Management (a training programme for legal managers and law firm owners) as well as regularly providing training on legal aid Supervision, costs maximisation, data protection and security and on general SRA compliance.

Uncovering Emotional Root Causes of Health Challenges Instructor Craig Weiner, DC, Licensed MetaHealth Foundation Trainer, EFT Master Trainer of Trainers. Learn to apply a method of analysis that effectively guides the application and integration of EFT, Matrix Reimprinting and other alternative healing modalities you may already currently use for yourself and on your clients. Discover how symptoms and disease are actually an intelligent process that is the body’s attempt to heal stress and trauma. With this knowledge, fear can be greatly reduced and a therapeutic intervention can then be utilized in a more precise way. You and your clients will achieve results faster and will be amazed at the insights, connections and progress they make in their healing journey. META-Health is the science, practice and art of Body-Mind-Social Health with a focus on how specific stress triggers, emotions and beliefs affect specific organ symptoms. META-Health is a methodology based on Integrative Medicine and Prevention and is practiced by all types of health professionals interested in a precise and effective Body-Mind-Social analysis and approach towards most effectively supporting individuals working to find emotional and physical healing. Your trainer for this Foundation weekend will be Craig Weiner, who has worked in the complementary health care field for over 30 years. He brings his professional clinical experience, his years as an educator and certified trainer in the Emotional Freedom Techqniques and Matrix Reimprinting and as a licensed META-Health Foundation Trainer. In the Foundation Course you will get the overview of the META-Health concepts and its implications for self-healing, assistance in transforming disease, and achieving sustainable health and resilience, including: Rhythms of life, and the organism’s self-regulating intelligence How the bio-logical needs change your perception and create life strategies How to decode the language of your organs Recognize the key points and phases of the healing process Experience the powerful META-Analytics questions Use the 8 milestones of META-Health to address the whole system and its soil Find META-meanings to create resilience Demonstrations and practical exercises will lead you to deeply integrate the wisdom of your body, and inspire you to actively claim and support your health. You will understand the natural, dynamic path of healing, and be empowered to lift your – and others’ – consciousness to make use of our potential! During this weekend we will spend time reviewing the core META-Health Principles: Our body-mind is highly intelligent Bio-logical survival and stress strategies, regeneration and resilience are at play in our brain, nervous system and hormonal system Significant emotional experiences shape our beliefs, personality and lifestyle Specific individual stress triggers influence typical organ tissues and functions The cycle of stress, regeneration and learning goes through distinct points and phases Awareness and imagination are capabilities of our brain which can recreate meaning and reprogram body-mind’s reactions There is no pre-requisite to taking this weekend course. Anyone who is interested can participate in the META-Health Foundation Training. The Foundation Training is the first step in becoming a certified META-Health Practitioner. Times: The course is a 12 hours training and will be held from 9:00 to 4:00 Seattle/Pacific time on both Friday and Saturday with a 60 minute lunch break held at approximately 12:30pm.

The S.C.I.E.N.C.E.S Extended Program is a 6-month powerful personal development training tool incl. 12 individual coaching sessions, based around Neuroplastic Mental Acceleration (NMA): encompassing the eight steps to ascension, spread over 60 x 30 minute training sessions: Accept, Aware, Assess, Adapt, Aspire, Accelerate, Actualise, Ascend. The program is designed to provide mental well-being & acceleration by promoting fluid intelligence (the brain’s ability to learn new skills) though activating neuroplasticity - synaptogenisis & neurogenisis.

Gym Instructor Online Training Our exclusive Gym Instructor: Gym Instructor course is designed to provide students with in-depth knowledge about health and fitness. The Gym Instructor: Gym Instructor course will provide you with an introduction for starting your career in the fitness industry. Becoming a gym instructor will test your knowledge and practicality. However, it can also be a very enjoyable and rewarding career. Working as a gym instructor: gym instructor always requires new skills to learn and new knowledge to acquire, this Gym Instructor: Gym Instructor course will provide you with all the necessary knowledge and skills to succeed in this field. Through this gym Instructor: gym Instructor course, you will learn about the science behind muscle growth. The gym Instructor: The Gym Instructor course also covers a wide range of bodybuilding and weight loss workouts, such as bench press, dumbbell squats, curls, lunges, deadlifts, bicycle crunches, and much more. By the end of this Gym Instructor: Gym Instructor course, you will be able to help your clients achieve their fitness goals and begin a rewarding career in the fitness industry. Whether you are a beginner in this field or looking to expand your knowledge, this Gym Instructor course will guide you to the highest point of success. Enroll in our Gym Instructor: Gym Instructor course now and advance your career in the fitness industry! Why Choose this Gym Instructor Course from us Gym Instructor: Gym Instructor Course developed by industry experts. Free PDF certificate as soon as completing the Gym Instructor: Gym Instructor course. Special Offers of this Gym Instructor: Gym Instructor Course This Gym Instructor: Gym Instructor Course includes a FREE PDF Certificate. Lifetime access to this Gym Instructor: Gym Instructor Course Instant access to this Gym Instructor: Gym Instructor Course Get FREE Tutor Support from Monday to Friday in this Gym Instructor: Gym Instructor Course Learning Outcomes After completing this Gym Instructor: Gym Instructor course, learners will be able to: Gain a thorough understanding of bodybuilding & weight training. Learn about a range of exercises for Gym instructors. Learn how to make a workout plan & diet plan for Gym Instructor. Understand the benefits of sleep for exercise recovery. Gain in-depth knowledge about supplements. [ Note: Free PDF certificate as soon as completing the Fitness / Gym Instructor: Gym Instructor Course ] Gym Instructor Online Training Industry Specialists Designed this GYM Instructor: GYM Instructor course into 06 detailed Modules. Course Curriculum of GYM Instructor Module 1: Introduction to Gym Instructor Module 2: Exercises Module 3: Workout Plan for Gym Instructor Module 4: Diet Plan for Gym Instructor Module 5: Sleep Module 6: Supplements Assessment Method of Gym Instructor After completing each module of the Fitness / Gym Instructor: Gym Instructor course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Gym Instructor After completing the MCQ/Assignment assessment for this Fitness / Gym Instructor: Gym Instructor course, you will be entitled to a Certificate of Completion from Training Tale which is completely free to download. Who is this course for? Gym Instructor: Gym Instructor Online Training This Fitness / Gym Instructor: Gym Instructor course is ideal for anyone who is passionate about fitness and wants to work as a Gym Instructor or Personal Trainer. Requirements Gym Instructor: Gym Instructor Online Training There are no specific requirements for this Fitness / Gym Instructor : Gym Instructor course because it does not require any advanced knowledge or skills. Career path Gym Instructor: Gym Instructor Online Training After completing this Gym Instructor : Gym Instructor course, you may able to pursue a variety of promising career opportunities, such as: Gym Instructor Personal Trainer Fitness instructor Certificates Digital Certificate Digital certificate - Included

24 Hour Flash Deal **33-in-1 Training Manager Mega Bundle** Training Manager Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Training Manager package online with Studyhub through our online learning platform. The Training Manager bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Training Manager course provides complete 360-degree training on Training Manager. You'll get not one, not two, not three, but 33 Training Manager courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Training Manager courses are yours for as long as you want them once you enrol in this course. This Training Manager Bundle consists the following career oriented courses: Employee Training Responsibilities: Effective Training Management Train the Trainer Certificate Conflict Resolution Workplace Communication Management Influencing and Negotiation Skills Diversity Training Performance Management Diploma in Workplace Professionalism and Communication Motivational Mentorship: Inspiring Personal and Professional Growth Mastering Organizational Chaos Organizational Behaviour, HR and Leadership Employee Engagement and Retention Strategies Accredited Mediator Skills Training: Mediation & Dispute Resolution Corporate Relationship Goals for Success Team Building Masterclass Strategic Management and Leadership Development Change Management UK Employment Law Workplace Health and Safety Advanced Diploma Motivating, Performance Managing and Maintaining Team Culture in a Remote Team Workplace Health and Safety Advanced Diploma Cross-Cultural Awareness Training Diploma Certificate Supporting a Grieving Employee: A Manager's Guide Employee Hiring and Termination Training Safety Awareness 101 for New Employee Time Management Creative Thinking: Techniques and Tools for Problem Solving Corporate Relationship Goals for Success Assertiveness Skills: Developing Confidence and Effective Communication Emotional Intelligence and Human Behaviour Interpersonal Skills for Professional Development: Building Effective Relationships Business Networking Skills Decision Making and Critical Thinking Online Course In this exclusive Training Manager bundle, you really hit the jackpot. Here's what you get: Step by step Training Manager lessons One to one assistance from Training Managerprofessionals if you need it Innovative exams to test your knowledge after the Training Managercourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all 33 Training Manager courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Training Manager certificate and transcript on the next working day Easily learn the Training Manager skills and knowledge you want from the comfort of your home The Training Manager course has been prepared by focusing largely on Training Manager career readiness. It has been designed by our Training Manager specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Training Manager Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Training Manager bundle course has been created with 33 premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Training Manager Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Training Manager Elementary modules, allowing our students to grasp each lesson quickly. The Training Manager course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Training Manager training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Training Manager. Requirements To participate in this Training Manager course, all you need is - A smart device A secure internet connection And a keen interest in Training Manager. Career path You will be able to kickstart your Training Manager career because this course includes various courses as a bonus. This Training Manageris an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Training Manager career opportunities. Certificates Training Manager Digital certificate - Included CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses.

Are you struggling with your exercise habits or do you know someone who is? Do you need to schedule yourself for doing regular exercise? This course will surely guide you to make food a friend instead of an enemy. Description: This course will help individuals who are in search for healthy and balanced lifestyle since it is beneficial to help in your overall health. It is important to incorporate exercises into your daily routine to be able to grasp how to change your mentality towards exercising and be able to eat healthily at the same time. In this course, you will know why finding the right fitness routine is important and how to know what exercises are best for you and your body's condition. Who is the course for? Trainers, professionals and other busy people who are into health and fitness. Health conscious people who want to strengthen their bodies and maintain their wellness. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Daily Exercise Course will be very beneficial and helpful, especially to health, diet, and sport-related careers like: Athletes Clinical Dietetics Fitness Instructor Education and Research Food and Nutrition Management Personal Trainer Public Health Nutrition Related Health Professionals Sports Administrator Sports Businessmen Sports Specialists Wellness Coach. Chapter-01 Introduction 00:15:00 Chapter-02 Is Exercising a Good Thing? Why? 01:00:00 Chapter-03 The Principles of Exercise 01:00:00 Chapter-04 Finding the Right Fitness Routine 01:00:00 Chapter-05 Working Out When Time is Tight 01:00:00 Chapter-06 Avoid These Fitness Mistakes 01:00:00 Chapter-07 How to Fit in Exercise Time 00:30:00 Chapter-08 Best Exercises for Women 01:00:00 Chapter-09 Choosing a Sports Bra 01:00:00 Chapter-10 Getting Your Family Moving 00:15:00 Chapter-11 Using a Pedometer to Exercise 01:00:00 Chapter-12 Exercising with Health Issues 01:00:00 Chapter-13 Types of Exercises 01:00:00 Chapter-14 Should You Use a Personal Trainer? 00:30:00 Chapter-15 Conclusion 00:15:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Embark on your fitness journey with our highly comprehensive bundle: "Home Workout for Fitness, Muscle Building and Nutrition - 3 QLS Course". This holistic fitness package includes three QLS-endorsed courses focused on Home Workouts for Fitness, Weight and Health, Muscle Building Secrets, and Nutrition and Hydration. Upon completion, you'll earn a hardcopy certificate for each of these courses, a testament to your dedication and learning. Complementing these are five CPD QS-accredited courses designed to provide a robust knowledge base on health and fitness. You'll delve into Superfood Nutrition, Fitness Functional Skills, Weight Loss Training, and strategies for maintaining a Healthy Lifestyle Diet. Plus, our Health and Fitness Masterclass will take you from beginner to advanced understanding in your health journey. Turn your home into a personal fitness hub with our enlightening course bundle! Key Features of the Home Workout for Fitness, Muscle Building and Nutrition - 3 QLS Course Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Home Workout for Fitness, Muscle Building and Nutrition - 3 QLS Course bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Home Workout for Fitness, Weight and Health QLS Course 02: Muscle Building Secrets QLS Course 03: Nutrition and Hydration 5 CPD QS Accredited Courses: Additionally, our Home Workout for Fitness, Muscle Building and Nutrition bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Superfood Nutrition: 60+ Foods For Health & Fitness Course 02: Functional Skills - Fitness Course 03: Weight Loss Training Course 04: Best Healthy Lifestyle Diet Course 05: Health And Fitness Masterclass: Beginner To Advanced In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Home Workout for Fitness, Muscle Building and Nutrition - 3 QLS Course courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of Home Workout for Fitness, Muscle Building and Nutrition: Understand the process of planning and executing home workouts for optimal fitness, weight, and health. Gain theoretical knowledge about muscle-building secrets. Learn the importance of nutrition and hydration for overall well-being. Acquire insights into superfood nutrition and its impact on health and fitness. Gain theoretical understanding of functional fitness skills. Understand the essentials of weight loss training. Learn how to maintain a healthy lifestyle diet for optimal health and fitness. The "Home Workout for Fitness, Muscle Building and Nutrition - 3 QLS Course" bundle offers a comprehensive look at the theory behind fitness, muscle building, and nutrition. You'll delve into the theory of home workouts, muscle-building secrets, and the crucial role nutrition and hydration play in health. Coupled with a collection of courses on superfoods, fitness skills, weight loss training, and a healthy diet, you'll be well-equipped with the knowledge to plan a balanced lifestyle. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Home Workout for Fitness, Muscle Building and Nutrition bundle. This bundle is ideal for: Anyone with an interest in fitness and nutrition theory. Individuals seeking to enhance their understanding of home workouts. Fitness enthusiasts looking to broaden their knowledge on muscle building and nutrition. Those looking to delve into the theoretical aspects of weight loss and diet planning Requirements You will not need any prior background or expertise to enrol in this Home Workout for Fitness, Muscle Building and Nutrition bundle. Career path After completing this Home Workout for Fitness, Muscle Building and Nutrition bundle, you are to start your career or begin the next phase of your career. Fitness Blogger/Writer - average salary range: £20,000 - £40,000 Health and Fitness Consultant - average salary range: £25,000 - £50,000 Personal Trainer - average salary range: £20,000 - £40,000 Nutritionist - average salary range: £20,000 - £45,000 Fitness Instructor - average salary range: £15,000 - £35,000 Health and Wellness Coach - average salary range: £20,000 - £45,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

About this Training Course Gas wells are the most uncertain hence critical component of any gas production system. A successful gas project relies on a reliable forecast of gas well production and on timely implementation of measures that restore, sustain and improve gas well capacity, and maximize reserves. This 5-day course provides the skills to understand and analyze (changes in) gas well performance, and to select and design those remedial measures. It addresses all four gas well components i.e. reservoir performance, inflow performance, outflow performance and surface performance, individually and combined. In depletion-drive reservoirs, the gas well outflow performance becomes inevitably compromised as the reservoir pressure depletes and the gas rate becomes insufficient to lift liquid water and condensate to surface. This condition is referred to as liquid loading and causes significant loss of well capacity and reserves. This 5-day course provides the means to recognize and predict liquid loading, introduces the deliquification techniques that mitigate liquid loading, and then teaches how to select, design, install and operate the optimum suite of deliquification measures. Training Objectives On completion of this course, participants will be able to: Recognize and model gas well reservoir, inflow, outflow and surface performance Understand and model gas well production forecast and reserves Identify and model gas well performance threats and opportunities, specifically liquid loading and deliquification Select and justify remedial measures that mitigate those threats or realize those opportunities, specifically deliquification measures Understand design, installation and operation of those deliquification measures Target Audience This course is intended for production engineer, surveillance engineer, completion engineer, production/process chemist, reservoir engineer, production programmer, production operator, as well as other professionals responsible for selecting, installing, operating, monitoring and optimizing deliquification. Course Level Basic or Foundation Training Methods This course consists of a series of lectures and exercises. The lectures are interactive with field examples to illustrate models and concepts, where participants are encouraged to contribute their own relevant field examples. The exercises make use of a series of Excel worksheets for model calculations. Participants are invited to implement their own field specific well data. When arranged beforehand, PROSPER gas well performance software can be used as well. This course addresses ways and means to monitor and manage gas well performance and deliquification. It covers the purpose, outcome and benefit of gas well surveillance and capacity measures to assist future surveillance and capacity planning. Specifically, it addresses the selection and implementation of deliquification measures. This course introduces the skills and tools required for periodic review of gas well performance in support of critical business processes Trainer Your expert course leader brings with him 38 years of oil and gas field experience largely within Shell of which 25 years as gas well production engineer. He has covered the full spectrum of activities moving from R&D to green field development to brown field surveillance and optimisation, to become a leading gas well performance and deliquification specialist. He likes to capture the complex reality of gas well inflow, outflow and reservoir performance by means of practical data-driven rules and tools that cover a wide range of conditions i.e. shallow-to-deep, prolific-to-tight, dry-to-wet, green-to-brown, 1-1/2'-to-9-5/8' tubing, and depletion-to-aquifer drive. Before his retirement end 2020, He worked for Shell affiliated oil and gas companies including Shell Malaysia, Petroleum Development Oman, NAM Netherlands and Shell R&D in Netherlands and USA. Since then, he has been active as an independent trainer and consultant, amongst others for Cairn India. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Level 4 Diploma(FREE QLS Endorsed Certificate)| 10 CPD Courses+10 PDF Certificates| 140 CPD Points|CPD & CiQ Accredited

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