This is unlike any other leadership programme you’ve ever taken part in – it is all about learning the practicalities of showing up as an emotionally intelligent leader who is trusted, engages effectively, connects well, makes people feel they matter and creates a psychologically safe environment where people can bring their very best contributions to the team and the organisation.
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
Overview Learn about Health and Safety Executive (HSE) from industry experts and boost your professional skill. This Health and Safety Executive (HSE) course will enhance your skill and make you ready for the job market. You'll get expert opinions about the best practices and problems of Health and Safety Executive (HSE). You'll also gain the skills of Health and Safety Executive (HSE) to excel in your job and tips to master professional skills in no time. You'll be connected with the community of Health and Safety Executive (HSE) professionals and gain first-hand experience of Health and Safety Executive (HSE) problem-solving. The Health and Safety Executive (HSE) is self-paced. You can complete your course and attend the examination in your suitable schedule. After completing the Health and Safety Executive (HSE), you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job. This Health and Safety Executive (HSE) will provide you with the latest information and updates of Health and Safety Executive (HSE). It will keep you one step ahead of others and increase your chances of growth. Why buy this Health and Safety Executive (HSE)? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Health and Safety Executive (HSE) you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Health and Safety Executive (HSE) does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Health and Safety Executive (HSE) was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Health and Safety Executive (HSE) is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Health and Safety Executive (HSE) Health and Safety at Work and the Laws 00:23:00 Managing for Health and Safety 00:42:00 Risk Assessment and Common Risks 00:21:00 Workplace Health, Safety and Welfare 00:19:00 Accidents and Ill Health at Work 00:17:00 Electrical, Fire and Gas Safety 00:25:00 Safety in Different Work Settings 00:21:00 Work Equipment Hazards and Risk Control 00:22:00 Other Health and Safety Hazards at Work 00:23:00 Mock Exam Mock Exam - Health and Safety Executive (HSE) 00:20:00 Final Exam Final Exam - Health and Safety Executive (HSE) 00:20:00
Not sure where to start your DevOps journey? Or want to know what kind of activities a DevOps engineer would do on Git and GitHub in the real world? Or would you like to set up a production-ready Git environment for your developers? Then this course is for you.
ð¡ Sparkling Workspaces, Seamless Operations: Housekeeping On The Job Site Online Training Course! ð§¹ Are you ready to elevate your job site with cleanliness and efficiency? Enroll in our Housekeeping On The Job Site Online Training Course, a comprehensive program meticulously designed to equip you with the knowledge and techniques needed to maintain a clean and organized work environment. Join us on a journey where cleanliness meets productivity, creating a workplace culture that values order and safety. ð Module 1: Introduction to Housekeeping on the Job Site - Tasks and Techniques Embark on your training journey with Module 1, providing a comprehensive introduction to housekeeping on the job site. Learn essential tasks and techniques for effective housekeeping, setting the foundation for a clean and organized work environment. ð§¼ Module 2: Addressing Housekeeping Challenges - Standards and Continuous Improvement Master the art of overcoming challenges in Module 2, focusing on housekeeping standards and continuous improvement. Explore strategies to address common challenges, establish standards for cleanliness, and implement a culture of continuous improvement in housekeeping practices. ð¤ Module 3: Teamwork and Collaboration in Housekeeping Culture Optimize your housekeeping efforts with Module 3, dedicated to teamwork and collaboration. Learn how to foster a culture of collaboration among team members, ensuring everyone contributes to maintaining a clean and organized work environment. ð Module 4: Housekeeping Inspections - Accident Prevention Enhance safety measures with Module 4, focusing on housekeeping inspections and accident prevention. Learn to conduct thorough inspections, identify potential hazards, and implement preventative measures to create a safer work environment. ð Module 5: Housekeeping Ongoing Training and Reinforcement Empower your team with continuous learning in Module 5, where you'll focus on ongoing training and reinforcement. Develop strategies to reinforce housekeeping practices, provide ongoing training, and ensure everyone is aligned with the highest standards of cleanliness. ð Module 6: Course Recap and Final Assessment Cap off your training with Module 6, summarizing key takeaways and conducting a final assessment. Reinforce your understanding of housekeeping best practices, assess your proficiency, and ensure your team is ready to maintain a clean and organized job site. ð Why Choose Our Housekeeping On The Job Site Online Training Course? Expert-Led Training: Learn from seasoned professionals specializing in workplace cleanliness and organization. Interactive Learning: Engage in practical simulations, real-world scenarios, and interactive exercises to apply theoretical knowledge. Customizable Training: Tailor the course to suit the specific needs of your industry or organization, ensuring maximum relevance. Productivity Booster: Enhance workplace efficiency by fostering a culture of cleanliness and organization. Don't let clutter hinder your workplace efficiency! Enroll now in the Housekeeping On The Job Site Online Training Course and empower yourself with the knowledge and skills needed to maintain a clean, organized, and productive work environment. Your journey to workplace cleanliness begins here! ð¡â¨ð Course Curriculum Module 1 Introduction to Housekeeping on the Job Site Tasks and Techniques Introduction to Housekeeping on the Job Site Tasks and Techniques 00:00 Module 2 Addressing Housekeeping Challenges Standards and Continuous Improvement Addressing Housekeeping Challenges Standards and Continuous Improvement 00:00 Module 3 Teamwork and Collaboration in Housekeeping Culture Teamwork and Collaboration in Housekeeping Culture 00:00 Module 4 Housekeeping Inspections Accident Prevention Housekeeping Inspections Accident Prevention 00:00 Module 5 Housekeeping Ongoing Training and Reinforcement Module 5 Housekeeping Ongoing Training and Reinforcement 00:00 Module 6 Course Recap and Final Assessment Course Recap and Final Assessment 00:00
Tired of browsing and searching for a Poultry Farming course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Poultry Farming bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Poultry Farming course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Poultry Farming and help you along your learning journey. Advanced audio-visual learning modules of these Poultry Farming courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Poultry Farming, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Poultry Farming Bundle Consists of the following Premium courses: Course 01: Poultry Farming Course 02: Agricultural Science Course 03: Animal Science Course 04: Animal Nutrition & Diet Course 05: Botany Course 06: Arboriculture Course 07: Forestry Course 08: Land Management Course Course 09: Hydroponics Gardening Course 10: Gardening and Horticulture Course 11: Mushroom Growing Course Course 12: Environment Management Course 13: Conservation Diploma Course Course 14: Environmental Law Enrol now in Poultry Farming to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Poultry Farming expertise and essential knowledge, which will assist you in reaching your goal. Curriculum: Course 01: Poultry Farming Introduction to Poultry Farming. Poultry Nutrition Diseases Vaccination Layers Broilers Ducks Turkey Incubation Brooding Housing and the Environment Record Keeping, Economics and Marketing Insect and Pest Control Safety and Awareness CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Requirements Our course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Poultry Farming expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Poultry Farming) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Poultry Farming) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.
Employee Motivation Certification Employee motivation is pivotal to a company's success. Workers who enjoy their jobs are more productive and more willing to put in extra effort and take fewer sick days. A motivated workforce contributes to a positive company culture, which in turn attracts talented employees and reduces turnover. This course provides an introduction to the mechanics of employee motivation, the factors that encourage people to give their best at work, and how to increase worker motivation. You will learn two theories of motivation and how they can be translated into everyday management practice. You Will Learn: Why organisations must take the issue of employee motivation seriously and how motivation can be understood using the ERG and Goal Setting models. How these theories can help us understand what really motivates employees and how managers can put these insights into practice. How to show appreciation to your employees and why traditional recognition schemes may not be effective. How and why employee involvement boosts motivation and the merits of the Tell, Sell, Consult and Join model as a decision-making framework. How to promote an enjoyable, inspiring and inclusive work environment that encourages a healthy work-life balance. Benefits Of Taking This Course You will develop a general understanding of employee motivation, which is invaluable if you work in a management position. You will be able to help disengaged employees regain their motivation, thus improving company performance. You will be able to prevent absenteeism and high turnover by promoting a healthy workplace environment. You will be able to make practical recommendations regarding employee motivation at all levels of your organisation. You will learn how to collaborate with employees to improve workplace processes and policies in a way that enhances everyone's job satisfaction.
Food Safety Cross Contamination Certification As indicated by the Food Standards Agency (FSA), there are more than 500,000 instances of food contamination in the UK consistently. Not exclusively are these ailments unsavory, they can likewise be deadly in a minority of cases. Cross-tainting is a typical reason for food contamination. It can happen in any kitchen or premises that handles both crude and prepared to-eat food sources. Luckily, with suitable security controls and cleanliness measures, it tends to be disposed of. This course will show you how to decrease the danger of cross-tainting in the work environment. You will Learn: What cross-defilement is, the way it happens, and the kinds of microscopic organisms that cause most foodborne diseases Why you should take each sensible measure to isolate crude and prepared to-eat food varieties, and how to execute FSA rules on food partition How a continuous cleaning timetable can forestall cross-pollution, and pragmatic guidance on the most proficient method to clean work surfaces Why and how close to home cleanliness and hand-washing techniques are significant in decreasing the danger of cross-tainting Advantages of taking this Course: On the off chance that you work in a kitchen, this course will help you work in a protected, sterile way that defends the strength of your clients and associates In the event that you are liable for doing hazard appraisals in your work environment, this course will assist you with discovering whether there is a sensible danger of cross-tainting In the event that you are an entrepreneur, this course will help you meet your commitments under sanitation law On the off chance that you are keen on general wellbeing, this course will give you an important knowledge into a territory of continuous worry in the food and cooking businesses
Parental Rights Certification Numerous specialists will, eventually, need time off work to invite another child into their family. In the UK, Maternity, Adoption, Paternity and Shared Parental Leave (SPL) offer "parental rights" upon laborers. All organizations need to have a functioning comprehension of applicable work laws to guarantee that all representatives are dealt with reasonably. In this course, you will realize what a specialist is qualified for get regarding paid and neglected leave, and how their business rights are dependent upon security while they are away from the work environment. You Will Learn: Who is qualified for Statutory Maternity Leave (SML), Statutory Maternity Pay (SMP) and Maternity Allowance (MA) Extraordinary cases whereby various standards may apply concerning the arrangement of SML and SMP, like sailors and chiefs Who is qualified for Statutory Paternity Leave and Statutory Paternity Pay (SPP) Who is qualified for Shared Parental Leave (SPL) and Shared Parental Pay (ShPP), and how the recompenses are determined The privileges of laborers who are away from the work environment on parental leave, and the privileges of laborers to take impromptu, neglected leave to really focus on their wards Advantages of Taking This Course: On the off chance that you work in a HR job, this course will furnish you with a valuable outline of parental rights that will guarantee all specialists get the advantages they merit On the off chance that you own a business, this course will help you meet your commitments under the law concerning parental rights In the event that you are a laborer, this course will illuminate you regarding your privileges under the law On the off chance that you are a director, this course will assist you with understanding the privileges of your colleagues and oversee them as needs be