927 Courses in Cardiff delivered Live Online

Excel 2016 Formulas and Functions Course Overview: This course is designed to provide learners with a comprehensive understanding of Excel 2016 formulas and functions. By covering essential tools and techniques, the course enables learners to confidently navigate the Excel environment and utilise formulas for data analysis, calculations, and reporting. With a focus on both fundamental and advanced functions, learners will gain the skills needed to streamline their tasks and improve efficiency in the workplace. The course’s practical value lies in its application across various industries, allowing professionals to enhance their data handling and reporting capabilities, making it an invaluable addition to any skill set. Course Description: The "Excel 2016 Formulas and Functions" course covers the core concepts of using Excel formulas and functions to manage and analyse data. It starts with the basics, such as SUM, AVERAGE, and IF functions, before advancing to more complex tools like VLOOKUP and conditional formatting.Through each module, learners will explore how to use these features to automate calculations, create dynamic reports, and manipulate datasets. The course offers a structured approach to mastering Excel, with clear guidance on how to use each function effectively in a business context. Learners will come away with the knowledge to work more efficiently in Excel, enabling them to make informed data-driven decisions and enhance productivity. Excel 2016 Formulas and Functions Curriculum: Module 01: Getting Started with Microsoft Excel 2016 Module 02: Basic Formulas and Functions Module 03: Formulas and Functions Activities (See full curriculum) Who is this course for? Individuals seeking to improve their Excel skills Professionals aiming to enhance their data analysis capabilities Beginners with an interest in data management and analysis Any other individuals looking to gain proficiency in Excel Career Path: Data Analyst Administrative Assistant Financial Analyst Business Analyst Project Coordinator

Course Overview This "Microsoft Power BI - Master Power BI in 90 Minutes!" course offers a concise yet comprehensive introduction to Power BI, empowering learners to quickly create and manage data dashboards. The course is designed for both newcomers and those looking to enhance their skills, covering essential topics to help users understand and utilise Power BI for data analysis and reporting. Upon completion, learners will gain the ability to design dynamic dashboards, manipulate data, and visualise trends, providing valuable insights for decision-making in various business environments. Course Description This course takes learners through Power BI’s core functionalities, starting with an introduction to the platform before advancing to building basic and sophisticated dashboards. Learners will explore key aspects such as data import, filtering, and the creation of interactive visuals. By working with live data, participants will develop an understanding of how to generate real-time reports, enhancing their ability to analyse data and derive insights. The course offers both beginner and advanced concepts, ensuring that all participants can apply what they’ve learned to real-world data scenarios. Upon completing the course, learners will feel confident in their ability to utilise Power BI to its full potential in any business context. Course Modules Module 01: Power BI - Introduction Module 02: Your First Power BI Dashboard Module 03: Your Advanced Power BI Dashboard with Real Live Data Module 04: Course Bonuses (See full curriculum) Who is this course for? Individuals seeking to enhance their data analysis skills. Professionals aiming to improve data visualisation and reporting capabilities. Beginners with an interest in business intelligence or data management. Anyone looking to gain insights into data-driven decision-making. Career Path Business Intelligence Analyst Data Analyst Data Visualisation Specialist Marketing Data Analyst Financial Analyst

Financial Analysis Course Overview The "Financial Analysis" course provides a comprehensive introduction to financial analysis, equipping learners with the knowledge and skills needed to interpret and evaluate financial statements. Covering key areas such as balance sheets, income statements, and cash flow analysis, this course enables learners to assess financial performance and make informed decisions. Whether you are starting your career in finance or aiming to enhance your existing knowledge, this course offers essential tools for financial analysis. Upon completion, learners will be able to analyse financial data effectively, understand the key financial indicators of businesses, and contribute to strategic financial decision-making. Course Description This course covers the fundamentals of financial analysis, providing in-depth insights into financial statements, including balance sheets, income statements, and cash flow statements. Learners will explore various financial reporting techniques, evaluate profitability, and develop the ability to conduct ratio and equity analysis. The course also delves into the applications and limitations of EBITDA and teaches learners to assess credit risks. By the end of the course, participants will have gained valuable skills in financial data interpretation, enabling them to assess financial health and contribute to strategic financial decisions in organisations. The learning experience combines theoretical knowledge with practical analytical skills to prepare learners for roles in finance and accounting. Financial Analysis Curriculum: Module 01: Introduction to Financial Analysis Module 02: The Balance Sheet Module 03: The Income Statement Module 04: The Cash Flow Statement Module 05: Financial Reporting Module 06: Analysing Profitability Module 07: The Applications and Limitations of EBITDA Module 08: Credit Analysis Module 09: Equity Analysis Module 10: Ratio Analysis (See full curriculum) Who is this course for? Individuals seeking to understand financial analysis Professionals aiming to enhance their financial reporting and decision-making skills Beginners with an interest in finance or accounting Business owners looking to improve their financial literacy Career Path Financial Analyst Accountant Credit Analyst Financial Consultant Corporate Finance Manager Business Intelligence Analyst Investment Analyst

Sage 50 (Updated v.29) Course Overview This updated Sage 50 (v.29) course offers a comprehensive guide to using the latest version of Sage 50 for accounting and financial management. Designed for learners at all levels, it covers essential functions such as setting up your company, managing invoices, reconciling accounts, and generating reports. With the focus on providing valuable insights into financial management software, this course helps learners develop the skills to manage and control financial data with efficiency. By the end of the course, learners will have a solid understanding of Sage 50’s features and be able to use it confidently in real-world applications. The course is ideal for professionals looking to expand their software skills or those pursuing a career in accounting or finance. Course Description In this updated Sage 50 (v.29) course, learners will delve into all aspects of the software, from installation and company setup to mastering functions like invoicing, payroll management, and producing detailed financial reports. Key topics include maintaining the chart of accounts, tracking expenses, and reconciling bank statements. Learners will also gain a thorough understanding of Sage 50's advanced features, including managing VAT returns and automating financial processes. This course offers an engaging experience where learners can explore the various capabilities of Sage 50, ensuring that they can apply their knowledge effectively in the workplace. Upon completion, learners will possess the expertise to confidently utilise Sage 50 for efficient financial management. Sage 50 (Updated v.29) Curriculum Module 01: Introduction to Sage 50 (Updated v.29) Module 02: Setting Up Your Company and Preferences Module 03: Managing Customers and Suppliers Module 04: Invoicing and Payments Management Module 05: Bank Reconciliation and VAT Returns Module 06: Producing Financial Reports Module 07: Advanced Features in Sage 50 Module 08: Troubleshooting and System Maintenance (See full curriculum) Who is this course for? Individuals seeking to enhance their accounting software knowledge. Professionals aiming to advance in finance or accounting roles. Beginners with an interest in accounting software and financial management. Business owners or administrators seeking to streamline financial processes. Career Path Accounts Assistant Financial Administrator Sage 50 Support Specialist Bookkeeper Payroll Officer Financial Analyst

Domestic Violence and Abuse Awareness Diploma Course Overview This Domestic Violence and Abuse Awareness Diploma provides a comprehensive introduction to recognising, understanding, and responding to domestic violence and abuse. The course equips learners with the knowledge to identify different forms of abuse, assess risks, and understand the profound impacts on victims and children. It emphasises the importance of supporting victims effectively and navigating the relevant UK legislation. Learners will develop skills essential for safeguarding and reporting, alongside accurate record keeping. Ideal for those wishing to increase awareness or pursue careers in social care, healthcare, education, or community support, this diploma fosters confidence and competence in addressing sensitive issues with professionalism and compassion. Course Description This course delves deeply into the nature and dynamics of domestic violence and abuse, exploring its various forms and the psychological, physical, and emotional consequences for victims, including children. Learners will examine risk assessment techniques and appropriate methods for supporting victims, while gaining a clear understanding of the UK legal framework governing domestic abuse. The programme also covers essential administrative skills such as incident reporting and record keeping to ensure accountability and protection. Delivered in a structured format, the course offers a thorough learning experience designed to build expertise for those working or intending to work in sectors focused on safeguarding, welfare, and community assistance. Domestic Violence and Abuse Awareness Diploma Curriculum: Module 01: Introduction to Domestic Violence & Abuse Module 02: The Components of Domestic Violence Module 03: The Impact of Domestic Violence on Victims Module 04: The Impact of Domestic Violence and Abuse on Children Module 05: Assessing the Risks of Domestic Violence and Abuses on Children Module 06: Supporting the Victim and Reporting Incidents Module 07: Record Keeping Module 08: Domestic Violence and Abuse Legislation in the UK (See full curriculum) Who is this course for? Individuals seeking to understand domestic violence and abuse awareness. Professionals aiming to enhance their safeguarding and support skills. Beginners with an interest in social care, health, or community support. Volunteers and advocates working with vulnerable populations. Career Path Safeguarding Officer Social Care Worker Healthcare Support Worker Community Support Worker Victim Support Advisor Early Years Practitioner

Microsoft Power BI Masterclass 2021 Course Overview: The "Microsoft Power BI Masterclass 2021" provides learners with the skills to become proficient in data analysis and visualization using Power BI. This comprehensive course covers the core functionalities of Power BI, from data preparation and transformation to creating impactful reports and dashboards. Learners will gain valuable insights into data modelling, visualisation, and the use of DAX for advanced calculations. By the end of the course, participants will be able to apply their knowledge to real-world projects, improving their ability to communicate data-driven insights effectively. This course is ideal for professionals and beginners who want to leverage Power BI to unlock the potential of their data. Course Description: This masterclass delves into the essential features of Microsoft Power BI, guiding learners through every stage of data analysis. Starting with project setup and data transformation in the Query Editor, the course progresses to advanced topics such as DAX functions and data storytelling. Learners will explore how to build data models, create dashboards, and employ Python in Power BI to enhance their reports. The course also covers Power BI Service for cloud-based analytics, row-level security for data protection, and integrating additional data sources. With a focus on empowering users to communicate insights clearly, the course ensures learners gain the expertise to manage data efficiently, make informed decisions, and stay up to date with evolving tools and features. Microsoft Power BI Masterclass 2021 Curriculum: Module 01: Introduction Module 02: Preparing our Project Module 03: Data Transformation - The Query Editor Module 04: Data Transformation - Advanced Module 05: Creating a Data Model Module 06: Data Visualization Module 07: Power BI & Python Module 08: Storytelling with Data Module 09: DAX - The Essentials Module 10: DAX - The CALCULATE function Module 11: Power BI Service - Power BI Cloud Module 12: Row-Level Security Module 13: More data sources Module 14: Next steps to improve & stay up to date (See full curriculum) Who is this course for? Individuals seeking to enhance their data analysis skills. Professionals aiming to advance their data visualization expertise. Beginners with an interest in data science or business analytics. Business analysts or data professionals looking to upskill in Power BI. Career Path: Data Analyst Business Intelligence Analyst Data Scientist Power BI Developer Reporting Analyst Data Visualisation Expert

PAT Testing - Portable Appliance Testing Training Course Overview The "PAT Testing - Portable Appliance Testing Training" course is designed to equip learners with the essential knowledge and skills required to safely conduct portable appliance testing in line with current UK regulations. Participants will gain a clear understanding of the legal requirements, risk assessment techniques, and best practices for maintaining workplace safety. This course is ideal for individuals involved in electrical safety, ensuring they can carry out PAT testing confidently and competently. Upon completion, learners will be prepared to enhance workplace safety through proper appliance inspection and compliance with relevant legislation. Course Description This comprehensive course covers all key areas of portable appliance testing, including the legal provisions that guide PAT testing, risk assessment methodologies, and the appropriate tools for conducting inspections. Learners will explore different types of electrical appliances, their classification, and how to perform initial visual examinations. Additionally, the course delves into the electrical installation testing process and safety precautions necessary to mitigate risks. Participants will also learn the essential practices for recording and reporting test results. By the end of the course, learners will be equipped with the skills needed to perform thorough PAT testing and ensure compliance with industry standards. PAT Testing - Portable Appliance Testing Training Curriculum Module 01: Introduction to PAT Module 02: Relevant Statutory Provisions for PAT Module 03: Risk Assessment Module 04: Reducing and Controlling Risks Module 05: Electrical Units and Appliance Classification Module 06: Initial Visual Examination Module 07: Instruments for Testing and Equipment Inspection Module 08: Electrical Installation Testing Module 09: Safety Precautions in Electrical Testing Module 10: Reporting and Record-keeping (See full curriculum) Who is this course for? Individuals seeking to enhance their knowledge of electrical safety. Professionals aiming to ensure compliance with PAT testing regulations. Beginners with an interest in electrical safety or maintenance. Safety officers or facilities managers responsible for ensuring workplace compliance. Career Path PAT Tester Health and Safety Officer Facilities Manager Electrical Compliance Officer Maintenance Technician Workplace Safety Consultant

Create Animations Using Flourish Studio Course Overview "Create Animations Using Flourish Studio" is designed to teach learners how to create dynamic, engaging animations using Flourish Studio, a powerful visualisation tool. This course covers everything from understanding the interface to building complex, interactive visualisations that can bring data to life. Through step-by-step instructions, learners will develop the skills necessary to enhance presentations, reports, and projects with professional-quality animations. By the end of the course, participants will be able to confidently use Flourish Studio to create visually compelling animations that are tailored to their specific data and narrative needs. This course is suitable for those looking to boost their visual communication skills and make an impact in data presentation. Course Description This course delves into the various capabilities of Flourish Studio, focusing on both its basic and advanced features. Learners will start by exploring the interface and learning how to work with different templates. The course then covers key areas such as importing and managing data, creating animations, and customising visualisations from scratch. In addition to mastering specific templates, participants will also learn how to craft a compelling data story and explore Flourish's other unique features. By the end of the course, learners will have the knowledge and skills to create engaging animations that effectively communicate data insights. Resources and tips for continued development will also be provided, ensuring that learners can keep building on their newfound expertise. Create Animations Using Flourish Studio Curriculum Module 01: Introduction to Flourish Studio Module 02: Getting Started with Flourish Module 03: Adding and Managing Data in Flourish Templates Module 04: Creating Visualisations in Flourish Studio from Scratch Module 05: More Visualisation Templates in Flourish Studio Module 06: Creating a Story and Other Options Module 07: Other Exciting and Important Features Module 08: Data Visualisation Tips & Resources Module 09: Congratulations (See full curriculum) Who is this course for? Individuals seeking to enhance their data presentation skills. Professionals aiming to improve their visual communication abilities. Beginners with an interest in data visualisation or animation. Anyone involved in creating impactful presentations or reports. Career Path Data Visualisation Specialist Marketing Analyst Data Storyteller Presentation Designer Business Intelligence Analyst Marketing Manager Data Analyst

Level 2 Health and Safety in the Workplace Course Overview This Level 2 Health and Safety in the Workplace course provides essential knowledge for maintaining a safe and compliant working environment across various industries. Learners will gain a thorough understanding of key health and safety principles, legal responsibilities, risk assessment techniques, and emergency procedures. Designed to equip individuals with the confidence and awareness to identify hazards and implement control measures, this course supports improved workplace safety culture. Upon completion, learners will be able to recognise common risks, understand health and safety legislation, and contribute effectively to creating safer workspaces, making it valuable for both new starters and those seeking to enhance their professional skills. Course Description This course covers fundamental topics including workplace hazards, risk management, fire safety, manual handling, and reporting procedures. Learners will explore health and safety legislation and the roles and responsibilities of employers and employees. The content is delivered through clear explanations and structured learning, enabling learners to develop critical awareness of how to maintain safe environments. Skills gained include hazard identification, risk evaluation, and understanding of preventative strategies, all essential for fostering compliance and wellbeing at work. Suitable for a broad range of sectors, the course offers comprehensive knowledge that supports personal development and prepares learners for further progression in health and safety or related fields. Level 2 Health and Safety in the Workplace Curriculum Module 01: Level 2 Health and Safety in the Workplace Curriculum (See full curriculum) Who is this course for? Individuals seeking to improve workplace safety awareness. Professionals aiming to develop their health and safety knowledge. Beginners interested in health and safety fundamentals. Employees required to meet compliance standards in any sector. Career Path Health and Safety Assistant Workplace Safety Coordinator Facilities Manager Construction Site Worker Administrative roles with health and safety responsibilities Entry-level positions in manufacturing, retail, and office environments

Transcription Level 3 Course Overview The Transcription Level 3 course is designed to provide learners with the advanced skills needed for professional transcription. This course offers an in-depth exploration of transcription techniques, focusing on accuracy, speed, and industry-specific terminology. Learners will gain a comprehensive understanding of various transcription methods, including medical, legal, and general transcription, with an emphasis on formatting and industry standards. By completing this course, learners will be equipped to excel in a range of transcription tasks, ensuring high-quality outputs for diverse sectors. Upon completion, learners will be able to transcribe various content types efficiently, making them highly valuable in the transcription industry. Course Description This Transcription Level 3 course covers the advanced aspects of transcription, starting with detailed lessons on formatting, accuracy, and professional transcription practices. Learners will be introduced to different types of transcription, such as medical, legal, and business, while developing a keen attention to detail and speed. The course is structured to provide learners with an understanding of transcription tools, techniques, and best practices, helping them to refine their skills for industry standards. Throughout the course, learners will engage with comprehensive training materials, exercises, and assessments designed to enhance their transcription abilities. By the end of the course, learners will have developed the expertise required to work as a transcriptionist in various professional settings, ensuring they meet the high demands of employers. Transcription Level 3 Curriculum Module 01: Transcription Level 3 (See full curriculum) Who is this course for? Individuals seeking to develop advanced transcription skills Professionals aiming to specialise in legal, medical, or general transcription Beginners with an interest in transcription or office administration Those looking to enter the transcription industry or freelance market Career Path Medical Transcriptionist Legal Transcriptionist General Transcriptionist Freelance Transcriptionist Virtual Assistant Court Reporter Audio Typist