• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

18251 Courses in Cardiff delivered Online

Excel VBA/Macros Foundations

4.5(3)

By Studyhub UK

A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Excel VBA/Macros Foundations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Excel VBA/Macros Foundations course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00

Excel VBA/Macros Foundations
Delivered Online On Demand8 hours 52 minutes
£10.99

Mastering Quizzes & Assessments in Cademy: A Comprehensive Guide

4.8(6)

By Cademy

Join our webinar and unlock the power of quizzes within Cademy's learning platform. Don't miss this opportunity to become a master of quizzes in Cademy, taking your online assessments to the next level. Join us for this informative webinar and learn how to create and utilise interactive quizzes that enhance the learning experience for your students.

Mastering Quizzes & Assessments in Cademy: A Comprehensive Guide
Delivered OnlineJoin Waitlist
FREE

One to One tuition- Maths-Primary

By Teaching4you

Teaching4you is a tuition company that works to encourage and build confidence in students nationwide.

One to One tuition- Maths-Primary
Delivered OnlineFlexible Dates
£25

Video Game Design Course

By IOMH - Institute of Mental Health

Overview Creating standout logos for games is both exciting and rewarding. Our "Video Game Design Training" course helps you master this art by teaching you how to design logos that perfectly capture the essence of different game genres. From thrilling racing games to spooky horror adventures, you’ll learn how to create logos that make a lasting impression. The course takes you through each step of the design process. You’ll begin with fundamental techniques and gradually advance to more complex logo designs. Whether it’s cute cartoon characters or gritty grunge styles, you’ll gain the skills needed to tackle various design challenges. By the end of this training, you’ll be equipped with practical skills for a range of creative careers. Whether you're looking to enter game design or graphic design, our course provides the tools and knowledge you need to shine in the industry. Start crafting logos that stand out and represent your unique vision! Become proficient in Video Game Design Training by grasping all the essential knowledge from our top-quality course step by step. Enrol now to ensure that your Video Game Design Training mastery is not limited to only conceptual frameworks! This Video Game Design Training will assist you in standing out from the crowd and being more efficient in your chosen area of expertise. Furthermore, if you require assistance with the Video Game Design Training, we will provide experts who will support and guide you. So, add this Video Game Design Training to your cart and boost your personal and career development. In this Video Game Design Training, you will: Sharpen your skills to help you advance your career. Acquire a comprehensive understanding of various related topics and tips from industry experts. Learn in-demand knowledge and skills in high demand among UK employers, which will help to kickstart your Video Game Design Training career. Enrolling in the Video Game Design Training can assist you in getting into your desired career faster than you ever imagined. So, without further ado, start now! Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Video Game Design Course course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Video Game Design Course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Video Game Design Course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Video Game Design Course is suitable for anyone aspiring to start a career in Video Game Design Course; even if you are new to this and have no prior knowledge on Video Game Design Course, this course is going to be very easy for you to understand.  And if you are already working in the Video Game Design Course field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Video Game Design course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Video Game Design Course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Video Game Design Course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Video Game Design course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Introduction to game logo design The first question to ask 00:02:00 My game logo design process 00:03:00 The importance of sketching 00:03:00 Basic logos Simple racing game logo design 00:12:00 Simple horror game logo design 00:17:00 Simple logo for a puzzle game 00:18:00 Complex logo designs Cute cartoon game logo design - Part 1 00:13:00 Cute cartoon game logo design - Part 2 00:18:00 Design a sci-fi logo using negative space - Part 1 00:08:00 Design a sci-fi logo using negative space - Part 2 00:16:00 Cartoon fantasy RPG game logo design -Part 1 00:15:00 Cartoon fantasy RPG game logo design -Part 2 00:14:00 Grunge zombie shooter game logo design - Part 1 00:11:00 Grunge zombie shooter game logo design - Part 2 00:19:00

Video Game Design Course
Delivered Online On Demand2 hours 49 minutes
£11

IT Support Technician Course - CPD Certified

4.7(47)

By Academy for Health and Fitness

Boost Your Career By Enrolling In This IT Support Technician Bundle To Overcome Your Challenges! 07 in 1 IT Support Technician Bundle Improve your knowledge and enhance your skills to succeed with this IT Support Technician bundle. This IT Support Technician bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our bundle is ideal for those who aim to be the best in their fields and are always looking to grow. This IT Support Technician Bundle Contains 07 of Our Premium Courses for One Discounted Price: Course 01: Learn Programming with Python Course 02: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 03: Mastering SQL Programming Course 04: IT: Ethical Hacking & IT Security Course 05: CompTIA CySA+ Cybersecurity Analyst (CS0-002) Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Building Your Computer Course All the courses under this IT Support Technician bundle are split into a number of expertly created modules to provide you with an in-depth and comprehensive learning experience. Upon successful completion of the IT Support Technician bundle, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Stand out from the crowd and get trained for the job you want. With this comprehensive IT Support Technician bundle, you can achieve your dreams and train for your ideal career. This IT Support Technician bundle covers essential aspects in order to progress in your chosen career. Why Prefer Us? All-in-one package of 07 premium courses IT Support Technician bundle Earn a certificate accredited by CPD. Get a free student ID card! (£10 postal charges will be applicable for international delivery) Globally accepted standard lesson planning Free Assessments 24/7 tutor support. Start your learning journey straightaway! *** Course Curriculum *** Our IT Support Technician bundle courses consist of the following learning modules: Course 01: Learn Programming with Python Module 01: An Installing Python FREE Documentation Command Line Variables Simple Python Syntax Keywords Import-Module Module 02: Additional Topics If Elif Else Iterable For Loops Execute Exceptions Module 03: Data Types Number Types More Number Types Strings More Strings Files Lists Dictionaries Tuples Sets Module 04: Comprehensions Definitions Functions Default Arguments Doc Strings Variadic Functions Factorial Module 05: Function Objects Lambda Generators Closures Classes Object Initialization Class Static Members Classic Inheritance Data Hiding Assessment Process Once you have completed all the courses in the IT Support Technician bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 70 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This IT Support Technician bundle is suitable for everyone. Requirements You will not need any prior background or expertise. Career path This IT Support Technician bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Accredited Certificate by CPD QS Digital certificate - £10 Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS Accredited Certificate by CPD QS Hard copy certificate - £29 Upon passing the Bundle, you need to order to receive a Hard copy Certificate for each of the courses inside this bundle. If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

IT Support Technician Course - CPD Certified
Delivered Online On Demand35 hours
£42

Excel PowerQuery and PowerPivot

4.9(27)

By Apex Learning

Overview This comprehensive course on Excel PowerQuery and PowerPivot will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel PowerQuery and PowerPivot 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 Excel PowerQuery and PowerPivot. It is available to all students, of all academic backgrounds. Requirements Our Excel PowerQuery and PowerPivot 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 3 sections • 28 lectures • 01:50:00 total length •pivot table power query power pivot - 1: 00:09:00 •pivot table power query power pivot - 2: 00:01:00 •pivot table power query power pivot - 3: 00:02:00 •pivot table power query power pivot - 4: 00:03:00 •pivot table power query power pivot - 5: 00:01:00 •pivot table power query power pivot - 6: 00:04:00 •pivot table power query power pivot - 7: 00:08:00 •pivot table power query power pivot - 8: 00:05:00 •pivot table power query power pivot - 9: 00:03:00 •pivot table power query power pivot - 10: 00:04:00 •pivot table power query power pivot - 11: 00:04:00 •pivot table power query power pivot - 12: 00:02:00 •pivot table power query power pivot - 13: 00:03:00 •pivot table power query power pivot - 14: 00:05:00 •pivot table power query power pivot - 15: 00:02:00 •pivot table power query power pivot - 16: 00:03:00 •pivot table power query power pivot - 17: 00:03:00 •pivot table power query power pivot - 18: 00:08:00 •pivot table power query power pivot - 19: 00:02:00 •pivot table power query power pivot - 20: 00:04:00 •pivot table power query power pivot - 21: 00:05:00 •pivot table power query power pivot - 22: 00:09:00 •pivot table power query power pivot - 23: 00:04:00 •pivot table power query power pivot - 24: 00:03:00 •pivot table power query power pivot - 25: 00:04:00 •pivot table power query power pivot - 26: 00:09:00 •Resources - Excel PowerQuery and PowerPivot: 00:00:00 •Assignment - Excel PowerQuery and PowerPivot: 00:00:00

Excel PowerQuery and PowerPivot
Delivered Online On Demand1 hour 50 minutes
£12

Diploma in IT (Information Technology) - CPD Certified

4.9(27)

By Apex Learning

Limited Time Sales: CPD Certified | 37 Video Lessons | Free PDF Certificate | Lifetime Access

Diploma in IT (Information Technology) - CPD Certified
Delivered Online On Demand1 hour 59 minutes
£9.99 to £12

Duolingo Test Preparation-Competitive Course (7-Day Access to Duolingo Online Course)

5.0(5)

By TEFL Wonderland - Brilliant Minds

Duolingo Test Preparation

Duolingo Test Preparation-Competitive Course (7-Day Access to Duolingo Online Course)
Delivered Online On Demand
£4.50

Penetration Tester - CPD Certified

4.7(47)

By Academy for Health and Fitness

If you aim to enhance your Penetration Tester - CPD Certified skills, our comprehensive Penetration Tester - CPD Certified course is perfect for you. Designed for success, this Penetration Tester - CPD Certified course covers everything from basics to advanced topics in Penetration Tester - CPD Certified. Each lesson in this Penetration Tester - CPD Certified course is crafted for easy understanding, enabling you to become proficient in Penetration Tester - CPD Certified. Whether you are a beginner or looking to sharpen your existing skills, this Penetration Tester - CPD Certified is the ideal choice. With our Penetration Tester - CPD Certified exclusive bundle, you will get a PDF Certificate, PDF Transcript and Digital Student ID Card (worth £50) Absolutely FREE. Courses are Included in This Penetration Tester - CPD Certified Bundle: Course 01: Web Application Penetration Testing Course 02: Penetration Testing with OWASP ZAP Course 03: CompTIA PenTest+ (Ethical Hacking) Course 04: Secure Programming of Web Applications - Developers and TPMs Course 05: Network Security Level 2 Course 06: IT: Ethical Hacking & IT Security Why Choose Our Penetration Tester - CPD Certified Course? FREE Penetration Tester - CPD Certified certificate accredited Get a free student ID card with Penetration Tester - CPD Certified Training Get instant access to this Penetration Tester - CPD Certified course. Learn Penetration Tester - CPD Certified from anywhere in the world The Penetration Tester - CPD Certified is affordable and simple to understand The Penetration Tester - CPD Certified is an entirely online, interactive lesson with voiceover audio Lifetime access to the Penetration Tester - CPD Certified course materials The Penetration Tester - CPD Certified comes with 24/7 tutor support So enrol now in this Penetration Tester - CPD Certified Today to advance your career! Start your learning journey straightaway! This Penetration Tester - CPD Certified's curriculum has been designed by Penetration Tester - CPD Certified experts with years of Penetration Tester - CPD Certified experience behind them. The Penetration Tester - CPD Certified course is extremely dynamic and well-paced to help you understand Penetration Tester - CPD Certified with ease. You'll discover how to master the Penetration Tester - CPD Certified skill while exploring relevant and essential topics. Assessment Process Once you have completed all the courses in the Penetration Tester - CPD Certified bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Penetration Tester - CPD Certified bundle is suitable for everyone. Requirements You will not need any prior background or expertise. Career path This Penetration Tester - CPD Certified bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Penetration Tester - CPD Certified
Delivered Online On Demand30 hours
£39

CBT Training (Cognitive Behavioural Therapy) - CPD Certified

4.7(47)

By Academy for Health and Fitness

9 in 1 Premium Courses Bundle! CPDQS Accredited | Audio Visual Training | 90 CPD Points | Free ID Card & Assessment

CBT Training (Cognitive Behavioural Therapy) - CPD Certified
Delivered Online On Demand33 hours
£39