5483 Trainer courses

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

Dive into the world of purchasing and procurement in the upstream oil & gas sector with EnergyEdge's specialized classroom training program.

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

Trainer to Candidate Ratio: Working at Height Theory: 12 Students to 1 instructor; Practical: 6 Students to 1 instructor Frist Aid Theory: 12 Students to 1 instructor; Practical: 6 Students to 1 instructor Manual Handling Theory: 12 Students to 1 instructor; Practical: 12 Students to 1 instructor Fire Awareness: Theory: 12 Students to 1 instructor; Practical: 6 Students to 1 instructor Sea Survival: Theory: 12 Students to 1 instructor; Practical: 6 Students to 1 instructor Enhanced First Aid: Theory: 12 Students to 1 instructor; Practical: 6 Students to 1 instructor Advanced Rescue Training: Theory: 12 Students to 1 instructor; Practical: 4 Students to 1 instructor

SCALP MICROPIGMENTATION (SMP) IS BECOMING ONE OF THE MOST SOUGHT-AFTER TREATMENTS IN THE HAIR LOSS INDUSTRY AND IS THE FASTEST GROWING SECTOR OF THE PERMANENT MAKEUP INDUSTRY.

Train the Trainer Recharge: The Healthy Trainer Course Overview This course offers an essential refresh for trainers aiming to enhance their personal wellbeing alongside their professional skills. It focuses on maintaining a healthy balance between the demands of training others and self-care, ensuring trainers remain effective, energised, and confident. Learners will develop strategies to manage their own stress, address challenges confidently, and create positive learning environments. This course equips participants with the ability to engage audiences meaningfully, foster productive feedback, and maintain resilience in dynamic training settings. By the end, trainers will be better prepared to sustain their motivation and deliver impactful sessions while prioritising their own health and wellbeing. Course Description The programme delves into key areas crucial for trainers to maintain optimal performance and wellbeing. It covers techniques for self-management, including stress reduction and emotional regulation, alongside strategies to resolve common challenges encountered in training roles. Emphasis is placed on managing classroom dynamics and engaging diverse audiences effectively. Additionally, learners will explore ways to interpret and respond to feedback constructively to improve delivery and participant outcomes. This course combines reflective learning with evidence-based methods to build resilience, boost trainer confidence, and support continuous professional growth in a balanced, healthy manner. Participants will leave with renewed skills to enhance both their training impact and personal wellbeing. Train the Trainer Recharge: The Healthy Trainer Curriculum Module 01: Welcome to Healthy Trainer Module 02: Manage Yourself Module 03: Manage Your Issues Module 04: Manage Your Classroom Module 05: Manage Your Audience Module 06: Manage Your Feedback (See full curriculum) Who is this course for? Individuals seeking to enhance their trainer wellbeing and effectiveness. Professionals aiming to develop sustainable training practices. Beginners with an interest in personal development and training skills. Trainers wanting to improve audience engagement and feedback management. Career Path Corporate Trainer Learning and Development Specialist Workshop Facilitator Training Coordinator Education Consultant

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.

This training course is delivered by Registered Trainers with many years of on-the-job experience and who can guide you through the theoretical and practical elements of this essential healthcare training course, and answer any questions that may arise during your training.

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

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