48816 Courses in Elgin delivered On Demand

Master SQL Database Queries with our comprehensive course. Learn SQL fundamentals, advanced techniques, and data analysis skills for efficient database management.

How to overcome lust and live a life of purity.

Unlock the secret to confident parallel parking with our 30-minute formula! Empower yourself to teach your teenager to parallel park without traditional driving lessons. Pass on the same method used by Professional Driving Instructors and boost your teen's chances of acing their driving test.

A three-day course of videos to give you a taste of Vinyasa yoga. The videos include a full-body vinyasa flow, core strength yoga and eagle pose

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

Functional Skills: Maths and English Level 2 Course Overview Need a solid boost in both maths and English to get ahead in work or study? This Functional Skills: Maths and English Level 2 course has got you covered. From fractions and BODMAS to grammar and punctuation, we’ve packed everything into bite-sized lessons that are easy to follow and fun to complete. Whether you’re prepping for further education, looking to improve employability, or just brushing up on the basics, this course helps you feel confident with numbers and words — all at once. Plus, it's fully online, meaning you can learn at your own pace, from anywhere. Zero stress, just progress! Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Confidently handle maths concepts like decimals, percentages, ratios, and algebra Solve real-life word problems involving fractions, profit & loss, and scientific notation Read, write, and speak more clearly and correctly in English Spot and avoid common mistakes in writing Improve your academic, workplace, or everyday communication skills Who is this Functional Skills: Maths and English Level 2 Course for? This course is ideal for anyone looking to improve their everyday maths and English skills, whether you're aiming to meet entry requirements for further study, boost your CV, or gain confidence in practical tasks like budgeting, writing emails, or solving problems. It’s perfect for school leavers, job seekers, apprentices, and adults returning to education - basically, anyone who wants to sharpen their skills in a friendly, flexible way. Entry Requirements There are no formal requirements — just basic understanding of English and motivation to learn. 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.

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.

Sage 50 Payroll for Beginners Course Overview Mastering payroll is essential for any business operation, and Sage 50 Payroll is one of the UK’s most widely used systems for managing employee payments, tax, pensions, and more. This beginner-level course is designed to introduce you to the complete payroll process using Sage 50, from setting up company details to running year-end reports. Whether you’re looking to work in payroll, start a role in HR or finance, or simply want to enhance your accounting knowledge, this course provides step-by-step training to help you build a solid foundation. You’ll start by exploring payroll basics and navigating company and legislation settings. Then, you’ll dive into practical tasks such as adding employees, entering payments, generating reports, and handling submissions. You’ll also gain insights into essential year-end procedures and how to process final payments correctly, giving you confidence in real-world scenarios. No prior payroll experience is required, making this course ideal for aspiring payroll administrators or small business owners looking to manage staff payments in-house. With flexible online learning and practical modules, this course ensures that you can develop your Sage 50 skills at your own pace — ready to take on payroll duties with efficiency and accuracy. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Understand the fundamentals of Sage 50 Payroll software Learn how to set up company and legislation settings correctly Gain the skills to add new and existing employees to the payroll system Process payrolls and update employee records efficiently Handle statutory payments and employee departures with confidence Master e-submissions and produce accurate reports and year-end summaries Who is this Sage 50 Payroll for Beginners Course for? This Sage 50 Payroll for Beginners course is ideal for aspiring payroll administrators and HR assistants who want to develop practical skills in managing payroll processes. It’s also perfectly suited for small business owners looking to handle their company’s payroll operations in-house. In addition, accountancy or finance students aiming to enhance their career prospects will benefit greatly from this course. Whether you're starting from scratch or looking to refresh your knowledge, this course provides the foundation you need to confidently use Sage 50 Payroll. Entry Requirements There are no formal prerequisites for this course. It is open to anyone interested in learning payroll using Sage 50, regardless of previous experience. A basic understanding of computer use is helpful, but not essential. All you need is a stable internet connection and a desire to learn! 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.

Microsoft Office 2019 (Updated and New Features 2022) Overview In today’s digital workplace, Microsoft Office proficiency is a must-have skill across all industries. From office administrators to marketing executives, everyone benefits from mastering the MS Office suite. That’s why our Microsoft Office 2019 course (including 2022 updates) is designed to help you gain job-ready skills and stay ahead in a competitive market. Through this course, you will explore the core applications of MS Office — Excel, Word, PowerPoint, and Access. You’ll begin with Excel, learning how to perform calculations, manage workbooks, and apply formatting to make your data clear and useful. Next, you’ll move on to Microsoft Word, where you'll discover how to efficiently prepare and format professional documents, manage lists, and insert tables and graphic elements. The course then introduces PowerPoint, guiding you through designing impactful presentations using charts, images, and animations. Finally, you’ll gain a practical understanding of Microsoft Access, focusing on modifying data, working with queries, and generating meaningful reports. By the end of this course, you’ll have developed a strong grasp of MS Office tools and features — including the latest 2022 updates — giving your CV a significant edge and preparing you for a variety of career paths. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Understand the updated features of Microsoft Office 2019 and the 2022 enhancements Learn to navigate and utilise key functions in Excel, including calculations, formatting, and workbook management Discover essential Word skills, from formatting text to publishing polished documents Develop the ability to create dynamic PowerPoint presentations with media and charts Gain working knowledge of Access, including queries, forms, and reports Prepare for a range of office roles with practical, up-to-date MS Office knowledge Who is this Microsoft Office 2019 Course for? This course is suitable for office professionals, students, job seekers, and anyone looking to improve their Microsoft Office skills. It's perfect for those aiming to work more productively or move into roles that require document creation, data handling, or presentations. Entry Requirements There are no formal prerequisites for this course. It is open to anyone interested in improving their Microsoft Office skills, regardless of previous experience. Basic computer literacy is helpful but not essential. 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.