This one day online course will assist candidates in preparing for the forthcoming initial Senior Caseworker exam.
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 2 hour digital training session is CPD accredited. It utilises lived experience and a filmed version of our acclaimed theatre production MOCKINGBIRD HIGH - a compelling and lyrical account of the devastating impact of domestic abuse on two teenage children and their mother. Plus interactive activities, group discussion to explore the relevance to your work practice and a support pdf.
Join me in the studio at West 16th on Wednesday 11th June to learn how to make a fabulous flower crown from fresh seasonal flowers and foliage. We will teach you step by step to select the flowers to fit your vibe - be it wedding, festival, disco or garden party. We then learn how to tape and wire your stems and finally to build them into a gorgeous crown. You'll pick up plently of florist tips and tricks along the way and leave with your gorgeous crown creation to take home. All the flowers, equipment and instruction will be provided alongside drinks and treats from the West 16th kitchen.
There are a number of reasons why it is important to actively promote equality and diversity within your business and the wider community, not only to ensure compliance with anti-discrimination legislation and professional regulations, including the SRA Standards & Regulations. There will also be business benefits to the organisation including attracting and retaining talented staff, improving staff morale, potentially accessing a wider client base and enhancing service levels and client satisfaction. Join us for this useful overview session on equality, diversity & inclusion which will cover the following points; The Meaning of Equality Discrimination Harassment & Victimisation Unconscious Bias The Equality Act & the Protected Characteristics Reasonable Adjustments Complying with E&D requirements Target Audience This online course is suitable for staff of all levels, from support staff to senior partners. Resources Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Amie Higgins, Consultant, DG Legal Amie is a Senior Solicitor, qualified under the Law Society’s Immigration & Asylum Accreditation Scheme (IAAS) as an Advanced Caseworker and Supervisor. Amie specialises in all aspects of Immigration, Asylum and Human Rights work, with a specialism in human trafficking/modern slavery cases and working with vulnerable clients. Amie is an experienced trainer, delivering a range of training on both legal and practice management topics.
Developmental stages of children and developing activities for 0-12 year olds Do you want to know more about how children learn and play at different ages to inform how you create family activities in your museum? About this training This training webinar will be led by cultural heritage learning consultant Anna Salaman. She has thirty years’ experience immersed in the arts, heritage and cultural sectors, specialising in learning and participation, creativity and play. Anna has worked with organisations around the world including ArtScience Museum (Singapore), Discover Children’s Story Centre, the Science Museum, the Natural History Museum, and the V&A. The session will help delegates to: learn about the developmental stages of children, ages 0-12, gain an understanding of different facilitation styles to build confidence when interacting with children of different age groups, explore the five types of play and facilitating play, make plans to put the training into practice in their organisation. Take a look at the full schedule. Please note: this is a recording of the session which took place on 6th June 2024. Who should attend? This training is aimed at staff who work in museums, art galleries and heritage sites and are interested in developing your knowledge and understanding of the developmental ages and stages of children to inform how you create activities for families.