4646 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

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

Overview With the ever-increasing demand for Communication Skills 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 Communication Skills may be. Learning about Communication Skills 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 Communication Skills . 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 Communication Skills 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 Communication Skills 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 Communication Skills 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 Communication Skills 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 Communication Skills , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Communication Skills , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Communication Skills , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Communication Skills 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 Effective Communication Effective Communication 00:00 Module 2 Effective Verbal Communication Effective Verbal Communication 00:00 Module 3 Effective Written Communication Effective Written Communication 00:00

Overview   With the ever-increasing demand for NFT 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 NFT may be.   Learning about NFT 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 NFT. 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 NFT 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 NFT Crash 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 NFT Crash 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 NFT Crash 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 NFT, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in NFT, Anyone looking for a certificate of completion on doing an online training on this topic, Students of NFT, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This NFT Crash 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 NFTs or Non Fungible Tokens NFTs or Non Fungible Tokens 00:00 Module 2 - DEFI (Decentralized Finance) DEFI (Decentralized Finance) 00:00

Overview With the ever-increasing demand for Learning Disabilities 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 Learning Disabilities may be. Learning about Learning Disabilities 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 Learning Disabilities . 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 Learning Disabilities 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 Learning Disabilities 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 Learning Disabilities 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 Learning Disabilities 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 Learning Disabilities , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Learning Disabilities , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Learning Disabilities , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Learning Disabilities 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 Chapter 1 Learning Disabilities - History and Background Learning Disabilities - History and Background 00:00 Chapter 2 Learning Strategies Learning Strategies 00:00 Chapter 3 What are Learning Disabilities What are Learning Disabilities 00:00 Chapter 4 Working Through Learning Disabilities Working Through Learning Disabilities 00:00

Overview With the ever-increasing demand for Midwifery 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 Midwifery may be. Learning about Midwifery 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 Midwifery . 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 Midwifery 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 Midwifery 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 Midwifery 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 Midwifery 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 Midwifery , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Midwifery , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Midwifery , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Midwifery 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 midwifery and maternity care Introduction to midwifery and maternity care 00:00 Module 2- Midwifery Maintenance and Culture Midwifery Maintenance and Culture 00:00 Module 3- Midwifery Support in Labour Midwifery Support in Labour 00:00 Module 4- Postnatal Care Postnatal Care 00:00 Module 5- Nurture and Nature Nurture and Nature 00:00

Overview With the ever-increasing demand for Gas Saving 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 Gas Saving may be. Learning about Gas Saving 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 Gas Saving . 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 Gas Saving 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 Gas Saving 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 Gas Saving 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 Gas Saving 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 Gas Saving , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Gas Saving , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Gas Saving , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Gas Saving 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 Chapter 1_ How To Save Gas How To Save Gas 00:00 Chapter 2_ Air Injection and Testimonials Air Injection and Testimonials 00:00 Chapter 3_ Saving Money By Saving Gas Saving Money By Saving Gas 00:00

Overview With the ever-increasing demand for Franchising 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 Franchising may be. Learning about Franchising 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 Franchising . 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 Franchising 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 Franchising 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 Franchising 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 Franchising 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 Franchising , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Franchising , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Franchising , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Franchising 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 What is a Franchise What is a Franchise 00:00 Module 2 Why Franchises are good Investments Why Franchises are good Investments 00:00 Module 3 Starting a Franchise Starting a Franchise 00:00 Module 4 Franchising Opportunities Franchising Opportunities 00:00 Module 5 Cautions before Franchising Cautions before Franchising 00:00

Overview With the ever-increasing demand for Brain Disorders Training 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 Brain Disorders Training may be. Learning about Brain Disorders Training 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 Brain Disorders Training . 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 Brain Disorders Training 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 Brain Disorders Training 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 Brain Disorders Training 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 Brain Disorders Training 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 Brain Disorders Training , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Brain Disorders Training , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Brain Disorders Training , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Brain Disorders Training 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 Chapter 1_ Mental Illness Mental Illness 00:00 Chapter 2_ Common Mental Illnesses Common Mental Illnesses 00:00 Chapter 3_ Behavioural Issues Chapter 3_ Behavioural Issues 00:00

Overview   With the ever-increasing demand for Food Delivery 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 Food Delivery may be.   Learning about Food Delivery 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 Food Delivery. 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 Food Delivery 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 Food Delivery Business 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 Food Delivery Business 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 Food Delivery Business 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 Food Delivery, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Food Delivery, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Food Delivery, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Food Delivery Business 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 - Business Preparation Business Preparation 00:00 Module 2 - Business Operations Business Operations 00:00 Module 3 - Tips and Strategies Tips and Strategies 00:00