37503 Courses in Bradford delivered Online

This Dignity & Safeguarding - Level 2 course is designed for individuals who work or intend to work with vulnerable adults in the health and social care sectors in various settings, such as hospitals, domiciliary care, or nursing homes. This Dignity & Safeguarding - Level 2 qualification aims to provide learners with knowledge and understanding of the key principles of dignity, the duty of care, and safeguarding as applied to adult health social care. Through this Dignity & Safeguarding - Level 2 course, learners will understand the principles and how they are applied in everyday work situations. They will also have an opportunity to examine the dilemmas that can arise and the consequences of not adhering to these principles. Learning Outcomes After completing this Dignity & Safeguarding - Level 2 course, the learner will be able to: Gain a thorough understanding of safeguarding in adult health and social care. Understand the principles of dignity in adult health and social care practice. Gain a solid understanding of the Duty of Care in Adult Health and Social Care. Gain a thorough understanding of dilemmas encountered in adult health and social care. Understand the issues of public concern in adult health and social care. Why Choose Dignity & Safeguarding - Level 2 Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Dignity & Safeguarding - Level 2 Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing this course. ***Courses are included in this Dignity & Safeguarding - Level 2 Course Course 01: Dignity & Safeguarding - Level 2 Course 02: Level 2 Health & Care Course 03: Level 5 Mental Health Care - MCA and DOLS ***Other Benefits of Dignity & Safeguarding - Level 2 Course Free 3 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the course ] ***Dignity & Safeguarding - Level 2*** Detailed course curriculum of the Dignity & Safeguarding - Level 2 Course: Module 1: Understand Safeguarding in Adult Health and Social Care Module 2: Principles of Dignity in Adult Health and Social Care Practice Module 3: Understand Duty of Care in Adult Health and Social Care Module 4: Understand Dilemmas and Public Concerns in Adult Health and Social Care ------------------------- Assessment Method After completing each module of the Dignity & Safeguarding - Level 2, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Dignity & Safeguarding - Level 2 course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Dignity & Safeguarding - Level 2 This Dignity & Safeguarding - Level 2 course is ideal for those who work with or intend to work with vulnerable adults in the health and social care sectors. Requirements Dignity & Safeguarding - Level 2 There are no specific requirements for this Dignity & Safeguarding - Level 2 course because it does not require any advanced knowledge or skills. Students who intend to enrol in this Dignity & Safeguarding - Level 2 course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Certificates Certificate of completion Digital certificate - Included

Limited Times Deal! Offer Ends Soon; Hurry Up!! In the United Kingdom (UK), OCD affects approximately 1.2%of the population. Obsessive Compulsive Disorder (OCD) is a very common, chronic, and enduring disorder in which a person has irrepressible and recurring thoughts or obsessions and behaviours that they feel compelled to repeat. OCD can affect a person at a very young age from like a year and a half old, which persists lifelong, impacting a person's usual mental/physical peace and everyday lifestyle. This OCD Awareness course covers how OCD can influence someone's life and those around them, especially if left untreated. Offer your cherished ones the finest care you can and develop your OCD Awareness abilities to care for everyone around you. This training will help you prepare for your responsibilities easily. This OCD awareness course will guide you through the Signs, Symptoms, and Causes of OCD, as well as Identify and Treating Specific OCD Symptoms, Treatment for OCD, Treating Children with OCD, and more. So, don't delay any longer and seize this once-in-a-lifetime opportunity! Make your OCD awareness and care experience as simple as possible. Learning Outcomes: Explain obsessive-compulsive disorder and its many subtypes. Describe the symptoms of obsessive-compulsive disorder in children. List the advantages of utilising CBT with children and adolescents. List the most frequent OCD distortions. Establish the significance of preserving workplace health and safety. Recognize how OCD affects an individual's quality of life. Discuss living with OCD and how to deal with an OCD family member. This OCD Awareness 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! Why Prefer This OCD Awareness Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS after completing the OCD Awareness course 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. Course Curriculum Module 01: Introduction to Obsessive-Compulsive Disorder (OCD): This module will introduce you to all the basics of OCD awareness to make yourself familiar with the condition. Module 02: Signs, Symptoms and Causes of OCD: This module will teach you the different signs, symptoms, and causes that come along with OCD. Module 03: Identifying and Treating Specific OCD Symptoms: This module will teach you how to identify OCD symptoms and also guide you through the treatments of specific symptoms of OCD. Module 04: Treatment for OCD: This module will teach you a wider range of treatments for OCD and how to care for it. Module 05: Treating Children with OCD: This module will raise more OCD awareness in children and how to treat it. Module 06: Overcoming OCD: This module will teach you the different ways to overcome OCD and how to care for it. Module 07: Relapse Prevention and Recovery: This module will teach you all about relapse prevention and recovery of OCD. Module 08: Living with OCD: This module will raise more OCD awareness and guide you through how to care for someone that has OCD and how to manage it if you have the disorder yourself. Assessment Process We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals with an interest in health & care, regardless of their skill level A beginner support worker and healthcare assistant looking to learn the fundamental principles and techniques of health & care An experienced health and care assistant looking to improve their skills and learn new techniques Those who are interested in developing their health & care skills to treat OCD Anyone with a passion for health & care and OCD in real-world day-to-day tasks Requirements The OCD Awareness software does not require any prior knowledge; everyone may participate! This course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This course allows you to study at your own speed while earning an industry-recognized certification. Career path Healthcare Assistant Support Worker Health & Care Professionals Senior Care Worker Emergency Care Assistant Psychological Wellbeing Practitioner Certificates CPD Accredited Certificate Digital certificate - £10 Certificate in OCD Awareness at QLS Level 3 Hard copy certificate - £89 After successfully completing the Certificate in OCD Awareness at QLS Level 3, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 89 GBP inside the UK 99 GBP (including postal fees) for international delivery CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

Immerse yourself in the world of compassionate caregiving with our 'Dementia Awareness' course. This meticulously crafted program begins by defining dementia, providing a solid foundation for understanding this complex condition. Delve into the intricacies of the brain and discover how dementia affects it, gaining invaluable insights into the cognitive changes that occur. With a comprehensive exploration of various dementia types and the stages of progression, you'll be well-equipped to identify and empathize with individuals facing these challenges. Our course goes beyond awareness to practical application. Learn how to assess dementia effectively and explore pharmaceutical and psychological treatments that can improve the quality of life for those affected. Raising awareness and preventing dementia is a critical aspect covered in this program, emphasizing the importance of early intervention. Caregiving for dementia becomes more meaningful as you discover the best practices and understand the relevant acts and legislation that guide this essential field. Learning Outcomes Define dementia and its various forms. Understand the impact of dementia on the brain. Identify the stages of dementia progression. Learn effective assessment techniques for dementia. Explore pharmaceutical and psychological treatments for dementia. Why choose this Dementia Awareness course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Dementia Awareness course for? Healthcare professionals, including nurses and caregivers. Individuals interested in dementia care and support. Family members of individuals with dementia. Anyone seeking to raise awareness and contribute to dementia prevention. Students pursuing healthcare and related fields. Career path Dementia Caregiver: £18,000 - £30,000 Registered Nurse: £24,000 - £40,000 Healthcare Assistant: £16,000 - £25,000 Clinical Psychologist: £35,000 - £60,000 Health Educator: £22,000 - £40,000 Social Worker: £24,000 - £42,000 Prerequisites This Dementia Awareness does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Defining Dementia Defining Dementia 00:12:00 Module 02: The Brain and How Dementia Affects It The Brain and How Dementia Affects It 00:20:00 Module 03: Types of Dementia Types of Dementia 00:30:00 Module 04: Stages of Dementia Stages of Dementia 00:35:00 Module 05: Assessing Dementia Assessing Dementia 00:14:00 Module 06: Pharmaceutical Treatment for Dementia Pharmaceutical Treatment for Dementia 00:25:00 Module 07: Psychological Treatment for Dementia Psychological Treatment for Dementia 00:30:00 Module 08: Raising Awareness and Preventing Dementia Raising Awareness and Preventing Dementia 00:35:00 Module 09: Caregiving for Dementia Caregiving for Dementia 00:10:00 Module 10: Dementia Care: Acts and Legislation Dementia Care: Acts and Legislation 00:16:00 Assignment Assignment - Dementia Awareness 00:00:00

Overview This comprehensive course on Inspirational Leadership Skills: Practical Motivational Leadership will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Inspirational Leadership Skills: Practical Motivational Leadership 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 Inspirational Leadership Skills: Practical Motivational Leadership. It is available to all students, of all academic backgrounds. Requirements Our Inspirational Leadership Skills: Practical Motivational Leadership 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 2 sections • 8 lectures • 02:39:00 total length •Module 01: Developing the Leader Within You: 00:21:00 •Module 02: Emotional Intelligence in Leadership: 00:17:00 •Module 03: Communication Skills: 00:26:00 •Module 04: Public Speaking: 00:30:00 •Module 05: Critical Thinking in Problem-Solving and Decision Making: 00:23:00 •Module 06: Motivation and Counselling: 00:16:00 •Module 07: Management and Leadership: 00:26:00 •Assignment - Inspirational Leadership Skills: Practical Motivational Leadership: 00:00:00

Duration 5 Days 30 CPD hours Additional course details: Nexus Humans 9000 System Manager 2.8 (3-day) 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 9000 System Manager 2.8 (3-day) 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 4 Days 24 CPD hours Additional course details: Nexus Humans 9000 System Manager 2.9 (4-day) 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 9000 System Manager 2.9 (4-day) 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.

Housing: Housing Training Your Realtor for Life! Activate your potential with our Level 2 Award in Involvement in Housing and Communities course. Do you intend to change your community for the better? The Level 2 Award in Involvement in Housing: Housing and Communities Course is right for you if so! You can acquire the abilities and information required to become a successful community developer by taking this Level 2 Award in Involvement in Housing and Communities course. Through our Level 2 Award in Involvement in Housing: Housingand Communities You'll get the self-assurance you need to act and change your community. Also, you will be able to use what you learn in the Level 2 Award in Involvement in Housing and Communities course in your own neighbourhood. All you need to know about the topic is covered in theLevel 2 Award in Involvement in Housing: Housing and CommunitiesCourse. You can learn the principles of community development with the aid of this Level 2 Award in Involvement in Housing and Communities course. You will also learn, How to recognize and address housing difficulties will become more clear to you by our special Level 2 Award in Involvement in Housing and Communities course . This Level 2 Award in Involvement in Housing and Communities course will help you to discover how to design and oversee social projects. You will also learn more about the accomplishments of efforts to advance society. Join Level 2 Award in Involvement in Housing: Housing and Communities course right away to get started changing the world! Main Course: Level 2 Award in Involvement in Housing and Communities Free Courses are including with this Housing: Housing Course Along with The Housing: Housing Course, We Offer a free Property Management Course Along with The Housing: Housing Course, We Offer a free Level 1 Health and Safety in a Construction EnvironmentCourse Along with The Housing: Housing Course, We Offer a free Estate Agent Diploma Course Special Offers of this Housing: Housing Training Course This Housing: Housing Course includes a FREE PDF Certificate. Lifetime access to this Housing: Housing Course Instant access to this Housing: Housing Course Get FREE Tutor Support to this Housing: Housing Course Housing: Housing Training The Level 2 Award in Involvement in Housing and Communities Course covers all the information you need to know about the subject. This Level 2 Award in Involvement in Housing and Communities course can help you learn the fundamentals of community development. Additionally, you will discover more about how to identify and handle housing issues thanks to our unique Level 2 Award in Involvement in Housing and Communities course. With the assistance of this Level 2 Award in Involvement in Housing and Communities course, you will learn how to plan and manage social projects. Also, you'll discover more about the successes of initiatives to improve society. Who is this course for? Housing: Housing Training Everyone who wants to change their neighbourhood should enrol in this Level 2 Award in Involvement in Housing and Communities course. Requirements Housing: Housing Training To enrol in this Housing: Housing Course, students must fulfil the following requirements. To join in our Housing :Housing Course, you must have a strong command of the English language. To successfully complete our Housing: Housing Course, you must be vivacious and self driven. To complete our Housing: Housing Training Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Housing: Housing Training Course. Career path Housing: Housing Training This Level 2 Award in Involvement in Housing and Communities course will open up your career in the community developer field.

The Microsoft Office Essentials - 3 Course Bundle has been expertly designed for you to complete through distance e-learning. Successful completion of the Microsoft Office bundle will see you achieve a CPD certified proficiency which will add significant weight to your CV and impress potential employers when applying for new jobs. Enrol now on the Microsoft Office Essentials - 3 Course Bundle and get access to top-quality training modules. Start studying Microsoft Office using any internet-enabled device including computers, tablets, and smartphones. With 24/7 student support, you can be sure of quick and comprehensive assistance whenever you need it. Why Choose Microsoft Office Essentials - 3 Course Bundle? Opportunity to boost your CV/Resume with CPD accredited proficiency Student ID card with amazing discounts - completely for FREE! (Postal charges will be applicable for international delivery) Certificates available in both PDF and hard copy format Interactive, high-quality course content with 24/7 online access Full tutor support and learning assistance included Course Curriculum Breakdown: Here are the topics you will cover on the Microsoft Office Essentials - 3 Course Bundle Course: Microsoft Excel 2022 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Excel Templates Excel Templates CPD 11 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office Essentials - 3 Course Bundle has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with the Microsoft Office Essentials - 3 Course Bundle. Requirements Enrol on the Microsoft Office Essentials - 3 Course Bundle with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Microsoft Office Essentials - 3 Course Bundle without any delay. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited Certificate Hard copy certificate - £29

Embark on a captivating journey with our Diploma in Forensic Psychology. Explore investigative psychology, courtroom dynamics, and understand criminal behavior. Ideal for those aiming to blend psychological expertise with legal acumen in a forensic setting.

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