16773 Disc courses delivered On Demand

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

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.

Working with young volunteers    Would you like to work with young volunteers in your organisation?   About this event   During this training session, we will be exploring all aspects of how to work with young volunteers, from recruitment and logistics to safeguarding.   This webinar will be led by Eleanor Moore the Sustainable Volunteering Officer with the Museum Development South West Programme. Her background is in social and community history curatorship and advisory work within the museums sector, with experience of managing volunteer teams.   She will be joined by Sebastian Amos, Chair of Trustees and Adam Marsden, Young Volunteer at Transport Museum Wythall and Rania Nur, former Young Volunteer, now Trustee at the Museum of the Home. They will be sharing case studies about the young volunteer programmes in their organisations.    The session will help delegates to: understand the importance of this work think about how to develop young volunteer roles gain inspiration from case studies to take your own work forward understand good practice around safeguarding and young volunteers.   Take a look at the full schedule.   Please note: This is a recording of the session which took place 18th June 2024.    Who should attend?   This training is aimed at staff who work in museums, art galleries and heritage sites who are interested in developing or improving their provision for young volunteers. Voluntary volunteer co-ordinators, whose main role is to lead day-to-day on the involvement of volunteers and/or young people, would also benefit from this session.  

Explore the Fundamentals of Networking with the Perfect Introduction to Networking Course. Understand the benefits of networking, spot networking opportunities, prepare for an event, and the following up process. Overcome your fears, enrol Today, and take control of your networking!

COMPUTER AIDED DESIGN + NICKY SIMPSON ONLINE ON-DEMAND FEES: FULL COURSE £35 WHAT THE COURSE IS ABOUT: A great short course, led by textile artist NICKY SIMPSON. This course introduces you to repeat patterning using PowerPoint, with video tutorials and comprehensive step-by-step guides. Whether you are using this in school, wanting to print for fashion or furnishing, or simply printing a T-shirt, this is a great way to get your own artwork or photographs into a repeat pattern for printing. It can also be used to print on paper for cards or letters and much more. This course shows how you can easily do repeat pattern designs, layering designs, inserting your designs into shapes and fashion illustration, with lots of exemplars and some inspirational designers. WHO IS THIS COURSE FOR: This course is suitable for anyone. You may be a teacher wanting to up-skill, a student who wants to further your current knowledge, or anyone who would like to be more creative with very limited equipment! All these tutorials can be used directly with students in schools. WHAT TO EXPECT: This comprehensive course offers a series of 6 short video tutorials, where you can practice alongside Nicky, working in your own time, at your own pace. Each video can be paused and rewound, using step-by-step guides.  Introduction: Welcome to the training room Video Tutorial 1: How to use the Picture Format Tool Bar Video Tutorial 2: Creating Repeat Patterns Video Tutorial 3: CAD from your own primary images Video Tutorial 4: Layering images Video Tutorial 5: Inserting Your Repeat Patterns Into Shapes Video Tutorial 6: Fashion Illustration PDF: Designers & Exemplars LEARNING OUTCOMES: Learn and practice a new and exciting skill. Develop confidence and enhance your IT skills with free tools! Create exciting repeat patterns that can be used for fashion, interiors or stationary. A creative activity to get your own photographs into a repeat pattern ready for printing. YOUR TRAINER:

A short online introductory course to free hand machine embroidery with Nicky Simpson

Working with Children and Young People to Respond to the Climate and Ecological Emergency   This is a recording of a session which took place Wednesday 20 March 2024.    Do you want to support children and young people to respond to the Climate and Ecological Emergency, but don’t know where to start?    About this event   The Climate and Ecological Emergency affects everyone, but its impact will be felt most by children and young people and they are becoming increasing concerned by the issue. In the Climate Network’s Climate Action Survey, more than 80% of young people revealed that they were concerned about climate change, and 75% believe it will negatively impact their future.   Museums can play an important role in supporting children and young people to learn more about the Climate and Ecological Emergency, to discuss and debate the issues surrounding it, and to get involved with social action to achieve long-term change.   In this webinar, delegates will:    understand the importance of this work think about how to use their collections and initiate local partnerships to take their own work forward gain inspiration from case studies to inform their work.   About the trainer   This training webinar will be led by Kathy Moore, Deputy Chair and Environmental Responsibility Champion at GEM and Director of Climate Museum UK. Kathy recently left SHARE Museums East after 10 years to work freelance. Always passionate about environmental issues, she ran an annual, museum-led A Level conference on biodiversity for over 10 years, using natural history collections and involving many external partners. Kathy has delivered Carbon Literacy courses to a variety of museums over the last two years and is now working with Historic England to roll out their Carbon Literacy offer.    She will be joined by Louise Bragan, Senior Officer: Programming and Learning at Wakefield Museums and Castles, Jodie Henshaw, Museum Curator at Mansfield Museum and and Izzy McLeod, a Amgueddfa Cymru Producer and climate communicator.   Take a look at the full schedule.     Who should attend?   This training is aimed at staff who work in museums, art galleries and heritage sites who are interested in supporting children and young people to respond to the Climate and Ecological Emergency within their organisation. 

Short online course showing creative methods of using dissolvable fabric in Art Textiles.

Has the Computer System Validation Engineer left and you’ve been handed their responsibilities? Do the thoughts of your next audit fill you with dread? CSV can be frustrating but this program will show you how to manage electronic data in a regulated manufacturing/laboratory/clinical environment using the GAMP framework and ensure compliance with FDA’s 21 CFR Part 11, EU Annex 11 or other regulatory guidelines.

Making your Museum Accessible to Low Income Families   In partnership with Children North East   This is a recording of a session which took place Wednesday 6 March, 10am-12.30pm You will have access to the recording to watch and revisit until 3rd October 2024.   Do you want to understand your audiences that are experiencing poverty better? Do you need dedicated time for your staff to understand the barriers faced by those experiencing poverty to accessing cultural spaces?   About this webinar   Both Kids in Museums and Children North East will share their insights into some of the barriers faced by families experiencing poverty when it comes to connecting with cultural spaces, and why this understanding is so important for all of us in the cultural sector.    This webinar will be led by Alison Bowyer, Executive Director of Kids in Museums, and Chloe Maclellan, Poverty Proofing Team Manager Communities, Early Years, Arts and Culture at Children North East.   They will be joined by Georgina Ascroft from Culture Hartlepool and Rebecca Maw from Jarrow Hall Anglo Saxon Farm, Village, and Bede Museum. Both Georgina and Rebecca will share some of their learning gained from the Poverty Proofing© process.   The session will help delegates to: deepen their understanding of poverty in the UK start to explore the connection between poverty and cultural space gain insight into how poverty can impact a family’s chances of engaging with cultural places think about how considerations around poverty impact on the experiences we provide to families in our own organisations. Take a look at the full schedule   About the trainers Alison is committed to Kids in Museums’ mission that all children, young people and families should be able to visit UK museums and feel welcome. Poverty is growing in prevalence as a barrier to a family museum visit and Kids in Museums wants to raise awareness about how to address this.    Chloe is a strong advocate for positive change fuelled by community voice, working in partnership with organisations to engage in Poverty Proofing© interventions to bring about this change as well as engaging in strategic partnerships to spread awareness and understanding of Poverty in the UK.    Who should attend? This training is aimed at staff and leaders who work in museums, art galleries, heritage sites, and cultural and arts spaces, who are interested in developing and enriching their current offer with a better understanding of audiences experiencing poverty.