47629 Learning 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

Improvers: Addressing the bit between just getting it & getting good at it - where we jam improver level songs with learning your first barre chords and scales and starting to get to grips with musical theory snuck into the jamming fun An improver player is someone who can play open chords, read tab and chord boxes and feels fairly comfortable playing a few songs and changing between chords. You are now ready to learn barre chords, licks, riffs and theory

Improvers: Addressing the bit between just getting it & getting good at it - where we jam improver level songs with learning your first barre chords and scales and starting to get to grips with musical theory snuck into the jamming fun An improver player is someone who can play open chords, read tab and chord boxes and feels fairly comfortable playing a few songs and changing between chords. You are now ready to learn barre chords, licks, riffs and theory

Elevate your economic prowess! Spark Generation's adaptable Economics course, blending flexibility with in-depth market insights. 💼💡

Sharpen your culinary leadership skills with our Kitchen Management course. Master safety, sanitation, menu creation, and strategic financial planning to excel as a kitchen manager. Dive into this all-encompassing guide to managing a high-functioning kitchen.

Empower families as a dedicated Family Support Worker. This course equips you with the skills to tackle family challenges, support addiction recovery, and safeguard children. Join us to make a meaningful difference in lives and build a rewarding career.

Live online took hold in 2020 and is a highly interactive, engaging and effective training medium, if it’s done right. Let us give your staff the key skills they need to make their virtual training learner-centred, by building a psychologically safe environment plus using online training tools such as break-out rooms, slides, video and whiteboards. Courses include: Key elements of a successful live online training session Knowing your audience Technology vs technique Blended/flipped/hybrid learning Making your activities and materials online-friendly Effective planning for live online sessions Timing live online training sessions

Customer service just isn’t enough. Customer experience is where the secret to success lies. Build a loyal and fruitful customer base by learning how to design frictionless processes and build empathetic and solution-focused services with our bespoke courses, which include: Customer service vs customer experience The changing nature of customers and how to stay ahead Customer needs vs customer expectations How our behaviour affects those around us and how to use the power of influence Communicating with customers positively and effectively Moments that matter Building trust and integrity What to do when things go wrong

Discover the holistic world of Bach Flower Remedies with our comprehensive course. Learn to prepare, preserve, and integrate these natural remedies for emotional balance and well-being across various age groups and emotional states.

Intermediates: Bedroom player to bar room rockstar - where we jam intermediate level songs with the barre chord, scale, improvisation, theory and chord extension learning snuck into the jamming fun An intermediate player can play E type barre chords and perhaps some/all A type positions. You can play a few scales and have been using them either to improvise or play solos, licks and riffs. Your knowledge of the fretboard is good