21253 Disc courses

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

From Small Talk to Big Opportunities - your perfect introduction to business networking. Networking can be intimidating and a bit daunting if you’re new to it, but it doesn't have to be.  In this online introduction to business networking course, you'll discover...  The benefits of networking. We’ll help you to recognise networking opportunities that will suit you. Know how to prepare for an event. How to follow up. And best of all, we’ll help you to create your own elevator pitch with our Pitch Building Template. This is your perfect introduction to the world of business networking, ideal for beginners who want to increase their confidence and feel more empowered. We understand the power of a network. Our passion for networking and helping others succeed is truly contagious, and we can't wait to share our knowledge and expertise with you. The main goal of this taster session is to help you overcome any fears or hesitations you might have about networking. We’ll guide you through the ins and outs of networking, leaving you feeling more confident about attending your next event, whether online or Face to Face. Don't let your fears hold you back any longer – Join us for this interactive this taster session that will set you on the path to networking success! This course is for you if… You’ve very little networking experience and you want to know where to start. You experience anxiety about meeting new people for business. You’re not comfortable in networking events. You want to develop your business You want to further a career or get a promotion.

The University Foundation Programme (UFP) is a one-year intensive course that prepares both British and international students to attend top UK universities.

This recording package is for individuals who did not attend the Rethinking Museums live event. If you attended online on 5 February and would like to upgrade your ticket to include a recording, please click here. Since the end of the pandemic, children, young people and families have faced a barrage of challenges to their standard of living, wellbeing, family life and place within society. Our conference will focus on how museums can become welcoming and accessible spaces that enable all children, young people and families to socialise, relax, play, work and learn. The three key themes of the conference are: Family Against the background of a slow post-Covid recovery and ingrained inequalities of access amongst museum audiences, we will share examples of museum programmes that have successfully welcomed children, young people and families who have historically been excluded. Often these new audiences have found a sense of safety and belonging in their local museums and become less isolated. Society In an increasingly polarised world where online disinformation proliferates, museums have a vital role in enabling people to build empathy and explore social justice issues. Work in this space helps museums remain relevant to younger audiences and helps them feel more optimistic about the future. Careers As the number of museum traineeships and apprenticeships are shrinking, so are the routes into a career in heritage. We’ll explore programmes that are opening up the museum workforce and enabling a wider group of young people to find meaningful work and build skills and confidence for future employment. You can read all about the conference and see the schedule on our website. About the recording The recording will include all of the conference sessions. You will receive the recordings approximately six weeks after the conference. You will be able to watch the recordings for six months from the date of the conference. All of the sessions will be captioned.

Motorsport is as much a business as it is a sport. Our new master’s programme will provide students with a broad range of modules which examine the national and international aspects of the industry from a commercial perspective. From governance, structure and international sports law, through to the importance and interdependence of commercial rights holders, promoters, manufacturer, teams, sponsors and the role played by the media, this course is aimed at enhancing the professional and career prospects of those with an aspiration of working within this exciting and challenging global industry. Our programme will help you to develop as professionals with a strong grounding in ethics and a clear sense of how motorsport relates to various cultures, stakeholders and the sectors it interacts with.

Leadership and Management development, Leadership training, management training, Leadership development

The "ISO 14298:2021 Lead Auditor Course" integrates the principles of ISO 14298:2021, the International Standard for Security Printing Management, with the methodologies outlined in ISO 19011:2018, the Guidelines for Auditing Management Systems. The course equips participants with the skills and knowledge required to lead security printing audits effectively, ensuring compliance with ISO 14298:2021, and applies the principles of ISO 17011:2017 for conformity assessment bodies. It covers audit planning, execution, and reporting while emphasizing risk management and continual improvement.

A simple pattern drafting course for anyone wanting to learn how to make their own blocks from scratch - great for teachers of GCSE & A Level Fashion & Textiles for both Art & Design and D&T.

Are you a graduate or an industry professional ready to take your career to the next level, develop a new specialism, or see your film idea or project realised? Our MA in Screen and Film Production could enable you to advance your career, develop and enhance your skillset, and align yourself with top industry professionals. Through research-based practice this new MA puts you and your aspirations at the centre of your learning, whilst refining your chosen specialist pathway. 

💥 Dyslexia & Working Memory The Masterclass That’s Helped Hundreds of Educators and Parents Make Real Change Do you feel like your child or student is trying hard… but still falling behind? Do they seem overwhelmed, forgetful, or struggle to follow instructions? 👉 It’s not laziness. It’s likely a weak working memory. And it’s more common than you think — especially in children with dyslexia. But here’s the GOOD news: with the right support, these children can THRIVE. 💡 Join me LIVE for my most popular masterclass – and discover the game-changing strategies that actually work. 👋 Hosted by Paloma Forde Special Needs Educator, Consultant, International Speaker and Dyslexia Screening Expert 💫 Founder of Dyslexia Support Services 🎯 With 27+ years of SEN experience, I’ve helped hundreds of educators and parents across the globe understand and support children with weak working memory — and I want to help you too. ✅ This session is for you if: You're a parent wondering why your bright child is struggling to keep up You’re an educator or TA constantly re-teaching or reminding the same students You’ve heard about working memory but don’t fully understand it You’re desperate for real solutions, not just theory 🧠 What we’ll cover: ✔️ What working memory is – and why it matters ✔️ How to spot the early signs in your child or students ✔️ Get a taste for what it is like to have a weak working memory with a practical activity! ✔️ Practical, proven strategies that will reduce overwhelm and ensure you are supporting your child/students in the RIGHT way. ✔️ PLUS: A live Q&A with me so you can get tailored advice 💥 What you’ll walk away with: Clear understanding of working memory and how it affects learning Confidence in spotting the signs in your child or student A bank of go-to strategies that can be used at home or in school Confidence in working with kids with a weak working memory knowing that they CAN achieve — when we give them the right support 📌 Key Details: LIVE via Zoom Replay available if you can’t make it live Sponsored by International Dyslexia Learning Solutions (IDL) Early Bird pricing ENDS 15th May – don’t miss out! 🎟️ BOOK YOUR PLACE NOW Spots are limited and always fill fast — this is my most popular webinar for a reason. Looking forward to supporting you! See you there, Paloma Forde The Go-To Global Dyslexia Screening Expert Founder | Dyslexia Support Services Please note that by signing up to my webinar, you will automatically be added to my mailing list. You can unsubscribe at anytime. You will also be automatically subscribed to IDL and can also unsubscribe anytime. Tickets are non-refundable.