43740 RES courses

The School Midday Supervision Course is designed to equip individuals with the essential skills needed to effectively supervise students during their lunch breaks, ensuring their safety, well-being, and proper conduct. This online course offers a flexible learning opportunity, ideal for those looking to enhance their understanding of school environments without the need for physical attendance. With the increasing importance of structured supervision, this course addresses key areas such as maintaining discipline, managing student behaviour, and dealing with any issues that arise during the midday break. Throughout the course, you will gain insights into the responsibilities of a midday supervisor and how to handle various situations with confidence. By learning how to communicate effectively with students and colleagues, you’ll be better prepared to create a positive and calm atmosphere during the lunch period. This course is perfect for anyone interested in supporting schools and ensuring that students are supervised in a safe, organised environment. Whether you’re looking to develop new skills or broaden your role within a school, this course offers a flexible and straightforward way to do so. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Midday Supervision Module 02: Safeguarding and Child Protection Module 03: Promoting Positive Behaviour Module 04: Managing Challenging Behaviour Module 05: Creating an Engaging Environment Module 06: Supporting Students with SEND Module 07: Health and Safety Procedures Module 08: Collaboration and Teamwork Learning Outcomes Safeguard children's welfare and protection. Cultivate positive behaviour strategies. Effectively manage challenging student behaviours. Craft engaging learning environments. Support students with SEND. Implement health and safety protocols. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring teaching assistants. School staff, including lunchtime supervisors. Parents and guardians. Individuals seeking a career change. Graduates pursuing roles in education. Anyone passionate about child welfare. Career path Teaching Assistant Classroom Support Worker Education Welfare Officer Special Educational Needs Assistant School Behaviour Support Officer Early Years Educator Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

The Workplace First Aid Level 3 Course is an essential qualification for anyone looking to become a vital member of their workplace safety team. Whether you’re working in an office, factory, or any other environment, having first aid knowledge is invaluable. This course ensures you are well-equipped to deal with emergencies, offering clear, concise, and life-saving information that anyone can understand. With a straightforward structure and simple guidance, this course will help you confidently respond to incidents, knowing exactly what to do in critical moments. In today's fast-paced work environments, ensuring the safety and well-being of your colleagues is more important than ever. This Level 3 course is designed to help you navigate a variety of first aid scenarios—from dealing with burns, fractures, and bleeding to handling heart attacks and strokes. By gaining this qualification, you not only become an asset to your team but also help foster a safer, more confident workplace. With easy-to-follow content, you'll be prepared to handle emergencies calmly, knowing you have the knowledge to make a real difference when it matters most. Key Features Accredited by CPD Instant e-certificate Fully online, interactive Workplace First Aid Level 3 course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Free Gifts Life Coaching Course Enrol now in this Workplace First Aid Level 3 course to excel! To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Workplace First Aid Level 3 training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. The curriculum of the Workplace First Aid Level 3 course has been designed by experts with years of experience behind them which is extremely dynamic and well-paced to help you understand the subject matter with ease. Accreditation This Workplace First Aid Level 3 is CPD Quality Standards (CPD QS) Accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Workplace First Aid Level 3 course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 10 CPD hours / points Accredited by The CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Workplace First Aid Level 3 basics. Requirements No prior degree or experience is required to enrol in this course. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Understanding nutrition isn’t about following trends—it’s about making informed choices that support your health goals. This course unpacks the essentials of balanced eating and smart weight management, breaking down the science into clear, digestible lessons. Whether you're looking to fine-tune your diet, manage weight effectively, or simply understand what’s really on your plate, this course offers structured, evidence-led guidance that fits into your schedule without a fuss. It’s ideal for those who want to brush up on the basics or dive deeper into topics like macronutrients, metabolism, energy balance, and responsible eating habits. The content is designed to help learners of all backgrounds develop a solid understanding of nutrition theory and how it applies to everyday food choices—no fads, no fluff, just solid knowledge you can count on. Whether you're studying for personal development or professional interest, this course keeps things practical, purposeful, and refreshingly straightforward. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Nutrition Module 02: Macronutrients Module 03: Micronutrients Module 04: Nutrition for Different Stages of Life Module 05: Weight Management Module 06: Strategies for Weight Management Module 07: Physical Activity and Weight Management Module 08: Weight Management For Life Stages and Health Conditions Learning Outcomes Understand the fundamental principles of nutrition. Differentiate between macronutrients and micronutrients. Apply nutrition knowledge to various life stages. Develop effective weight management strategies. Comprehend the significance of physical activity in weight control. Adapt weight management techniques to different life stages and health conditions. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is for Individuals seeking a deeper understanding of nutrition and weight management. Health enthusiasts looking to enhance their lifestyle choices. Parents who want to provide optimal nutrition for their families. Fitness enthusiasts interested in effective weight management. Healthcare professionals expanding their knowledge base. Anyone eager to improve their health and well-being. Career path Nutrition Advisor Health Coach Wellness Consultant Personal Trainer Dietetic Assistant Community Health Educator Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Discover the power of Brainspotting, a groundbreaking therapeutic technique that taps into the brain's natural ability to heal. This course introduces you to the fundamentals of Brainspotting, a highly effective method used to help individuals process and resolve trauma, stress, and emotional blockages. Through focused learning and structured guidance, you will explore how specific eye positions can unlock deep healing processes within the brain, offering relief from emotional pain and stress-related conditions. With this course, you will gain a deeper understanding of how the mind and body are connected, and how to use Brainspotting in a therapeutic setting to enhance emotional well-being. Whether you're a mental health professional or simply curious about therapeutic techniques, this course offers a clear path to understanding how Brainspotting can be applied to support healing. Dive into this innovative technique, learn its core principles, and start integrating it into your practice. Engage with cutting-edge knowledge that can transform how you approach emotional and psychological challenges. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Brainspotting Module 02: Basic Principles of Brainspotting Module 03: Brainspotting Techniques and Procedures Module 04: Advanced Brainspotting Approaches Module 05: Trauma Processing and Integration in Brainspotting Module 06: Ethical Considerations and Self-Care in Brainspotting Learning Outcomes: Master the foundational principles of Brainspotting. Develop advanced techniques for trauma processing. Demonstrate a profound understanding of ethical considerations. Cultivate self-care strategies for effective therapy. Apply Brainspotting to provide valuable therapeutic support. Enhance your expertise in mental health and trauma therapy. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Psychologists and therapists seeking to expand their expertise Counsellors and social workers wanting to improve their therapeutic skills Healthcare professionals looking to offer holistic mental health support Students pursuing a career in psychology or therapy Individuals with a passion for helping others heal emotionally Anyone interested in the field of trauma therapy Career path Trauma Therapist Mental Health Counsellor Clinical Psychologist Social Worker Psychiatric Nurse Rehabilitation Specialist Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Achieving a Level 5 Food Hygiene Rating is the gold standard for any food establishment in the UK. This course takes you step-by-step through the essential practices that ensure the highest hygiene standards are maintained in your workplace. Whether you run a restaurant, café, or catering service, understanding how to maintain a pristine environment for food safety is crucial. With the rise in consumer demand for safe dining experiences, having this qualification under your belt will give you the confidence to meet regulations and exceed expectations. This online course is designed to equip you with the knowledge to safeguard both the food you serve and the reputation of your business. Throughout the course, you'll explore key aspects of food hygiene, from maintaining cleanliness in kitchens to handling food correctly. With easily digestible content and practical tips that can be applied directly to your business, you’ll learn how to prevent contamination, ensure proper storage, and avoid common mistakes that can lead to penalties. By the end, you'll be fully prepared to achieve that sought-after Level 5 rating, demonstrating your commitment to excellence in food safety and your customers' well-being. With this course, meeting the standards is just the beginning; it’s about fostering trust and delivering top-tier food hygiene. Key Features Accredited by CPD Instant e-certificate Fully online, interactive Food Hygiene Rating Level 5 course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Free Gifts Life Coaching Course Enrol now in this Food Hygiene Rating Level 5 course to excel! To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Food Hygiene Rating Level 5 training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. The curriculum of the Food Hygiene Rating Level 5 course has been designed by experts with years of experience behind them which is extremely dynamic and well-paced to help you understand the subject matter with ease. Accreditation All of our courses are fully accredited, including this Food Hygiene Rating Level 5 course, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Food Hygiene Rating Level 5 course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Food Hygiene Rating Level 5 basics. Requirements No prior degree or experience is required to enrol in this course. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Course Overview Have you ever felt confused about the environmental issues? We are surely living in an era where climate change is one of the biggest concern. But there are various types of reports and opinions that you might feel confused. But not anymore. Learn environmental management from this Environmental Management Training course and enhance your environmental literacy today. In this Environmental Management Training course, you will be familiarized with different environmental changes and their reasons. You will learn about ecological changes and how environmental planning can help you improve your environmental management skill. You will also learn about environmental law and policies, how to perform an environmental audit and understand the current ecological concerns from this course. This Environmental Management Training course is perfectly for you to understand the environmental effect of your actions and learn how to take responsibility for your actions. The bite-sized lessons will help you understand the concepts and techniques easily.  Learning Outcomes Learn about the change of the ecology Understand the negative effect of environmental change Discover how to apply environmental management in your workplace and personal life Familiarize with the principles of EMS Learn about the potential of environmental management Understand the EU and UK law of environmental protection Learn the skills you need to perform an environmental audit Know how to act responsibly for environmental changes and negative effects of environmental change Learn about situation on environmental management Understand how you can improve environmental performance of your workplace Who is this course for? This comprehensive Environmental Management Training course is ideal for those who want to understand climate change effects and maintain a environment friendly surrounding.  Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Environmental Management Training is a useful qualification to possess and would be beneficial for any related profession or industry such as: Environmental Managers Environmental Advisors Sustainability Managers Ecologists Business Owners Environmental Analysts Scientists Entrepreneurs Environmental Management Training Module 01: Environment and Ecology 00:21:00 Module 02: Environmental Issues 00:26:00 Module 03: Environmental Planning 00:22:00 Module 04: Environmental Management System 00:32:00 Module 05: Ecosystem Management 00:29:00 Module 06: Environmental Law and Policy 00:24:00 Module 07: Improving Environmental Performance 00:25:00 Module 08: Environmental Management Audit 00:38:00 Module 09: Situational Environmental Management 00:27:00 Module 10: Review and Performance 00:18:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Project is the world's most famous and outreached software by individuals who are working in project management environment. This course will drive you to go beyond the fundamental understanding and explore the more advanced features of Microsoft Project. This Microsoft project intermediate level intends to enhance your computer skills from Basic all the way to next level, one step at a time, so enrol now and utilise the opportunity. This course will provide you with the necessary skills, knowledge and information of Microsoft Project. Who is this course for? Individuals who are working in project management environment and are looking forward to enhancing their Microsoft Project skills. People who have basic information about Microsoft Project and are looking for to learning its advanced techniques. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Project Intermediate Level will be very beneficial and helpful, especially to the following professionals: Project Director. Project Manager. Project Management Officer. Project Assistant. Microsoft Project Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with the Project Environment (I) 01:00:00 Module Three - Working with the Project Environment (II) 01:00:00 Module Four - Templates and Other New Project Time Savers 01:00:00 Module Five - Working with Custom Fields 01:00:00 Module Six - Working with Tasks 01:00:00 Module Seven - Working with Resources (I) 01:00:00 Module Eight - Working with Resources (II) 01:00:00 Module Nine - Using the Team Planner 01:00:00 Module Ten - Managing Risks and Measuring Performance 01:00:00 Module Eleven - Communicating Project Information 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Microsoft Project Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Project Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft Project Intermediate Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft PowerPoint is a program that helps you create, edit and show presentations. These presentations could be for work, school or any occasions. This advanced course will help you make presentations creatively. You will learn how to use the Pictures, TextBox, Table, and Drawing Tools tab and know how to do advanced drawing tasks. Know how to use the Research Task Pane and notes to slides. All of these advanced skills in PowerPoint will help you maximise the potentials of the program. In this course you will learn the necessary skills, knowledge and information of Microsoft PowerPoint. Who is the course for? Professionals who want to learn about Microsoft PowerPoint 2007 functions and features. People who have an interest in knowing advanced Microsoft PowerPoint 2007 aspects. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft PowerPoint 2007 Advanced Level course is a useful qualification to possess and would be beneficial for these professions or career which are: Admin Assistant PA Secretary Administrator Office Manager. Microsoft PowerPoint 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Adding Pictures 01:00:00 Module Three - Working with Text Boxes 01:00:00 Module Four - Adding SmartArt 01:00:00 Module Five - Adding Tables 01:00:00 Module Six - Inserting Advanced Objects 01:00:00 Module Seven - Advanced Drawing Tasks 01:00:00 Module Eight - PowerPoint's Research Tools 01:00:00 Module Nine - Creating Notes and Handouts 01:00:00 Module Ten - Using Slide Masters 01:00:00 Module Eleven - Advanced Presentation Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft PowerPoint 2007 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft PowerPoint 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft PowerPoint 2007 Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: A management succession plan affects an entire association. Planning a succession includes arrangement, measuring alternatives, starting and overseeing change, and performing an intensive investigation of your staff and their abilities and experience. Our diploma in Business Succession Planning course gives you a comprehension of the strategies and methods of business succession and skill building to implement the changes smoothly and successfully with skills like conducting a SWOT analysis, drafting a succession plan and mapping worker experience and skill sets. You will also learn to distinguish between succession planning and poor replacement planning and how to prepare team members to take on the responsibilities of leadership so that the company thrives in the transition. Who is the course for? Beginners who want to develop a Business Plan. Existing entrepreneurs who need a Business Plan. Managers asked to write a business plan. Business Students. A consultant who is looking for a framework to help clients to develop a plan. Business owners. Freelancers. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Business Succession Planning Course would be beneficial for the following professionals: Program manager. Risk management consultant. Office manager. Financial planner. Start your own business. Business analyst. Management consultant. Human resource officer. Business Succession Planning Course Module One - Getting Started 01:00:00 Module Two - Succession Planning Vs. Replacement Planning 01:00:00 Module Three - Preparing for the Planning Process 01:00:00 Module Four - Initiating Process 01:00:00 Module Five - The SWOT Analysis 01:00:00 Module Six - Developing the Succession Plan 01:00:00 Module Seven - Executing the Plan 01:00:00 Module Eight - Gaining Support 01:00:00 Module Nine - Managing the Change 01:00:00 Module Ten - Overcoming Roadblocks 01:00:00 Module Eleven - Reaching the End 01:00:00 Module Twelve - Wrapping Up 01:00:00 Mock Exam Mock Exam- Business Succession Planning Course 00:20:00 Final Exam Final Exam- Business Succession Planning Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Take your career to the next level by mastering new Excel functions. This The New functions in Microsoft Excel in 2021 course aims to provide you with a greater understanding of Excel's new formulas to boost your work output. Microsoft Excel is a widely used spreadsheet program in various organizations. It simplifies the process of calculation, analysis and visualization of data and information. Having Excel skills adds a considerable amount of weight to your resume. In this The New functions in Microsoft Excel in 2021 course, you will learn about the latest functions of Excel to simplify your Excel tasks. You will learn the principles behind dynamic arrays and explore how to create a table of random numbers or random dates with Randarray. It will teach you the new ways of dynamically sorting data with the sort by function. You will also delve into other functions such as XLOOKUP, SWITCH and CONCAT and determine how they work.  Learning Outcomes Familiarize with the new functions of Excel Understand how the FILTER function works Explore how the new UNIQUE, SORT and SORTBY Excel functions work Know how to use RANDARRAY function to randomly sort lists Be able to use DYNAMIC array formulas Understand how to use the new functions in reports Who is this course for? The New functions in Microsoft Excel in 2021 course is highly relevant for professionals who want to excel in their position with their Excel skills. Gaining the skills adds weight to the resume and provides tremendous career opportunities. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The New functions in Microsoft Excel in 2021 course provides useful skills to possess and would be beneficial for any related profession or industry such as: Office administrators Accounting officers Managers HR Project Supervisors Data analyst Teachers Sales Representatives The New functions in Microsoft Excel in 2021 Module 01: Introduction and Agenda 00:07:00 Module 02: RANDARRAY 00:04:00 Module 03: UNIQUE 00:05:00 Module 04: SEQUENCE 00:04:00 Module 05: SORT and SORTBY 00:09:00 Module 06: SORT A Practical Example 00:06:00 Module 07: FILTER 00:07:00 Module 08: FILTER A Practical Example 00:08:00 Module 09: Other Useful New Functions 00:15:00 Module 10: Using the New Functions in Reports 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00