48818 Courses in Cardiff delivered Online

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Miss Date Doctor’s Conflict Resolution coaching is designed to help couples and individuals navigate conflicts in a healthy and constructive way. Our coaching provides you with the tools and techniques needed to resolve conflicts without damaging your relationship or emotional well-being. We understand that conflicts can arise in any relationship, and that dealing with them effectively is key to building stronger, more fulfilling relationships. Our Conflict Resolution coaching can help you develop skills such as active listening, empathy building, and problem-solving, as well as techniques to de-escalate tense situations and prevent conflicts from becoming destructive. Our coaching also includes strategies for preventing conflicts from arising in the first place, such as setting clear boundaries, communicating effectively, and building healthy habits. With our Conflict Resolution coaching, you can learn to navigate conflicts in a way that strengthens your relationship and helps you build a brighter future together. The Miss Date Doctor Conflict Resolution Package helps with the following: Relationship Conflict, Conflict Resolution Techniques, Conflict Management, Active Listening, Empathy Building, Problem-Solving, De-escalation, Preventing Conflicts, Healthy Habits, Clear Boundaries, Communication, Conflict Resolution Coaching, Conflict Resolution Skills. https://relationshipsmdd.com/product/conflict-resolution-package/

The Computing Technology Industry Association (CompTIA) is the association representing the international technology community. Its goal is to provide a unified voice, global advocacy and leadership, and to advance industry growth through standards, professional competence, and education and business solutions. In order to most efficiently serve the industry and its members, CompTIA has developed specialized initiatives and programs dedicated to major areas within the IT industry. They include, convergence technology, e-commerce, IT training, software services, certification, public policy and workforce development.

This course will help you find remedies to a lack of new business or a lack of property sales etc etc

EFQM Certified Model Foundation Course The EFQM Foundation course will help you to benchmark and improve the performance of every organisation by using the new EFQM Model and RADAR diagnostic tool, version 2025! This is a two-day online course, delivered via a mix of work-rooms, presentations, videos, and one-to-one support. This course is credited as part of the admission to the EFQM Assessor, Performance Improvement Practitioner or Excellence Practitioner courses. Who is the EFQM Certified Model Foundation course for? This is the essential course for anyone who wants to find out about the EFQM Model and RADAR and how these tools can benefit an organisation. This course is suitable for anyone who wants to understand the new EFQM Model and how it can be used to make their organisation more effective. Whilst this training is effective as a stand-alone course, it is also a pre-requisite for anyone considering one of the EFQM qualification routes as a way of progressing their management development and career. At the end of the course, you will be able to: - demonstrate how the EFQM Model could benefit your organisation and how it could be used to overcome current and future challenges - explain how the Model is structured and how the different elements apply to your organisation - start applying the RADAR as both a diagnostic tool - to identify strengths and areas for improvement – and a performance improvement methodology - conduct a high-level self-assessment of your organisation - understand the opportunities provided by EFQM data and insights - gain an insight into the alternative uses of the EFQM Model The EFQM Foundation Course Training Programme Following the welcome and introduction, this course comprises of 9 modules: Module 0: Welcome & course objectives Module 1: Why we need a model to face & master complexity? Why the EFQM Model? Module 2: Introduction to the EFQM Model Module 3: The Model (part 1): Direction Module 4:The Model (part 2): Execution Module 5: The Model (part 3): Results Module 6: RADAR Module 7: Assessment Module 8: Data & Insights Module 9: Next steps Delivery The course is delivered through a virtual trainer led live class Cost £800 + VAT If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here.

Earn up to 90k as a 'Network Engineer' or Your 100% Money Back Network outages cost UK businesses £100 billion annually. With over 50,000 open network engineer jobs paying £54,000 per year on average, skilled professionals are in high demand. Do you have what it takes to design, build, and protect company infrastructure? This Network Engineer Job Guarantee Programme is your all-in-one solution to learn networking skills from scratch and also secure a job in this exciting industry. With our unique blend of comprehensive courses and career support, your dream job is within reach. We understand the challenges of transitioning into a new field, which is why our program is tailored to guide you every step of the way - from mastering core skills to landing your first job as a Network Engineer. By choosing our Network Engineer Job Guarantee Programme, you're not just gaining skills; you're gaining a lifelong career partner. Our mission is simple - to be your trusted partner every step of the way, from training to employment. In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Programmers, so we can help you get your foot in the door. If you are not happy with our service, we also offer a 100% money-back guarantee. So what are you waiting for? Enrol in our Network Engineer Job Guarantee Programme today and start your journey to becoming a successful Network Engineer! Why Choose Us? So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Certified Network Engineer Programme: Personalised Guidance: We believe in the power of individual attention. Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some Network Engineering experience, we will guide you towards honing your skills and developing a strong foundation in Network Engineering. One-On-One Consultation: Gain invaluable insights and guidance from seasoned professionals who have thrived in the Network Engineering field. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and expertise. Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking Certified Network Engineers. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere. Interview Preparation: No more stress over unexpected interview questions. We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress. Courses we will provide once you enrol in the program: Course 01: Network Security Level 2 Course 02: IGCSE ICT: Network Essentials Course 03: Computer Networks Security Course 04: CompTIA Networking Course 05: AWS Certified Cloud Practitioner Course 06: IT Support Technician Course 07: CompTIA A+ (220-1001) Course 08: CompTIA Network (N10-007) Course 09: CompTIA A+ (220-1002) Course 10: CompTIA IT Fundamentals ITF+ (FCO-U61) Course 11: CompTIA PenTest+ (Ethical Hacking) Course 12: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 13: Cisco ASA Firewall Training Course 14: CompTIA Network+ Certification Course 15: Penetration Testing with OWASP ZAP: Mastery course Course 16: GDPR Data Protection Course 17: Data Center Training Essentials: Mechanical & Cooling Course 18: Cyber Security Awareness Training How Can We Offer Job Guarantees? HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector. The is completed in 9 easy steps: Step 1: Enrol in the Programme Begin your exciting journey with us by enrolling in the Network Engineer Job Guarantee Programme. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied. After you enrol in the Program, you will get lifetime access to 18 Premium Courses related to Network Engineering. These courses will teach you the knowledge and skills required to become a successful Network Engineer. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about anything! Step 2: Initial One-On-One Counselling Session Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path. Step 3 - Certification upon Course Completion After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject. Step 4: CV Revamping Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the programming/development industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently. Step 5: Building Network and Submitting CV We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile. Step 6: Interview Preparation With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills. Step 7: Securing Job Interviews Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want. Step 8: Post-Interview Support Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job. Step 9: Celebrate Your New Job! Once you've secured your dream job in Network Engineering, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role. We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful career in Network Engineering begins with us. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Network Engineering Course is suitable for: Beginners with no prior programming experience who are looking to enter the world of coding. Intermediate programmers who wish to expand their skills and explore Network Engineering's extensive usage. IT professionals seeking to diversify their skill sets and stay relevant in today's tech-driven market. Data analysts and scientists who want to leverage Network Engineering's powerful libraries for their data processing needs. Students and recent graduates looking to enhance their employability in the thriving tech industry. Entrepreneurs who wish to understand and utilise Network Engineering to automate tasks and analyse data for their businesses. Anyone with a keen interest in Network Engineering and a desire to delve into its applications in diverse fields like web development, data science, machine learning, and more. Requirements No experience required. Just enrol & start learning. Career path Network Engineer: £30,000 - £70,000 annually Network Security Analyst: £35,000 - £85,000 annually Cloud Solutions Architect: £40,000 - £100,000 annually IT Support Specialist: £25,000 - £55,000 annually Cyber Security Consultant: £40,000 - £90,000 annually Systems Administrator: £30,000 - £75,000 annually Penetration Tester: £35,000 - £95,000 annually Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Framed (Hardcopy) Certificate Hard copy certificate - Included Enrolment Letter Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included Student ID Card Digital certificate - Included

Project Stakeholder Relationship Skills (Virtual) This course is designed to provide project managers with the ability to: Analyze the complexities of major stakeholder relationship categories Apply the most appropriate interpersonal relationship skills to the different categories of relationships Align the dynamic needs of the stakeholders with a project's objective throughout the project life cycle What You Will Learn At the end of this program, you will be able to: Gain a deep understanding of the Scrum Framework - the theory, practices, roles, rules, and values - as defined in The Scrum Guide Understand, in detail, the role of Scrum Master, and how the role interacts with different members of the Scrum Team and other stakeholders Master the Scrum principles to better understand their application when returning to the workplace Understand how to construct an effective development team with an appropriate mix of skills and experience Know how to act as a servant-leader for the Scrum Team, promoting and enabling self-organization to create high-value products. Learn how to facilitate Scrum Events and remove impediments to the Scrum Team's progress Help Scrum Product Owners shape and refine product backlogs to guide early and incremental delivery of valuable products Drive adoption of the Scrum framework for more effective product and solution development, working with stakeholders and other Scrum Masters to improve its effectiveness Foundation Concepts Stakeholders and project success Stakeholder management research Managing stakeholder relationships Identifying Stakeholders Stakeholder categories Stakeholder relationships across the project life cycle Tools and techniques for identifying stakeholders Assessing Stakeholders Assessing stakeholder relationships Recognizing stakeholder attitudes toward the project Analyzing stakeholders Using other types of stakeholder assessments Building Stakeholder Relationships The importance of psychological safety Building trust and getting results The anatomy of trust Navigating Challenging Situations Dynamics of conflict Responding to conflict Managing difficult conversations

his course covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects.

Hatha yoga tuition in the style of shadow yoga, includes asana (yoga postures) and a meditative aspect using mantra and a focus on the breath

About this training course This highly interactive 5-day training is aimed at those who wish to take their E&P accounting skills to a more advanced level than our introductory course, E&P Accounting - Level 1, and our intermediate course, E&P Accounting - Level 2. It will help equip you for more demanding analytical roles within your organisation. Training Objectives After the completion of this training course, participants will be able to: Carry out and manage the day-to-day financial accounting activities associated with participation in E&P joint ventures Prepare, analyse and present information for effective financial reporting Understand the impact of a comprehensive range of activities on the financial statements of an upstream oil and gas company Practically apply IFRS in accounting for a wide range of typical oil and gas industry activities Target Audience This is an advanced level course designed for: those who have already attended E&P Accounting - Level 1 and E&P Accounting - Level 2, or those who can demonstrate, by a combination of relevant experience and previous study, sufficient prior knowledge to contribute and benefit from attending this workshop Course Level Advanced Training Methods Training Method - Scenario Based Learning Learning centers around highly realistic E&P company scenarios. A computer-based simulation is used to plan, record and report the progress of your company through several years of international E&P activities. Teams of 2 - 3 people participate in the financial management of these activities, including Operator and Non-operator accounting, recording of transactions, updating of financial statements and analysis of results. The highly interactive laptop-based scenario approach will enable you to follow the impact of each activity from initiation through to final results and analysis of company performance. You will need to bring with you to the course your own laptop PC with MS Excel™ pre-installed. Prior knowledge of spreadsheet techniques is assumed. Trainer will provide various Excel files which participants may retain at the end of the course. Course Duration: 5 days in total (35 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 25. Trainer Your expert course leader has more than 30 years of experience in the international oil and gas industry, covering all areas of Finance and Audit, including involvement in Commercial roles. During her 19 years with ENI she worked in Italy, Netherlands, Egypt and UK and was CFO for 2 major ENI subsidiaries. She has delivered training courses in Accounting, Audit, Economics and Commercial topics in many Countries. She has a Degree in Economics & Accounting and is a Certified Chartered Accountant. She is also a Chartered Auditor and an International Petroleum Negotiator. Outside of work, she is inspired by the beauty of nature and art, helping disadvantaged people, sports (football, golf) and her cat. Courses Delivered Internationally: E&P Accounting, Auditing in the Oil & Gas Industry Cost Control & Budgeting Introduction to the Oil & Gas Industry Petroleum Project Economics Contracts Strategy International O&G Exploitation Contracts POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations