2223 Courses delivered Online

Overview It doesn't matter in which part of the world you live or what culture you follow; one thing is undoubtedly considered harmful to your present and future. That is Debt. Debt can make your life worse. It is like a vicious circle; a continuing unpleasant situation created when one problem causes another problem that then makes the first problem worse. No one wants to be part of this chain of events. But honestly speaking, the concept of debt is not always harmful. It depends on how you see it and use it. Here comes the role of Debt Management. You should know how to manage debt smartly and efficiently. At Apex Learning, we share the goal of millions of people, which is to make the world better. We have prepared a tool to help deal with debt management: our Debt Management - Online Course. You can access our course anytime, anywhere. Enrol now before falling into a debt trap. What Can You Expect From The Course? Understanding the fundamentals of debt management and its importance. Distinguishing between long-term and short-term debt and their implications. Identifying and assessing your personal debt situation effectively. Developing a realistic debt management plan. Learning strategies for avoiding debt problems. Dealing with bankruptcy and insolvency within legal regulations. 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 Debt Management - Online Course. It is available to all students, of all academic backgrounds. Requirements Our Debt Management - Online Course 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 14 lectures • 05:08:00 total length •Module 01: Introduction to Debt Management: 00:22:00 •Module 02: Long Term and Short Term Debt: 00:20:00 •Module 03: Identifying Your Debt: 00:27:00 •Module 04: Debt Management Plan: 00:30:00 •Module 05: Debt Assessment: 00:23:00 •Module 06: Debt Financing: 00:18:00 •Module 07: Building Budget: 00:23:00 •Module 08: Debt Counselling: 00:18:00 •Module 09: When Is Debt Good?: 00:19:00 •Module 10: Avoiding Debt Problems: 00:19:00 •Module 11: How to Handle Debt Collectors: 00:16:00 •Module 12: How to Get Out of Debt: 00:18:00 •Module 13: Dealing with Bankruptcy and Insolvency: 00:32:00 •Module 14: Laws and Regulations: 00:23:00

Overview Attain the best online training possible to become a sought-after manager who can steer Hotels and Hospitality services in successful directions. This Hospitality and Hotel Revenue Management Advanced Diplomacourse is designed to coach you in every aspect and element of Hospitality responsibilities and guarantees you are able to deliver outstanding customer service. The course is designed to prepare for the demands of customers in Hotels, and also such other events or locations, such as cruise ships, popular bars or clubs, restaurants, and high-profile tourist destinations. You will learn how to recruit and train staff, maintain housekeeping, upkeep a facility, and organise large-scale events and the appropriate catering. 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 Hospitality and Hotel Revenue Management Advanced Diploma. It is available to all students, of all academic backgrounds. Requirements Our Hospitality and Hotel Revenue Management Advanced Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 22 lectures • 07:08:00 total length •Module 01: Introduction to Hospitality Management: 00:24:00 •Module 02: An Overview of Hotel Industry: 00:18:00 •The Process of Selection and Recruitment in Hospitality Industry: 00:21:00 •The Process of Development and Training in Hospitality Industry: 00:24:00 •Module 05: Management of Front Office Operations: 00:19:00 •Management of Housekeeping, Engineering and Security Operations: 00:27:00 •Management of Food and Beverage Operations: 00:20:00 •Management of Service Quality in Hospitality Industry: 00:20:00 •Marketing in Travel and Tourism Business: 00:24:00 •Module 10: Accounting in Hospitality Industry: 00:26:00 •Module 11: Customer Satisfaction: 00:20:00 •Module 12: E-Hospitality and Technology: 00:22:00 •Module 1. Fundamentals of Hotel Revenue Management: 00:16:00 •Module 2. Importance of Revenue Management: 00:20:00 •Module 3. Key Performance Indicator in Revenue Management: 00:18:00 •Module 4. Forecasting of Hotel Revenue Management: 00:21:00 •Module 5. Pricing of Hotel Revenue Management: 00:22:00 •Module 6. Profitable Distribution Strategy: 00:07:00 •Module 7. Overbooking Practices in Hotel Revenue Management: 00:10:00 •Module 8. How to Promote your Hotel: 00:15:00 •Module 9. Customer and Other Essential Factors: 00:13:00 •Module 10. The Future of Hotel Revenue Management in UK: 00:21:00

Overview Train your dog all by yourself by learning about dog behaviour with our Training for Puppies course.Dogs are one of the friendliest animals. But occasionally they can behave a bit weird. Sometimes it can be hard to understand and train your dog properly. There is always a reason behind your dog's weird behaviour, and this Training for Puppies course will help you understand that reason. It will help you get inside your dog's head to understand what's causing their bad behaviour. This comprehensive learning package will teach you dog psychology, communication, and body language to decode what your dog is trying to say.Enrol today in our Training for Puppies course and build a stronger bond with your dog. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Training for Puppies. It is available to all students, of all academic backgrounds. Requirements Our Training for Puppies is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 5 sections • 18 lectures • 02:17:00 total length •Why Getting 2, 8 Week Old Parson Terrier Puppies Changed My Life And My Career!: 00:03:00 •This could be you!: 00:15:00 •Here's what you'll get from this course: 00:03:00 •That's the Puppy for Me! E-Book: 01:00:00 •You'll discover how to avoid first night crying in this video: 00:05:00 •Here's the best way to toilet train your puppy: 00:03:00 •**Bonus Video** Puppy toilet training questions answered: 00:11:00 •Find out how to stop your puppy from biting your hands and toes: 00:03:00 •How to stop your puppy from chewing your furniture and best items: 00:03:00 •In this video you'll find out the best way to socialize your puppy: 00:06:00 •How to prevent separation anxiety from developing in your puppy: 00:02:00 •In this video you'll learn how to crate train your puppy: 00:05:00 •During this video you'll see how to groom your puppy: 00:02:00 •In this video you'll learn about feeding your puppy: 00:02:00 •You'll discover how to stop your puppy from stealing your clothes in this video: 00:04:00 •Getting your puppy ready for a walk: 00:02:00 •Start leash work and recalling training now with your puppy - here's how!!: 00:04:00 •How to stop your puppy from eating poop!: 00:04:00

Overview This comprehensive course on Microsoft Excel: Master Power Query in 120 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Master Power Query in 120 Minutes! comes with accredited certification 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 Microsoft Excel: Master Power Query in 120 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 25 lectures • 02:25:00 total length •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Excel Power Query - Query Editor Ribbon: 00:09:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Transform Data - Split Text Fields in Excel Power Query: 00:10:00 •Transform Data - Group By in Excel Power Query: 00:03:00 •Transform Data - Unpivoting Columns in Excel Power Query: 00:05:00 •Transform Data - Pivoting Columns in Excel Power Query: 00:02:00 •Transform Data - Split Columns into Other Columns in Excel Power Query: 00:04:00 •Transform Data - Filtering Rows in Excel Power Query: 00:05:00 •Transform Data - Sorting Columns in Excel Power Query: 00:02:00 •Transform Data - Transform and Add Columns in Excel Power Query: 00:07:00 •From Folder - Import From Folder in Excel Power Query: 00:07:00 •From Folder - Doing Auto Cleanup in Excel Power Query: 00:13:00 •From Folder - Extract Data from Forms in Excel Power Query: 00:13:00 •From Workbook - Extract Multiple Criteria in Excel Power Query: 00:05:00 •From Workbook - Extract Multiple Worksheets in Excel Power Query: 00:04:00 •Joins - Intro to Joins: 00:04:00 •Joins - Merging: 00:08:00 •Joins - Full Outer Join: 00:06:00 •Joins - Right Anti Join: 00:09:00 •Power Query - Convert Reports into Pivot Tables: 00:05:00 •Modulo: 00:06:00

Overview Learn how to build road safety strategies by enrolling in our exclusively designed Transport Manager Complete Training Level 4 course.This course contains all the knowledge and information you need to plan and implement traffic management plans, providing you with the skills and attributes needed to succeed in the role.This course will teach you everything you need to know about transport infrastructure. After successful completion, you will have strongly developed skills to work for an operator to ensure it's vehicles are street-legal, and that all drivers comply with the traffic and driver hours rule. You will have the knowledge to increase performance, reduce operational cost and make safer highways. Pave your way towards a career in a reputed organisation by gaining an industry-recongised qualification. How will I get my certificate? At the end of the course there will be an online MCQ test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Transport Manager Complete Training Level 4. It is available to all students, of all academic backgrounds. Requirements Our Transport Manager Complete Training Level 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 4 sections • 18 lectures • 06:50:00 total length •Module 01: An Introduction to Successful Transport Management: 00:20:00 •Module 02: The UK's Travel Infrastructure - Road and Rail: 00:10:00 •Module 03: Road Freight and Transport Management: 00:30:00 •Module 04: Passenger Road Transport and its Management: 00:30:00 •Module 05: Rail and Transport Management: 00:15:00 •Module 06: Transport Management for Ports and Inland Waters: 00:15:00 •Module 07: Transport Management for Airlines: 00:10:00 •Module 08: Trends, Challenges and Best Practice in Transport Management: 00:10:00 •Module 09: Transport Management and Health and Safety: 00:10:00 •ECC TM EWM Shipment Integrated Scenario: 00:30:00 •SAP Transportation Domestic Scenario: 00:22:00 •SAP Transportation Management (TM) Integrated Scenario: 00:15:00 •TM Overview + End to End Process Flow: 00:43:00 •SAP TM Uncontrolled Shipment Scenario: 00:28:00 •SAP TM - Air Way bill ID Generation: 00:26:00 •Effective SAP TM for perfect order fulfillment!: 00:56:00 •Mock Exam - Transport Manager Complete Training Level 4: 00:20:00 •Final Exam - Transport Manager Complete Training Level 4: 00:20:00

Overview Improve your work and your writing dramatically by harnessing the untapped capabilities of Microsoft Word. Every writer and administrator uses Microsoft Word, but by taking this innovative course, you will learn how to use its many functions to your advantage. This MS Word Diploma course presents ways in which you can use extra functions built into Word to automate and invigorate your communications. You'll be taught how to use Mail Merge and customise the software to your specific requirements, making it easy to enhance and format letters or documentation. It could provide you with a revelation in terms of use and make Word an invaluable assistant. 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 MS Word Diploma. It is available to all students, of all academic backgrounds. Requirements Our MS Word Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 31 lectures • 03:58:00 total length •Navigate in Microsoft Word: 00:12:00 •Create and Save Word Documents: 00:24:00 •Manage Your Workspace: 00:06:00 •Edit Documents: 00:16:00 •Preview and Print Documents: 00:04:00 •Customize the Word Environment: 00:08:00 •Apply Character Formatting: 00:17:00 •Control Paragraph Layout: 00:19:00 •Align Text Using Tabs: 00:07:00 •Display Text in Bulleted or Numbered Lists: 00:03:00 •Apply Borders and Shading: 00:04:00 •Make Repetitive Edits: 00:06:00 •Apply Repetitive Formatting: 00:10:00 •Use Styles to Streamline Repetitive Formatting Tasks: 00:14:00 •Sort a List: 00:05:00 •Format a List: 00:06:00 •Insert a Table: 00:07:00 •Modify a Table: 00:06:00 •Format a Table: 00:03:00 •Convert Text to a Table: 00:04:00 •Insert Symbols and Special Characters: 00:04:00 •Add Images to a Document: 00:11:00 •Apply a Page Border and Color: 00:03:00 •Add Headers and Footers: 00:05:00 •Control Page Layout: 00:05:00 •Add a Watermark: 00:04:00 •Check Spelling Grammar and Readability: 00:07:00 •Use Research Tools: 00:06:00 •Check Accessibility: 00:03:00 •Save a Document to Other Formats: 00:04:00 •Assignment - MS Word Diploma: 00:05:00

Overview Learn fascinating facts and theories behind the criminal mind with our Forensic Psychology Course Level 3 Certificationcourse.Forensic psychology is a subfield of psychology involving criminal investigation and criminal psychology. Professional forensic psychologists must have intense research skills and excellent knowledge of criminology and the Criminal Justice System.This Forensic Psychology Course Level 3 Certification course will teach you the forensic psychologist's role, offenders' common traits, how eyewitness testimonies work, how to conduct psychological research, and much more. It will prepare you with the fundamental skills to kickstart your career in this field. ** Completing this course does not imply that you are qualified to work as a Practitioner Psychologist. If you are seeking a course that fits the HCPC's standards, please contact the HCPC or the RCSLT. ** 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 Forensic Psychology Course Level 3 Certification. It is available to all students, of all academic backgrounds. Requirements Our Forensic Psychology Course Level 3 Certification is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 25 lectures • 02:57:00 total length •Interventions to reduce risk of re-offending: 00:07:00 •History of development of Forensic Psychology: 00:06:00 •Research Design and Methodology: 00:12:00 •Critical evaluation of psychological research: 00:09:00 •What is Criminology: 00:10:00 •Understanding Crime: 00:10:00 •Classification and Measurement of Crimes: 00:10:00 •Characteristics of Offenders (Criminals): 00:05:00 •Introduction to theories of offending: 00:06:00 •Theories of sexual offending: 00:08:00 •Theories of violent offending: 00:08:00 •Theories of fire-setting behaviour: 00:08:00 •Personal characteristics of offenders: 00:06:00 •Personality disordered offenders: 00:06:00 •Psychopathic offenders: 00:07:00 •Mental Illness and offending: 00:07:00 •An Introduction to Offender Profiling: 00:05:00 •Approaches to Offender Profiling: 00:05:00 •The Effectiveness of Offender Profiling: 00:06:00 •Eye-witness testimony: 00:09:00 •Expert witness testimony: 00:04:00 •Attitudes towards victims: 00:06:00 •'What works' literature in reducing re-offending: 00:06:00 •Incident management (Crisis Negotiation): 00:08:00 •Introduction: About the Course and the Tutor: 00:03:00

Overview Don't listen to 'Fake News' and Conspiracy Theories. Learn the facts about Climate Change and how you can make a difference. This innovative course will enlighten and educate you with scientifically proven facts about the world's changing environment and the challenges ahead. The Solving Climate Change Problems with Renewable Energy course has been written with the assistance of industry professionals and is designed to give you the complete and verified details about Climate Change. You will be taught about current weather patterns and ongoing pollution concerns. The content also covers sustainable energy sources and the achievable goals that everyone should attempt. Know the truth and become 'greener' today. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Solving Climate Change Problems with Renewable Energy. It is available to all students, of all academic backgrounds. Requirements Our Solving Climate Change Problems with Renewable Energy is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 3 sections • 32 lectures • 19:25:00 total length •Introduction: 00:30:00 •What is Renewable Energy?: 00:30:00 •Types of Renewable Energy: 00:15:00 •Solar Power: 00:30:00 •Wind Power: 01:00:00 •Hydropower: 01:00:00 •Biofuel: 00:30:00 •The Possibilities of Renewable Energy: 01:00:00 •Government Incentives: 01:00:00 •Renewable Energy Is Key to Fighting Climate Change: 01:00:00 •Energy Audits: 01:00:00 •LEED: 01:00:00 •BREEAM: 01:00:00 •EPC: 01:00:00 •How to Choose Your Renewable Energy Sources: 01:00:00 •The Advantages and Disadvantages of Renewable Energy: 01:00:00 •Solar Geometry: 01:00:00 •Solar Chimney: 00:30:00 •Solar Wall: 00:30:00 •PV/Thermal: 00:10:00 •Solar Water Heaters: 00:30:00 •Solar Water Heaters: 00:30:00 •Solar Photovoltaic Technology Basics: 00:30:00 •Other Energy Saving Technologies: 00:15:00 •Underground Thermal Energy Storage (UTES): 00:15:00 •Trigeneration / CCHP: 00:15:00 •Rainwater Harvesting: 00:15:00 •Fuel Cell: 00:45:00 •Earth Duct: 00:15:00 •Light Pipe: 00:15:00 •Conclusion: 00:15:00 •Assignment - Solving Climate Change Problems with Renewable Energy: 00:00:00

Overview Learn how to sort out your finances and negotiate excellent property deals by enrolling in our professionally designed Property Negotiation Diploma course. This course offers a wide array of training modules, designed to teach you how to act on clients' best interests by negotiating sales prices. This course provides you with the knowledge to kickstart your career as a property negotiator. After course completion, you will be able to update property listings, locate a property for sale, and oversee leasing activities. You will have the skills to conduct effective market research and update clients about market conditions to maintain and expand your client base. 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 Property Negotiation Diploma. It is available to all students, of all academic backgrounds. Requirements Our Property Negotiation Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 32 lectures • 15:40:00 total length •What is Estate Agent: 00:15:00 •Requirements for the Job: 00:20:00 •History of the Estate Agent: 00:20:00 •The Real Estate Industry: 00:15:00 •Different Types of Estate Agents: 00:15:00 •Online Estate Agents: 00:20:00 •Estate agent Fees and Contracts: 00:30:00 •Pros and Cons of Hiring an Estate Agent: 00:20:00 •Getting to Know Your Clients: 00:20:00 •A Day in the Life of an Estate Agent: 00:15:00 •Selling Property with an Estate Agent: 00:15:00 •Property Marketing: 00:15:00 •The Regulations for Estate Agent Boards and Why It is Important: 00:15:00 •Valuation: 00:20:00 •Performing Viewings: 00:15:00 •Negotiating: 00:30:00 •Buying with an Estate Agent: 00:20:00 •Sales Progression: 00:30:00 •Technology: 00:25:00 •Investment Property: 00:40:00 •About Letting Agents: 00:25:00 •Property Management: 00:15:00 •Laws and Regulations: 00:30:00 •How to Set Up an Estate Agency: 00:15:00 •Property Development and the Process: 00:35:00 •Main Actors and Economic Context: 01:20:00 •Land for Development: 02:00:00 •Making Decisions: 00:20:00 •Sorting Out Your Finances: 00:30:00 •Establishing Your Business: 00:20:00 •Market Research: 01:15:00 •Promotion and Selling: 01:00:00

Overview This comprehensive course on Microsoft Excel: Excel Sheet Comparison with VBA will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Excel Sheet Comparison with VBA comes with accredited certification 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 Microsoft Excel: Excel Sheet Comparison with VBA. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Excel Sheet Comparison with VBA is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 23 lectures • 02:10:00 total length •Introduction to Compare Data Workbook: 00:06:00 •Download Resources: 00:00:00 •Key requirements for Comparing any Datasets or Worksheets: 00:03:00 •Tool to Compare Datasets or Worksheets: 00:06:00 •Overview of Compare Data Workbook: 00:09:00 •Most Important things to remember before you use compare data workbook: 00:03:00 •IMPORTANT - First Column as KEY Column with UNIQUE Values: 00:09:00 •Deep Dive into Compare Data Workbook's Environment: 00:10:00 •How to Change Header Rows for your data: 00:06:00 •Basics of Using macro enabled Excel files and Code Modules: 00:04:00 •Changing the Main two sheets name, variance tags in VBA Code: 00:05:00 •Changing various elements across VBA Code modules: 00:05:00 •Clear Sheet data button VBA Code: 00:04:00 •Convert Row data into Structured, clean and formatted data with Power Query 1: 00:07:00 •Convert Row data into Structured, clean and formatted data with Power Query 2: 00:07:00 •Mutual Funds Portfolio - Finding Variances at two different times: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 1: 00:05:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 2: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 3: 00:08:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 4: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 5: 00:08:00 •IMPORTANT Facts and Limitation of Compare Data Workbook: 00:03:00 •Conclusion: 00:01:00