48579 Courses in Ryton delivered On Demand

New Excel Functions   Course Description   Ross Maynard     Description In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions. The functions I am going to cover are: RANDARRAY- creating a table of random numbers or random dates UNIQUE – identifying the distinct items in a list SEQUENCE – listing numbers with a set interval SORT and SORTBY – new ways of dynamically sorting data FILTER – building the ability to filter data into formulae XLOOKUP – replacing VLOOKUP with greater flexibility IFS and SWITCH making it easier to construct IF statements The new CONCAT, and TEXTJOIN text functions   If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.         Learning Outcomes Participants in this course will learn: What the new dynamic arrays feature in Microsoft Excel means How the new RANDARRAY function works How the new UNIQUE function works How the new SEQUENCE function works How the new SORT and SORTBY functions work How the new FILTER function works How the new XLOOKUP function can replace VLOOKUP How to build IF statements with the new IFS function How the new SWITCH function works How the new TEXTJOIN function can replace CONCATENATE and CONCAT How the new functions can be used in management reporting     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.       About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

A short audio created by a qualified therapist. This calming audio is for self-regulation and anxiety. Using a combination of grounding techniques, breathwork and visualisation, this gentle audio will talk you through step by step, bringing you to a place of calm and can be used again and again. Ideal for moments of overwhelm or anxiety

A super short course in settling in a new puppy with success from day 1 plus how to get your pup toilet trained at super speed Course curriculum 1 Settling in & Toilet Training! Settling In Part 1 Settling In Part 2 Top 5 Settling In Tips! Toilet Training 101

A recorded lesson about The Great Fire of London, perfect for 7-11 year olds.

Literacy & Numeracy and how to teach students

Title: 🌡️ Mastering Workplace Health: Infectious Diseases in the Workplace 🌡️ Are you ready to safeguard your workplace against the invisible threats of infectious diseases? Introducing our comprehensive text course, 'Infectious Diseases in the Workplace,' your ultimate guide to understanding, preventing, and managing contagious illnesses within your professional environment.   👨‍💼 Why Choose 'Infectious Diseases in the Workplace'? In today's fast-paced and interconnected world, infectious diseases pose a significant risk to businesses and employees alike. From seasonal flu outbreaks to global pandemics, being prepared to tackle these challenges head-on is essential for maintaining productivity, morale, and most importantly, safety in the workplace. Our expertly crafted text course offers invaluable insights into the world of infectious diseases, equipping you with the knowledge and strategies necessary to protect yourself, your colleagues, and your organization. Delve into topics such as: Understanding the fundamentals of infectious diseases Identifying common workplace pathogens Implementing effective prevention and control measures Navigating legal and ethical considerations Responding to outbreaks and emergencies with confidence With a blend of theory, practical tips, and real-world case studies, this course empowers you to become a proactive advocate for workplace health and safety.   👩‍💼 Who is this for? Whether you're an HR professional, a healthcare worker, a manager, or simply someone who wants to promote a healthier work environment, this course is tailor-made for you. No prior medical or scientific knowledge is required - just a desire to learn and a commitment to fostering a safer workplace for all.   💼 Career Path Investing in your understanding of infectious diseases in the workplace opens up a world of opportunities across various industries and roles. Here are just a few career paths that can benefit from this course: Occupational Health Specialist: Become an indispensable asset to your organization by developing expertise in preventing and managing workplace-related health issues. Human Resources Manager: Safeguard employee well-being and organizational productivity by integrating infectious disease management strategies into HR policies and procedures. Healthcare Administrator: Lead your healthcare facility to excellence by staying ahead of infectious disease trends and implementing best practices for infection control. Emergency Preparedness Coordinator: Prepare your organization to respond effectively to infectious disease outbreaks and other health-related emergencies. Public Health Advocate: Champion community health initiatives and advocate for policies that promote disease prevention and workplace safety.   🔍 FAQs Q: Can I take this course if I don't have a background in healthcare or science? A: Absolutely! Our course is designed to be accessible to individuals from all backgrounds. We provide clear explanations and practical examples to ensure that everyone can grasp the concepts and apply them effectively in the workplace. Q: How long does it take to complete the course? A: The duration of the course depends on your pace of learning. On average, students complete the course within [insert estimated timeframe], but you can progress through the material at your own convenience. Q: Will I receive a certificate upon completion? A: Yes, upon successfully completing the course and passing the final assessment, you will receive a certificate of completion to showcase your newfound expertise in infectious disease management. Q: Is the course updated to reflect current events and emerging infectious diseases? A: Absolutely. We continuously monitor developments in the field of infectious diseases to ensure that our course content remains relevant and up-to-date. You can rest assured that you'll be equipped with the latest knowledge and strategies to address evolving challenges in the workplace. Q: Can I access the course materials on mobile devices? A: Yes, our platform is mobile-friendly, allowing you to access course materials anytime, anywhere, from your smartphone or tablet. Don't let infectious diseases catch you off guard. Enroll in 'Infectious Diseases in the Workplace' today and take the first step towards creating a safer, healthier, and more resilient workplace environment. Your colleagues - and your bottom line - will thank you. 🚀 Course Curriculum Module 1 Introduction to Infectious Diseases in the Workplace Introduction to Infectious Diseases in the Workplace 00:00 Module 2 Common Infectious Diseases in the Workplace Common Infectious Diseases in the Workplace 00:00 Module 3 Personal Protective Equipment (PPE) Personal Protective Equipment (PPE) 00:00 Module 4 Hygiene Practices to Prevent the Spread of Infectious Diseases Hygiene Practices to Prevent the Spread of Infectious Diseases 00:00 Module 5 Vaccinations and Immunizations Vaccinations and Immunizations 00:00 Module 6 Health and Safety Policies and Procedures Health and Safety Policies and Procedures 00:00

💼 Unlock the Secrets of Investment Banking: Your Path to Financial Success! 💰 Are you ready to dive into the fast-paced world of investment banking? Enroll in our Investment Banking text course and embark on a journey towards mastering the intricacies of finance, mergers, acquisitions, and more. Whether you're a seasoned professional looking to advance your career or a novice eager to enter the world of high finance, this course is your gateway to success.   🌟 Why Invest in Investment Banking? Investment banking is a dynamic and lucrative field that plays a crucial role in the global economy. By understanding the fundamentals of investment banking, you'll gain invaluable insights into financial markets, corporate finance, and strategic decision-making. Whether you aspire to become an investment banker, financial analyst, or corporate strategist, this course will equip you with the knowledge and skills needed to thrive in a competitive industry.   📚 What Will You Learn? In our Investment Banking text course, you'll explore a wide range of topics, including: Financial Markets and Instruments Corporate Valuation and Financial Modeling Mergers and Acquisitions Capital Markets and Fundraising Risk Management and Regulatory Compliance With each module, you'll deepen your understanding of key concepts and principles, preparing you to tackle real-world challenges with confidence and expertise.   🎓 Who is This For? Our Investment Banking course is perfect for: Finance Professionals Seeking Career Advancement Students Pursuing Careers in Investment Banking or Finance Entrepreneurs and Business Owners Looking to Navigate Financial Markets Anyone Interested in Understanding the Dynamics of Corporate Finance and Capital Markets No matter your background or experience level, this course offers something for everyone interested in mastering the art of investment banking.   🚀 Career Path Upon completing our Investment Banking course, you'll be well-positioned to pursue a variety of exciting career opportunities, including: Investment Banking Analyst Financial Analyst Corporate Finance Manager Mergers and Acquisitions Advisor Asset Manager Private Equity Associate With the foundational knowledge and skills acquired in this course, you'll be equipped to excel in diverse roles within the finance industry, paving the way for a rewarding and prosperous career.   🔍 Frequently Asked Questions (FAQs) Q: Is this course suitable for beginners with no prior finance experience? A: Yes, our Investment Banking course is designed to accommodate learners of all levels, from beginners to seasoned professionals. We provide clear explanations and practical examples to ensure that even those with minimal finance background can grasp complex concepts. Q: How long does it take to complete the course? A: The duration of the course varies depending on your learning pace and schedule. On average, most students complete the course within [insert estimated time frame], but you can progress at your own pace and revisit materials as needed. Q: Will I receive a certificate upon completion of the course? A: Yes, upon successfully completing the Investment Banking course, you'll receive a certificate of achievement, showcasing your newfound expertise in investment banking and finance. Q: Can I access the course materials on mobile devices? A: Absolutely! Our course materials are accessible on all devices, including desktops, laptops, tablets, and smartphones, allowing you to learn anytime, anywhere. Q: Is there any prerequisite knowledge required to enroll in the course? A: While prior knowledge of finance or accounting may be beneficial, it is not required. Our course covers fundamental concepts and builds upon them progressively, making it accessible to learners of all backgrounds.   🌐 Begin Your Journey to Financial Mastery Today! Don't miss out on this opportunity to gain invaluable skills and insights into the world of investment banking. Enroll now in our Investment Banking text course and take the first step towards a successful and rewarding career in finance. Your path to financial success starts here! 🌟💼📈 Course Curriculum Module 1 Introduction to Investment Banking Introduction to Investment Banking 00:00 Module 2 Financial Markets and Instruments Financial Markets and Instruments 00:00 Module 3 Capital Markets and Investment Banking Capital Markets and Investment Banking 00:00 Module 4 Trading and Sales in Investment Banking Trading and Sales in Investment Banking 00:00 Module 5 Research and Analysis in Investment Banking Research and Analysis in Investment Banking 00:00 Module 6 Asset Management in Investment Banking Asset Management in Investment Banking 00:00

Overview   'A man without a goal is like a ship without a rudder'. We often find people around us clueless about their life, career, future, and just about everything else. All they need is a little push in the direction - from someone expert enough who knows where and how much to push. That man with expertise is called a life coach. The demand for life coaches is soaring high day by day. And we aim to fill up this demand by building you into a skilled life coach so that you can start making an impact in people who direly need it.   The course materials of this online course on life coaching have been prepared with consultation from the relevant experts. The information available on Life Coaching is kept up to date regularly so that learners don't get left behind on the current trends/updates. As a result, you will gain the following skills from the learning materials of this life coach training:   Coaching/Life Coaching Self-management Elevator Pitching Business Development Selling & Marketing Programme Outlining Relationship & Confidentiality Management Performance Evaluation Business Finance   The self-paced online learning methodology from Compete High helps you learn whenever or however you wish - keeping in mind the busy schedule of the learners or the possible inconveniences that come with physical classes. The bite-sized lessons are proven to be most effective in memorising and learning them by heart. On top of that, you have the option to receive a certificate of accomplishment after successfully completing the course!   So, instead of searching for hours, enrol right away on this Life Coaching course from Compete High and accelerate your career on the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for? While we don't discourage anyone or impose restrictions on enrolling and learning something new from this Life Coaching course, people falling under any of the following criteria will benefit the most: People aiming to start a life coaching business Anyone looking for the basics of Life Coaching, Anyone who wants to be an independent Life Coach, Anyone looking for a certificate of completion on doing an online training on Life Coaching, Anyone with a general interest/curiosity   Career Path As mentioned above, this Life Coaching course is the perfect gateway for a rewarding career ahead as an independent life coach or by starting a life coaching business. Although the earning potential varies based on experience, branding, and other factors, the average annual income of a life coach can go from £35,000 to even £120,000. Course Curriculum Module 1: Basics of Coaching Basics of Coaching 00:00 Module 2: Life Coaching: An Overview Life Coaching: An Overview 00:00 Module 3: Developing Your Coaching Skills Developing Your Coaching Skills 00:00 Module 4: Getting Yourself Right First Getting Yourself Right First 00:00 Module 5: Primary Steps to Starting a Career as a Life Coach Primary Steps to Starting a Career as a Life Coach 00:00 Module 6: Self-Management as a Life Coach Self-Management as a Life Coach 00:00 Module 7: Selling and Marketing Your Life Coaching Business Selling and Marketing Your Life Coaching Business 00:00 Module 8: Relationship with Clients, Confidentiality and Ethical Standards Relationship with Clients, Confidentiality and Ethical Standards 00:00 Module 9: Professional Development and Relationships with other Competitors Professional Development and Relationships with other Competitors 00:00 Module 10: Financing Your Life Coaching Business Financing Your Life Coaching Business 00:00

Overview   With the ever-increasing demand for Hair Care in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Hair Care may be.   Learning about Hair Care or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Hair Care. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Hair Care is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by compete high in this Afro Kids Hair Care course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Afro Kids Hair Care course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Afro Kids Hair Care course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Hair Care, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Hair Care, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Hair Care, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Afro Kids Hair Care course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1- Introduction to Kids Natural Hair Care Introduction to Kids Natural Hair Care 00:00 Module 2-Afro Hair Care Routine for Your Child Afro Hair Care Routine for Your Child 00:00 Module 3-Hair Care Products for Afro Textured Kids Hair Care Products for Afro Textured Kids 00:00 Module 4-Daily Maintenance and Care for Afro Hair Daily Maintenance and Care for Afro Hair 00:00 Module 5-Providing Proper Nutrition to Your Child's Hair Providing Proper Nutrition to Your Child's Hair 00:00 Module 6-Styling Afro Textured Kids Natural Hair Styling Afro Textured Kids Natural Hair 00:00 Module 7-Problems in Curly Kinky Hair and their Solutions Problems in Curly Kinky Hair and their Solutions 00:00 Module 8-Afro-American Boys Hair Care Afro-American Boys Hair Care 00:00

Overview With the ever-increasing demand for Nursing in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Nursing may be. Learning about Nursing or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Nursing. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Nursing is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Nursing Diploma course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Nursing Diploma course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for? While we refrain from discouraging anyone wanting to do this Nursing Diploma course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Nursing, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Nursing, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Nursing, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path This Nursing Diploma course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 01 - Foundations of Nursing Practice Foundations of Nursing Practice 00:00 Module 02 - The Nursing Process The Nursing Process 00:00 Module 03 - Roles Basic to Nursing Care Roles Basic to Nursing Care 00:00 Module 04 - Actions Basic to Nursing Care Actions Basic to Nursing Care 00:00 Module 05 - Healthcare Overview Healthcare Overview 00:00 Module 06 - Bioethics Bioethics 00:00 Module 07 - Physical Healthcare Physical Healthcare 00:00 Module 08 - Mental Healthcare Mental Healthcare 00:00 Module 09 - Public Health Public Health 00:00 Module 10 - Related Sectors Related Sectors 00:00 Module 11 - Healthcare Worker Healthcare Worker 00:00