1715 Office courses in Cardiff delivered Live Online

Course Overview The "Microsoft Excel Complete Course" is designed to equip learners with the essential skills to master Microsoft Excel, one of the most widely used tools in data analysis and business operations. This course covers a comprehensive range of topics, including Excel's new features, formula creation, data visualisation, and workbook management. It offers practical knowledge that will help learners work more efficiently, whether they are managing large datasets, analysing trends, or presenting information. By the end of this course, learners will be confident in using Excel for various business tasks, gaining a strong foundation for further professional development. Course Description This course covers all key aspects of Microsoft Excel, from the basics to advanced techniques. Learners will explore Excel’s new features in the 2019 version, as well as how to perform calculations, modify worksheets, and apply formatting. The course delves into functions, lists, and data analysis tools, including PivotTables and charts. Learners will also learn how to work with multiple worksheets and workbooks, use lookup functions, and automate workbook functionality. With a focus on essential Excel tools and techniques, learners will gain the ability to efficiently manage and analyse data for business or personal use. Course Modules Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Office Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Working with Functions Module 09: Working with Lists Module 10: Analyzing Data Module 11: Visualizing Data with Charts Module 12: Using PivotTables and PivotCharts Module 13: Working with Multiple Worksheets and Workbooks Module 14: Using Lookup Functions and Formula Auditing Module 15: Sharing and Protecting Workbooks Module 16: Automating Workbook Functionality Module 17: Creating Sparklines and Mapping Data Module 18: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to improve their data management and analysis skills. Professionals aiming to enhance their productivity in Excel for business applications. Beginners with an interest in data analysis or office administration. Anyone looking to build a strong foundation in Excel for career advancement. Career Path Data Analyst Financial Analyst Office Administrator Project Manager Business Analyst Operations Manager Administrative Assistant HR Specialist

Duration 2 Days 12 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using Tableau to perform numerical or general data analysis, visualization, and reporting. They need to provide data visualizations from multiple data sources, or combine data to show comparisons, manipulate data through calculations, create interactive visualizations, or create visualizations that showcase insights from statistical analysis. This course is also designed for students who plan to obtain Tableau Desktop Certified Associate certification, which requires candidates to pass the Tableau Desktop Certified Associate exam. Overview Blend data multiple sources. Join data. Access data in PDFs. Refine visualizations with sets and parameters. Analyze data with calculations. Visualize data with advanced calculations. Perform statistical analysis and forecasting. Create geographic visualizations. Get answers with Ask and Explain The advent of cloud computing and storage has ushered in the era of "big data." With the abundance of computational power and storage, organizations and employees with many different roles and responsibilities can benefit from analyzing data to find timely insights and gain competitive advantage. Data-backed visualizations allow anyone to explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Beyond the fundamental capabilities of creating data driven visualizations, Tableau allows users to manipulate data with calculations to show insights, make visualizations interactive, and perform statistical analysis. This gives users the ability to create and share data driven insights with peers, executives, and clients. Prerequisites Tableau Desktop: Part 1 Lesson 1: Blending Data from Multiple Sources Topic A: Blend Data Topic B: Refine Blends to Visualize Key Information Lesson 2: Joining Data Topic A: Create Joins Topic B: Troubleshoot Joins Topic C: Merge Data with Unions Lesson 3: Accessing Data in PDFs Topic A: Connect to PDFs Topic B: Clean Up and Organize PDF Data Lesson 4: Refining Visualizations with Sets and Parameters Topic A: Create Sets Topic B: Analyze Data with Sets Topic C: Apply Parameters to Refine Visualizations Topic D: Create Advanced Visualizations Lesson 5: Analyzing Data with Calculations Topic A: Create Calculated Fields to Analyze Data Topic B: Manipulate Data with Functions Topic C: Analyze Data with Table Calculations Lesson 6: Visualizing Data with Advanced Calculations Topic A: Create Groups and Bins with Calculations Topic B: Analyze Data with LOD Expressions Lesson 7: Performing Statistical Analysis and Forecasting Topic A: Perform Statistical Analysis Topic B: Forecast Data Trends Lesson 8: Creating Geographic Visualizations Topic A: Create Maps Topic B: Customize Mapped Data Lesson 9: Getting Answers with Ask and Explain Topic A: Ask Data Topic B: Explain Data Additional course details: Nexus Humans Tableau Desktop - Part 2 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Tableau Desktop - Part 2 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours Overview This program is designed to provide you with the knowledge and skills necessary to: Build a solid foundation in human resource management. Discuss key pieces of federal legislation that impact HR. Understand the role of the EEOC and its investigatory process. Improve your employee recruitment and selection process to help avoid legal pitfalls. Understand the importance of effectively communicating base pay, incentive compensation, and benefits information to staff at all levels. Gain knowledge of employee orientation, onboarding, and training and development. Learn the process, methods and purpose of performance appraisals. Gain the critical knowledge necessary to help reduce costs, avoid potential lawsuits, and improve your ability to handle challenging HR issues. This program is ideal if you are just starting out in the HR profession. 1 - HUMAN RESOURCE MANAGEMENT The HR profession Strategic and human resource planning 2 - EMPLOYMENT LAW Federal CEO legislation The EEOC and affirmative action Compensation legislation Other federal 3 - RECRUITMENT AND SELECTION Recruiting The selection process Evaluating applicants 4 - COMPENSATION AND BENEFITS Total compensation Pay increases and incentives Compensation system design Benefits overview 5 - EMPLOYEE DEVELOPMENT Orientation, training, and development Training program design Training evaluation 6 - PERFORMANCE MANAGEMENT Performance management systems Performance appraisal process Disciplinary action Termination Additional course details: Nexus Humans SHRM Essentials of HR Management training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SHRM Essentials of HR Management course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

AgilePM® Practitioner: In-House Training This course offers preparation for the Practitioner-level examination to gain the APMG-International™ / Agile Project Management Practitioner Certification. Agile Project Management (AgilePM) is the result of collaboration between APMG-International and The DSDM Consortium. DSDM (Dynamic Systems Development Method) is the longest-established Agile method, launched in 1995, and is the only Agile method to focus on the management of Agile projects. The method has evolved over the years and the DSDM Agile Project Framework is the latest version of which AgilePM is a subset. DSDM has always operated predominantly in the corporate environment and has consistently demonstrated its ability to successfully work with and complement existing corporate processes. APMG-International is a global Examination Institute accredited by The APM Group Ltd. It is one of the Examination Institutes accredited by AXELOS. APMG-International has regional offices located in Australia, China, Denmark, Germany, the Netherlands, Malaysia, the United States, and the United Kingdom. Their portfolio of qualifications includes the Best Practice qualifications of ITIL®, PRINCE2®, MSP®, M_o_R®, and P3O®. AgilePM is one of their specialist management qualifications, which also include Change Management and Service Catalogue. The course covers all the Practitioner elements of the AgilePM Handbook v2 with: Clear explanations of the method and practical examples provided by your course tutor Sample exam paper for the Practitioner-level exams to enrich your knowledge and understanding A case study to allow you to practice the application of the method to an agile project The Traditional Classroom option includes the Practitioner exam to provide you with the right opportunity to verify your new skill set by way of a professional qualification The Virtual Classroom option includes a Practitioner exam voucher to allow you to choose the date and time of your online exam to verify your new skill set by way of a professional qualification What You Will Learn You will learn how to: Identify and apply the concepts, tools, and techniques described in Section 2 (Digging Deeper) of the APMG-International's Agile Project Management Handbook (v2.0) to agile projects Tailor and customize AgilePM to suit the needs of different projects Use AgilePM in conjunction with other project management methods such as PRINCE2® Prepare yourself for the Practitioner exam in AgilePM Roles and Responsibilities - The PM View The roles Key project manager relationships Agile Project Management - Through the Lifecycle The DSDM process and the project lifecycle Project management focus phase by phase The Effective Use of Products The products Deliver on Time - Combining MoSCoW & Timeboxing Ensuring effective prioritisation Bringing MoSCoW and timeboxing together People, Teams, and Interactions Effective communication Collaboration Requirements and User Stories What is a requirement? User stories Estimating - How and When Coping with uncertainty Estimating through the lifecycle Project Planning through the Lifecycle Planning in a DSDM project Planning activities phase by phase Quality - Never Compromise Quality What do we mean by quality? Solution and process quality Risk Management Project risk How DSDM helps mitigate project risk Tailoring the Approach The project approach questionnaire Summary and Next Steps

  A CMS provides organizations a structured approach to meet all compliance obligations, i.e., requirements that they mandatorily have to comply with such as laws, regulations, court rulings, permits, licenses, as well as those that they voluntarily choose to comply with such as internal policies and procedures, codes of conduct, standards, and agreements with communities or NGOs.  About This Course   The benefits of implementing a compliance management system (CMS) based on ISO 37301 are manifold: helping the organization avoid or mitigate the costs, risks, and damage of noncompliance, ensuring the long-term sustainability of the organization, promoting trust and confidence, encouraging good governance practices, due diligence, and ethically sound business dealings, etc.  The ISO 37301 Lead Implementer training course provides the knowledge needed to establish, implement, manage, maintain, and continually improve a CMS. It aims to provide an in-depth understanding of ISO 37301 requirements, as well as the best practices and approaches used for the implementation and subsequent maintenance of the compliance management system. The training course enables you to help organizations establish processes needed to adhere to all compliance obligations and establish controls that proactively prevent noncompliance and contribute to the creation of a culture of integrity, transparency, and openness. The training course is followed by the certification exam. If you pass, you gain the 'Certified ISO 37301 Lead Implementer' credential. This credential validates your professional capabilities and competences to implement a CMS in an organization based on the requirements of ISO 37301. This training course will help you: Gain a comprehensive understanding of the concepts, approaches, methods, and techniques used for the implementation and effective management of a CMS Acknowledge the correlation between ISO 37301 and other standards and regulatory frameworks Gain the ability to interpret the requirements of ISO 37301 in the specific context of an organization Develop the necessary knowledge and expertise to support an organization in effectively planning, implementing, managing, monitoring, and maintaining a CMS Acquire the expertise to advise an organization in implementing CMS best practices Assessment     Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 12 question, essay type exam on Day 4 of the course. The overall passing score is 70%, to be achieved within the 150 minute time allowance. Exam results are provided within 24 hours, with both a Certificate and a digital badge provided as proof of success.     Prerequisites   The main requirements for participating in this training course are a basic knowledge of ISO management system standards, as well as a general understanding of ISO 37301 (or ISO 19600 guidelines) and the MS implementation principles. What's Included?   Certification fees are included in the exam price. Training material of over 450 pages of information and practical examples will be provided. An attestation of course completion worth 31 CPD (Continuing Professional Development) credits will be issued to participants who have attended the training course. In case of exam failure, candidates can retake the exam once for free within 12 months following the initial exam date. Who Should Attend?   Managers, consultants, and compliance officers wishing to develop a thorough understanding of ISO 37301 requirements for a compliance management system Managers and consultants seeking a comprehensive CMS implementation framework Compliance officers responsible for practicing due diligence with regard to compliance risks Individuals wishing to contribute in maintaining organizational integrity by supporting ethical behaviour Managers and members of governance, risk management, and compliance teams Individuals aspiring to become compliance officers or compliance management consultant Accreditation Provided by   This course is Accredited by NACS and Administered by the IECB

Learn how to work with data using Python (the coding language) as a tool. Learn how data is structured and how to manipulate it into a usable, clean form ready for analysis. Work on a small real-life project from conception to solution, in a team or on your own.

HACCP Level 2 Training Courses for Food and Drink Manufacturers and Caterers. Special Offer

  Delivered in either Live Online (4 days) or in our Classroom (5 days), the ISO/IEC 27005 Lead Risk Manager training enables you to acquire the necessary expertise to support an organization in the risk management process related to all assets of relevance for Information Security using the ISO 27005 standard as a reference framework. During this training course, you will gain a comprehensive knowledge of a process model for designing and developing an Information Security Risk Management program. The training will also contain a thorough understanding of best practices of risk assessment methods such as OCTAVE, EBIOS, MEHARI and harmonized TRA. This training course supports the implementation process of the ISMS framework presented in the ISO/IEC 27001 standard. About This Course   After mastering all the necessary concepts of Information Security Risk Management based on ISO/IEC 27005, you can sit for the exam and gain the "Certified ISO/IEC 27005 Lead Risk Manager' credential. By holding this credential, you will be able to demonstrate that you have the practical knowledge and professional capabilities to support and lead a team in managing Information Security Risks.   Learning objectives Master the concepts, approaches, methods and techniques that enable an effective risk management process based on ISO/IEC 27005 Acknowledge the correlation between Information Security risk management and security controls Learn how to interpret the requirements of ISO/IEC 27001 in Information Security Risk Management Acquire the competence and skills to effectively advise organizations on Information Security Risk Management best practices Acquire the knowledge necessary for the implementation, management and maintenance of an ongoing risk management program Educational approach This training is based on both theory and best practices used in Information Security Risk Management Lecture sessions are illustrated with examples based on cases studies Practical exercises are based on a case study which includes role playing and discussions Practice tests are similar to the Certification Exam Who Should Attend?   Information Security risk managers Information Security team members Individuals responsible for Information Security, compliance, and risk within an organization Individuals implementing ISO/IEC 27001, seeking to comply with ISO/IEC 27001 or individuals who are involved in a risk management program IT consultants IT professionals Information Security officers Privacy officers What's Included?   Official Course Slide decks Candidate pack Exam fees Prerequisites   A foundational understanding of ISO/IEC 27005 and knowledge of Risk Assessment and Information Security. Our Guarantee     We are an approved IECB Training Partner. You can learn wherever and whenever you want with our robust classroom and interactive online training courses. Our courses are taught by qualified practitioners with commercial experience. We strive to give our delegates the hands-on experience. Our courses are all-inclusive with no hidden extras.  The one-off cost covers the training, all course materials, and exam voucher. Our aim: To achieve a 100% first time pass rate on all our instructor-led courses. Our Promise: Pass first time or 'train' again for FREE. *FREE training and exam retake offered Accreditation Assessment   The exam for this course is a 12 question essay type. The pass mark is 70% and should be achieved within the allotted 150 minute exam timeframe. Exam results are provided within 24 hours. Provided by   This course is Accredited by NACSand Administered by the IECB

Level 2 HACCP RSPH Training Course

AgilePM® Practitioner: Virtual In-House Training This course offers preparation for the Practitioner-level examination to gain the APMG-International™ / Agile Project Management Practitioner Certification. Agile Project Management (AgilePM) is the result of collaboration between APMG-International and The DSDM Consortium. DSDM (Dynamic Systems Development Method) is the longest-established Agile method, launched in 1995, and is the only Agile method to focus on the management of Agile projects. The method has evolved over the years and the DSDM Agile Project Framework is the latest version of which AgilePM is a subset. DSDM has always operated predominantly in the corporate environment and has consistently demonstrated its ability to successfully work with and complement existing corporate processes. APMG-International is a global Examination Institute accredited by The APM Group Ltd. It is one of the Examination Institutes accredited by AXELOS. APMG-International has regional offices located in Australia, China, Denmark, Germany, the Netherlands, Malaysia, the United States, and the United Kingdom. Their portfolio of qualifications includes the Best Practice qualifications of ITIL®, PRINCE2®, MSP®, M_o_R®, and P3O®. AgilePM is one of their specialist management qualifications, which also include Change Management and Service Catalogue. The course covers all the Practitioner elements of the AgilePM Handbook v2 with: Clear explanations of the method and practical examples provided by your course tutor Sample exam paper for the Practitioner-level exams to enrich your knowledge and understanding A case study to allow you to practice the application of the method to an agile project The Traditional Classroom option includes the Practitioner exam to provide you with the right opportunity to verify your new skill set by way of a professional qualification The Virtual Classroom option includes a Practitioner exam voucher to allow you to choose the date and time of your online exam to verify your new skill set by way of a professional qualification What You Will Learn You will learn how to: Identify and apply the concepts, tools, and techniques described in Section 2 (Digging Deeper) of the APMG-International's Agile Project Management Handbook (v2.0) to agile projects Tailor and customize AgilePM to suit the needs of different projects Use AgilePM in conjunction with other project management methods such as PRINCE2® Prepare yourself for the Practitioner exam in AgilePM Roles and Responsibilities - The PM View The roles Key project manager relationships Agile Project Management - Through the Lifecycle The DSDM process and the project lifecycle Project management focus phase by phase The Effective Use of Products The products Deliver on Time - Combining MoSCoW & Timeboxing Ensuring effective prioritisation Bringing MoSCoW and timeboxing together People, Teams, and Interactions Effective communication Collaboration Requirements and User Stories What is a requirement? User stories Estimating - How and When Coping with uncertainty Estimating through the lifecycle Project Planning through the Lifecycle Planning in a DSDM project Planning activities phase by phase Quality - Never Compromise Quality What do we mean by quality? Solution and process quality Risk Management Project risk How DSDM helps mitigate project risk Tailoring the Approach The project approach questionnaire Summary and Next Steps