17731 Courses in Cardiff delivered Online

Learning Objectives Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion   Pre-Requisites Intermediate Microsoft Excel training or equivalent experience is recommended.   Description This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code. Course Introduction Introduction 00:03:00 Section 01 Lesson 1-Adding the Developer Toolbar 00:05:00 Lesson 2-Understanding the VBA Editor 00:11:00 Lesson 3-Recording a Macro in Personal 00:10:00 Lesson 4-Understanding the Elements of the VBA Language 00:07:00 Lesson 5-Understanding Methods 00:05:00 Lesson 6-Understanding Comments 00:06:00 Lesson 7-Working with the Range Property and Worksheet Object 00:07:00 Lesson 8-Adding a Macro Button to a Spreadsheet 00:03:00 Lesson 9-Working with the ActiveCell Object 00:02:00 Lesson 10-Working with the Offset Property 00:08:00 Section 02 Lesson 1-Understanding Variables 00:07:00 Lesson 2-Working with Integer Variables 00:03:00 Lesson 3-Understanding Option Explicit 00:05:00 Lesson 4-Working with Other Variable Types 00:07:00 Section 03 Lesson 1-Working with IF Statements 00:04:00 Lesson 2-Working with ELSE 00:03:00 Lesson 3-Working with ELSEIF 00:03:00 Lesson 4-Understanding Conditional Operators 00:06:00 Lesson 5-Working with NOT, AND, and OR 00:07:00 Lesson 6-Working with Nested IF 00:04:00 Lesson 7-Working with Select Case 00:06:00 Lesson 8-Working with WITH and END WITH 00:05:00 Section 04 Lesson 1-Working with Text Strings 00:05:00 Lesson 2-Working with LCASE and UCASE Functions 00:05:00 Lesson 3-Working with LEN and TRIM Functions 00:07:00 Lesson 4-Working with LEFT, RIGHT, and MID Functions 00:07:00 Section 05 Lesson 1-Understanding Loops 00:02:00 Lesson 2-Working with For Next Loops 00:07:00 Lesson 3-Working with For Each Loops 00:06:00 Lesson 4-Working with Cells Property 00:08:00 Lesson 5-Working with Do Until Loops 00:09:00 Lesson 6-Working with Do While Loops 00:05:00 Section 06 Lesson 1-Calling Sub Procedures 00:05:00 Lesson 2-Working with Exit Sub 00:04:00 Lesson 3-Working with Message Boxes 00:08:00 Lesson 4-Working with Input Boxes 00:08:00 Lesson 5-Working with VBA Functions 00:12:00 Lesson 6-Working with Object Variable and Set 00:06:00 Section 07 Lesson 1-Understanding and Creating a User Form 00:08:00 Lesson 2-Adding Controls to a User Form 00:16:00 Lesson 3-Adding Code for a User Form 00:10:00 Lesson 4-Launching a User Form from Excel 00:05:00 Section 08 Lesson 1-Getting Started with Debugging 00:10:00 Lesson 2-Stepping Through Your Code 00:06:00 Lesson 3-Working with Breakpoints 00:03:00 Lesson 4-Working with the Immediate Window 00:05:00 Lesson 5-Working with the Locals Window 00:05:00 Lesson 6-Working with the Err Object 00:06:00 Lesson 7-Getting Help-v2 00:07:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 VBA Expert 00:00:00 Final Exam Final Exam - Excel 365 VBA Expert 00:20:00

Overview This comprehensive course on HTML and CSS Coding: Beginner to Advanced will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This HTML and CSS Coding: Beginner to Advanced comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this HTML and CSS Coding: Beginner to Advanced. It is available to all students, of all academic backgrounds. Requirements Our HTML and CSS Coding: Beginner to Advanced is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 127 lectures • 11:50:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:07:00 •How to Get Course requirements: 00:02:00 •Getting Started on Windows, Linux or Mac: 00:02:00 •How to ask a Great Questions: 00:01:00 •FAQ's: 00:01:00 •Introduction: 00:05:00 •Choosing Code Editor: 00:06:00 •Installing Code Editor (Sublime Text): 00:04:00 •Overview of a Webpage: 00:05:00 •Full HTML Code Page: 00:07:00 •First Hello World! Webpage: 00:09:00 •Introduction: 00:03:00 •Heading: 00:09:00 •Paragraph: 00:08:00 •Formatting Text: 00:12:00 •List Items Unordered: 00:05:00 •List Items Ordered: 00:04:00 •Classes: 00:09:00 •ID's in CSS: 00:06:00 •Comments in HTML: 00:04:00 •Summary: 00:04:00 •Introduction: 00:02:00 •Images: 00:12:00 •Forms: 00:05:00 •Form Actions: 00:04:00 •Br tag: 00:03:00 •Marquee: 00:06:00 •Text area: 00:06:00 •Tables: 00:06:00 •Links: 00:07:00 •Navbar - Menu: 00:04:00 •HTML Entities: 00:05:00 •Div tag: 00:06:00 •Google Maps: 00:07:00 •Summary: 00:02:00 •Introduction: 00:02:00 •HTML5 Audio: 00:07:00 •HTML5 Video: 00:05:00 •Progress Bar: 00:04:00 •Drag and Drop: 00:18:00 •Canvas: 00:06:00 •I frames: 00:05:00 •Input Types: 00:04:00 •Input Attributes: 00:06:00 •YouTube Video Linking: 00:04:00 •Creating Responsive Page: 00:05:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Registration Form: 00:04:00 •Login Form: 00:04:00 •About Us Form: 00:02:00 •Contact Us Form: 00:10:00 •Footer Form: 00:03:00 •Integrate All Together: 00:07:00 •Coding Exercise: 00:01:00 •Solution for Coding Exercise: 00:02:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Challenge - HTML 5 Clock Face with Numbers: 00:05:00 •Project overview: 00:03:00 •Conclusion on Project: 00:01:00 •Summary: 00:02:00 •Introduction: 00:03:00 •CSS Syntax: 00:05:00 •Creating a first page with CSS Style: 00:13:00 •Inline CSS: 00:06:00 •Internal CSS: 00:05:00 •CSS External: 00:10:00 •CSS Classes: 00:09:00 •CSS IDs: 00:06:00 •Colors: 00:08:00 •Backgrounds: 00:04:00 •Floating: 00:09:00 •Positioning: 00:06:00 •Margins: 00:07:00 •Padding: 00:04:00 •Borders: 00:03:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Styling Text: 00:07:00 •Aligning Text: 00:04:00 •Styling Links: 00:10:00 •Font Family: 00:07:00 •Font Styles: 00:03:00 •Applying Google Fonts: 00:07:00 •Box Model: 00:09:00 •Icons: 00:09:00 •Tables: 00:16:00 •Navigation-Menu: 00:11:00 •Dropdowns: 00:15:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Advanced Selectors: 00:05:00 •Forms: 00:17:00 •Website Layout: 00:21:00 •Rounded Corners: 00:08:00 •Color Keywords: 00:06:00 •Animations: 00:08:00 •Pseudo Classes: 00:03:00 •Gradients: 00:03:00 •Shadows: 00:03:00 •Calculations: 00:05:00 •Creating Responsive Page: 00:06:00 •Summary: 00:02:00 •Introduction: 00:01:00 •Button Styles: 00:06:00 •Flexbox: 00:14:00 •CSS Grid: 00:15:00 •Pagination: 00:07:00 •Multiple Columns: 00:06:00 •Image Reflection: 00:03:00 •UI - UX Design: 00:09:00 •Social Media Icons: 00:08:00 •External CSS Style adding: 00:06:00 •Coding Exercise: 00:01:00 •Solution for Coding Exercise: 00:03:00 •Summary: 00:02:00 •Introduction: 00:01:00 •CSS Project Getting: 00:05:00 •CSS Project Overview: 00:08:00 •Summary: 00:01:00 •Introduction: 00:02:00 •Installing Free FTP Solution (FileZilla): 00:04:00 •Setting Up FTP (File Transfer Protocol): 00:03:00 •Publish Website to Hosting Server: 00:04:00 •Summary: 00:01:00

The COLP role goes beyond just ensuring your firm follows the rules in the SRA Standards and Regulations, it also comes with a personal accountability factor that demands your attention. Fear not! This 3 hour course will usher you through the intricacies of being a COLP, ensuring you not only meet but excel in your regulatory obligations.  The course will cover: Navigating the Regulatory Landscape: Understanding the Framework for COLPs Dive into the intricate regulatory framework that Compliance Officers for Legal Practice (COLPs) operate under. Shouldering the Responsibility: Unpacking the Duties of a COLP Explore the multifaceted responsibilities that come with the role of a COLP. Choosing the Right Leader: Identifying the Ideal COLP Candidate Learn the criteria for selecting the most suitable individual to take on the crucial role of COLP. Cracking the Codes: Key Elements of Codes and SRA Principles Delve into the essential components of the Codes and SRA Principles that form the backbone of legal compliance. Building a Robust Foundation: Understanding Compliance Systems for All Firms Explore the concept of compliance systems, what they entail, and why every firm should have one in place. Reporting Matters: Recognising 'Serious' Issues, SRA Enforcement Strategy, and Reporting Protocols Uncover the definition of 'serious' matters, grasp the SRA Enforcement Strategy, and gain practical insights on making effective reports to the SRA. Paper Trails Matter: Effective Record Keeping, Including Non-material Breaches Master the art of comprehensive record-keeping, including strategies for recording non-material breaches, and understand why it's integral to compliance. Personal Liability: Understanding and Mitigating Risks Navigate the landscape of personal liability for COLPs and develop strategies to mitigate associated risks. Staying Ahead: Keeping Abreast of Regulatory Changes and Guidance Develop effective strategies for staying up to date with dynamic regulatory changes and evolving guidance. Planning for Compliance: Crafting a Robust Strategy, Assessing Risk, and File Reviewing Formulate a comprehensive plan for tackling compliance, including risk assessment, maintaining risk registers, and implementing effective file reviewing. Across the Board: Legal and Regulatory Compliance Areas Every COLP Must Master Gain a high-level overview of crucial legal and regulatory compliance areas, including AML, transparency rules, and other pivotal aspects that demand the attention of all COLPs. Target Audience This online course is suitable for those new to the COLP role, or those supporting the COLP and for those that would like a refresher of the role and their responsibilities. Resources Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Helen Torresi, Consultant, DG Legal Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services. Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! This Diploma in Data Entry Administrator at QLS Level 3 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! In today's data-driven world, efficient data management is more crucial than ever. Our comprehensive Data Entry course offers an in-depth understanding of the most relevant tools and techniques to streamline your data entry tasks. From mastering the basics to leveraging powerful tools like Excel, Flash Fill, and Autofill, this course equips you with everything you need to increase your productivity and boost your career prospects. With a strong emphasis on practical application, each module of this course is designed to help you tackle real-world challenges faced by data entry professionals. Learn how to create a data entry form in Excel and explore the use of statistics packages to improve your overall data entry skills. This course provides a solid foundation to enhance your marketability in the competitive job market. Learning Outcomes: Gain an understanding of the data entry process and its importance. Develop competence in using computers for efficient data entry tasks. Learn common rules and guidelines for accurate data entry. Master the use of Excel for improved data entry efficiency. Understand the functions of Flash Fill and Autofill in automating data entry tasks. Acquire skills in creating data entry forms and using statistics packages. Why Prefer This Data Entry at QLS Level 3 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Data Entry at QLS Level 3 course: Module 1: Introduction to Data Entry Module 2: Using the Computer for Data Entry Module 3: Common Rules and Guidelines for Data Entry Module 4: Using Excel for Efficient Data Entry Module 5: Using Excel's Flash Fill and Autofill to Automate Data Entry Module 6: How to Create a Data Entry Form in Excel? Module 7: Using Statistics Packages in Data Entry Assessment Process After completing an online module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Data Entry Administrator at QLS Level 3exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is for: Individuals seeking to improve their data entry skills Professionals looking to enhance their productivity Office administrators and support staff Students exploring career options in data management Requirements No prior background or expertise is required. Career path The Data Entry at QLS Level 3 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Like as: Data Entry Clerk: £18,000 - £22,000 Administrative Assistant: £17,000 - £21,000 Office Administrator: £18,000 - £23,000 Customer Service Representative: £17,000 - £21,000 Data Analyst: £25,000 - £35,000 Document Controller: £22,000 - £28,000 Certificates CPDQS Accredited Certificate Digital certificate - Included Diploma in Data Entry Administrator at QLS Level 3 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Data Entry Administrator at QLS Level 3, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost.

Why Choose Rhinoceros 3D Night Training Course? Learning Rhino 3D opens doors to advanced 3D modeling, making it essential for architects, designers, and engineers. Its versatility, ease of use, and powerful features make it an industry favorite for creating intricate designs, from architecture to product design. Click here for more info: Website Personalized Learning: 1-on-1 sessions tailored to your needs Flexible Timing: Convenient evening classes (5 pm - 7 pm) Mon to Sat Duration: 10 hours. Choose your own day and time Rhino 3D Training Overview Our Rhino 3D Training offers in-person or live sessions suitable for beginners and those aiming to optimize their workflow in Rhinoceros 3D. Course Highlights: Master precise free-form 3D NURBS modeling. Explore advanced surfacing commands and the Rhino interface. Develop skills in curve, surface, and solid modeling. Learn effective modeling practices for various industries, from industrial design to jewelry and graphic design. Who Should Attend? This course is perfect for individuals starting their Rhino journey or aiming to refine their modeling skills. If jewelry modeling is your focus, check out our specialized Rhino Training for Jewelry Design Course. Why Choose Us? Hands-on, instructor-led sessions with flexible scheduling (weekdays, evenings, or weekends from 9 am to 7 pm). Expert instruction from Rhino professionals. Real-time practice with industry-aligned projects. Comprehensive electronic notes and course completion certificate. Ongoing support and career advice from experienced trainers. Benefits of Rhino Training Ideal for enthusiasts in animation, modeling, NURBS curves, surfaces, or solids, Rhino Training empowers you with industry-standard skills. No prerequisites are required, ensuring accessibility for all learners. Upon completing this course, you will: Master Rhino's Interface: Gain proficiency in Rhino's commands, toolbars, and menus, enabling efficient 3D modeling. Create Complex 3D Models: Develop the skills to create intricate 3D objects using curves, surfaces, and solids with various techniques like lofts, sweeps, and revolves. Refine Modeling Techniques: Learn advanced editing methods, such as filleting, chamfering, and curve Booleans, to refine and modify objects. Navigate the 3D Space: Understand 3D navigation, viewports, and construction planes, enabling precise modeling in a virtual space. Prepare Models for Production: Master techniques for analyzing and preparing 3D models for manufacturing, prototyping, and 3D printing. Enhance Rendering and Visualization: Learn rendering techniques to create realistic visuals of your models for presentations and proofs. Job Opportunities: After completing this course, you can pursue a variety of careers, including: 3D Modeler: Create detailed 3D models for industries like gaming, animation, or virtual reality. Product Designer: Design and visualize products for manufacturing using 3D modeling software. Architectural Visualization Specialist: Develop detailed architectural models for presentations and client approvals. Industrial Designer: Design consumer products, furniture, or appliances for manufacturing companies. Jewelry Designer: Craft intricate jewelry designs with precise detailing using 3D modeling techniques. Prototyping Specialist: Work in industries like aerospace or automotive, creating prototypes for testing and development. Freelance 3D Artist: Offer your skills on platforms like Upwork or Fiverr, creating custom 3D models for clients worldwide. Rhino 3D Training Overview Our Rhino 3D Training offers in-person or live sessions suitable for beginners and those aiming to optimize their workflow in Rhinoceros 3D. Course Highlights: Master precise free-form 3D NURBS modeling. Explore advanced surfacing commands and the Rhino interface. Develop skills in curve, surface, and solid modeling. Learn effective modeling practices for various industries, from industrial design to jewelry and graphic design. Who Should Attend? This course is perfect for individuals starting their Rhino journey or aiming to refine their modeling skills. If jewelry modeling is your focus, check out our specialized Rhino Training for Jewelry Design Course. Why Choose Us? Hands-on, instructor-led sessions with flexible scheduling (weekdays, evenings, or weekends from 9 am to 7 pm). Expert instruction from Rhino professionals. Real-time practice with industry-aligned projects. Comprehensive electronic notes and course completion certificate. Ongoing support and career advice from experienced trainers. Benefits of Rhino Training Ideal for enthusiasts in animation, modeling, NURBS curves, surfaces, or solids, Rhino Training empowers you with industry-standard skills. No prerequisites are required, ensuring accessibility for all learners. Advantages: Personalized Rhino 3D Evening Training with individual attention. Flexibility to select your preferred time and day for the training. Access to free online support even after completing the course. Comprehensive PDF notes and handouts provided for effective learning. Receive a certificate upon completing the Rhino 3D Evening Training Course. Affordable pricing options tailored to your budget. Assistance in computer configuration for seamless software installation. Referral benefits: Recommend a friend and enjoy exclusive discounts. Special discounts available for group training sessions. Operating hours from Monday to Saturday, extending into the evening for convenience. Tailored training programs designed to meet your specific needs and requirements.

Spring Clean Your Qi – 2024 Eight Week Online Qigong Course For Spring Feel healthy vibrant and get your zing back for spring When: Tuesday Evenings 6-7.15pm and Thursday mornings 8-8.30am (via Zoom) All classes are recorded so you can catch up in your own time. Dates: Tuesdays 6-7.15pm: March 5th, 12th, 19th, and 26th and April 9th, 16th, 23rd and 30th Thursdays 8-8.30am: March 7th, 14th, 21st, 28th and April 11th, 25th and May 2nd Suitable for everyone no matter your experience Spring can be a tricky time for us, as our bodies are moving from the most still Yin restful time of the year to a very Yang active energy of new growth. It’s a massive about-turn for our whole energy system and it can be bumpy!  In Chinese medicine the liver is responsible for the smooth flow of Qi or energy in our body, and in the spring this liver Qi is being challenged, as we come out of the winter stillness it can take a while for us to feel lively and able to take on the new challenges. If our Liver Qi is struggling it can leave us feeling grumpy, irritated and restless, with headaches and brain fog, we may have sore, dry or itchy eyes and tired stiff achey joints. During this course we will use Qigong exercises, meditations, sounds and breath practices, to help bring us into our healthy balance, giving our liver the support it needs so we can move from Winter to Spring, feeling healthy and vibrant and ready to take on the new.  Together we will learn “The Eight Brocades” a simple and easy to practice Qigong form you can use every day to improve your energy and feel great. “The Eight Brocades” is one of the most popular Qigong practices dating back nearly 1000 years in China. it is made up of eight Qigong movements, each opening different meridian or energy pathways in the body, to release fatigue and harness our healthy Qi. Benefits include improved energy, vitality, bone density, strength, flexibility, balance, coordination, and longevity to name a few. Also, a great practice for reducing blood pressure, cancer support, thyroid issues, back pain, arthritis, and more. What is included:  Eight live 75min evening zoom classes Eight live 30min morning WAKE UP YOUR QI classes on zoom Access to replays of all classes so you can catch up in your own time. Learn “The Eight Brocades” A simple and powerful Qigong form to help you feel amazing Weekly supporting material for home practice including: – 10min video Guided Qigong Practice – Learn how to clear meridian pathways in the body for greater balance – Key acupuncture points for self massage – Weekly nutrition tips for a healthy spring body cleanse What will i get out of this course? Reconnect with your body Clear your mind A healthy detox for your organs Increased flexibility for all your joints Improved circulation Healthy hormonal balance Clear vision – bright eyes Better sleep Reduced pain Improved mood More energy Less stress

This course includes all of the tools you'll need to be successful with cryptocurrencies, and it's all based on real-world experience and knowledge rather than theory.

There are quite a few issues with manual memory management. Therefore, to avoid memory leaks and optimally use your memory, automatic memory management is essential. In this course, we'll learn about garbage collection as a form of automatic memory management.

What is dance psycholgy? Why does it matter? And what you as a dancer, dance teacher should defintely know about it to better improve mental well-being? All these questions will be answered in this workshop who will introduce you to dance psychology and its key aspects. The workshop will be recorded for those who cannot attend.

This one day online course will assist candidates in preparing for the forthcoming initial Senior Caseworker exam.