17633 Teaching courses in Bolton delivered On Demand

Overview With the ever-increasing demand for Digital Marketing in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Digital Marketing may be. Learning about Digital Marketing or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Digital Marketing. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Digital Marketing is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by Compete High in this Digital Marketing : Social Media course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Digital Marketing : Social Media course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Digital Marketing : Social Media course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Digital Marketing, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Digital Marketing, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Digital Marketing, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Digital Marketing : Social Media course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1_ Introduction Introduction 00:00 Module 2_ Social Media Etiquette Social Media Etiquette 00:00 Module 3_ Twitter Twitter 00:00 Module 4_ Facebook Facebook 00:00 Module 5_ Instagram Instagram 00:00 Module 6_ LinkedIn LinkedIn 00:00

Overview With the ever-increasing demand for Freelancing in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Freelancing may be. Learning about Freelancing or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Freelancing . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Freelancing is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Freelancing course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Freelancing course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Freelancing course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Freelancing , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Freelancing , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Freelancing , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Freelancing course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Chapter 1 Introduction to Freelancing Introduction to Freelancing 00:00 Chapter 2 Potential Drawbacks Potential Drawbacks 00:00 Chapter 3 Finding Work Finding Work 00:00

🚀 Unlock the Power of Digital Marketing with our Comprehensive Online Course! 🌟 Are you ready to take your digital marketing skills to the next level? Look no further! Introducing our cutting-edge online course: 'Best Practices for Digital Marketing - Google, Facebook, and More.'   In today's fast-paced digital world, mastering the art of online marketing is crucial for businesses and professionals alike. Whether you're a seasoned marketer looking to stay ahead of the curve or a beginner eager to dive into the world of digital advertising, this course is tailored just for you. What You'll Learn: 🔥 Proven strategies for maximizing your impact on Google, Facebook, and other major platforms. 🔍 Search Engine Optimization (SEO) techniques to boost website visibility and organic traffic. 💡 Insights into crafting compelling ad campaigns that convert and drive results. 📈 Analytics and measurement tools to track and optimize your marketing efforts effectively. 🤝 Building strong customer relationships through social media and beyond. 🎯 Targeted approaches for various platforms to maximize ROI and engagement.   Why Choose Our Course? ✅ Expert-led instruction from industry professionals with years of hands-on experience. ✅ Interactive modules, real-life case studies, and practical exercises for enhanced learning. ✅ Up-to-date insights reflecting the latest trends and algorithm changes in the digital landscape. ✅ Flexible learning at your own pace, accessible anytime and anywhere. ✅ Exclusive resources and tools to implement your newfound knowledge immediately.   Join thousands of satisfied students who have transformed their marketing strategies with our comprehensive course! Whether you're a freelancer, business owner, marketer, or aspiring professional, this course will equip you with the skills and confidence needed to thrive in the competitive digital marketing arena. Don't miss this opportunity to elevate your digital marketing expertise. Enroll now and take the first step toward achieving your marketing goals! 🌟 Limited Time Offer: Enroll Today and Gain Lifetime Access to the Course! 🌟 Invest in your success and dominate the digital realm. Join us on this exciting journey to becoming a digital marketing expert! Course Curriculum

Overview With the ever-increasing demand for Communication Skills in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Communication Skills may be. Learning about Communication Skills or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Communication Skills . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Communication Skills is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Communication Skills course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Communication Skills course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Communication Skills course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Communication Skills , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Communication Skills , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Communication Skills , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Communication Skills course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Module 1 Effective Communication Effective Communication 00:00 Module 2 Effective Verbal Communication Effective Verbal Communication 00:00 Module 3 Effective Written Communication Effective Written Communication 00:00

🚀 Unlock Your Full Potential with 'Guide for Being a Winner' Online Course! 🏆 Are you ready to transform your life and become the champion you were born to be? Introducing our groundbreaking online course - 'Guide for Being a Winner' - your ultimate roadmap to success, fulfillment, and a winning mindset!   🌟 Why Choose 'Guide for Being a Winner'?   🚀 Comprehensive Strategies: Gain access to proven strategies and techniques used by successful individuals across various fields. Whether you're pursuing personal or professional goals, this course equips you with the tools to conquer challenges and emerge victorious.   🧠Master Your Mindset: Unleash the power of a winning mindset! Learn how to overcome self-doubt, cultivate resilience, and turn obstacles into opportunities. Our course empowers you to build the mental resilience necessary for triumph in any endeavor.   💼 Career Acceleration: Elevate your professional game! Discover the insider secrets that successful professionals use to climb the career ladder rapidly. From effective communication to strategic decision-making, this course equips you with the skills to stand out in your industry.   👥 Social and Personal Success: Forge meaningful connections and cultivate a winning presence in your personal life. Learn the art of effective communication, charisma, and relationship-building, enabling you to thrive in your personal and social circles.   📈 Goal Setting and Achievement: Set and achieve ambitious goals with precision! 'Guide for Being a Winner' provides a step-by-step guide to goal setting, planning, and execution. Witness your dreams transform into reality as you implement our proven success strategies.   🎓 Lifetime Access: Enjoy lifetime access to course materials, ensuring you can revisit and reinforce your learning at your own pace. Stay connected with updates and additional content that keeps you ahead of the curve.   🌐 Accessible Anywhere, Anytime: Our user-friendly online platform allows you to access the course from the comfort of your home or on the go. No more barriers to your success - learn at your convenience!   🔥 Join the Winners' Circle Today! Invest in yourself and take the first step towards a brighter, more successful future. Don't settle for mediocrity when greatness is within your reach. Enroll in 'Guide for Being a Winner' now and embark on your journey to excellence Course Curriculum

Sales Overview: Abrasive Wheels Training Course Are you looking to enhance workplace safety and empower your team with essential skills? Introducing our comprehensive 'Abrasive Wheels Training' course designed to equip your workforce with the knowledge and expertise needed for the safe and effective use of abrasive wheels. Course Highlights: Module 1: Introduction to Abrasive Wheels Gain a foundational understanding of abrasive wheels, their types, and their applications. Explore the importance of abrasive wheels in various industries and their role in enhancing productivity. Module 2: Abrasive Wheel Components and Selection Dive into the intricacies of abrasive wheel components and their functionalities. Learn how to choose the right abrasive wheel for specific tasks, optimizing efficiency and performance. Module 3: Mounting and Storage of Abrasive Wheels Master the proper techniques for mounting abrasive wheels to ensure secure and effective installation. Understand the best practices for storing abrasive wheels to extend their lifespan and maintain safety standards. Module 4: Operation and Maintenance of Abrasive Wheels Learn the essential skills for operating abrasive wheels safely and efficiently. Gain insights into routine maintenance practices to maximize the lifespan of abrasive wheels and minimize downtime. Module 5: Hazards and Risk Assessment Identify potential hazards associated with abrasive wheel usage and understand their implications. Develop the skills to conduct thorough risk assessments, implementing preventive measures to create a safer working environment. Why Choose Our Abrasive Wheels Training Course: Expert-led Instruction: Our course is crafted and delivered by industry experts with extensive experience in abrasive wheel usage and safety protocols. Interactive Learning: Engage in practical scenarios, case studies, and hands-on exercises to reinforce theoretical knowledge. Compliance and Certification: Ensure compliance with industry regulations and receive a recognized certification upon successful completion of the course. Customization Options: Tailor the course to meet the specific needs of your organization, ensuring relevance and applicability. Risk Mitigation: Equip your team with the skills to identify and address potential hazards, reducing the risk of accidents and injuries in the workplace. Invest in the safety and competence of your workforce with our Abrasive Wheels Training course. Contact us today to discuss how this comprehensive program can benefit your organization and propel your team towards a safer, more efficient workplace. Course Curriculum Module 1_ Introduction to Abrasive Wheels Introduction to Abrasive Wheels 00:00 Module 2_ Abrasive Wheel Components and Selection Abrasive Wheel Components and Selection 00:00 Module 3_ Mounting and Storage of Abrasive Wheels Mounting and Storage of Abrasive Wheels 00:00 Module 4_ Operation and Maintenance of Abrasive Wheels Operation and Maintenance of Abrasive Wheels 00:00 Module 5_ Hazards and Risk Assessment Hazards and Risk Assessment 00:00

Overview Our comprehensive course is designed to provide you with the necessary skills and knowledge to excel in your field. Developed by professionals with years of experience, this course is perfect for anyone looking to kick start their career or advance their skills. It features an audio-visual presentation and easy-to-learn modules, allowing for a self-paced learning experience. Our expert online support team is available during weekdays to assist you throughout the course. Learning Outcomes Upon completion of the course, you will be able to: Understand the fundamentals and its applications. Develop the necessary skills to succeed in the field . Apply your newly acquired knowledge to real-world scenarios. Create effective and efficient solutions for relevant topics. Enhance your employability and career prospects. It is designed to provide you with the knowledge needed to stand out in the competitive job market. With lifetime access to course materials and the ability to learn at your own pace, this course is the perfect opportunity to improve your skills and advance your career. You can learn at your own pace, from the comfort of your home, as all course materials are accessible online at any time. Why Choose Us? Lifetime access to course materials Full tutor support is available Monday through Friday for all courses Learn essentials skills at your own pace from the comfort of your home Gain a thorough understanding of the course Access informative video modules taught by expert instructors 24/7 assistance and advice available through email and live chat Study the course on your computer, tablet, or mobile device Improve your chances of gaining professional skills and earning potential by completing the course. Why should you study this course? The course offers a comprehensive introduction to the subject matter and provides a solid foundation for further study. It will also help students to gain knowledge and skills that can be applied in their professional or personal life. Assessment The course includes a series of quizzes that will test your understanding and retention of the material covered in the course. The quizzes will help you to identify areas where you may need further practice, and you will have the opportunity to review the course materials as needed. Upon successfully passing the final quiz, you will be able to order your certificate of achievement. Career Path The course is designed to equip you with the skills and knowledge you need to succeed in the field. After completing the course, you will be able to pursue a variety of career opportunities in different industries. Course Content END OF LIFE CARE TRAINING Module 1: Understanding End-of-Life Care Module 2: Legal and Ethical Aspects of End-of-Life Care Module 3: Identification of the Stage of Illness Module 4: Breaking Bad News & Communication in End-of-Life Care Module 5: Pain and Symptom Management Module 6: Psychosocial, Emotional, and Spiritual Care Module 7: Care in the Last Days of Life Module 8: Child and Young Adult End-of-Life Care Module 9: Hospice and Palliative Care Module 10 Nutrition and Hydration at the End of Life

Overview With the ever-increasing demand for ASD Awareness in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in ASD Awareness may be. Learning about ASD Awareness or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in ASD Awareness . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on ASD Awareness is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this ASD Awareness course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this ASD Awareness course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this ASD Awareness course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of ASD Awareness , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in ASD Awareness , Anyone looking for a certificate of completion on doing an online training on this topic, Students of ASD Awareness , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This ASD Awareness course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 What is Autism What is Autism 00:00 Module 2 Causes of Autism Causes of Autism 00:00 Module 3 Understanding the Symptoms of Autism Understanding the Symptoms of Autism 00:00 Module 4 Understanding the Impact of Autism on Individuals and Families Understanding the Impact of Autism on Individuals and Families 00:00 Module 5 Understanding Communication and Social Interaction in Autism Understanding Communication and Social Interaction in Autism 00:00 Module 6 Navigating Sensory Overload and Meltdowns Navigating Sensory Overload and Meltdowns 00:00

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.

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