39993 Learning courses in Leicester 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

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.

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

Spanish Language Masterclass Course Overview Ready to speak Spanish with confidence? The Spanish Language Masterclass is your all-in-one guide to becoming fluent in one of the world’s most widely spoken languages. This comprehensive and beginner-friendly course is designed to help you build real conversational skills, whether you're learning for travel, career advancement, or personal growth. Through step-by-step lessons, you'll explore everything from pronunciation and grammar to everyday vocabulary and useful expressions, all under the guidance of an experienced instructor. The course is completely self-paced, allowing you to learn anytime, anywhere. By the end of the course, you’ll have the confidence and skills to communicate effectively in Spanish and receive a recognised certificate to showcase your achievement. Start today and take your first step toward becoming bilingual and globally connected. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Gain a solid foundation in Spanish grammar, vocabulary, and pronunciation. Understand how to use common verbs like ser, tener, and haber in different tenses. Develop practical skills for everyday conversations—talking about time, weather, shopping, and more. Master sentence structures, articles, prepositions, and conjunctions to speak fluently. Learn the use of reflexive and reciprocal verbs, indirect object pronouns, and expressions of likes/dislikes. Apply your knowledge in real-life scenarios such as describing your home, discussing routines, or expressing future plans. Grasp the differences between present, past, and future tenses with confidence. Who is this Spanish Language Masterclass Course for? This Spanish Language Masterclass is perfect for beginners and anyone looking to improve their Spanish skills. Whether you’re learning for travel, career growth, or personal enrichment, this course is designed to fit all types of learners, with flexible, self-paced lessons. Entry Requirements There are no formal entry requirements for this course. It is open to all learners, regardless of academic background or prior experience. Accredited Certification After successfully completing the course, you can get a UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. For the PDF certificate, you’ll need to pay £9.99. You can get the hard copy for 15.99, which will reach your doorstep by post.

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.

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.

Xero Accounting and Bookkeeping Course Overview For maintaining bookkeeping accuracy, Xero is one of the most reliable software. Businesses pay a substantial amount to employees who are well equipped with Xero bookkeeping skills. This comprehensive Xero Accounting and Bookkeeping course is designed to help you master essential financial skills and simplify business operations. Whether you’re a business owner, freelancer, or aspiring bookkeeper, this course will equip you with practical knowledge of Xero software to handle accounting tasks efficiently. Each lesson is crafted to provide actionable knowledge, with real-world examples and step-by-step demonstrations ensuring you grasp the concepts with ease. By the end of the course, you’ll not only understand Xero inside out but also earn an industry-recognized certification that highlights your expertise. Take control of your financial future today—master Xero and transform your accounting game! Learning Outcome Set up and customize Xero for your business needs. Manage bank accounts, invoices, bills, and financial transactions efficiently. Generate insightful financial reports and interpret them. Automate recurring invoices and bills to save time. Understand VAT settings and complete both manual and digital filings. Handle payroll tasks, including employee setup and salary payments. Track fixed assets and manage depreciation seamlessly. Why Choose Xero Accounting and Bookkeeping Course Affordable Package Expert Guidance Comprehensive Curriculum Practical Learning 24/7 Flexible Access CPD Accredited Certification Who is this Xero Accounting and Bookkeeping Course for? This course is ideal for small business owners who want to take control of their finances without relying on external help. It also suits accounting professionals aiming to enhance their skills and stay updated with modern tools. Beginners interested in starting a career in accounting or bookkeeping will find the course easy to follow and highly practical. Additionally, freelancers looking to expand their services and offer bookkeeping support to clients can greatly benefit from the knowledge and techniques covered. Career Path Completing this Xero Accounting and Bookkeeping​ course opens up several exciting career opportunities in the accounting and finance sector. You can pursue roles such as: Bookkeeper: £18,000 to £35,000 per year Accounts Assistant: £21,000 to £28,000 per year Payroll Administrator: £22,000 to £50,000 per year Accounting Technician: £17,000 to £34,000 per year Management Accountant: £24,000 to £60,000 per year

Learning to love ourselves, and live in alignment with our children, by applying the principles of unschooling to our own lives.

A CPD accredited course to help you reduce your anxiety. A deeply reflective course exploring ways to reduce anxiety, learning coping strategies and setting goals for the future.