33195 PE courses in Cardiff 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

Fitness Instructor Course Overview If you’re passionate about health and fitness and want to help others reach their goals, our Fitness Instructor Course is the perfect place to begin. This course offers a comprehensive introduction to personal training, covering everything from anatomy and client assessment to resistance training and cardio programming. You’ll learn the key roles and responsibilities of a fitness coach, dive deep into the muscular and cardiovascular systems, and gain practical knowledge through detailed exercise demonstrations. From planning training sessions to understanding muscle growth and fat loss, this course is designed to equip you with the tools to guide clients effectively and confidently. Whether you're a beginner or looking to build on your existing knowledge, this course is structured to help you become a competent and confident fitness instructor—ready to make a difference. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Understand the responsibilities of a fitness instructor Gain in-depth knowledge of anatomy and muscle function Learn to assess clients and create personalised training plans Master key concepts of resistance training and progressive overload Develop expertise in cardio workouts and HIIT training Learn the fundamentals of flexibility and proper warm-up techniques Get practical instruction on essential exercises like squats, deadlifts, and push-ups Who is this Fitness Instructor Course for? This Fitness Instructor Course is perfect for aspiring fitness coaches and personal trainers looking to gain professional-level knowledge and skills. It’s also a great fit for health and sports science students who want to build a strong foundation in fitness training and exercise science. Gym enthusiasts who are eager to understand the principles behind effective workouts will find immense value, as will anyone with a passion for fitness and a desire to help others achieve their health goals. Entry Requirements There are no formal prerequisites for this course. It is open to anyone interested in fitness and training, regardless of prior experience. A basic understanding of exercise and a willingness to learn is all you need to get started. 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.

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

QuickBooks Online Bookkeeping Course Overview Bookkeeping is a complex yet very crucial task for an organisation or a business. It requires skills and expertise to maintain accuracy in online bookkeeping. The Quickbooks Online Bookkeeping course is here to help you understand all the functions and tools of Quickbook. Within a few hours, you will know the ins and outs of Quickbook online bookkeeping. The Quickbooks Online Bookkeeping course will teach you the fundamentals of Quickbook. Step-by-step, you will learn how to write reports, paying suppliers, posting customer invoices and more. You will acquire the skills to manage payroll and calculate VAT. Every module will include new and advanced techniques of Bookkeeping and gradually increase your proficiency in this subject. Good bookkeeping skills are always on demand. Join the Quickbooks Online Bookkeeping course to learn everything you need to become a competent bookkeeper. It will provide you with additional skills to stay ahead of the competition. Learning Outcome Set up and navigate QuickBooks Online confidently Create and manage customer and supplier records Post invoices, credit notes, and handle payments with ease Record petty cash, sundry receipts, and cheque transactions Prepare and submit VAT returns using QuickBooks Reconcile bank statements and manage outstanding items Post wage journals and journal adjustments Generate reports for accurate business decision-making Who is this QuickBooks Online Bookkeeping Course for? This course has been expertly designed for those who want practical, real-world bookkeeping skills without wading through jargon. You’ll go from “just looking” at QuickBooks to actually understanding how to use it like a seasoned bookkeeper. Plus, our self-paced lessons let you learn whenever and wherever, with instructor-led support to guide you along the way. By the end, you’ll have a strong working knowledge of QuickBooks Online and the confidence to use it in your role—or for your own business. Career Path Completing this course can open doors to various finance and admin roles across industries. Some potential job paths in the UK include: Junior Bookkeeper – earn between £20,000 – £25,000 per year Accounts Assistant – typically earns £22,000 – £28,000 annually Office Administrator (with bookkeeping duties) – earns around £21,000 – £26,000 Finance Support Officer – earns between £24,000 – £30,000 Freelance Bookkeeper – can earn £15 – £35 per hour, depending on experience and clients

Introduction to Applied Accounting Course Overview The Introduction to Applied Accounting course is the perfect starting point for anyone looking to build a strong foundation in the world of accounting. Covering everything from basic accounting principles to financial reporting, management accounting, and cost analysis, this course offers a well-rounded view of real-world accounting practices. You'll explore key topics like the accounting cycle, double-entry bookkeeping, balance sheets, cash flow management, working capital, and even cost accounting techniques. Whether you're aiming to kickstart a new career or sharpen your skills for business success, this course provides essential knowledge delivered in an easy-to-follow and practical way. With businesses increasingly relying on accurate financial data to drive decisions, there's never been a better time to master the fundamentals of accounting and open new career opportunities! Extra Included: Free Course Included: Basic of Accounting Lifetime Access Free Student ID Card Learning Outcome Understand the core concepts and principles of accounting. Master the accounting cycle and double-entry system. Analyse financial statements including balance sheets and income statements. Explore key financial ratios to assess business health. Manage working capital, liquidity, and cash flows. Gain insights into cost accounting, budgeting, and financial reporting. Identify the limitations of accounting systems and recognise intangible assets. Understand internal and external auditing processes. Who is this Introduction to Applied Accounting Course for? This course is ideal for anyone interested in developing a solid foundation in accounting. It's perfect for beginners considering a career in finance, small business owners managing their own accounts, professionals looking to refresh or formalise their knowledge, and students planning to pursue further studies in accounting or business. Entry Requirements There are no formal prerequisites for this course. It is open to anyone with an interest in British Sign Language, particularly those who have completed a basic BSL course or have prior exposure to the language. A foundational understanding of BSL is beneficial to get the most out of the advanced content. 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.

Course Overview The comprehensive Affiliate Marketing has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Affiliate Marketing today, and learn from the very best the industry has to offer! This best selling Affiliate Marketing has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Affiliate Marketing is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Affiliate Marketing is CPD-accredited, so you can be confident you’re completing a quality training course will boost your CV and enhance your career potential. The Affiliate Marketing is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Affiliate Marketing, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Affiliate Marketing will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Affiliate Marketing to be completed at your own pace, whether that’s part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview This BSL online course is updated and includes every essential sign and their meanings. The course is divided into two parts, Level 1 and Level 2. The first part covers everything from fingerspelling to forming sentences. You'll learn how to introduce yourself and say about your family too. Basic topics like colours, transports, weather, hobbies etc are included here. Part two dives into more real world conversational topics from where you can easily learn the language to use it daily. From home to professional environment you can learn every nuance signs to make you an expert with this language. The bsl online course covers all your needs and beyond to get an excellent grip and understanding of the language. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Master fluent BSL communication skills. Develop effective conversations in BSL. Understand the nuances of sign language grammar. Foster inclusion in the deaf and hard-of-hearing community. Who is this Advanced Diploma in British Sign Language (BSL) Course for? This course is perfect for anyone with basic BSL knowledge who wants to advance their skills. It's ideal for professionals in education, healthcare, or customer service, as well as anyone looking to communicate better with the Deaf community. Entry Requirements There are no formal prerequisites for this course. It is open to anyone with an interest in British Sign Language, particularly those who have completed a basic BSL course or have prior exposure to the language. A foundational understanding of BSL is beneficial to get the most out of the advanced content.

Tax Accounting Course Overview Tax Accounting teaches you everything you need to know about taxation in the UK from the ground up, helping you earn a professional certificate for free to boost your career profile. This Tax Accounting course is a comprehensive, instructor-guided programme designed to give you a thorough understanding of the tax system and your responsibilities within it. To excel in today’s competitive financial sector, having specialist tax knowledge is essential. Through this in-depth training, you will develop the critical skills needed to start or enhance your career in tax accounting, whether you’re a beginner or an experienced professional looking to refine your expertise. The learning materials are accessible online, giving you the flexibility to study at your own pace and accelerate your journey towards a successful and rewarding career in accounting and finance. Extra Included: Free Course Included: Accounting Masterclass Lifetime Access Free Student ID Card Learning Outcome Understand the structure of the UK tax system and administration processes. Calculate and manage income tax, corporation tax, VAT, and capital gains tax. Complete and submit self-assessment tax returns accurately. Manage payroll taxes, national insurance contributions, and employee wages. Grasp advanced concepts of income taxation and financial analysis. Apply double-entry accounting principles in taxation contexts. Explore professional career paths and responsibilities of a tax accountant. Why Choose This Course? The Tax Accounting course provides practical, job-ready training that covers real-world tax scenarios. You’ll gain hands-on skills highly valued by employers and small businesses. Whether you're aiming to start your career, grow your freelance services, or simply understand tax accounting better for personal or business needs, this course offers the clarity and confidence you need to succeed. Who Is This Course For Aspiring tax accountants or payroll professionals Finance and accounting students Small business owners managing their own taxes Professionals seeking to expand their tax knowledge Entry Requirements There are no specific prerequisites for this course. It is open to anyone interested in learning about tax accounting. 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.

Sales Overview: Traffic Psychology and Human Factors Are you looking to delve into the intricate dynamics of traffic psychology and human factors to enhance road safety and optimize transportation systems? Look no further than our comprehensive module package titled 'Traffic Psychology and Human Factors.' Tailored for professionals, researchers, and enthusiasts alike, this series offers profound insights into the behavioral, cognitive, and environmental aspects shaping our roadways.   1. Introduction to Traffic Psychology and Human Factors: Begin your journey by unraveling the core principles and theories underpinning traffic psychology and human factors. Explore the intricate interplay between human behavior, cognition, and the built environment, setting a solid foundation for deeper exploration. 2. Driver Perception and Attention: Delve into the fascinating world of driver perception and attention. Uncover how individuals process and interpret visual information while navigating complex traffic scenarios. Learn strategies to optimize attentional resources and mitigate the risks associated with attentional lapses. 3. Driver Cognition and Decision Making: Embark on an exploration of the cognitive processes driving human decision-making behind the wheel. Analyze how drivers perceive risks, evaluate alternatives, and execute actions in real-time situations. Gain insights into cognitive biases and heuristics influencing driver behavior. 4. Driver Behaviour and Performance: Dive into the realm of driver behavior and performance, where psychology meets practical application. Examine factors influencing driver performance, including stress, fatigue, and emotions. Discover techniques to enhance driver behavior through training, intervention, and design. 5. Road User Behaviour: Expand your understanding beyond drivers to encompass the diverse array of road users. Investigate the behaviors and interactions among pedestrians, cyclists, and motorists. Gain valuable perspectives on shared spaces, conflict resolution, and inclusive design principles. 6. Traffic Psychology and the Environment: Explore the symbiotic relationship between traffic psychology and the environment. Assess how environmental factors, such as infrastructure design and urban planning, shape human behavior and traffic patterns. Unearth strategies for creating safer, more sustainable transportation systems.   Unlock the potential to revolutionize road safety and transportation efficiency with 'Traffic Psychology and Human Factors.' Whether you're an aspiring researcher, transportation planner, or safety advocate, this comprehensive module package equips you with the knowledge and tools needed to navigate the complex landscape of human behavior on the road. Accelerate your understanding, transform your approach, and pave the way towards safer, smarter transportation solutions. Course Curriculum Module 1: Introduction to Traffic Psychology and Human Factors Introduction to Traffic Psychology and Human Factors 00:00 Module 2: Driver Perception and Attention Driver Perception and Attention 00:00 Module 3: Driver Cognition and Decision Making Driver Cognition and Decision Making 00:00 Module 4: Driver Behaviour and Performance Driver Behaviour and Performance 00:00 Module 5: Road User Behaviour Road User Behaviour 00:00 Module 6: Traffic Psychology and the Environment Traffic Psychology and the Environment 00:00