34013 Courses 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

Explore the laws of the universe with this self-paced course from Spark Generation! From mechanics to electromagnetism, learn more about the world of matter and energy. This self-paced course guides you through real-world applications, experiments, and problem-solving exercises. Join us to unravel the mysteries of the physical world!

Explore the laws of the universe with this Cambridge self-paced course from Spark Generation! You will have the flexibility to learn when and where you want, as the course is one click away.

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

Learn the basics of makeup artistry and build a solid foundation in sanitation, contouring, eye makeup, and special effects. You will get to know about the latest tools, learn about color theory, and gain skills that translate directly into creating bridal, brow, and lip makeup. Enhance your professional portfolio and show your talent to the world!

Literacy & Numeracy and how to teach students

The Birth of the Industrial Revolution in Britain 1707 to 1830   Course Description   Introduction The Industrial Revolution started in Britain in the eighteenth century. A number of factors converged to create the conditions for developments in industry and science. Agricultural improvements created a cadre of wealthy landowners with money to invest. Improved educational opportunities, particularly in Scotland, created a broader set of young people with ideas and ambition. Greater religious freedom allowed individuals of talent to develop businesses. Interest in science and technology blossomed and the birth of the coffee house culture brought people with ideas into the orbit of those with money. But it was not all rosy. The new culture of ideas and experimentation was almost entirely limited to men. A woman’s place was seen to be in the home. At the same time the slave trade flourished providing much of the wealth for investment and, shamefully, Britain was a key facilitator in this odious business – and there were few voices of dissent at the time. And the poor lived short and brutish lives of hard physical work in grim conditions with an inadequate diet and very little healthcare. In this course I am going to take you through the key milestones of the early industrial revolution – in the textile industry, in coal mining and iron production, in civil engineering; in the development of steam power and the birth of the railways.     Course Pre-Requisites There are no course pre-requisites.     What Students will Learn The history of the industrial revolution in Britain from 1707 to 1830 The factors that created the conditions for the industrial revolution Developments in the textile industry in the eighteenth century The development of steam as a source of power The birth of steam locomotion Developments in coal, coke and iron Civil engineering in the eighteenth century Scientific developments in the eighteenth century     Curriculum SS1 The Birth of the Industrial Revolution 6 mins SS2 The Textiles Revolution 13 min SS3 The Birth of the Steam Engine 10 mins SS4 The Age of Steam Locomotion 14 mins SS5 Fuelling the Industrial Revolution 10 mins SS6 The Engineering Revolution 6 mins SS7 The Scientific Revolution 18 mins SS8 Black Lives during the Industrial Revolution 5 mins SS9 The Birth of the Industrial Revolution 2 mins SS10 The Industrial Revolution History Quiz 19 mins   Total time: 1 hour 44 minutes     Additional Resources None     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in finance processes. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Level 1, 2 & 3 Diploma in Animal Care and First Aid Training This Animal Care course is designed to transform you into a connoisseur of animal care and welfare. Developed with precision and expertise, this all-encompassing animal care course unfolds the multi-faceted world of animal well-being, covering everything from basic health and nutrition to advanced animal care topics like Animal Psychology and First Aid. Learning Outcomes: Define 'animal care & welfare' with precision, assimilating the legal and ethical ramifications. Gain an authoritative grasp on animal care by learning how to meticulously assess an animal's health status by understanding behavioural, physical, and physiological indicators. Obtain a comprehensive list of animal health aspects that are crucial for animal care worker in maintaining an animal's well-being. Grasp the importance of treatments, and delve into the specifics of administering proper animal care, including protocols vital for recovery and ongoing health. Familiarise yourself with the imperative of microchipping, a cornerstone in modern animal care that safeguards against loss and aids in quick identification. Attain a comprehensive grasp of pet nutrition essentials, enabling you to make informed choices for sustaining animal care, health and well-being. Acquire specialised knowledge in animal first aid, including essential skills in managing cardiac and respiratory emergencies and administering CPR. Manage allergic reactions effectively, and ascertain how to position an animal during emergencies for optimal recovery. Learn to counteract animal poisoning, insect stings, heatstroke, and shock. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Level 1, 2 & 3 Diploma in Animal Care and First Aid Training Course Syllabus Animal Care & Welfare: Gain a comprehensive understanding of the principles and practices essential to Animal Care and welfare. This module is engineered to provide learners with a holistic understanding of the three foundational pillars of animal care & welfare: a robust biological function, a stable emotional state, and the liberty to manifest natural behaviours. Animal Health & Nutrition in Animal Care: This module is skillfully curated to equip you with the essentials for fostering a thriving environment for animals. Recognise the integral role a sound health and nutrition system plays in elevating the quality of life for your pets or animals under professional animal care. Master the fundamentals of animal health and nutrition as they relate to comprehensive Animal Care. Hygiene And First Aid for Animals: Acquire skills in maintaining hygiene and administering first aid in the context of Animal Care. Delve into the nitty-gritty of animal first aid, a crucial skill set for both pet owners and professionals. Learn what constitutes first aid, why it's indispensable, and the situations that demand veterinary intervention. This module educates you on identifying the main classifications of emergencies, including life-threatening situations that require immediate attention. Getting to Know The Dogs & Puppies: This section aims to enhance your relationship with arguably the most loyal companions in the animal kingdom: dogs. Despite their famed loyalty and affection, dogs can sometimes exhibit behaviours that are perplexing or challenging. This module helps demystify those behaviours, ushering you into a realm of understanding that elevates your interaction with dogs to unprecedented levels. Understand the specific needs and behaviours of dogs and puppies for effective Animal Care. Getting to Know The Kittens And Cats: This section kicks off with a deep dive into feline behavior. Explore the multifaceted aspects of what makes a cat tick, whether it's their notorious independence or their elusive playfulness. Decode the enigmatic nature of cats, ranging from their grooming habits to their complex social cues, so that you can appreciate and respond to them in a more meaningful way. Learn about the unique requirements and characteristics of kittens and cats in Animal Care. Animal Psychology through Animal Care: Gain insights into animal psychology and behaviour to enhance your Animal Care practices. Animal Psychology serves as an intellectual nexus where science meets empathy, dissecting the fascinating world of animal minds across different species. In this advanced and stimulating module, you'll embark on an investigative journey to unravel the cognitive and emotional intricacies of the animals that share our world, elevating your understanding from mere observation to deeply informed comprehension.

Whether you're a passionate pet lover or an aspiring entrepreneur, this course is your pathway. Enroll with us to succeed in the rewarding world of pet sitting and dog walking.

Step into the world of small business success with our captivating online course, tailored for the dreamers and doers of today's entrepreneurial landscape.