4539 Trainer courses in Cardiff delivered Online

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

About this Virtual Instructor Led Training (VILT) This 3 half-day Virtual Instructor Led Training (VILT) course will help participants grasp the idea of real-world risk management and how this relates to the cyber world. The VILT course will cover topics surrounding identifying cyber risks and vulnerabilities, guidance on applying administrative actions, and comprehensive solutions to ensure your organization is adequately secure and protected. The VILT course will guide participants on how to conduct a security risk assessment for their organization, and equip them with the skills to develop a risk compliance assessment plan as well as methods to develop risk management strategies which can improve their organization's security posture. The VILT course has at least a 30% hands-on approach through the use of Table Top Exercises. The VILT course will cover the following modules: Introduction to Risk Assessments (RA) Threat Actors and Their Motivations Threat and Risk Assessment Critical Controls Identification Maturity Assessment Treated Cyber Risk Profile Target Cyber Risk Profile and Strategy Target Audience The VILT course is intended for professionals responsible for organizational information and security system and those involved in operating and maintenance of critical information and IT network & sotware systems. Professionals who are designated as the Single Point of Accountability (SPoA) as well as system auditors will find this course useful. Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 3 half-day sessions comprising 4 hours per day, with 2 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Course Duration: 3 half-day sessions, 4 hours per session (12 hours in total). This VILT course is delivered in partnership with ENGIE Laborelec. Trainer Your expert course leader is a is specialized in cybersecurity risk management. Before joining ENGIE, she worked for The National Cybersecurity Agency of France (ANSSI) based in Paris (France) and for Deloitte Belgium located in Zaventem (Belgium). She has been involved in cybersecurity projects focusing on the principle of protecting critical infrastructures. Her different experiences in Cyber Security, Anti-Money Laundering and Global Trade Compliance (including Export Control and Customs) gave her the opportunity to use methodologies tackling strategic, operational and financial control issues at all levels of an organization: people, business processes, IT applications and infrastructure, legal and regulatory compliance. She was an EBIOS Risk Manager (RM) trainer while she worked for the French government; EBIOS RM is the French method for assessing and treating digital risks. She also had the opportunity to represent France towards European institutions and other relevant stakeholders for topics related to cybersecurity risk management. 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 about post training coaching support and fees applicable for this. Accreditions And Affliations

About this training course This highly interactive 5-day training is aimed at those who wish to take their E&P accounting skills to a more advanced level than our introductory course, E&P Accounting - Level 1, and our intermediate course, E&P Accounting - Level 2. It will help equip you for more demanding analytical roles within your organisation. Training Objectives After the completion of this training course, participants will be able to: Carry out and manage the day-to-day financial accounting activities associated with participation in E&P joint ventures Prepare, analyse and present information for effective financial reporting Understand the impact of a comprehensive range of activities on the financial statements of an upstream oil and gas company Practically apply IFRS in accounting for a wide range of typical oil and gas industry activities Target Audience This is an advanced level course designed for: those who have already attended E&P Accounting - Level 1 and E&P Accounting - Level 2, or those who can demonstrate, by a combination of relevant experience and previous study, sufficient prior knowledge to contribute and benefit from attending this workshop Course Level Advanced Training Methods Training Method - Scenario Based Learning Learning centers around highly realistic E&P company scenarios. A computer-based simulation is used to plan, record and report the progress of your company through several years of international E&P activities. Teams of 2 - 3 people participate in the financial management of these activities, including Operator and Non-operator accounting, recording of transactions, updating of financial statements and analysis of results. The highly interactive laptop-based scenario approach will enable you to follow the impact of each activity from initiation through to final results and analysis of company performance. You will need to bring with you to the course your own laptop PC with MS Excel™ pre-installed. Prior knowledge of spreadsheet techniques is assumed. Trainer will provide various Excel files which participants may retain at the end of the course. Course Duration: 5 days in total (35 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 25. Trainer Your expert course leader has more than 30 years of experience in the international oil and gas industry, covering all areas of Finance and Audit, including involvement in Commercial roles. During her 19 years with ENI she worked in Italy, Netherlands, Egypt and UK and was CFO for 2 major ENI subsidiaries. She has delivered training courses in Accounting, Audit, Economics and Commercial topics in many Countries. She has a Degree in Economics & Accounting and is a Certified Chartered Accountant. She is also a Chartered Auditor and an International Petroleum Negotiator. Outside of work, she is inspired by the beauty of nature and art, helping disadvantaged people, sports (football, golf) and her cat. Courses Delivered Internationally: E&P Accounting, Auditing in the Oil & Gas Industry Cost Control & Budgeting Introduction to the Oil & Gas Industry Petroleum Project Economics Contracts Strategy International O&G Exploitation Contracts 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

Start your dog training business with expert agility & leash training skills. Earn an endorsed certificate and build a rewarding career. Enroll today!

Could there be a way to release pain, unwanted habits, or life’s ups and downs? How about making positive changes happen with this powerful method – EFT Tapping, short for Emotional Freedom Techniques, and affectionately known as Tapping. EFT is The most effective energy healing modality or any modality at all that we have ever experienced. This course explains the theory and practice of EFT Tapping and gives you practical experience of the full range of powerful possibilities, for you or yours. This is not a pen-and-paper or video presentation class! This is live healing that you can actually feel! You will leave having actually experienced various forms of the EFT Tapping training at this level, with full confidence in applying it with ease. Learn and experience how to easily let go of life's stresses, strains, and ups & downs. Learn and experience how to get relief from neck and shoulder tension, headaches, chronic back-ache. Learn and experience how to get control over bad habits like eating that one biscuit too many, drinking that extra glass of wine, or those cigarettes – without any unwanted side-effects! Learn from an EFT Tapping Master Practitioner, Trainer and Author with experience in running workshops since 1999, and who is committed to raising standards and awareness of EFT Tapping.

If training forms a large part of staff members’ roles, give them the advanced techniques they need. We’ll help them assess training needs across a team, department or organisation as well as deliver training with impact and provide you with real ROI. This course includes:

Training Trainers of Spiritual Directors Developing the abilities needed to facilitate Spiritual Direction formation programmes

24-Hour Flash Sale! Prices Reduced Like Never Before!! Level 2 Certificate in Gym Instructing Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Shape the future of health and wellness with each training session you lead. In the UK, the fitness industry thrives, supported by over 10 million gym members and growing. If you're passionate about health and fitness, the Level 2 Certificate in Gym Instructing Bundle offers a unique pathway to make a significant impact. This suite of courses is expertly designed to help you master the art of fitness training and transform your passion into a dynamic career. Our course bundle spans a wide array of disciplines crucial for a successful career in fitness and wellness. From foundational Gym Instructing and Personal Training to specialised knowledge in Sports Nutritionand Diet regimes like the Mediterranean and Paleo diets, this bundle has it all. You'll explore cutting-edge fitness techniques including HIIT, Kettlebell Workouts, and Bodyweight Exercises, alongside essential medical knowledge in Sports Therapy, Physiotherapy, and First Aid. Courses Are Included In This Level 2 Certificate in Gym Instructing Bundle: Course 01: Level 2 Certificate in Gym Instructing Course 02: Gym Workouts & Bodybuilding Training Course 03: Fitness Instructor: QLS Endorsed Course 04: Personal Trainer Course 05: Sports and Fitness Coaching Course 06: Fitness with Kettlebell Course 07: HIIT Training & Bodyweight Exercises Course 08: Anatomy and Physiology of Human Body Course 09: Nutrition: 60+ Foods For Health, Fitness & Dieting Course 10: Sports Nutrition Course 11: Understanding Mediterranean and Okinawa Diets Course 12: Paleo Diet Course 13: Basic Cardiac (Heart) Care Course Course 14: Concussion and Brain Injury Awareness Course 15: Sports Injuries Course 16: Sports First Aid Course 17: Sports Medicine Fundamentals Course 18: Sports Therapy Course 19: Hydrotherapy Course 20: Cold Water Therapy Course 21: Physiotherapy Course Course 22: Pain Management Course 23: Acupressure Pain Management Course 24: Functional Skills - Fitness Course 25: Communication Skills Masterclass Step into a career that keeps you on your toes and offers the chance to genuinely impact others' lives for the better. This comprehensive training bundle is your ticket to becoming a versatile and knowledgeable fitness professional. Whether you're guiding clients through their fitness journeys or helping athletes maximise their performance, these courses provide the tools you need. Enrol today and turn your passion for fitness into a rewarding career! Learning Outcomes of this Bundle: Design and deliver safe & effective exercise programs. Achieve proficiency in diverse training techniques, including HIIT and kettlebell workouts. Understand nutritional principles and diet planning for optimal fitness. Master injury prevention and rehabilitation with sports medicine fundamentals. Develop essential first aid and physiotherapy skills for sporting contexts. Enhance communication and coaching skills to effectively guide clients. With this Level 2 Certificate in Gym Instructing course, you will get 25 CPD Accredited PDF Certificates, Hard Copy Certificate of Level 2 Certificate in Gym Instructing and our exclusive student ID card absolutely free. Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Course Curriculum Course 01: Level 2 Certificate in Gym Instructing Module 01: 7 Day Work Program Module 02: Bodybuilding Tips Module 03: HIT Module 04: Hypertrophy Module 05: Joint Health Module 06: Workout Course 02: Gym Workouts & Bodybuilding Training Module 01: Introduction Module 02: The Major Muscle Groups Explained Module 03: Muscle Growth Fundamentals Module 04: Client Assessment Module 05: Workout Design Module 06: Sample Workouts Module 07: Exercise Videos Module 08: Exercise Videos: Isolation Exercises Module 09: Setting Up A Bodybuilding Diet Module 10: Supplements Module 11: Rest & Recovery Course 03: Fitness Instructor: QLS Endorsed Module 01: Introduction Module 02: Anatomy Module 03: Client Assessment Module 04: Resistance Training Module 05: Exercise Instruction Videos Module 06: Cardio & Endurance Training Module 07: Flexibility Module 08: Feedback =========>>>>> And 22 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*25 = £325) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) 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 bundle. This bundle is ideal for: Fitness enthusiasts Aspiring gym instructors Potential personal trainers Sports therapists Diet and nutrition advisors Health coaches Progression: You can further enrol in - Level 3 Certificate in Personal Training Personal training RQF personal training Level 3 Diploma in Fitness Instructing and Personal Training (RQF) Active IQ Level 3 Diploma in Gym Instructing and Personal Training Level 3 Certificate in Personal Training (RQF) Level 2 fitness instructor Level 2 Certificate in Fitness Instructing Level 2 Certificate in Fitness Instructing (Gym-Based Exercise) (RQF) Level 2 Certificate in Fitness Instructing - Gym-Based Exercise (RQF) Level 2 Certificate in Fitness Instructing Level 3 Diploma in Fitness Instructing and Personal Training (RQF) Level 4 Certificate in Advanced Personal Training Level 3 Diploma in Personal Training (RQF) Active IQ Level 3 Diploma in Personal Training Requirements This Level 2 Certificate in Gym Instructing doesn't require prior experience and is suitable for diverse learners. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Personal Trainer: £18,000 - £50,000 Gym Instructor: £18,000 - £30,000 Sports Therapist: £20,000 - £40,000 Nutritionist: £20,000 - £50,000 Health Coach: £20,000 - £45,000 Sports Medicine Specialist: £30,000 - £70,000 Certificates CPD Accredited Digital certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard copy certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Introduction to Safeguarding Adults and Children The Role of the Designated Person About this event Introduction to Safeguarding Adults and Children The Role of the Designated Person Latest policies, legislation and guidance relating to safeguarding Collaboration and Partnership Training Requirements and Levels Adult training skills enhancement Tools for creating effective sessions

The S.C.I.E.N.C.E.S World Leader Program is a 6-month powerful personal development training tool incl. Polymathic Training and 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.