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
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.
ð¦ Unlock the Secrets of Banking: Enroll in Our Banking Text Course Today! ð Are you ready to navigate the intricate world of banking with confidence and expertise? Look no further! Our comprehensive Banking Text Course is designed to provide you with essential knowledge and insights into the dynamic realm of finance. Whether you're a banking professional seeking to enhance your skills or an individual eager to understand the fundamentals of banking, this course is your gateway to success. ð Why Choose Our Banking Text Course? Comprehensive Coverage: Dive into the core concepts of banking, from financial institutions and services to banking regulations and risk management. Accessible Learning: Access course materials anytime, anywhere, making learning convenient and flexible to fit your busy schedule. Expert Insights: Benefit from the wisdom and expertise of industry professionals who bring real-world experience to the virtual classroom. Practical Applications: Gain practical knowledge and skills that you can immediately apply in your personal and professional life. ð What Will You Learn? Explore the role of banks in the economy and the financial system. Understand different types of banking services, including retail banking, commercial banking, and investment banking. Gain insights into banking regulations, compliance requirements, and risk management practices. Learn about financial products and services offered by banks, such as loans, mortgages, and credit cards. Explore emerging trends and technologies shaping the future of banking, including digital banking and fintech innovations. ð¨âð Who is this for? Banking professionals looking to enhance their knowledge and skills. Students pursuing a career in finance or banking. Entrepreneurs and business owners seeking to understand banking fundamentals. Individuals interested in personal finance and financial literacy. ð Career Path Upon completing our Banking Text Course, you'll be equipped with valuable knowledge and skills that can open doors to a wide range of career opportunities in the finance and banking industry. Whether you aspire to work as a bank teller, financial analyst, investment banker, or even start your own fintech company, this course will provide you with a solid foundation to pursue your goals. ð FAQs (Frequently Asked Questions) Q: Is this course suitable for beginners with no prior knowledge of banking? A: Absolutely! Our Banking Text Course is designed to cater to learners of all levels, from beginners to seasoned professionals. We provide clear explanations and comprehensive coverage of essential banking concepts to ensure that everyone can grasp the fundamentals. Q: How long does it take to complete the course? A: The duration of the course may vary depending on your pace of learning and the amount of time you dedicate to studying. On average, learners typically complete the course within a few weeks to a few months. Q: Can I access the course materials on my mobile device? A: Yes, our platform is mobile-friendly, allowing you to access course materials conveniently from your smartphone or tablet. Whether you're on the go or relaxing at home, you can continue your learning journey seamlessly. Q: Will I receive a certificate upon completing the course? A: Yes, upon successfully completing the course and passing any assessments or quizzes, you'll receive a certificate of completion to showcase your newfound knowledge and skills. Q: Is there any support available if I have questions or need assistance during the course? A: Absolutely! Our dedicated support team is here to assist you every step of the way. If you have any questions or encounter any challenges during the course, simply reach out to our support team, and we'll be happy to help. ð Ready to Dive into the World of Banking? Don't miss out on this opportunity to unlock the secrets of banking and take your knowledge and skills to new heights. Enroll now in our Banking Text Course and embark on a transformative journey towards financial expertise and success. Your future in banking starts here! ððð¼ Course Curriculum Module 1 Introduction to Banking Introduction to Banking 00:00 Module 2 Banking Operations and Services Banking Operations and Services 00:00 Module 3 Bank Financial Statements and Analysis Bank Financial Statements and Analysis 00:00 Module 4 Banking Risks and Risk Management Banking Risks and Risk Management. 00:00 Module 5 Investment Banking Investment Banking 00:00 Module 6 Retail Banking Retail Banking 00:00
Overview We all know the rule of 'The Customer Comes First', but when do they stay with you? When can a business ensure its customer base to be loyal and retainable? While there are multiple factors at play here, but one of the keys to customer retention is quality customer service. Businesses nowadays rely heavily on people skilled in customer service and customer satisfaction - which is often hard to come by. To bridge that skill gap, empower human resources with outstanding customer support & service capabilities, and help business owners/managers gather essential knowledge to run & manage the relevant operations smoothly, we have put together this carefully-crafted course with the help of our learning resource development team. If you are someone who wants to build a career in this promising field, our course will be your perfect guide along the road. This course focuses on providing beginners' with the base, helping moderately-skilled learners to level up their understandings, and enabling professionals to fill in the blanks of the updates within the fields of customer experience enhancement. Reflecting the above-mentioned promises, this Customer Service course focuses on helping the learners develop the following skills: Effective communication & active listening Problem solving Attentiveness Anger Management Time Management Stress Management Conflict resolution Customer relationship management Customer experience enhancement Customer service evaluation Email writing & etiquettes Positive attitude & body language So, enrol now, develop these in-demand skills of the 21st century and make meaningful connections with your customers around the globe. Who is this course for? If you run a business or work for one, you have to understand what your customers want, how to serve them properly, and repeat this process - no matter what your job description says or whichever department you work in. Having said that, people falling into either one of the below groups will benefit the most from this course: Jobseekers in fields related to customer service/customer support/customer experience Amateurs or professionals with intermediate skills in the above-mentioned fields Business-owners/managers/team leaders Business students People looking to get certified in customer service Career Path This Customer Service course paves the way for a handful of career opportunities, with roles such as: Customer Service Representative/Executive/Officer Customer Service Advisor/Specialist Customer Service Manager Also, the job roles related to customer support/customer experience will also be available to you. While the salaries for the above-mentioned jobs vary based on responsibilities, the levelwise breakdown of expected salaries are - Entry level: £16,750 - £20,750 Mid-level: £26,400 - £36,800 Senior level: £35,00 - £50,500 Course Curriculum Module 1 - Basics of Customer Service Basics of Customer Service 00:00 Module 2 - Why Customer Service Matters Why Customer Service Matters 00:00 Module 3 - What's Different about Good Service What's Different about Good Service 00:00 Module 4 - First Steps and Body Language First Steps and Body Language 00:00 Module 5 - Effective Communication Strategies Effective Communication Strategies 00:00 Module 6 - Phone Tone and Etiquette Phone Tone and Etiquette 00:00 Module 7 - Relationship Building Relationship Building 00:00 Module 8 - Turning Complaints into Opportunities Turning Complaints into Opportunities 00:00 Module 9 - E-Mail Etiquette E-Mail Etiquette 00:00 Module 10 - Customer Relationship Management (CRM) Customer Relationship Management (CRM) 00:00 Module 11 - Empowering Great Customer Service Empowering Great Customer Service 00:00 Module 12 - Evaluating and Measuring Customer Service Evaluating and Measuring Customer Service 00:00
Overview With the ever-increasing demand for Security and Risk Management 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 Security and Risk Management may be. Learning about Security and Risk Management 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 Security and Risk Management . 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 Security and Risk Management 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 Security and Risk Management 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 Security and Risk Management 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 Security and Risk Management 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 Security and Risk Management , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Security and Risk Management , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Security and Risk Management , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Security and Risk Management 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 01 Introduction to Security Management Introduction to Security Management 00:00 Chapter 02 Security Risk Analysis and Risk Reduction Security Risk Analysis and Risk Reduction 00:00 Chapter 03 Managing Security Managing Security 00:00 Chapter 04 Physical Security Management Physical Security Management 00:00 Chapter 05 Information Security Management Information Security Management 00:00 Chapter 06 Cybersecurity Cybersecurity 00:00 Chapter 07 Organisational Security Management Organisational Security Management 00:00 Chapter 08 Home Security Management Home Security Management 00:00
Overview With the ever-increasing demand for running operations 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 running operations may be. Learning about running operations 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 running operations. 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 running operations 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 Operations Management 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 Operations Management 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 Operations Management 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 running operations, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in running operations, Anyone looking for a certificate of completion on doing an online training on this topic, Students of running operations, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Operations Management 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 Operations Management Introduction to Operations Management 00:00 Module 2-Operations Strategy Operations Strategy 00:00 Module 3-Operations Process Design Operations Process Design 00:00 Module 4- Supply Chain Management Supply Chain Management 00:00 Module 5 - Business Planning Business Planning 00:00 Module 6-Performance Management Performance Management 00:00 Module 7-Strategic Analysis and Product Scope Strategic Analysis and Product Scope 00:00 Module 8 - Business Development and Succession Business Development and Succession 00:00