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

1908 Secretarial & PA courses delivered Online

Accounting and Finance Diploma

5.0(10)

By Apex Learning

Overview Become confident and assured in managing the finances of your company or any fiscal task that is assigned to you. This comprehensive course will take your existing account managing skills to the next level and educate you in more advanced processes and abilities. The Accounting and Finance Diploma course provides a masterclass in the methods of cash flow control, investment appraisals, budget deliberation, and crucial decision making. Every monetary-linked commerce choice that needs to be made will benefit from the knowledge that you have gained right here. Make sure your career and business are financially sound by enrolling now. 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 Accounting and Finance Diploma. It is available to all students, of all academic backgrounds. Requirements Our Accounting and Finance 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 5 sections • 24 lectures • 01:18:00 total length •Chris Moore - Accounting: 00:01:00 •Chris Moore - 1. Introduction: 00:03:00 •Chris Moore - 2. First Transactions: 00:05:00 •Chris Moore - 3. T Accounts introduction: 00:03:00 •Chris Moore - 4. T-Accounts conclusion: 00:03:00 •Chris Moore - 5. Trial Balance: 00:02:00 •Chris Moore - 6. Income Statement: 00:03:00 •Chris Moore - 7. Balance Sheet: 00:03:00 •Chris Moore - 8. Balance Sheet Variations: 00:03:00 •Chris Moore - 9. Accounts in practise: 00:05:00 •Chris Moore - 10. Balance Sheets what are they: 00:05:00 •Chris Moore - 11. Balance Sheet Level 2: 00:03:00 •Chris Moore - 12. Income Statement Introduction: 00:06:00 •Chris Moore - 13. Are they Expenses, or Assets: 00:03:00 •Chris Moore - 14. Accounting Jargon: 00:02:00 •Chris Moore - 15. Accruals Accounting is Fundamental: 00:03:00 •Chris Moore - 16. Trial Balance 3 days ago More: 00:04:00 •Chris Moore - 17. Fixed Assets and how it is shown in the Income Statement: 00:03:00 •Chris Moore - 18. Stock movements and how this affects the financials: 00:03:00 •Chris Moore - 19. Accounts Receivable: 00:03:00 •Chris Moore - 20. How to calculate the Return on Capital Employed: 00:05:00 •Chris Moore - 21. Transfer Pricing - International Rules: 00:02:00 •Handout - Accounting and Finance Diploma: 00:00:00 •Assignment - Accounting and Finance Diploma: 00:05:00

Accounting and Finance Diploma
Delivered Online On Demand1 hour 18 minutes
£12

Level 5 Diploma in Veterinary Assistant

5.0(10)

By Apex Learning

Overview Turn your love of animals towards a role that can help save and preserve their lives by training in Vet Assistant practises. This Level 5 Diploma in Veterinary Assistant course will teach you to join emotional and practical skills, and be able to work in a Vet surgery or animal shelter. The collection of learning modules that will be made available is designed to tutor you in a wide range of skills. You will learn how to handle all types of pets and animals safely, understand their nutritional needs and behaviour, work with a professional Vet, react in medical emergencies, and counsel worried owners. 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 Level 5 Diploma in Veterinary Assistant. It is available to all students, of all academic backgrounds. Requirements Our Level 5 Diploma in Veterinary Assistant 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 • 26 lectures • 18:40:00 total length •Module 01: The Development of Veterinary Medicine: 01:30:00 •Module 02: Naming And Classifying Animals: 00:20:00 •Module 03: The Cell: 00:45:00 •Module 04: Tissues: 01:00:00 •Module 05: Connective Tissue: 01:00:00 •Module 06: Muscle Tissue and Nervous Tissue: 00:20:00 •Module 07: Tissue Healing And Repair: 00:30:00 •Module 08: The Skin: 00:35:00 •Module 09: Bone: 00:40:00 •Module 10 : The Skeleton: 00:35:00 •Module 11: Describing Disease Occurrence: 01:30:00 •Module 12: Cardiovascular System: 01:00:00 •Module 13: Respiratory System and Lymphatic System: 00:35:00 •Module 14: The Gut and Digestion: 00:45:00 •Module 15: Urinary System and Reproductive System: 01:00:00 •Module 16: Nervous System, Senses and Endocrine System: 01:00:00 •Module 17: Nutrients: 01:00:00 •Module 18: Metabolism: 01:00:00 •Nervous System, Senses and Endocrine System Part - 01: 00:37:00 •Nervous System, Senses and Endocrine System Part - 02: 00:36:00 •Nervous System, Senses and Endocrine System Part - 03: 00:22:00 •Nutrients Part 1: 00:31:00 •Nutrients Part 2: 00:30:00 •Metabolism Part 1: 00:29:00 •Metabolism Part 2: 00:30:00 •Assignment - Level 5 Diploma in Veterinary Assistant: 00:00:00

Level 5 Diploma in Veterinary Assistant
Delivered Online On Demand18 hours 40 minutes
£12

Forensic Psychology Course Level 3 Certification

5.0(10)

By Apex Learning

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

Forensic Psychology Course Level 3 Certification
Delivered Online On Demand2 hours 57 minutes
£12

Overview of Oil and Gas Industry

5.0(10)

By Apex Learning

Overview This comprehensive course on Overview of Oil and Gas Industry will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Overview of Oil and Gas Industry 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 Overview of Oil and Gas Industry. It is available to all students, of all academic backgrounds. Requirements Our Overview of Oil and Gas Industry 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 12 sections • 34 lectures • 01:55:00 total length •Introduction: 00:02:00 •Oil in our economic life - Introduction: 00:02:00 •The role of oil in our economic life: 00:03:00 •Centers of production and demand: 00:02:00 •Exploration risks: 00:01:00 •The importance of capital investment: 00:03:00 •Associations between companies: 00:01:00 •The concentration of production: 00:01:00 •The beginnings of the oil industry: 00:04:00 •The Rockefeller era: 00:05:00 •The development of the oil industry: 00:02:00 •The world oil order before 1960: 00:02:00 •The formation of OPEC and the 2 oil shocks: 00:07:00 •The consequences of the 2 oil shocks: 00:03:00 •The 1986 oil counter shock: 00:05:00 •The Gulf Crisis: 00:02:00 •The current situation: 00:06:00 •Energy equivalence: 00:05:00 •The world energy balance: 00:04:00 •Regional energy balances: 00:01:00 •Energy consumption and wealth: 00:03:00 •Energy consumption and price: 00:02:00 •Energy consumption forecast: 00:06:00 •Energy resources: 00:06:00 •The historical development: 00:05:00 •The current position: 00:03:00 •Future prospects: 00:01:00 •The production of natural gas: 00:02:00 •The consuming countries: 00:04:00 •OPEC: 00:07:00 •The major oil companies: 00:09:00 •Facts and figures: 00:03:00 •Facts and figures: 00:02:00 •Conclusion: 00:01:00

Overview of Oil and Gas Industry
Delivered Online On Demand1 hour 55 minutes
£12

Football Coach

5.0(10)

By Apex Learning

Overview This comprehensive course on Football Coach will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Football Coach 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 Football Coach. It is available to all students, of all academic backgrounds. Requirements Our Football Coach  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 9 sections • 45 lectures • 02:24:00 total length •Introduction: 00:01:00 •FIFA Structure: 00:02:00 •Coach Salary: 00:05:00 •Coach Type: 00:03:00 •UEFA Coaching Licenses: 00:05:00 •Sports Degree: 00:04:00 •Where to Start?: 00:01:00 •Performance Components in Football: 00:02:00 •How to Coach: Considering Different Methodologies: 00:05:00 •Tactical Periodization Principles: 00:06:00 •Headers: 00:02:00 •Ball Protection: 00:02:00 •Introduction into Nutrition in Football: 00:01:00 •Why Study Nutrition?: 00:03:00 •Energy Intake: 00:02:00 •Carbohydrates: 00:03:00 •Carbohydrates: Amount and Timing: 00:04:00 •Fats: 00:03:00 •Proteins: 00:04:00 •Micronutrients: Overview: 00:01:00 •Minerals: 00:06:00 •Vitamins and Water: 00:03:00 •Counteracting Heat, Cold, High Altitude, Jet Lag: 00:03:00 •Dietary Supplements for Football: 00:05:00 •Football and Alcohol: 00:03:00 •Football and Alcohol: 00:03:00 •Why HIIT?: 00:03:00 •Definition and History: 00:02:00 •Physical Components: 00:05:00 •Rate of Perceived Exertion (RPE): 00:02:00 •Maximal Aerobic Speed (vVO2max): 00:03:00 •Heart Rate (HR): 00:05:00 •30-15 Intermittent Fitness Test (30-15 IFT): 00:03:00 •HIIT Target Types: 00:03:00 •Long Intervals: 00:02:00 •Short Intervals: 00:05:00 •Repeated-Sprint Sequence (RSS): 00:03:00 •Sprint Interval Training (SIT): 00:01:00 •Game Based HIIT (GBHIIT): 00:04:00 •Game Based HIIT Recap: 00:04:00 •Putting It All Together: 00:01:00 •Motivation: 00:04:00 •Leadership and Communication: 00:06:00 •Conclusion and References: 00:06:00 •Assignment -Professional Football Coach Training: 00:00:00

Football Coach
Delivered Online On Demand2 hours 24 minutes
£12

Electrician

5.0(10)

By Apex Learning

Ready to power up your career? Join our Electrician course to learn everything from basic electricity to circuit analysis. Get certified and step into a rewarding profession! Enroll now!

Electrician
Delivered Online On Demand3 hours
£12

Health Awareness and Social Care Training

5.0(10)

By Apex Learning

Overview Enrol in our Health Awareness and Social Care Training today and build the necessary skills, knowledge and experience to transform your career. The Health Awareness and Social Care Training could enhance your continuing professional development thus propelling you more towards your dream job. This Health Awareness and Social Care Training could be your key, if you are interested in a long term career in the field of Health Awareness and Social Care Training. This Health Awareness and Social Care Training course consists of a number of easy to digest, in-depth modules which are designed to provide you with detailed knowledge on Health Awareness and Social Care Training. This Health Awareness and Social Care Training aims to accompany you through your journey to help you become a master of Health Awareness and Social Care Training. Learn through a mixture of interactive lessons and online study materials. 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 Health Awareness and Social Care Training. It is available to all students, of all academic backgrounds. Requirements Our Health Awareness and Social Care Training 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 • 13 lectures • 07:21:00 total length •Module 1: Introduction to Health and Social Care: 00:19:00 •Module 2: Communication and its Relevance: 00:42:00 •Module 3: Rights and Responsibilities as a Health and Social Care Worker: 00:38:00 •Module 4: Role as A Caregiver and Healthcare Professional: 00:26:00 •Module 5: Working in Health and Social Care; Promoting Equality, Diversity and Rights: 00:49:00 •Module 6: Important Principles and Policies in Health and Social Care Work: 00:23:00 •Module 7: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1: 00:50:00 •Module 8: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 2: 00:48:00 •Module 9: Safeguarding Vulnerable Individuals: 00:52:00 •Module 10: Health and Safety Responsibilities: 00:51:00 •Module 11: Risk Management in Health and Social Care: 00:03:00 •Mock Exam - Health Awareness and Social Care Training: 00:20:00 •Final Exam - Health Awareness and Social Care Training: 00:20:00

Health Awareness and Social Care Training
Delivered Online On Demand7 hours 21 minutes
£12

Logistics and Supply Chain Management

5.0(10)

By Apex Learning

Overview Learn effective business research methods and develop a more productive supply chain to enhance profitability, by enrolling in our exclusively designed Logistics and Supply Chain Management course.This course will equip you with strong management skills to supervise storage and distribution of goods in a company, and handle industrial challenges and trends to ensure business profitability and customer satisfaction.All successful companies demand skilled supply managers for generating large product volumes on time, using cost-effective techniques. After your successful completion, you will be far more capable of using logistics while making lucrative decisions, matching the operations to established budgets, tracking the transfer process of supplies, materials, and more. Make sure you're ready to manage supply chains during a time of crisis. 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 Logistics and Supply Chain Management. It is available to all students, of all academic backgrounds. Requirements Our Logistics and Supply Chain Management 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 • 25 lectures • 14:20:00 total length •Course Overview: 00:05:00 •Getting Started: 00:15:00 •The Evolution of the Supply Chain: 00:15:00 •The Basic Supply Chain Structure: 00:15:00 •Supply Chain Drivers: 00:15:00 •Aligning Your Supply Chain with Business Strategy: 00:15:00 •Managing Supply Chain Risks: 00:15:00 •Tracking and Evaluating Supply Chain Data: 00:30:00 •Troubleshooting Supply Chain Problems: 00:15:00 •Sharing Supply Chain Activities: 00:15:00 •Sustainable Supply Chain Strategies: 00:15:00 •Applying Lean Techniques to the Supply Chain: 00:15:00 •The Future of Supply Chain Management: 00:15:00 •Module One - Getting Started: 00:30:00 •Module Two - Understanding Lean: 01:00:00 •Module Three - Liker's Toyota Way: 01:00:00 •Module Four - The TPS House: 01:00:00 •Module Five - The Five Principles of Lean Business: 01:00:00 •Module Six - The First Improvement Concept (Value): 01:00:00 •Module Seven - The Second Improvement Concept (Waste): 01:00:00 •Module Eight - The Third Improvement Concept (Variation): 01:00:00 •Module Nine - The Fourth Improvement Concept (Complexity): 01:00:00 •Module Ten - The Fifth Improvement Concept (Continuous Improvement): 01:00:00 •Module Eleven - The Improvement Toolkit: 00:30:00 •Module Twelve - Wrapping Up: 01:00:00

Logistics and Supply Chain Management
Delivered Online On Demand14 hours 20 minutes
£12

Life Coach Certificate

5.0(10)

By Apex Learning

Overview Gain excellence in interpersonal communication and fast-track your career towards success by attending the Life Coach Certificate course. The course offers interactive study materials of coaching fundamentals and additional constructive ideas that will develop your leadership skills and make you a witty professional. Being a coach requires diverse talent to possess. Our expert educator will also train you in implementing the acquired skills effectively. 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 Life Coach Certificate. It is available to all students, of all academic backgrounds. Requirements Our Life Coach Certificate 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 • 21 lectures • 07:46:00 total length •Module 01: Introduction to Life Coaching: 01:00:00 •Module 02: History of Life Coaching: 00:10:00 •Module 03: Listening as a Coach: 00:30:00 •Module 04: The Language of Coaching: 01:00:00 •Module 05: Coaching as a Developmental Change Process: 00:45:00 •Module 06: Empowering the Client: 01:00:00 •Module 07: Ethics in Coaching: 00:50:00 •Module 08: Becoming an Effective Leader and Coach: 00:20:00 •Introduction : Let's begin the journey to true love!: 00:09:00 •Mindfulness Practice 01 : Breath- a doorway to freedom!: 00:13:00 •Meditation 02 : Are you ready to fall in love with your body as a sacred temple?: 00:13:00 •Practice 03 : Discover the mystery of the present through sensation tracking: 00:13:00 •Practice 04- If you like freedom this practice is for you!: 00:10:00 •Practice 05 : Opening to the Secret of the Magical Pause: 00:11:00 •Practice 06 : Lining Up Your Speech with Integrity: 00:09:00 •Practice 07 : Dropping Down Into the Mystery of the Golden Realms: 00:09:00 •Practice 08- A Return to the Bliss of Self-Love: 00:07:00 •Now You're Ready to Dive Into Practice - A Review of it All: 00:04:00 •Bonus- Relating to Family In Present Time - Yes you can do it!: 00:02:00 •Guided Meditation- 'Open Your Heart & Experience Unconditional: 00:16:00 •Guided Meditation- 'The Awakened Body': 00:15:00

Life Coach Certificate
Delivered Online On Demand7 hours 46 minutes
£12

Microsoft Excel: Excel Sheet Comparison with VBA

5.0(10)

By Apex Learning

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

Microsoft Excel: Excel Sheet Comparison with VBA
Delivered Online On Demand2 hours 10 minutes
£12