40128 Learning courses in Sheffield delivered On Demand

Elevate your administrative prowess with our Administrative Assistant course. Learn to manage daily routines, communication, records, and office technology effectively. Become the organizational backbone in any professional setting with top-tier relationship and conflict management skills.

Unlock the potential of real estate investing with our comprehensive course. Master probate deals, financing, and marketing while boosting your mindset. Start your journey now!

Bonjour to fluency! Dive into French elegance and language finesse with Spark Generation. Elevate your skills with the self-paced course from Spark Generation! 🥐

Navigate the complexities of Global Economics with our expertly designed course. Explore international trade, finance, globalization, and the intricacies of economic development. Prepare for the future with insights into geoeconomics, geopolitics, and global governance.

Mind-bending insights await! Spark Generation's adaptable Psychology course, delving into human behaviour with flexible learning. Choose to learn when, where and how 🧠 With the subscription offered by Spark Generation, you get now access to more than 55+ Cambridge, Wellbeing and Future Readiness content and 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

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.

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

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.

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.