4448 Trainer courses in Leicester delivered Online

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 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 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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 Certificates Certificates Certificate of completion Digital certificate - Included

Functional fitness exercises are designed to train the muscle to work together, and tend to use multiple joints and muscles to maximise your fitness levels. In this course, you will learn the basic principles of functional fitness, to fine tune your fitness regime. You will learn about the benefits of functional fitness and how it trains the muscles to work together. It also covers essential information on common mistakes to avoid when performing functional fitness exercises.  This course will train you how to improve your balance, endurance and range of motion, developing your flexibility, with step-by-step video guidance. Whether you are looking to take your fitness routine to the next level, or kickstart a career in the fitness industry, this course introduces techniques that will help you get in shape in no time, from the comfort of your own home. Learning Outcomes: Learn about the benefits of functional fitness, and how it trains the muscles to work together Understand the common mistakes to avoid when performing functional fitness exercises Improve your balance and range of motion, with our step-by-step training Take your endurance to the next level and increase your flexibility Achieve your weight loss goals from the comfort of your own home Gain the practical skills and knowledge to kickstart a career in the fitness industry Enhance your fitness routine and strengthen your core muscles in no time Reduce the risk of injury and improve your quality of life Career Path On successful completion of this course, learners will be able to incorporate functional exercises into their everyday fitness routine, with the opportunity to earn valuable information of the following careers: Fitness Instructor Personal Trainer Fitness Coach Section 01: First Concepts & Benefits Introduction 00:01:00 What is Functional Fitness? 00:08:00 Benefits of Functional Fitness 00:08:00 Section 02: Understanding & Beating Anxiety Functional Fitness and Others Exercises 00:08:00 Common Mistakes with Functional Fitness 00:07:00 Functional Fitness and Power 00:08:00 Section 03: Strength, ROM, Balance & Endurance Functional Fitness and Strength 00:07:00 Functional Fitness And Range of Motion 00:06:00 Functional Fitness and Balance and Endurance 00:07:00 Section 04: Final Thoughts & Tips Conclusion 00:01:00

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! According to recent studies, HIIT training & bodyweight exercises are some of the most effective ways to burn fat, build lean muscle, and improve overall fitness levels. If you're looking to get fit, lose weight, and tone your body, then this HIIT Training & Bodyweight Exercises course is perfect for you! This Certificate in HIIT Training & Bodyweight Exercises at QLS Level 3 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Throughout the HIIT Training & Bodyweight Exercises course, you'll learn how to design and progress your own HIIT workouts, as well as gain access to exercise videos to keep your routine fresh and exciting. In addition, you'll also discover the importance of nutrition and how to determine your ideal calorie intake and macronutrient ratios. By the end of this HIIT Training & Bodyweight Exercises course, you'll have all the tools and knowledge you need to achieve your fitness goals and transform your body. After this HIIT Training & Bodyweight Exercises course, you will be able to learn: Understand the benefits of HIIT training and bodyweight exercises. Design and progress your own HIIT workouts for optimal results. Perform a range of bodyweight exercises with correct form and technique. Determine your ideal calorie intake and macronutrient ratios for your fitness goals. Identify quality protein, carb and fat sources to support your nutrition plan. Select appropriate supplements to enhance your fitness journey. Why Prefer This HIIT Training & Bodyweight Exercises at QLS Level 3 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of this HIIT Training & Bodyweight Exercises course: Module 01: Introduction Module 02: Workout Module 03: Exercise Videos (use these to change up your workout) Module 04: Diet Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Certificate in HIIT Training & Bodyweight Exercises at QLS Level 3 exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This HIIT Training & Bodyweight Exercises at QLS Level 3 course is for: Fitness enthusiasts looking to improve their overall health and fitness levels. Individuals wanting to lose weight and tone their bodies through HIIT training and bodyweight exercises. Anyone interested in learning about nutrition and how to optimise their diet for their fitness goals. Requirements HIIT Training & Bodyweight Exercises at QLS Level 3 No prior background or expertise is required. Career path The HIIT Training & Bodyweight Exercises at QLS Level 3 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Like as: Fitness instructor: £20,000 - £30,000 Personal trainer: £18,000 - £40,000 Gym manager: £25,000 - £35,000 Fitness blogger/vlogger: varies Health and wellness coach: £25,000 - £40,000 Sports nutritionist: £25,000 - £40,000 Certificates Certificate in HIIT Training & Bodyweight Exercises at QLS Level 3 Hard copy certificate - Included After successfully completing the Certificate in HIIT Training & Bodyweight Exercises at QLS Level 3, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost. CPDQS Accredited Certificate Digital certificate - Included

This training is for lawyers and covers key topics to ensure compliance with the Lexcel standard and other regulations.

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk 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 classrom, 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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 Certificates Certificates Certificate of completion Digital certificate - Included

The emphasis is on competence, fitness to practice and life-long learning. Underpinning this is that clinical specialists and experts take the lead in teaching and training to develop knowledge and skills. However, not everyone has the tools to teach knowing how to is the key to successful learning, this programme is designed to Train the Trainer.

Overview This comprehensive course on TRX Bodyweight Workout - Fat Loss & Muscle Building Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This TRX Bodyweight Workout - Fat Loss & Muscle Building Training comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the Course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this TRX Bodyweight Workout - Fat Loss & Muscle Building Training. It is available to all students, of all academic backgrounds. Requirements Our TRX Bodyweight Workout - Fat Loss & Muscle Building Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 31 lectures • 01:08:00 total length •Introduction & What you will learn: 00:02:00 •TRX explained: Why it can be better than normal exercise: 00:02:00 •Who is TRX for?: 00:04:00 •What are the benefits of TRX?: 00:03:00 •Most common TRX mistakes: 00:03:00 •How to set up your TRX trainer system: 00:03:00 •The TRX Workout Plan: 00:04:00 •How to progress with your TRX workout: 00:05:00 •The right warm up: 00:01:00 •Dynamic stretching routine: 00:03:00 •Compound vs isolation exercises: 00:02:00 •TRX Biceps Curl: 00:01:00 •TRX Body Row: 00:01:00 •TRX Chest Flyes: 00:01:00 •TRX Chest Press: 00:01:00 •TRX Hamstring Curl: 00:01:00 •TRX Lunge and Row: 00:01:00 •TRX Lunges: 00:01:00 •TRX Pike Press: 00:01:00 •TRX Plank: 00:01:00 •TRX Push Up: 00:01:00 •TRX Side Plank: 00:01:00 •TRX Single Leg Squats: 00:01:00 •TRX Squats: 00:01:00 •TRX Triceps Extensions: 00:01:00 •TRX Y Flyes: 00:01:00 •How to combine TRX and Cardio: 00:04:00 •TRX Cardio routine: 00:03:00 •Boosting your results overview: 00:01:00 •Step by step muscle building formula: 00:09:00 •Best Beginner Supplements: 00:04:00

Stop Smoking With Confidence Training Program, you'll learn the skills you need to finally stop smoking and stay smoke-free. A swift, no-nonsense primarily audio course of action to become a Non-Smoker within the next seven days, includes hypnosis. Your trainer is Caroline Anderson MSc Psych, BSc Clinical Hypnosis,Mstr NLP, EFT3, Dip Personnel Mgmt.

Official BRCGS Food Safety Issue 9 Lead Auditor training course. Delivered online (Zoom) by a live BRCGS Approved Training Partner & Virtual Trainer. Exam and Certificate fee included in the price.

Getting a dog is an exciting time for the entire family. As man's greatest friend, a devoted dog is more than simply a pet since they are treated as a treasured part of the family. However, in order to acquire that degree of affection and connection, owners need to consider starting their dog on the correct foot. Dogs should have a strong foundation in obedience and problem behaviour avoidance so that you and they can be happier and healthier. We have good news for you if you are a dog lover or just want to learn how to train a dog. We have prepared the Dog Training course to meet all your needs. This course will teach you the fundamentals of dog care and how to greet your new dog. Then you should be aware of canine communication and separation anxiety. Among other things, this Dog Training course will provide the answers to ten frequently asked dog questions. You will get an understanding of the principles of client-dog training consultations. Dog training will be a difficult undertaking, especially at first. And if you're having trouble communicating with them, training them to be obedient and behave appropriately will be much more difficult. This is where this Dog Training course can help. It will undoubtedly give you vital commands and abilities on how to teach dogs, as well as more about challenges you may experience during the process and how to resolve them. So, without wasting your time, join us now! Learning Outcomes Positive reinforcement can aid in the prevention of aggressive behaviour. Explore the right way to greet a dog. Enhance your dog's communication skills. Recognise and define the various dog expressions. Learn how to handle ten common dog issues. Find out more about client-dog training consultations. You Will Get An Additional Course As A Gift! Dog Agility Course Why Prefer This Dog Training Course? Earn a certificate endorsed by the Quality Licence Scheme & another certificate accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Dog Training course: Module 1: Introduction Module 2: Feeding Time - Aggression and Stealing Food Module 3: The Right Way to Greet a Dog Module 4: Separation Anxiety Module 6: The Answers To 10 Popular Dog Questions You Are Likely To Be Asked Module 7: The Answers To 10 Common Puppy Training Questions That You'll Likely Be Asked Module 8: Dog Training Consultations With Clients Bonus Video A Demonstration Of A Real-Life Dog Training Consultation Assessment Process After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analyzed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Diploma in Dog Training at QLS Level 5 exam, you will be able to request a certificate with additional cost that has been endorsed by the Quality Licence Scheme. CPD 160 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 course. This course is open to everybody. Career path The Dog Training course is ideal for dog owners and lovers who wish to live in peace with their well-behaved and obedient canines. It can also aid with professions in pet care, such as: Dog Trainer Veterinarian Pet Groomer In the UK, the average salary of a dog trainer is typically £25,000 per annum. Certificates Certificate Accredited by CPDQS Digital certificate - £10 Diploma in Dog Training at QLS Level 5 Hard copy certificate - £119 Show off Your New Skills with a Certificate of Completion After completing the Diploma in Dog Training at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 119 GBP inside the UK 129 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS Upon finishing the Dog Training course, you need to order to receive a Certificate Accredited by CPD that is recognised all over the UK and also internationally. The pricing schemes are - 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)