43881 PE courses

Overview This comprehensive course on Master Work and Time Topics in Mathematics will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Master Work and Time Topics in Mathematics 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 Master Work and Time Topics in Mathematics. It is available to all students, of all academic backgrounds. Requirements Our Master Work and Time Topics in Mathematics is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 34 lectures • 04:46:00 total length •Promotional Video: 00:01:00 •Quick Guide: 00:01:00 •Problems based on Inverse Proportion: 00:14:00 •Problems based on Persons, Days, Work and Hours: 00:14:00 •Short-cut formulas and LCM method: 00:15:00 •Problems based on two Persons: 00:08:00 •Problems based on by three Persons: 00:12:00 •Efficiency or rate of work: 00:10:00 •Practice Problems (Efficiency): 00:09:00 •Skilled Problems on Efficiency: 00:11:00 •Work given in the form of fraction (Basics): 00:07:00 •Practice Problems (Work given in the form of fraction): 00:10:00 •Leaving and Joining of persons - 1: 00:10:00 •Leaving and Joining of persons - 2: 00:08:00 •Problems involving Men, Women and Boys-1: 00:06:00 •Problems involving Men, Women and Boys-2: 00:12:00 •Problems involving Men, Women and Boys-3: 00:10:00 •Work and wages: 00:12:00 •Special Case: 00:07:00 •Basics of Pipes and Cistern: 00:12:00 •Pipes and Cistern Type -1: 00:08:00 •Pipes and Cistern Type - 2: 00:05:00 •Pipes and Cistern Type -3: 00:08:00 •Pipes and Cistern Type - 4: 00:06:00 •Pipes and Cistern Type - 5: 00:06:00 •GMAT 1: 00:04:00 •GMAT Solutions Q1, Q2, Q3 4: 00:15:00 •GMAT Solutions Q4, Q5, Q6 4: 00:05:00 •GMAT Solutions Q7: 00:04:00 •GMAT Solutions Q8, Q9, Q10: 00:08:00 •GMAT Problems part - 2: 00:04:00 •GMAT Solutions of part - 2: 00:10:00 •GMAT Problems part - 3: 00:04:00 •GMAT Solutions of part - 3: 00:10:00

Overview Know how to manage your organisation's resources and marketplace objectives, boosting your career potential to higher levels. This Strategic Business Management Advanced Diploma course will train you in advanced strategic methodologies that will transform your business and deliver successful results. The course was compiled with the aid of industry experts and reinforces management principles that are vital to victory in any sector. You will be coached in many corporate skills such as leadership, operations management, performance recognition, marketing, decision-making, research and development, and cost-efficiency. It provides the perfect package for anyone that genuinely wants to excel in business. 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 Strategic Business Management Advanced Diploma. It is available to all students, of all academic backgrounds. Requirements Our Strategic Business 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 5 sections • 46 lectures • 00:45:00 total length •Designing Your Organisational Structure: 00:30:00 •Introduction to Operations Management: 00:15:00 •Understanding Financial Terms: 00:30:00 •Getting the Right People in Place: 00:15:00 •Getting Your Product Together: 00:15:00 •Building a Corporate Brand: 00:30:00 •Marketing Your Product: 01:00:00 •Selling Your Product: 00:15:00 •Planning for the Future: 00:15:00 •Goal Setting: 00:30:00 •Succession Planning 101: 00:15:00 •Managing Your Money: 00:15:00 •Ethics: 00:15:00 •Building a Strong Customer Care Team: 00:15:00 •Training Employees for Success: 00:15:00 •Leadership Essentials: 00:15:00 •Business Planning Basics: 01:00:00 •Market Evaluation: 01:00:00 •Analyze Competition: 02:00:00 •Determine A Marketing Strategy: 01:00:00 •Decide What Extras You May Need Like Staff etc: 00:30:00 •The Dangers In Not Making A Business Plan: 00:15:00 •Wrapping Up: 00:15:00 •Introduction: 00:15:00 •The Purple Cow: 00:30:00 •Try to be an Exceptionist: 00:30:00 •Make Yourself Well Recognised Before Your Customers: 00:15:00 •Wow Your Customers: 00:30:00 •Develop a Personal Style: 00:30:00 •Use Creative Imageries to Catch the Attention: 00:30:00 •Be a Traditionalist, Not a Fad Chaser: 00:15:00 •Bringing Out the Purple Cow in Your Business: 00:30:00 •Conclusion: 00:15:00 •What is Business Administration?: 00:30:00 •Business and Organisations: 00:15:00 •Management of Business: 00:30:00 •Business Organization Perspectives: 00:30:00 •Introduction: 01:00:00 •Decision Making: 00:30:00 •Approaches to Leadership: 00:30:00 •How to Build Trust and Confidence: 01:00:00 •A Manager's Pitfalls: 01:00:00 •How to Build Team Spirit: 01:00:00 •Dealing with Problem Employees: 01:00:00 •Using Your Emotional Intelligence: 01:00:00 •Conclusion to Management: 00:15:00

Course Overview: The global acrylic nail industry is booming and is expected to reach $2.5 billion by 2027. This Acrylic Nail course is your gateway to a thriving career in the nail industry, where your skills will be in high demand.Moreover, this Acrylic Nail course encompasses every intricate detail of the profession, from understanding nail anatomy to mastering the art of acrylic nails. Such a comprehensive curriculum ensures learners emerge well-versed in all facets of the domain.Additionally, we have curated a dynamic curriculum that covers all aspects of acrylic nail application, nail art techniques, and essential knowledge about nail anatomy, diseases, and product chemistry.Enrol now and start your career journey with us! Key Features of the Course: Upon completing the course, you will receive a CPD (Continuing Professional Development) certificate, recognised and respected within the industry. We provide round-the-clock support to ensure a smooth and enjoyable learning experience, with dedicated tutors ready to answer your queries and provide guidance. Who is This Course For? This course is ideal for individuals who have a passion for nail artistry and want to pursue a fulfilling career as a nail technician. What You Will Learn: In the Counselling Course - Acrylic Nail, you will gain expertise in acrylic nail techniques while unleashing your artistic flair. The course consists of 13 modules that cover a comprehensive range of topics. You will begin by exploring nail extension techniques and learning how to enhance the length and beauty of nails. Next, you will delve into nail anatomy, acquiring in-depth knowledge of nail structure and composition to provide effective and safe treatments. Understanding and managing common nail diseases and disorders are also covered, ensuring the well-being of your clients.With a focus on nail product chemistry, you will develop a solid understanding of the chemistry behind nail products, enabling informed choices and exceptional results. The course further equips you with the skills to master nail extension applications, overlays, nail art techniques, maintenance, removal, health and safety protocols. Why Enrol in This Course: Top Reviewed Course: Our Counselling Course - Acrylic Nail, has received rave reviews from countless students who have successfully built thriving careers in the nail industry after completing this course. Recently Updated: Our course content is regularly updated to reflect the latest industry trends, techniques, and advancements, ensuring that you stay ahead of the curve. Trending Industry: The nail industry is experiencing exponential growth, with nail technicians earning an average salary of £20,000 to £50,000 annually in the UK. Requirements: You only need a passion for beauty and a willingness to learn. No prior experience or qualifications are required. Career Path: Upon completion of our Counselling Course - Acrylic Nail, you will be equipped with the skills and knowledge for a range of exciting careers, including: Nail Technician: £18,000 - £30,000 per year Freelance Nail Artist: £15 - £40 per hour Beauty Blogger/Vlogger: £15,000 - £50,000 per year Nail Product Sales Representative: £18,000 - £30,000 per year Nail Educator: £25,000 - £40,000 per year Certification: Upon completing the Counselling Course - Acrylic Nail, you will receive a CPD certificate, affirming your competence and enhancing your professional credibility in the nail industry. Course Curriculum 3 sections • 15 lectures • 03:57:00 total length •Module 01: Nail Extension Techniques: An Introduction: 00:12:00 •Module 02: Nail Anatomy: 00:15:00 •Module 03: Nail Diseases and Disorders: 00:30:00 •Module 04: Nail Product Chemistry Simplified: 00:15:00 •Module 05: Nail Extension Techniques: 00:05:00 •Module 06: Acrylic Nail Extension: Part-1 (Applying Tips to the Nails): 00:20:00 •Module 07: Acrylic Nail Extension: Part-2 (Applying Overlays): 00:20:00 •Module 08: Art in Acrylic Nails: Basic to Advance: 00:05:00 •Module 09: Hands-on Nail Art Training: 00:05:00 •Module 10: Maintaining Artificial Nails: 00:15:00 •Module 11: Acrylic Nail Removal: 00:10:00 •Module 12: Health and Safety in Beauty Salon: 00:25:00 •Module 13: Client Care and Communication: 00:20:00 •Mock Exam - Acrylic Nail: 00:20:00 •Final Exam - Acrylic Nail: 00:20:00

Course Overview: The insurance industry is booming, with global premiums expected to reach $5.2 trillion by 2025. In the UK alone, the insurance industry employs over 1 million people and generates over £200 billion in annual revenue. If you're looking for a career in the insurance industry, the Insurance Broker Training Level 3 course is the perfect place to start. This comprehensive course will teach you everything you need to know about the insurance industry, from the basics of insurance principles to the different types of insurance products available. In this comprehensive Insurance Broker Training Level 3 course, we dive deep into the multifaceted world of insurance, equipping learners with the knowledge and expertise to excel as insurance brokers. Focusing on the UK insurance industry, this course delves into the principles, processes, and types of insurance, empowering individuals to navigate the complex landscape confidently and precisely. Every part is covered in detail, From personal to commercial lines, liability to life insurance. So enrol now and get started! Key Features of the Course: CPD Certification 24/7 Learning Assistance Interesting Learning Materials Who is This Course For? This Insurance Broker Training Level 3 course is suitable for individuals who aspire to pursue a career as insurance brokers, insurance agents, underwriters, claims adjusters, risk managers, insurance consultants, or insurance sales professionals. Whether you are a fresh graduate or a seasoned professional seeking to expand your horizons, this course offers valuable insights and expertise to empower you to thrive in the insurance industry. What You Will Learn: In this comprehensive insurance Broker Training Level 3 course, You will gain an understanding of the insurance industry's inner workings, explore the intricacies of the UK insurance industry, grasp the fundamental principles of insurance, delve into the nuances of general and personal lines, commercial lines, liability, and life insurance, unravel the complexities of insurance fraud, and unravel the underwriting process. Additionally, you will delve into commercial lines insurance, exploring the complexities of providing coverage for businesses and commercial entities. The course will equip you with a thorough understanding of liability insurance, an essential aspect of risk management in various industries. You will also gain insights into the intricacies of life insurance, including different policy types and their significance in financial planning. Furthermore, you will develop a keen awareness of insurance fraud and learn effective strategies to detect, prevent, and combat fraudulent activities. Finally, the course will guide you through the underwriting process, equipping you with the skills to assess risks, determine appropriate coverage, and make informed decisions to protect policyholders and insurers. Why Enrol in This Course: Enrolling in our Insurance Broker Training Level 3 course offers many advantages. The course has garnered top reviews from past learners, assuring you of its quality and effectiveness. The content is regularly updated. This will enhance employability, unlock exciting career opportunities, and position you for success. Requirements: There are no specific prerequisites for this Insurance Broker Training Level 3 course. A passion for learning and a commitment to acquiring new skills are the only requirements for this rewarding journey. Career Path: Upon completing this Insurance Broker Training Level 3 course, you will get edges in various lucrative career paths in the insurance industry. Insurance Broker (£30,000 - £70,000) Insurance Agent (£18,000 - £40,000) Underwriter (£25,000 - £60,000) Claims Adjuster (£20,000 - £45,000) Risk Manager (£30,000 - £80,000) Insurance Consultant (£25,000 - £60,000) Insurance Sales Professional (£20,000 - £50,000) Certification: Upon completing the Insurance Broker Training Level 3 course, you will be awarded a CPD certificate, which will testify to your newly acquired skills and expertise in insurance brokering. Take advantage of this incredible opportunity to unlock a rewarding career in the thriving insurance industry. Enrol in our Insurance Broker Training Level 3 course today and embark on a journey towards professional success! Course Curriculum 2 sections • 11 lectures • 08:12:00 total length •Module 01: Insurance Industry: 00:40:00 •Module 02: The UK Insurance Industry: 01:00:00 •Module 03: Principles of Insurance: 01:05:00 •Module 04: General Insurance: 00:45:00 •Module 05: Personal Lines Insurance: 01:20:00 •Module 06: Commercial Lines Insurance: 01:20:00 •Module 07: Liability Insurance: 00:47:00 •Module 08: Life Insurance: 00:39:00 •Module 09: Insurance Fraud: 00:23:00 •Module 10: Underwriting Process: 00:13:00 •Assignment - Insurance Broker Training Level 3: 00:00:00

Overview Enter the fascinating world of criminal investigation and test your deductive skills to see if they would suffice in the real-life incidents. This Criminology Complete Bundlecourse brings together three fundamental areas of Policing (Profiling, Psychology, and Forensics) and trains you in their use. With true-crimes and 'armchair detection' being a popular pastime for many people, this innovative tutorial brings together different investigative techniques and explains their importance in the modern Justice System. You will be given opportunities to test and explore the theories in interactive exercises and see if a career in more law enforcement might be in your future. 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 Criminology Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our Criminology Complete Bundle 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 • 50 lectures • 13:07:00 total length •Promo Video: 00:03:00 •What is Psychology: 00:10:00 •The Biological Approach: 00:10:00 •Behaviourist and Cognitive Approaches: 00:10:00 •Person-Centred Approaches: 00:08:00 •Research Methods in Psychology: 00:12:00 •Debates in Psychology: 00:13:00 •Social Influence: Compliance, Obedience and Conformity: 00:10:00 •Social Cognition: 00:09:00 •Applied Social Psychology: 00:10:00 •Perception: 00:10:00 •Attention: 00:02:00 •Remembering (Memory): 00:10:00 •Forgetting (Memory): 00:07:00 •Language: 00:10:00 •Thinking (Cognition): 00:07:00 •Attitudes: 00:10:00 •Problem-Solving and Artificial Intelligence: 00:09:00 •Issues in Child Development: 00:05:00 •Cognitive Development: 00:25:00 •The Development of Language and Communication: 00:06:00 •Social Perception (Interpersonal Perception): 00:06:00 •Moral Development: 00:09:00 •The definition and Diagnosis of Atypical (Abnormal) Behaviour: 00:07:00 •Treatments of atypical (abnormal) behaviour: 00:07:00 •Emotional disorders: 00:05:00 •Research Methods: 00:06:00 •Research Issues: 00:06:00 •Data Analysis: 00:07:00 •Thank You and Good Bye!: 00:04:00 •Resource Materials : Psychology: 00:00:00 •Module 01: Introduction to Criminology and Profiling: 00:23:00 •Module 02: Classification of Crime: 00:18:00 •Module 03: Violent Crimes: 00:29:00 •Module 04: The Crime Scene: 00:30:00 •Module 05: Dealing with Crime: 00:41:00 •Module 06: Understanding Criminal Psychology: 00:31:00 •Module 07: Forensic Science: 00:35:00 •Module 08: Phases of Profiling: 00:33:00 •Module 09: Criminal Profiling: Science, Logic and Metacognition: 00:28:00 •Module 10: Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice: 00:22:00 •Module 11: Victimology: 00:25:00 •Module 12: The Criminal Justice System in England and Wales: 00:19:00 •Module 01: Introduction to Domestic Violence & Abuse: 00:28:00 •Module 02: The Components of Domestic Violence: 00:25:00 •Module 03: The Impact of Domestic Violence on Victims: 00:32:00 •Module 04: The Impact of Domestic Violence and Abuse on Children: 00:50:00 •Module 05: Assessing the Risks of Domestic Violence and Abuses on Children: 00:15:00 •Module 06: Supporting the Victim and Reporting Incidents: 00:31:00 •Module 07: Record Keeping: 00:19:00

Course Overview: This comprehensive course on Quality Tools and Problem Solving Methods will deepen your understanding on this topic.After successful completion of this course, you can acquire the required skills in this sector. This Quality Tools and Problem Solving Methods 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. Key Features of the Course: CPD certificate upon completion 24/7 learning assistance for continuous support Engaging and interactive learning materials A comprehensive curriculum covering various aspects of Quality Tools and Problem Solving Methods Learn at your own pace, anywhere and anytime Who is This Course For? This Quality Tools and Problem-Solving Methods course is designed for anyone interested in quality management, interested problem solvers, engineers, and anybody looking to expand their knowledge of quality assurance procedures. Whether you're new to quality control or have some experience, this course will provide you with the knowledge and skills you need to succeed in your sector. What You Will Learn: This Quality Tools and Problem Solving Methods course covers: the key principles of quality management and problem solving techniques. Techniques for effective data collection and analysis using check sheets. Brainstorming methods for innovative idea generation. Creation and interpretation of cause & effect diagrams for problem identification. Application of Pareto diagrams and histograms in data analysis. Process improvement and analysis using flowcharts and control charts. Implementing problem-solving methodologies like the A3 process and 8D. Why Enrol in This Course: Enrolling in Basic Automotive Engineering: Onboard Diagnostics will provide you with several benefits. Firstly, it is a top-reviewed course that has recently been updated to align with the latest advancements in automotive technology. By staying up-to-date, you'll gain a competitive edge in the job market and increase your chances of securing exciting career opportunities. Requirements: To enrol in the Quality Tools and Problem Solving Methods course, you typically need: Basic knowledge of quality management concepts. Interest in learning advanced problem-solving techniques. Educational or professional background in business or engineering (recommended but not mandatory). Basic computer and internet skills are needed for accessing course materials. Proficiency in the course language, usually English. Completion of any specific registration or application process set by the course provider. Career Path: Upon completing Quality Tools and Problem Solving Methods , you can explore various exciting career paths. Here are five course-related professions, along with their average UK salaries: Quality Manager (£40,000-£80,000 per year) Process Improvement Analyst (£30,000-£60,000 per year) Manufacturing Engineer (£35,000-£70,000 per year) Continuous Improvement Specialist (£35,000-£65,000 per year) Quality Assurance Engineer (£30,000-£55,000 per year) Certification: Upon completing the Quality Tools and Problem Solving Methods course, you'll receive a CPD certificate widely recognised in various industries. This certificate will elevate your professional standing and open up new career prospects. Enrol today to excel in problem-solving and quality management, joining a global community of learners on this transformative journey. Course Curriculum 21 sections • 44 lectures • 03:14:00 total length •About the instructor: 00:01:00 •Summary of the course: 00:01:00 •Checksheet-1: 00:01:00 •CCIN practice final v2: 00:06:00 •The brainstroming: 00:01:00 •Brainstorming ip: 00:06:00 •The cause and effect diagram: 00:01:00 •CE in practice: 00:08:00 •Tool The Histogram-1: 00:01:00 •The histogram in practice: 00:10:00 •Pareto diagram: 00:01:00 •Pareto in practice final: 00:09:00 •Control Chart-1: 00:01:00 •Control chart in practice part 1: 00:11:00 •Control chart in practice part 2: 00:10:00 •Scatter Plot-1: 00:01:00 •Scatterplot In practice: 00:07:00 •Flowchart in practice: 00:10:00 •Flowchart-1: 00:01:00 •Psp Overview: 00:01:00 •The PSP: 00:04:00 •The PSP in detail: 00:08:00 •The A3: 00:01:00 •A3 sheet: 00:04:00 •The A3 in practice: 00:15:00 •The 8D: 00:01:00 •The 8D in practice: 00:12:00 •The 8D sheet final: 00:04:00 •The PDCA: 00:01:00 •5 Why: 00:01:00 •Six Sigma: 00:01:00 •More about six sigma: 00:05:00 •Shainin system: 00:06:00 •Shainin Method: 00:01:00 •Overview of the section: 00:01:00 •The Preventive Tools: 00:01:00 •The Fmea: 00:01:00 •The FMEA in practice: 00:12:00 •The FMEA process: 00:14:00 •Control plan in practice: 00:07:00 •The Control Plan: 00:01:00 •Final Conclusion: 00:01:00 •QMS: 00:04:00 •Resources - Quality Tools and Problem Solving Methods: 00:00:00

Overview This Microsoft Excel Course for Everyone - Complete Excel Course is your passport to spreadsheet mastery.Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!Enrol right away to see how your confidence and chances rise! Don't wait! 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 Course for Everyone - Complete Excel Course. It is available to all students, of all academic backgrounds. Requirements Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs. Particularly designed to be easily accessed with an internet connection on tablets and smartphones. No strict deadlines; learn whenever it's convenient for you. Individuals with basic English proficiency. Career Path After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as : Data Analyst: £25,000 - £50,000 per year Financial Analyst: £30,000 - £60,000 per year Operations Manager: £35,000 - £70,000 per year Accountant: £25,000 - £50,000 per year Business Intelligence Analyst: £35,000 - £65,000 per year These salary ranges can vary based on factors such as experience, location, and the specific industry of the business. Course Curriculum 15 sections • 80 lectures • 06:51:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:04:00 •Getting started on Windows, macOS, Android, and IOS: 00:01:00 •How to ask great questions: 00:02:00 •FAQ's: 00:01:00 •Starting Excel: 00:04:00 •Introduction: 00:02:00 •Worksheet basics: 00:22:00 •Entering values and formulas: 00:12:00 •Data formats: 00:10:00 •Data handling basics - cut copy and paste: 00:07:00 •Save and print in excel: 00:10:00 •Excel Ranges: 00:05:00 •Introduction: 00:01:00 •Basic formula operations: 00:06:00 •Mathematical functions level 1: 00:20:00 •Mathematical functions level 2: 00:12:00 •Text functions level 1: 00:09:00 •Text functions level 2: 00:13:00 •Logical functions: 00:11:00 •Date time functions: 00:06:00 •V Lookup formula: 00:12:00 •HLookup formula: 00:04:00 •HLookup + Match formula: 00:09:00 •Match + Index formula: 00:05:00 •Introduction: 00:02:00 •XLookup: 00:08:00 •Handling #NA and Approximates match in XLookup: 00:11:00 •Wildcard matching in XLookup: 00:06:00 •Introduction: 00:02:00 •Split text into columns: 00:07:00 •Flash Fill: 00:07:00 •Remove Duplicates: 00:08:00 •Data Validation: 00:07:00 •Get- import Data from Text: 00:06:00 •Get - import Data from CSV: 00:03:00 •Introduction: 00:01:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Number: 00:05:00 •Formatting Date: 00:03:00 •Formatting tables: 00:05:00 •Introduction: 00:01:00 •Creating Pivot Table: 00:07:00 •Value field settings: 00:04:00 •Number format: 00:02:00 •Pivot Table Design: 00:03:00 •Excel Exercise: 00:01:00 •Solution for Excel Exercise: 00:02:00 •Introduction: 00:01:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Easy way to create charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line charts: 00:02:00 •Area charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Format AreaPlot or XY chart: 00:08:00 •Scatter or bubble charts: 00:02:00 •Introduction: 00:01:00 •Frequency Distribution and Histograms: 00:04:00 •Waterfall charts: 00:02:00 •Hierarchy charts: sunburst and tree map: 00:03:00 •Combination charts: 00:02:00 •Sparklines: 00:05:00 •Pivot charts: 00:02:00 •Maps chart: 00:04:00 •3D Maps chart: 00:03:00 •Introduction: 00:01:00 •Stock charts: 00:02:00 •Radar charts: 00:02:00 •Surface charts: 00:02:00 •Heat maps: 00:04:00 •Named ranges: 00:05:00 •Indirect Name range Function: 00:06:00 •Import Data table from PDF file - Excel 2021: 00:04:00 •Import Data from Website - Excel 2019 above: 00:09:00 •Project: Sales forecast tracker: 00:07:00 •Product Sale Tax invoice: Tax Calculations: 00:05:00

Overview Sustainable construction and design have become essential in today's rapidly evolving world. This LEED V4: Building Design and Construction course offers comprehensive insights into how sustainable construction can be achieved, keeping in line with global green standards. From introductions to in-depth dives into critical topics, the curriculum will guide participants through the intricate world of sustainable building. Moreover, a study showed that buildings cover over 50% of all global emissions. Ensuring our buildings are efficiently designed and constructed is non-negotiable if we want to move towards a more sustainable future. So, enrol today and pave your way to a brighter tomorrow.  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 LEED V4: Building Design and Construction. It is available to all students, of all academic backgrounds. Requirements Our LEED V4: Building Design and Construction 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 11 sections • 79 lectures • 04:13:00 total length •Introduction: 00:01:00 •Getting Started: 00:04:00 •Minimum Program Requirements: 00:07:00 •Rating System Selection: 00:07:00 •Integrative Process: 00:04:00 •Integrative Project Planning and Design: 00:02:00 •Overview: 00:03:00 •Neigbourhoud Development: 00:03:00 •Sensitive Land: 00:02:00 •Surrounding Density & Diverse Uses: 00:07:00 •High Priority Site: 00:02:00 •Access to Quality Transit: 00:06:00 •Bicycle Facilities: 00:06:00 •Reduced Parking Footprint: 00:04:00 •Green Vehicles: 00:04:00 •Overview: 00:02:00 •Construction Activity Pollution Prevention: 00:03:00 •Environmental Site Assessment: 00:03:00 •Restore or Protect Habitat: 00:04:00 •Open Space: 00:03:00 •Rainwater Management: 00:03:00 •Heat Island Reduction: 00:04:00 •Light Pollution Reduction: 00:05:00 •Site Master Plan: 00:02:00 •Tenant Design and Construction Guidelines: 00:02:00 •Places of Respite: 00:03:00 •Direct Exterior Access: 00:02:00 •Joint Use Facilities: 00:03:00 •Overview: 00:01:00 •Prereq Outdoor Water Use: 00:03:00 •Prereq Indoor Water Use: 00:04:00 •Prereq Building Water Metering: 00:02:00 •Credit Outdoor Water Use: 00:02:00 •Credit Indoor Water Use: 00:03:00 •Cooling Tower Water use: 00:03:00 •Building Water Metering Credit: 00:02:00 •Overview: 00:02:00 •Fundamental Commissioning & Verification: 00:04:00 •Minimum Energy Performance: 00:05:00 •Prereq Building Level Energy Metering: 00:02:00 •Fundamental Refrigerant Management: 00:02:00 •Enhanced Commissioning: 00:05:00 •Minimum Energy Performance: 00:04:00 •Advanced Energy Metering: 00:02:00 •Demand Response: 00:03:00 •Renewable Energy Production: 00:02:00 •Enhanced Refrigerant Management: 00:03:00 •Green Powerand Carbon Offsets: 00:02:00 •Overview: 00:02:00 •Storage and Collection of Recyclables: 00:03:00 •Construction and Demolition Waste Management Planning: 00:02:00 •Preq PBT Source Reduction - Mercury: 00:03:00 •Building Life-Cycle Impact Reduction: 00:05:00 •BPDO-Environmental Product Declaration: 00:04:00 •BPDO-Sourcing of Raw Materials (2020 Update Web): 00:03:00 •BPDO-Material Ingredients: 00:05:00 •PBT Source Reduction - Mercury Credit: 00:02:00 •PBT Source Reduction - Lead Cadmium Copper: 00:03:00 •Furniture and Medical Furnishings: 00:04:00 •Design for Flexibilty: 00:02:00 •Construction and Demolition Waste Management: 00:03:00 •Overview: 00:01:00 •Min Indoor Air Quality Performance: 00:06:00 •Environmental Tobacco Smoke Control: 00:03:00 •Minimum Accoustic Performance: 00:03:00 •Enhanced Indoor Air Quality Strategies: 00:02:00 •Low Emitting Materials: 00:03:00 •Construction Indoor Air Quality Management Plan: 00:04:00 •Indoor Air Quality Assessment: 00:03:00 •Thermal Comfort: 00:04:00 •Interior Lighting: 00:06:00 •Daylight: 00:06:00 •Quality Views: 00:03:00 •Accoustic Performance: 00:03:00 •Innovation Credit: 00:03:00 •Innovation LEED AP: 00:01:00 •Regional Priority Overview: 00:01:00 •Regional Priority Credit: 00:02:00 •Completion: 00:01:00

Overview This comprehensive course on LEED Green Associate will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This LEED Green Associate 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 LEED Green Associate. It is available to all students, of all academic backgrounds. Requirements Our LEED Green Associate is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 12 sections • 77 lectures • 03:57:00 total length •LEED Green Associate (LEED GA BD+C Introduction).: 00:03:00 •Integrative Process.: 00:04:00 •Integrative Project Planning and Design.: 00:02:00 •Location and Transportation Overview.: 00:03:00 •Neighbourhood Development.: 00:03:00 •Sensitive Land.: 00:02:00 •High Priority Site.: 00:02:00 •Surrounding Density & Diverse Uses.: 00:07:00 •Access to Quality Transit.: 00:06:00 •Bicycle Facilities.: 00:06:00 •Reduced Parking Footprint.: 00:04:00 •Green Vehicles.: 00:04:00 •Sustainable Site Overview.: 00:02:00 •Construction Activity Pollution Prevention.: 00:03:00 •Environmental Site Assessment.: 00:03:00 •Restore or Protect Habitat.: 00:04:00 •Open Space.: 00:03:00 •Rainwater Management.: 00:03:00 •Heat Island Reduction.: 00:04:00 •Light Pollution Reduction.: 00:05:00 •Site Master Plan.: 00:02:00 •Tenant Design and Construction Guidelines.: 00:02:00 •Places of Respite.: 00:03:00 •Direct Exterior Access.: 00:02:00 •Joint Use Facilities.: 00:03:00 •Water Efficiency Overview.: 00:01:00 •Prereq Outdoor Water Use.: 00:03:00 •Prereq Indoor Water Use.: 00:04:00 •Building Water Metering Credit.: 00:02:00 •Credit Outdoor Water Use.: 00:02:00 •Indoor Water Use.: 00:03:00 •Cooling Tower Water use.: 00:03:00 •Building Water Metering Credit.: 00:02:00 •Energy & Atmosphere Overview.: 00:02:00 •Fundamental Commissioning & Verification.: 00:04:00 •Minimum Energy Performance: 00:05:00 •Prereq Building Level Energy Metering.: 00:02:00 •Fundamental Refrigerant Management.: 00:02:00 •Enhanced Commissioning.: 00:05:00 •Minimum Energy Performance.: 00:04:00 •Advanced Energy Metering.: 00:02:00 •Demand Response.: 00:03:00 •Renewable Energy Production.: 00:02:00 •Enhanced Refrigerant Management.: 00:03:00 •Green Power and Carbon Offsets.: 00:02:00 •Materials & Resources Overview.: 00:02:00 •Storage and Collection of Recyclables.: 00:03:00 •Construction and Demolition Waste Management Planning.: 00:02:00 •Preq PBT Source Reduction - Mercury.: 00:03:00 •Building Life-Cycle Impact Reduction.: 00:05:00 •BPDO Environmental Product Declaration.: 00:04:00 •BPDO Sourcing of Raw Materials.: 00:03:00 •BPDO Material Ingredients.: 00:05:00 •PBT Source Reduction - Mercury Credit.: 00:02:00 •PBT Source Reduction - Lead Cadmium Copper.: 00:03:00 •Furniture and Medical Furnishings.: 00:04:00 •Design for Flexibility.: 00:02:00 •Construction and Demolition Waste Management.: 00:03:00 •Indoor Environment Quality Overview.: 00:01:00 •Min Indoor Air Quality Performance.: 00:06:00 •Environmental Tobacco Smoke Control.: 00:03:00 •Minimum Accoustic Performance.: 00:03:00 •Enhanced Indoor Air Quality Strategies.: 00:02:00 •Low Emitting Materials.: 00:03:00 •Construction Indoor Air Quality Management Plan.: 00:04:00 •Indoor Air Quality Assessment.: 00:03:00 •Thermal Comfort.: 00:04:00 •Interior Lighting.: 00:06:00 •Daylight.: 00:06:00 •Quality Views.: 00:03:00 •Accoustic Performance.: 00:03:00 •Innovation Credit.: 00:03:00 •Innovation LEED AP.: 00:01:00 •Regional Priority.: 00:01:00 •Regional Priority Credit.: 00:02:00 •Completion.: 00:01:00 •Assignment - LEED Green Associate.: 00:00:00

Overview This comprehensive course on 20 Keys for Happy Life will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This 20 Keys for Happy Life 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 20 Keys for Happy Life. It is available to all students, of all academic backgrounds. Requirements Our 20 Keys for Happy Life is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 4 sections • 24 lectures • 02:37:00 total length •Introduction: 00:01:00 •My Promise to You: 00:03:00 •Key 1 - Environment: 00:10:00 •Key 2 - Choices: 00:07:00 •Key 3 - Disappointments: 00:11:00 •Key 4 - Other People's Opinion: 00:05:00 •Key 5 - Perfectionism: 00:06:00 •Key 6 - Be Positive: 00:12:00 •Key 7 - Perspective: 00:07:00 •Key 8 - The World Moves On: 00:08:00 •Key 9 - Scenarios: 00:13:00 •Key 10 - The '3 Questions' Method: 00:04:00 •Key 11 - World Ranking: 00:05:00 •Key 12 - Social Media, Bullying & Dealing With Difficult People: 00:11:00 •Key 13 - Work: 00:16:00 •Key 14 - Variety: 00:04:00 •Key 15- Block Scheme of Happiness: 00:02:00 •Key 16- Take Care of Your Home: 00:04:00 •Key 17- Health: 00:07:00 •Key 18- Dealing With Complainers: 00:04:00 •Key 19 - People Like to Talk: 00:06:00 •Key 20 - Comparing Yourself to Others: 00:08:00 •Thank You: 00:03:00 •Assignment - 20 Keys for Happy Life: 00:00:00