3540 Courses delivered Online

Overview Social crimes disrupt the well-being and harmony of our society and threaten the safety of the people within it. Learn how to raise awareness against social crimes and do your part as a member of society with our Social Crime Awareness Training course. This course aims to provide you with an in-depth understanding of social crimes. Here, you will learn about different types of social crimes witnessed in our society. Then, the course will increase your knowledge of criminal behaviour, crime reporting and victim support. Furthermore, you will learn the strategies for crime prevention and raising awareness.  At the end of the course, you will receive a certificate of achievement. This certificate will help you pursue a career in the relevant sectors. So enrol now and start developing your skills! Course Preview Learning Outcomes Understand what is social crime and its types Enhance your knowledge of criminal behaviour Learn how to report crimes and offer support to the victims Develop the ability to conduct crime prevention and awareness campaigns Get introduced to the new trends in social crimes Deepen your understanding of rehabilitation and reintegration of offenders Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Reporting crimes Victim support Prevention Awareness building Who Should Take This Social Crime Awareness Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Social Crime Awareness Training course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Social Crime Awareness Training Certification After completing and passing the Social Crime Awareness Training course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Social Crime Awareness Training will equip you with effective skills and abilities and help you explore career paths such as  Criminologist Police Officer Victim Support Worker Community Outreach Coordinator Policy Analyst Module 01: Introduction to Social Crime Introduction to Social Crime 00:18:00 Module 02: Types of Social Crimes Types of Social Crimes 00:13:00 Module 03: Crime and Vulnerable Populations Crime and Vulnerable Populations 00:15:00 Module 04: Understanding Criminal Behaviour Understanding Criminal Behaviour 00:16:00 Module 05: Reporting Crimes and Victim Support Reporting Crimes and Victim Support 00:16:00 Module 06: Crime Prevention and Awareness Campaigns Crime Prevention and Awareness Campaigns 00:16:00 Module 07: International Perspectives on Social Crime International Perspectives on Social Crime 00:16:00 Module 08: Emerging Trends in Social Crime Emerging Trends in Social Crime 00:15:00 Module 09: Rehabilitation and Reintegration of Offenders Rehabilitation and Reintegration of Offenders 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Emergencies happens everyday and everywhere. Their responses require a dynamic and unique set of skills. Lives hang in the balance. Safety is the bottom-line. If an exciting and extraordinary career is what you're looking for, and if you want to contribute to society in a meaningful way, the Emergency Management Course will give you the opportunity to be the best you can be. Enter the exciting and growing field of Emergency Management. This course is a comprehensive, distance delivered course that will provide you with a fundamental understanding of the opportunities and challenges in this dynamic, rapidly growing field. Practitioners in this area need to have both theoretical knowledge and practical skills in order to effectively mitigate against the risk of harm or loss for industry, public sector, community, individuals and government. You'll tackle risk assessment theory, terrorism, mitigation/prevention, response and recovery techniques. At the end of the day, your career will be a defining part of who you are. Manage your future today. Certification: After completing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Level 2 Certificate in Emergency Management is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Level 2 Certificate in Emergency Management is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Welcome FREE 00:03:00 Meet your trainers 00:04:00 Is this course for you 00:04:00 Workbook 00:00:00 Potential Emergencies for Venues Emergency Planning, identification and Analysis. Plus Fire Emergen 00:05:00 Bomb Threats 00:05:00 Active Shooter and Terrorism 00:03:00 Crowd Related Emergencies 00:02:00 Emergency Control Organisation ECO Considerations 00:06:00 Emergency Response Procedures Notification, Communication, Control, Response, Evacuation 00:08:00 Human Behaviour and Children 00:05:00 Lifts and Escalators, Media, People with Disabilities 00:04:00 Personal Effects, Emergency Colour Codes, Recovery 00:01:00 Warden Skills Leadership and Communication in Emergencies 00:05:00 Being Calm Under Pressure and Situational Awareness 00:01:00 Tactical Decision Games, Drills and Exercises 00:09:00 Wrap Up Wrap Up 00:01:00 Course Certification Order Your Certificate 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Life Coaching | Online Course Do you feel the spark to guide other people? Do you need more skills to help people meet their goals confidently? Step into life coaching with our dynamic 'Life Coaching Online Course.' With an average life coach salary ranging from £30,000 to £60,000 per year in the UK, this field offers personal fulfilment and financial reward. Our Life Coaching Online Course course goes beyond the basics. This course talks about psychology and strategies for effective coaching. You'll learn how to utilise neuro-linguistic programming (NLP) to unlock your potential and that of your clients. Besides, you will discover the secrets to managing fears and embracing change, a highly sought-after skill in today's fast-paced world. Life coaches are typically the masters of emotional intelligence. Therefore, this course sheds light on emotional intelligence and communication techniques.  After completing the Life Coaching Online Course, you'll be able to understand and influence others more effectively, enhancing both your personal and professional relationships. Furthermore, this Life Coaching Online Course will assist you in mastering the art of body language and communication techniques and refine your listening skills to understand clients' moods, thoughts, and intentions. Whether you're looking to start a new career as a life coach, enhance your existing coaching skills, or improve your life and those around you, this course is the perfect starting point.  Enrol in the Life Coaching Online Course course and become part of the ever-expanding community of life coaches making a significant impact in the UK and beyond. Learning Outcomes Acquire a comprehensive knowledge of life coaching fundamentals, including NLP technology. Develop and apply enhanced self-awareness to understand personal strengths and weaknesses. Master skills to support clients in overcoming fears and embracing change. Gain expertise in Emotional Intelligence, communication techniques, and body language. Learn ethical coaching practices and principles for business development and client goal setting. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 01: Life Coaching: The Purpose and Fundamentals Life Coaching: The Purpose and Fundamentals 00:50:00 Module 02: Develop Your Self-Awareness Develop Your Self-Awareness 00:54:00 Module 03: The Development of Core Beliefs and Managing Fears The Development of Core Beliefs and Managing Fears 00:49:00 Module 04: Life Coaching Types and Key Attributes of a Life Coach Life Coaching Types and Key Attributes of a Life Coach 01:02:00 Module 05: Understanding Emotional Intelligence Understanding Emotional Intelligence 00:46:00 Module 06: Body Language and Communication Techniques Body Language and Communication Techniques 00:46:00 Module 07: A Structure for Client Work and Goal Setting A Structure for Client Work and Goal Setting 00:40:00 Module 08: Basic Principles for Business Development and Growth Basic Principles for Business Development and Growth 00:56:00 Module 09: The Ethical Coach: Protect Yourself and Your Clients The Ethical Coach: Protect Yourself and Your Clients 00:50:00

CPD QS Accredited | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Corporate management personnel often are not aware that internal auditors have standards and guidelines defined by the profession. Internal Audit (IA) is not always seen as those who must follow established professional standards. Internal auditors don't have a “license to practice”. So why do we need Standards? A value oriented IA function will have an understanding of the International Professional Practices Framework (IPPF) Standards and be able to articulate their importance to management. Absence of acknowledgement of the Standards infers the group is a quality assurance function. That may be what the organization wants, but they should be able to differentiate. Learning Objectives Explore the mission of Internal Audit (IA) as defined by the Institute of Internal Auditors (IIA) Explore the Mandatory Guidance and core principles as identified by the Institute of Internal Auditors Standards Explore the IA Code of Ethics as defined by the Institute of Internal auditors Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction and Overview Introduction to Institute of Internal Auditors Standards Part One 00:04:00 Internal Audit Mission 00:09:00 Principles Core Principles 00:05:00 Principle Competence and Due Care 00:12:00 Competence Alternatives 00:08:00 Principle: Objective and Free from Undue Influence 00:15:00 Principle: Positioning and Resourcing 00:09:00 Alternatives Alternative Resourcing 00:11:00 Alternative Positioning 00:11:00 Definition of IA Alternatives 00:10:00 Ethics and Standards Ethics Rules of Conduct 00:08:00 IPPF Standards 00:05:00 Supplementary Resources Supplementary Resources - Internal Audit Standards Overview 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction to Fully Theory of a Lash Lift & Brow Lamination Introduction 00:02:00 FAQ of Clients: What Is a Lash Lift and How Does It Work 00:03:00 FAQ of Clients: What Is a Brow Lamination and How Does It Work 00:02:00 FAQ of Clients: Lash or Brow Lift Harmful or Side Effects 00:01:00 FAQ of Clients: What are the Risks That Might Occur During the Procedure 00:02:00 Contraindications of a Lash and Brow Lift 00:03:00 Hygiene Standards: Workplace 00:01:00 Hygiene Standards: Personal Hygiene 00:01:00 Hygiene Standards: Working Materials 00:01:00 Hygiene Standards: Cleaning the Lash Lift Silicon Pads correctly 00:02:00 How to find whether a client has an allergy to the products used 00:02:00 How to do a Skinpatch Test 00:02:00 What to do When Clients get the products into their eyes 00:01:00 Aftercare of a Lash and Brow Lift 00:01:00 Pricing: How Much Should I Charge Clients for The Treatments 00:01:00 DIY Lash and Brow Lift Warnings 00:02:00 Practice: Lash Lift & Brow Lamination How to do a Brow Lamination and tint the Brows professionally 00:09:00 How to do a Lash Lift and Tint the Lashes Professionally 00:13:00 Supplementary Resources Supplementary Resources - Makeup Artistry Basic to Masterclass , Online Makeup Course 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

🌟 Unlock Success in the Workplace with Mastering Workplace Communication through Active Listening! 🌟   Are you looking to propel your career to new heights? Enhance your professional relationships? Elevate your communication skills to stand out in today's competitive workplace? Welcome to our transformative online course: 'Mastering Workplace Communication through Active Listening.' In this comprehensive program, you will embark on a journey that goes beyond traditional communication methods. Active listening is the cornerstone of effective communication, and this course is designed to equip you with the essential skills to become a master communicator.   🚀 What You'll Gain: Enhanced Communication Proficiency: Learn the art of active listening, enabling you to understand others deeply, fostering trust and cooperation. Improved Interpersonal Relationships: Build stronger connections with colleagues, supervisors, and clients, leading to more productive and harmonious collaborations. Conflict Resolution Expertise: Acquire conflict resolution strategies by listening actively, diffusing tensions, and reaching mutually beneficial resolutions. Career Advancement Opportunities: Stand out in your professional sphere by showcasing superior communication skills, leading to promotions and recognition. Boosted Team Performance: Foster a positive work environment by cultivating listening skills, resulting in increased team productivity and efficiency. 🔑 Course Highlights: Engaging Modules: Dive into interactive modules filled with practical exercises, real-life scenarios, and quizzes to reinforce your learning. Expert-Led Instruction: Learn from industry experts who will guide you through proven techniques and strategies for effective communication. Accessible Anytime, Anywhere: Enjoy the convenience of learning at your own pace, fitting lessons seamlessly into your busy schedule. Peer Interaction: Engage with a community of like-minded individuals, sharing experiences and insights to enhance your learning journey.   🎓 Who Should Enroll: Professionals seeking to excel in their careers by mastering communication skills. Team leaders, managers, and supervisors aiming to create cohesive and productive work environments. Individuals aspiring to build stronger personal and professional relationships through effective communication.   🌟 Enroll Now and Empower Your Communication Skills Today! 🌟 Invest in yourself and your future success by enrolling in 'Mastering Workplace Communication through Active Listening.' Join countless professionals who have transformed their careers through effective communication. Don't miss this opportunity to unlock your full potential in the workplace! Sign up now to gain immediate access and start your journey toward becoming a master communicator! Course Curriculum INTRODUCTION Promo Video - Listening Skills The Ultimate Workplace Soft Skills 00:00 LISTENING TACTICS & STRATEGIES Quick Wins - The Cell Phone Secret to Good Listening Skills 00:00 Stacking the Listening Environment in Your Favor 00:00 The Telephone Listening Trap Will Never Catch You Again 00:00 Housekeeping Note Sometimes You should Turn OFF Your Listening Skills 00:00 Setting Just One Agenda Item Listening 00:00 It Is Incredibly Easy to See How Well You Are Listening - Test 00:00 It's Even Easier to Listen When You Do This 00:00 Technology Will Eat Your Brain Unless You Do This 00:00 Using Your Most Effective Body Language Tool 00:00 The Best Listening Body Language From the Neck Down 00:00 Reading the Speaker's Body 00:00 Connecting At the Emotional Level with Your Colleague To Hear All 00:00 Mastering the Art of NOT Interrupting 00:00 Asking for Clarification Is A Great Form of Listening 00:00 Engaging in Conversation at Just the Right Time 00:00 Strong Listening Creates Strong Reactions From You 00:00 Honing Your Sense of Timing and Judgment to Make You a Great Listener 00:00 Using The Magic of Pen and Paper Tools to Your Advantage 00:00 Summarizing the Conversation Is Great for You and Your Colleague 00:00 The One-Page Email Memo Summary Aces the Listening Skills Test - Every Time! 00:00 CONCLUSION Conclusion - Your New Reputation As a Great Listener! 00:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Welcome Floral Design for Beginners Introduction 00:02:00 The difference between Floral Design and Flower Arranging 00:01:00 Checkpoint Challenge 00:00:00 Tools of Trade Supplies 00:03:00 Water and Additives 00:02:00 Scissor sharpening 00:01:00 Pin Frogs: Silly Name, Extremely Useful 00:01:00 Tools of the Trade Summary 00:00:00 Color is a Science. Color Choices are Driven By Emotion Emotional Expressions Through Color 00:03:00 Monochromatic Colors Unify 00:07:00 Complementary Colors Are… Well, Complimentary 00:11:00 Color is a Science Summary 00:00:00 Balance and Perspective: Visual Mass, Physical Weight and Placement Understanding Visual Mass and Physical Weight 00:03:00 Balance and Perspective Summary 00:00:00 Memorable Arrangements Contain 4 Floral Styles Line, Focal, Mass, and Filler Elements 00:05:00 Memorable Arrangements Summary 00:00:00 Containers: An Integral Part of Your Story Containers Summary 00:00:00 Supplementals Knowing When to Stop 00:04:00 Supplementals Summary 00:00:00 The Secret Sauce: Personalization Twist It! 00:13:00 Career Opportunities 00:08:00 Growing Your Business Summary 00:00:00 What Have You Learned? Learning When to Stop 00:00:00 Top 10 Floral Design Tips Top 10 Tips for Floral Designers 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum The Basics - Electrical Circuit Fundamentals Welcome and Introduction 00:03:00 Voltage Current Resistance 00:04:00 What Every Circuit Needs 00:01:00 What Every Circuit Needs - Applied to a Schematic 00:02:00 Power Load and Ground - Can it Be this Easy 00:02:00 Power Load and Ground - Explained Using a Schematic 00:02:00 Diagnostic Basics and Circuit Types Diagnosing an Inoperative Circuit 00:02:00 Four Types of Faults 00:12:00 Series and Parallel Circuit Differences - Review 00:06:00 Series Circuit Voltmeter Worksheet 00:02:00 Series Circuit - Voltage Reading Explained 00:17:00 Parallel Circuit Voltmeter Worksheet 00:01:00 Parallel Circuit - Voltage Readings Explained 00:10:00 Series Schematic Variations 00:05:00 Diagnosing Faults Using Schematics Schematic Wiring Differences 00:02:00 Brake and Park Lamp Schematic 00:01:00 Brake and Park Lamp - Fault 1 00:06:00 Brake and Park Lamp - Fault 2 00:03:00 Horn Schematic - Description and Operation 00:05:00 Horn Schematic - Additional Schematic Details 00:13:00 Horn Schematic - My Horn sounds like a Sick Cow 00:08:00 Horn Schematic - Horn Inoperative 00:07:00 Horn on All the Time 00:07:00 Thank You and Next Steps 00:02:00 Supplementary Resources Supplementary Resources - Automotive Electrical Diagnosis - Beginner 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

🌟 Unlock the Full Power of Microsoft Excel 2019! 🌟 Ready to take your Excel skills to the next level? Dive into our comprehensive online course - 'Microsoft Excel 2019 - Advanced Level Training' - designed to transform you into an Excel maestro! 🚀 Here's What You'll Master: 📊 Section 1: Excel - Advanced - Get hands-on with advanced techniques and shortcuts to streamline your workflow. 📂 Section 2: Working with Multiple Workbooks - Seamlessly manage multiple workbooks and boost your productivity effortlessly. 🔒 Section 3: Protecting Worksheets and Workbooks - Learn how to safeguard your data with robust protection strategies. 📝 Section 4: Conditional Formulas - Unravel the power of conditional logic and unleash the true potential of formulas. 🧮 Section 5: Advanced Functions - Elevate your Excel expertise by mastering complex functions for data analysis. 📚 Section 6: Text Based Functions - Manipulate text effortlessly and efficiently with advanced text-based functions. 🔍 Section 7: What IF Tools - Explore the 'What If' analysis tools to make informed decisions and predictions. 🏁 Section 8: Excel Advanced - Conclusion - Wrap up with a comprehensive understanding and practical application of advanced Excel features. 🎁 Section 9: Bonus #1 - Advanced Pivot Tables - Delve into bonus content covering advanced techniques for Pivot Tables, a must-have skill for data analysis pros. 🌟 Why Choose Our Course? 🔐 Expert Guidance: Led by seasoned Excel professionals, ensuring clarity and depth in learning. 🔄 Practical Assignments: Apply your newfound skills through real-world exercises. 📈 Career Growth: Elevate your career prospects by mastering sought-after Excel abilities. 🌐 Accessible Learning: Study at your own pace from anywhere, anytime with our user-friendly online platform. 🤝 Join our vibrant community of learners dedicated to mastering Excel's advanced functionalities. 💡 Enroll now and revolutionize your Excel prowess with 'Microsoft Excel 2019 - Advanced Level Training'! Don't miss this chance to become an Excel wizard! 💡   Course Curriculum Section 1 - Excel - Advanced Excel Advanced Introduction 01:39 Advanced Shortcut Keys 02:58 Section 2 - Working with Multiple Workbooks Tracing Precedents 00:00 Tracing Dependants 00:00 Watch Window 00:00 Show Formulas 00:00 Section 3 - Protecting Worksheets and Workbooks Protecting Cells in a Worksheet 00:00 Protecting the Workbook Structure 00:00 Encryption with Passwords 00:00 Section 4 - Conditional Formulas Name Ranges 00:00 Simple IF Function 00:00 IF, AND 00:00 IF, OR 00:00 Nested Formulas 00:00 CountIF and CountIFs 00:00 SumIF and SumIFs 00:00 Section 5 - Advanced Functions Advanced VLookUp 00:00 IF and IS Error - Part 1 00:00 IF and IS Error - Part 2 00:00 Advanced Index Match 00:00 Dates - Part 1 00:00 Dates - Part 2 00:00 Replace and Substitute - Part 1 00:00 Replace and Substitute - Part 2 00:00 Section 6 - Text Based Functions Left, Right and Mid Function 00:00 Search Function 00:00 Concatenate and Search 00:00 Indirect - Static 00:00 Indirect - Dynamic 00:00 Section 7 - What IF Tools Goal Seek 00:00 Data Tables 00:00 Scenarios 00:00 Solver 00:00 Section 8 - Excel Advanced - Conclusion Excel Advanced - Conclusion 00:00 Section 9 - Bonus # 1 - Advanced Pivot Tables Building a Mini Dashboard 00:00