17749 Courses in Liverpool delivered On Demand

Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables   These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful.   Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one     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

This Commercial Manager has been developed for analysing commercial risk management. This course also will educate you on several management factors which include management of budget, project management, management of loans and debt along with an overview of commercial management. Start learning Commercial Manager that will give you enough knowledge and skills to build your dream career. About this course This Commercial Manager helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Commercial Manager is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who Is This Course For:​ This Commercial Manager is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Commercial Manager related skills to aid his/her career path. No formal entry prerequisites are required Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 1: An Overview of Commercial Management Module 2: Commercial Risk Management Analysis Module 3: Management of Budget Module 4: Project Management Module 5: Management of Loans and Debt Course Content Commercial Manager Module 1: An Overview of Commercial Management 00:14:00 Module 2: Commercial Risk Management Analysis 00:15:00 Module 3: Management of Budget 00:19:00 Module 4: Project Management 00:19:00 Module 5: Management of Loans and Debt 00:13:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Start learning Basics of Corporate Finance Training that will give you enough knowledge and skills to build your dream career. About this course This Basics of Corporate Finance Training helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Basics of Corporate Finance Training is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who Is This Course For:​ This Basics of Corporate Finance Training is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Basics of Corporate Finance Training related skills to aid his/her career path. No formal entry prerequisites are required Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 01: Basics of Corporate Finance Module 02: Financial Planning and Growth for the Long Term Module 03: Financial Statement Analysis Module 04: Corporate Finance as a Career Course Content Finance: Basics of Corporate Finance Module 01: Basics of Corporate Finance 00:08:00 Module 02: Financial Planning and Growth for the Long Term 00:20:00 Module 03: Financial Statement Analysis 00:22:00 Module 04: Corporate Finance as a Career 00:08:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

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 recorded video of a presention given by Rev Don MacGregor to The Hamblin Vision on the subject of Science, Oneness and God.

Discover the world around you! Explore the fundamentals of geography, from physical landscapes to human interactions. Gain insights into maps, cultures, and environmental phenomena through engaging lessons and captivating visuals, thanks to Spark Generation's Cambridge self-paced course.

11-in-1 Premium Bundle | CPD QS Certified | 110 CPD Points | Free Hardcopy + PDF Certificate + Exam | Lifetime Access

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin et eros odio. Morbi molestie tempor elit. Sed fringilla felis ullamcorper purus finibus placerat. Vivamus vestibulum iaculis maximus. In nulla enim, iaculis et felis nec, porta imperdiet mauris. Vestibulum egestas felis eu dui molestie tempor. Nam a metus id elit ultricies sagittis. Sed elementum bibendum euismod. Nam a venenatis sapien. Cras sed euismod odio. Cras tellus magna, molestie ac euismod sed, dignissim sit amet nisl. Praesent tristique magna et turpis pharetra accumsan. Sed posuere rutrum lacinia.

Pediatric Examination Aims to  These pediatric assessment and examination techniques are specific for pediatric patients. In this pediatric examination CPD course you will evaluate the physical, developmental, and functional aspects of children, the level of milestones, and the relation with normal growth and abnormal growth patterns or delayed milestones. You will explore evidence-based methodologies, expert guidance, and assessment scales to effectively address the needs of pediatric populations. By this certified CPD course for medical worker, pediatric history taking and physical examination will become easier. Learning Objective  Understand the importance of pediatric assessment What are different age groups according to different organizations? This CPD Course will provide complete knowledge about pediatric general physical examination. In this CPD course, you will explore the milestones related to certain age groups and gain insight about the factors that affect developmental milestones. Understand typical vs atypical movement patterns in certain age groups supported by evidence-based research. Learn about the ICF model of pediatric assessment Physiotherapy assessment tool for pediatric Explore the clinical pediatric assessment and understand the pediatric assessment with the case study Become proficient in making pediatric examination reports. Understand the impact of multimodal pediatric examination in the clinical or hospital setting. By the end of this CPD course, you will be able to make the pediatric examination report by using the pediatric assessment scales. This CPD course will help to make informed decision about the treatment plan and to make referrals for serious conditions. Who Should Enroll Pediatric Physiotherapist Pediatric Orthopedic Medical Students Pediatric Nurses Occupational Therapist CPD Credit Hours  2 Hours 30 min Resources 1-Month Access to Learning Resources Downloadable Course Material CPD Certificate Course Instructor: Dr. Khadija Fareed (DPT, MS Pain Management, PPTA) is a skilled physiotherapist with five years of clinical experience. She holds a degree in physiotherapy from RLMC and a master's in pain management from Superior University. Dr. Khadija Fareed has worked in orthopedic departments, she also served as an academic physiotherapist, and presented at conferences. Her commitment to patient care and professional development makes her a valuable asset in the field. Course Instructor About Physiotherapy Online Physiotherapy Online is a physiotherapist-owned educational company with a vision to create an ensemble of international educators to cater to undergraduate, postgraduate physiotherapy students as well as post professionals who are keen to advance or refesh their existing knowledge in varied specialities. As every student has a unique approach to learning, we have therefore created a library of bite sized chapters which may be accessed as an individual module or a course as a whole; self study webinars; live workshops for those who would like to get an in-person hands on immersive experience and audio books for those on the go.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Fermentum iaculis eu non diam phasellus vestibulum lorem sed. Tristique senectus et netus et malesuada fames ac turpis egestas. Neque sodales ut etiam sit amet nisl purus. Elit ut aliquam purus sit amet luctus venenatis. Ultrices gravida dictum fusce ut. Mauris a diam maecenas sed enim ut sem. Fusce id velit ut tortor pretium viverra suspendisse potenti. Pellentesque sit amet porttitor eget dolor. Tempus imperdiet nulla malesuada pellentesque elit. Gravida dictum fusce ut placerat orci nulla. Sed viverra ipsum nunc aliquet. Turpis massa sed elementum tempus egestas sed sed risus. In fermentum et sollicitudin ac. Lorem ipsum dolor sit amet consectetur adipiscing elit pellentesque habitant. Eget nunc scelerisque viverra mauris in aliquam sem fringilla. Parturient montes nascetur ridiculus mus mauris vitae. Sed ullamcorper morbi tincidunt ornare. Massa tempor nec feugiat nisl pretium fusce id. Elementum nibh tellus molestie nunc non blandit massa enim. Neque sodales ut etiam sit amet nisl purus. Maecenas sed enim ut sem viverra aliquet eget sit amet. Scelerisque in dictum non consectetur a erat nam. Diam vulputate ut pharetra sit amet aliquam id diam maecenas. Tincidunt arcu non sodales neque sodales ut etiam sit. Est ullamcorper eget nulla facilisi etiam dignissim diam quis enim. In tellus integer feugiat scelerisque varius morbi. In nulla posuere sollicitudin aliquam ultrices sagittis orci a. Pellentesque eu tincidunt tortor aliquam nulla facilisi cras fermentum odio. Ut tristique et egestas quis ipsum. Scelerisque purus semper eget duis at tellus at urna condimentum. Dolor sit amet consectetur adipiscing elit. Elit duis tristique sollicitudin nibh sit amet commodo nulla facilisi. Interdum velit laoreet id donec. Ultricies integer quis auctor elit sed vulputate mi. Sollicitudin nibh sit amet commodo nulla facilisi nullam vehicula ipsum. Bibendum neque egestas congue quisque egestas. Duis ultricies lacus sed turpis tincidunt id aliquet risus feugiat. Suspendisse ultrices gravida dictum fusce ut placerat orci nulla pellentesque. Amet tellus cras adipiscing enim eu turpis egestas. Eros donec ac odio tempor orci dapibus ultrices in iaculis. Aliquam malesuada bibendum arcu vitae elementum curabitur. Tempor commodo ullamcorper a lacus vestibulum sed arcu. Vel pretium lectus quam id. Sodales ut eu sem integer vitae. Eget nulla facilisi etiam dignissim diam quis enim lobortis scelerisque. Ut eu sem integer vitae. Purus viverra accumsan in nisl. Ac turpis egestas integer eget aliquet nibh praesent. Volutpat diam ut venenatis tellus in metus vulputate. Sed sed risus pretium quam vulputate. Pharetra massa massa ultricies mi quis hendrerit dolor. Maecenas accumsan lacus vel facilisis volutpat est velit. Tincidunt id aliquet risus feugiat in ante metus dictum at. Lorem ipsum dolor sit amet. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Consectetur adipiscing elit ut aliquam purus sit amet luctus. Suspendisse interdum consectetur libero id faucibus nisl tincidunt. Laoreet id donec ultrices tincidunt arcu non sodales neque. Eu ultrices vitae auctor eu augue. Pharetra massa massa ultricies mi quis hendrerit. Tortor consequat id porta nibh venenatis cras sed. Integer quis auctor elit sed vulputate mi. Egestas congue quisque egestas diam in arcu cursus euismod quis. Non arcu risus quis varius quam quisque id. Velit euismod in pellentesque massa placerat duis ultricies. Augue lacus viverra vitae congue eu consequat ac felis. Enim neque volutpat ac tincidunt vitae semper quis. Mi in nulla posuere sollicitudin aliquam ultrices sagittis. Ipsum dolor sit amet consectetur adipiscing elit ut aliquam. Amet porttitor eget dolor morbi non arcu risus quis. Ultrices eros in cursus turpis massa. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Sit amet tellus cras adipiscing enim eu turpis egestas pretium. Tempor id eu nisl nunc mi ipsum faucibus vitae aliquet. Quis auctor elit sed vulputate mi sit amet mauris. Vitae congue mauris rhoncus aenean vel elit scelerisque. Donec ultrices tincidunt arcu non sodales neque sodales. Donec pretium vulputate sapien nec. Aliquam nulla facilisi cras fermentum odio eu. Consequat id porta nibh venenatis cras sed. Urna id volutpat lacus laoreet non curabitur. Id interdum velit laoreet id donec ultrices. Eget nunc scelerisque viverra mauris. Dignissim sodales ut eu sem integer vitae. Sapien pellentesque habitant morbi tristique senectus et netus et. Arcu dui vivamus arcu felis bibendum ut tristique. Lacus luctus accumsan tortor posuere ac ut consequat semper viverra. Aliquet nec ullamcorper sit amet risus nullam eget felis. Nullam non nisi est sit amet facilisis magna etiam tempor.