16972 Basic courses in Cardiff delivered On Demand

🚀 Unlock the Power of Microsoft Excel with Our Excel VBA Programming Training Course! 📊 Are you ready to take your Excel skills to the next level? Dive deep into the world of Excel VBA programming and unleash the full potential of this powerful tool! Our comprehensive online course, 'Microsoft Excel VBA Programming Training,' is designed to equip you with the expertise needed to automate tasks, streamline processes, and boost productivity within Excel. Here's what you'll learn in this dynamic course: 📌 Section 1: Introduction Get acquainted with the fundamentals of Excel VBA programming. Understand its significance and explore the vast possibilities it offers to transform your Excel experience. 📌 Section 2: Macros Master the art of creating and executing macros to automate repetitive tasks and significantly reduce manual work. Learn to streamline your workflow like a pro! 📌 Section 3: VBA Editor Navigate the VBA Editor seamlessly. Gain proficiency in using this interface to write, edit, and debug your VBA code effectively. 📌 Section 4: Variables and Procedures Understand the concept of variables and procedures in VBA. Learn how to declare, assign, and utilize them efficiently to optimize your coding process. 📌 Section 5: Loops and IF Statements Discover the power of loops and conditional IF statements. Harness these constructs to create dynamic and responsive Excel applications. 📌 Section 6: Error Handling Learn robust error-handling techniques to troubleshoot issues and create resilient VBA programs. 📌 Section 7: User Defined Functions Unlock the potential of creating custom functions tailored to your specific needs, enhancing Excel's capabilities beyond its default functions. 📌 Section 8: Assignments Apply your newfound knowledge through hands-on assignments and practical exercises to reinforce your skills. 📌 Section 9: Creating Forms Explore the creation of user-friendly forms and interfaces within Excel, making interactions more intuitive and efficient. Whether you're a beginner or have some experience in Excel, this course is tailored to suit your learning needs. With comprehensive modules, real-world examples, and expert guidance, you'll gain the confidence to create powerful VBA scripts and automate Excel operations like never before! Join us today and embark on a transformative journey in mastering Microsoft Excel VBA programming. Elevate your Excel skills and become a proficient VBA programmer! Enroll now and excel in Excel VBA programming! 💡📈✨ Course Curriculum Section 1 - Introduction What is VBA 00:00 Object Orientated Programming 00:00 Section 2 - Macros Macros Initial Setup 00:00 Recording a Macro 00:00 Saving a Macro 00:00 Section 3 - VBA Editor Launching VBA 00:00 VB Editor 00:00 Custom Menu 00:00 Naming Projects 00:00 Modules 00:00 Code Window 00:00 Comments 00:00 Section 4 - Variables and Procedures Introduction 00:00 Vraibales 00:00 Variable Exercise 00:00 What are Procedures 00:00 What are Procedures - Part Two 00:00 What are Procedures - Part Three 00:00 Message Boxes 00:00 Input Box 00:00 Input Box - Part Two 00:00 Basic Navigation 00:00 Sheets 00:00 Draft LessonCell Navigation 00:00 Advanced Sheets 00:00 Offset 00:00 Section 5 - Loops and IF Statements Introduction 00:00 Operators 00:00 Using Variables 00:00 What is Automation 00:00 For Loop 00:00 Do Loops 00:00 IF Statements 00:00 IF Statements - Part Two 00:00 Select Case 00:00 Section 6 - Error Handling Debugging 00:00 Section 7 - User Defined Functions UDFs 00:00 Section 8 - Assignments Introduction 00:00 Exercise 1 - Record a Macro 00:00 Exercise 2 - Duplicating Data 00:00 Exercise 3 - Generate a Report 00:00 Generate a Report - Part Two 00:00 Exercise 4 - Inner and Outer Loops 00:00 Inner and Outer Loops - Part Two 00:00 Inner and Outer Loops - Part Three 00:00 Inner and Outer Loops - Part Four 00:00 Inner and Outer Loops - Part Five 00:00 Section 9 - Creating Forms Form Controls 00:00 Building the Form 00:00 Initialize the Form 00:00 Command Buttons 00:00 Command Buttons - Part Two 00:00

If you’re looking to start a career in JavaScript coding, but don’t know where to begin, this might be for you. This course is aimed at absolute beginners that have never done any coding before. Early on in the course, you’ll learn what coding is, what certain types of languages are used for, specifically JavaScript, and the types of careers available through learning JavaScript.

Explaining the background to Legionella and Legionnaires’ Disease, the potential risks associated with water systems and how these can be prevented or controlled.

Course Overview The Electrical Engineering & DC Circuits Basics course is ideal for those looking to kickstart a career in this field. It covers basic electrical theory and laws, the roles and responsibilities of an Electrical Engineer, and the fundamental concepts of electrical DC circuits in detail. Through this practical course, you will learn how to perform tasks such as analysing electrical circuits and making basic Ohm's calculations. It will deepen your knowledge of current, voltage and impedance, electrical fields, and other key topics. This industry-recognised qualification has been designed by industry experts, and includes both video and instructor-led guidance to ensure you get the best of your learning experience. There are no specific entry requirements for this course, which is suitable for those who are new to the industry. This best selling Electrical Engineering & DC Circuits Basics has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Electrical Engineering & DC Circuits Basics is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Electrical Engineering & DC Circuits Basics is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Electrical Engineering & DC Circuits Basics is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Electrical Engineering & DC Circuits Basics, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Electrical Engineering & DC Circuits Basics will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Electrical Engineering & DC Circuits Basics to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

This extensive course for beginners provides the basics of chatbots with machine learning, deep learning, AWS, and its applications, building it from scratch with hands-on practice for chatbot development. This course will help you learn basic to advanced mechanisms of developing chatbots using machine learning, deep learning, and AWS with Python.

This course is intended for anyone who has already undertaken basic body massage/sports massage training and would like to develop their knowledge of common injuries affecting the upper limbs which may lead clients to book a treatment, with self help measures that they can suggest to their clients. This course can also introduce students to upper limb injuries prior to undertaking a sports massage course and to gain further insight into upper injuries from a more medical viewpoint after undertaking sports massage training.

This course provides basic introductory guidance to FinTech. You will be using an easy programming language R to learn some basic statistics in money management. You will also understand how to time the stock market and build tradeable factor-based algorithms from scratch. This course provides some of the most basic rules of thumb and intuition that every successful trader should know.

10 QLS Endorsed Courses for PAT Tester | 10 Endorsed Certificates Included | Lifetime Access

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support

With a sharp focus on the scientific arena, our bundle, "Lab Technician, Chemical Spill & Biochemistry- QLS Endorsed", amalgamates a range of meticulously designed courses that aim to cultivate a proficient understanding of lab procedures, chemical safety, and biochemistry. Two of these are QLS-endorsed, a marker of quality and relevancy in the learning field, and completion of these will earn you hardcopy certificates, tangible proof of your knowledge enhancement. An additional five courses, all CPD QS accredited, further expand the horizons of learning by including topics such as Microbiology, Basic Biology, and COSHH Training for Assessors, to name a few. These subjects are meticulously intertwined, providing comprehensive exposure to different facets of science and laboratory work. The bundle is meticulously tailored to cover different elements of the scientific sphere, ensuring the learner evolves with a robust and well-rounded understanding of the field. By completing this bundle, you enhance not only your knowledge base but also your employability with recognised qualifications. ey Features of the Lab Technician, Chemical Spill & Biochemistry- QLS Endorsed Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Lab Technician, Chemical Spill & Biochemistry- QLS Endorsed bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Laboratory Technician Level 7 QLS Course 02: Chemical Spill QLS Course 03: Biochemistry 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Microbiology Course 02: Basic Biology Course 03: Level 3 Diploma in Anatomy and Physiology of Human Body Course 04: Infection Prevention Training Course 05: COSHH Training for Assessors In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Lab Technician, Chemical Spill & Biochemistry- QLS Endorsed courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Advanced understanding of laboratory operations and safety protocols. Deepened knowledge of chemical spill handling and prevention. Mastery of the principles of biochemistry. Proficient understanding of microbiological principles and techniques. Foundational knowledge in basic biology and its applications. Comprehensive grasp of human anatomy and physiology. Improved skills in infection prevention and COSHH assessment. This invigorating bundle serves as a comprehensive guide for those who aspire to elevate their competency in the field of laboratory work and biochemistry. Covering an expansive range of subjects, from the essence of human anatomy to the practicalities of infection prevention, it is a cornucopia of learning that promises a profound enhancement of your scientific understanding. Designed to equip learners with a formidable scientific knowledge base, this bundle is the ideal solution for those eager to excel in laboratory environments and biochemistry domains. It bridges the gap between theoretical understanding and practical application, seamlessly integrating different facets of science and lab work. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring lab technicians seeking comprehensive knowledge. Individuals interested in biochemistry and laboratory safety. Those aiming to enhance their skills in microbiology and basic biology. Professionals looking to broaden their knowledge in infection prevention and COSHH assessment. Career path Lab Technician: Average salary £21,000 - £27,000 annually in the UK. Biochemist: Average salary £31,000 - £44,000 annually in the UK. Microbiologist: Average salary £26,500 - £38,000 annually in the UK. Biology Teacher: Average salary £24,000 - £41,000 annually in the UK. Infection Control Nurse: Average salary £26,000 - £35,000 annually in the UK. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included