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

A three-day course of videos to give you a taste of Vinyasa yoga. The videos include a full-body vinyasa flow, core strength yoga and eagle pose

Photography Level 3 Course by Top Rated Instructor

Course Overview Learn how to manage your company on global terms and understand overseas finance with this course on International Business. Business managers or entrepreneurs who think big, need to be flexible and knowledgeable when it comes to operating outside of national boundaries. Taking this training will enable you to work further afield and create new and exciting opportunities for yourself. This Overseas Business tutorial covers every critical aspect of trading and commercialism in marketplaces outside of the UK. You will gain the confidence to work in global capital markets anywhere and create strategies that will succeed in unique economic environments. The contents include a masterclass on demographic studies and intercontinental agreements. So unleash your Transnational ambition by enrolling now and learn how to succeed beyond the UK borders. This best selling International Business has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth International Business is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The International Business is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The International Business is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the International Business, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the International Business will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the International Business to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The comprehensive Email Marketing Course has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Email Marketing Course today, and learn from the very best the industry has to offer! This best selling Email Marketing Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Email Marketing Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Email Marketing Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Email Marketing Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Email Marketing Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Email Marketing Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Email Marketing Course to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Microsoft Office 2019 (Updated and New Features 2022) Overview In today’s digital workplace, Microsoft Office proficiency is a must-have skill across all industries. From office administrators to marketing executives, everyone benefits from mastering the MS Office suite. That’s why our Microsoft Office 2019 course (including 2022 updates) is designed to help you gain job-ready skills and stay ahead in a competitive market. Through this course, you will explore the core applications of MS Office — Excel, Word, PowerPoint, and Access. You’ll begin with Excel, learning how to perform calculations, manage workbooks, and apply formatting to make your data clear and useful. Next, you’ll move on to Microsoft Word, where you'll discover how to efficiently prepare and format professional documents, manage lists, and insert tables and graphic elements. The course then introduces PowerPoint, guiding you through designing impactful presentations using charts, images, and animations. Finally, you’ll gain a practical understanding of Microsoft Access, focusing on modifying data, working with queries, and generating meaningful reports. By the end of this course, you’ll have developed a strong grasp of MS Office tools and features — including the latest 2022 updates — giving your CV a significant edge and preparing you for a variety of career paths. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Understand the updated features of Microsoft Office 2019 and the 2022 enhancements Learn to navigate and utilise key functions in Excel, including calculations, formatting, and workbook management Discover essential Word skills, from formatting text to publishing polished documents Develop the ability to create dynamic PowerPoint presentations with media and charts Gain working knowledge of Access, including queries, forms, and reports Prepare for a range of office roles with practical, up-to-date MS Office knowledge Who is this Microsoft Office 2019 Course for? This course is suitable for office professionals, students, job seekers, and anyone looking to improve their Microsoft Office skills. It's perfect for those aiming to work more productively or move into roles that require document creation, data handling, or presentations. Entry Requirements There are no formal prerequisites for this course. It is open to anyone interested in improving their Microsoft Office skills, regardless of previous experience. Basic computer literacy is helpful but not essential. Accredited Certification After successfully completing the course, you can get a UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. For the PDF certificate, you’ll need to pay £9.99. You can get the hard copy for 15.99, which will reach your doorstep by post.

Course Overview This BSL online course is updated and includes every essential sign and their meanings. The course is divided into two parts, Level 1 and Level 2. The first part covers everything from fingerspelling to forming sentences. You'll learn how to introduce yourself and say about your family too. Basic topics like colours, transports, weather, hobbies etc are included here. Part two dives into more real world conversational topics from where you can easily learn the language to use it daily. From home to professional environment you can learn every nuance signs to make you an expert with this language. The bsl online course covers all your needs and beyond to get an excellent grip and understanding of the language. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Master fluent BSL communication skills. Develop effective conversations in BSL. Understand the nuances of sign language grammar. Foster inclusion in the deaf and hard-of-hearing community. Who is this Advanced Diploma in British Sign Language (BSL) Course for? This course is perfect for anyone with basic BSL knowledge who wants to advance their skills. It's ideal for professionals in education, healthcare, or customer service, as well as anyone looking to communicate better with the Deaf community. Entry Requirements There are no formal prerequisites for this course. It is open to anyone with an interest in British Sign Language, particularly those who have completed a basic BSL course or have prior exposure to the language. A foundational understanding of BSL is beneficial to get the most out of the advanced content.

Spanish Language Masterclass Course Overview Ready to speak Spanish with confidence? The Spanish Language Masterclass is your all-in-one guide to becoming fluent in one of the world’s most widely spoken languages. This comprehensive and beginner-friendly course is designed to help you build real conversational skills, whether you're learning for travel, career advancement, or personal growth. Through step-by-step lessons, you'll explore everything from pronunciation and grammar to everyday vocabulary and useful expressions, all under the guidance of an experienced instructor. The course is completely self-paced, allowing you to learn anytime, anywhere. By the end of the course, you’ll have the confidence and skills to communicate effectively in Spanish and receive a recognised certificate to showcase your achievement. Start today and take your first step toward becoming bilingual and globally connected. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Gain a solid foundation in Spanish grammar, vocabulary, and pronunciation. Understand how to use common verbs like ser, tener, and haber in different tenses. Develop practical skills for everyday conversations—talking about time, weather, shopping, and more. Master sentence structures, articles, prepositions, and conjunctions to speak fluently. Learn the use of reflexive and reciprocal verbs, indirect object pronouns, and expressions of likes/dislikes. Apply your knowledge in real-life scenarios such as describing your home, discussing routines, or expressing future plans. Grasp the differences between present, past, and future tenses with confidence. Who is this Spanish Language Masterclass Course for? This Spanish Language Masterclass is perfect for beginners and anyone looking to improve their Spanish skills. Whether you’re learning for travel, career growth, or personal enrichment, this course is designed to fit all types of learners, with flexible, self-paced lessons. Entry Requirements There are no formal entry requirements for this course. It is open to all learners, regardless of academic background or prior experience. Accredited Certification After successfully completing the course, you can get a UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. For the PDF certificate, you’ll need to pay £9.99. You can get the hard copy for 15.99, which will reach your doorstep by post.

The innovative Marketing for Business Entrepreneurs has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector. This popular Marketing for Business Entrepreneurs has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique Marketing for Business Entrepreneurs course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The Marketing for Business Entrepreneurs is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the Marketing for Business Entrepreneurs consists of a range of educational modules that allow study sessions to be organized at any time and any place When the final assessment of the Marketing for Business Entrepreneurs has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the Marketing for Business Entrepreneurs course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the Marketing for Business Entrepreneurs has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at. Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.