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

34563 Courses

Diploma in Childminding at QLS Level 6

4.5(3)

By Studyhub UK

This comprehensive course offers valuable insights and skills for individuals aspiring to become nursery nurses or childminders. Covering various aspects of childcare and early education, the course delves into child psychology, attachment building, curriculum development, safeguarding, and inclusive practices. Participants will gain a deep understanding of child development, health and safety, nutrition, and effective partnership with parents and carers.   Learning Outcomes: Understand the role of nursery nurses in childcare settings. Learn about child growth, development, and psychology. Build strong attachments and relationships with children. Explore factors influencing child development. Develop observation and assessment skills for early years settings. Implement effective curriculum and early learning strategies. Promote equality, diversity, and inclusive practices. Ensure the safeguarding, protection, and welfare of young children.   Why buy this Diploma in Childminding at QLS Level 6?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home   Who is this course for? This Diploma in Childminding at QLS Level 6 course is ideal for Aspiring nursery nurses or childminders. Individuals interested in working with young children. Parents seeking to enhance their childcare knowledge. Childcare professionals looking to upgrade their skills.   Prerequisites This Diploma in Childminding at QLS Level 6 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.   Career path Nursery Nurse - Average Salary: £15,000 - £22,000 per year. Childminder - Average Salary: Self-employed, earnings vary based on location and services provided. Early Years Educator - Average Salary: £18,000 - £25,000 per year. Preschool Teacher - Average Salary: £16,000 - £25,000 per year. Childcare Coordinator - Average Salary: £20,000 - £30,000 per year.   Certification After studying the course materials of the Diploma in Childminding at QLS Level 6 you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £125 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Module 01: Introduction to Nursery Nurse Introduction to Nursery Nurse 00:15:00 Module 02: Caring for Children Caring for Children 00:25:00 Module 03: Understanding the Growth and Development of Children Understanding the Growth and Development of Children 00:26:00 Module 04: Introduction to Child Psychology Introduction to Child Psychology 00:28:00 Module 05: Attachment and Relationship Building in Childhood Attachment and Relationship Building in Childhood 00:31:00 Module 06: Factors that Influence Development Factors that Influence Development 00:36:00 Module 07: Personality and Intellectual Development of Children Personality and Intellectual Development of Children 00:36:00 Module 08: Observation and Assessment of Children in the Early Years Setting Observation and Assessment of Children in the Early Years Setting 00:20:00 Module 09: Curriculum and Developing Early Learning Curriculum and Developing Early Learning 00:27:00 Module 10: Promoting Equality, Diversity and Inclusive Practice in Early Years of Learning Promoting Equality, Diversity and Inclusive Practice in Early Years of Learning 00:27:00 Module 11: Safeguarding, Protection and Welfare of Young Children Safeguarding, Protection and Welfare of Young Children 00:25:00 Module 12: Health and Safety of Children in the Early Years Health and Safety of Children in the Early Years 00:35:00 Module 13: Nutrition and Healthy Food for Children Nutrition and Healthy Food for Children 00:30:00 Module 14: Play and Learning in Children's Education Play and Learning in Children's Educatio 00:28:00 Module 15: Working with Children Having Special Needs Working with Children Having Special Needs 00:26:00 Module 16: Working in Partnership with Parents and Carers Working in Partnership with Parents and Carers 00:19:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Diploma in Childminding at QLS Level 6
Delivered Online On Demand7 hours 14 minutes
£10.99

How To Do Keyword Research For SEO & Ranking On Google

4.5(3)

By Studyhub UK

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special How To Do Keyword Research For SEO & Ranking On Google Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The How To Do Keyword Research For SEO & Ranking On Google Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This How To Do Keyword Research For SEO & Ranking On Google Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This How To Do Keyword Research For SEO & Ranking On Google Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this How To Do Keyword Research For SEO & Ranking On Google? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the How To Do Keyword Research For SEO & Ranking On Google there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This How To Do Keyword Research For SEO & Ranking On Google course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This How To Do Keyword Research For SEO & Ranking On Google does not require you to have any prior qualifications or experience. You can just enrol and start learning.This How To Do Keyword Research For SEO & Ranking On Google was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This How To Do Keyword Research For SEO & Ranking On Google is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction To The Course What To Expect In This Course 00:02:00 Why Is Keyword Research Important? 00:03:00 Introduction - Doug Cunnington 00:01:00 Keyword Research Tools Introduction To The Google Adwords Keyword Planner 00:02:00 Searching For New Keyword And Ad Group Ideas 00:04:00 Getting Search Volume For a List Of Keywords 00:02:00 Multiplying Keyword Lists To Get New Keyword Ideas 00:01:00 Comparing Keyword Tools Introduction To Long Tail Pro 00:02:00 Using Google Trends 00:07:00 LongTailPro Vs. Google keyword Planner 00:02:00 Using Long Tail Keywords What Are Long Tail Keywords? 00:02:00 Using The Google Results Page 00:03:00 Using Google Webmaster Tools For Existing Keywords You Can Optimize 00:03:00 Using Google Trends 00:07:00 Using Google Correlate 00:06:00 Other Sites To Use For Long Tail Research Soovle 00:02:00 UberSuggest 00:04:00 Keyword Tool 00:03:00 Quora 00:03:00 Keyword Xtreme@ 00:03:00 Determining Commercial Intent Is The Searcher Going To Buy Something? 00:03:00 Understanding The 4 Types Of Keywords 00:05:00 Looking At The Adwords Suggested Bid@ 00:05:00 Competition Analysis What About Competition 00:02:00 The Moz Toolbar 00:06:00 Majestic Backlink Analyzer 00:08:00 SEMRush 00:06:00 AHREFS Site Explorer 00:07:00 Examples of Good Low Competition Sites 00:07:00 Case Study - A Perfect Long Tail Keyword Generating Revenue A Perfect Example Of a Long Tail Keyword Article Generating Traffic 00:09:00 Conclusion To The Course Concluding The Course 00:03:00

How To Do Keyword Research For SEO & Ranking On Google
Delivered Online On Demand2 hours 3 minutes
£10.99

Level 2 Certificate in Principles of End of Life Care Course

By Training Tale

End of Life Care: Level 2 Certificate in Principles of End of Life Care This Level 2 Certificate in Principles of End of Life Care course is designed to teach you the essential skills and knowledge to support an individual at their end of life. This Level 2 Certificate in Principles of End of Life Care course will provide you a thorough understanding of care planning, dealing with difficult issues, and applying your knowledge in a practical setting. Understanding Level 2 Certificate in Principles of End of Life Care course will also assist you in developing communication skills and understanding the importance of communicating effectively with your patients and their families. The knowledge you will gain from this End of Life Care: Level 2 Certificate in Principles of End of Life Care course will enable you to always put the best interests of your patients ahead of your own. Why Choose End of Life Care: Level 2 Certificate in Principles of End of Life Care Course from Us Self-paced End of Life Care: Level 2 Certificate in Principles of End of Life Care course, access available from anywhere. End of Life Care: Level 2 Certificate in Principles of End of Life Care Course developed by industry experts. Free PDF certificate as soon as completing this End of Life Care: Level 2 Certificate in Principles of End of Life Care course. Main Course: Level 2 Certificate in Principles of End of Life Care course Free Courses: Course 01: Level 3 Award in Health and Social Care Course 02: Clinical Psychology Diploma Course 03: Adults Support Worker Special Offers of this End of Life Care: End of Life Care Course This Sports of Life Care: End of Life Care Course includes a FREE PDF Certificate. Lifetime access to this End of Life Care: End of Life Care Course Instant access to this End of Life Care: End of Life Care Course Get FREE Tutor Support from Monday to Friday in this End of Life Care: End of Life Care Course [ Note: Free PDF certificate as soon as completing the End of Life Care: End of Life Care Course] End of Life Care: Level 2 Certificate in Principles of End of Life Care Course Curriculum of Level 2 Certificate in Understanding End of Life Care Module 01: Understand how to work in end-of-life Care. Module 02: Understand how to provide support to manage pain and discomfort. Module 03: End-of-life care and dementia Module 04: Understanding the role of the care worker at the time of death. Module 05: Understand loss and grief in end-of-life Care. Assessment Method of End of Life Care After completing each module of the End of Life Care: End of Life Care Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of End of Life Care After completing the MCQ/Assignment assessment for this End of Life Care: End of Life Care Course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? End of Life Care: Level 2 Certificate in Principles of End of Life Care This End of Life Care: Level 2 Certificate in Principles of End of Life Care course is ideal for: Health and social care workers Individuals working in an adult care environment. Carers and caretakers Special Note: Our Level 2 Certificate in Principles of End of Life Care Course is not a regulated course. To get Qualified, you may choose the following options: Level 2 Certificate in Principles of End of Life Care (RQF) Level 3 Certificate in the Principles of End of Life Care (RQF) Certificate in principles of end of life care (QCF) Level 2 Award in Awareness of End of Life Care (QCF) Certificate In Understanding End Of Life Care RQF QCF Level 2 NCFE Level 3 Certificate (RQF) - End of Life Care Requirements End of Life Care: Level 2 Certificate in Principles of End of Life Care Students who intend to enrol in this End of Life Care: Level 2 Certificate in Principles of End of Life Care Course must meet the following requirements: End of Life Care: Good command of the English language End of Life Care: Must be vivacious and self-driven. End of Life Care: Minimum Basic computer knowledge End of Life Care: A minimum of 16 years of age is required. Career path End of Life Care: Level 2 Certificate in Principles of End of Life Care The knowledge you will gain through this Level 2 Certificate in Principles of End of Life Care course may lead you to a variety of career opportunities, such as - Social Care Workers- £28,000 (Approximately) Adult Care Worker £30,000 (Approximately) Healthcare Advisor - £27,500 (Approximately) Certificates Certificate of completion Digital certificate - Included

Level 2 Certificate in Principles of End of Life Care Course
Delivered Online On Demand20 hours
£12

Category Procurement Manager

By Compliance Central

Are you looking to enhance your Category Procurement Manager skills? If yes, then you have come to the right place. Our comprehensive course on Category Procurement Manager will assist you in producing the best possible outcome by mastering the Category Procurement Manager skills. The Category Procurement Manager course is for those who want to be successful. In the Category Procurement Manager course, you will learn the essential knowledge needed to become well versed in Category Procurement Manager. Our Category Procurement Manager course starts with the basics of Category Procurement Manager and gradually progresses towards advanced topics. Therefore, each lesson of this Category Procurement Manager course is intuitive and easy to understand. Why would you choose the Category Procurement Manager course from Compliance Central: Lifetime access to Category Procurement Manager course materials Full tutor support is available from Monday to Friday with the Category Procurement Manager course Learn Category Procurement Manager skills at your own pace from the comfort of your home Gain a complete understanding of Category Procurement Manager course Accessible, informative Category Procurement Manager learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Category Procurement Manager bundle Study Category Procurement Manager in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Category Procurement Manager Course Improve your chance of gaining in demand skills and better earning potential by completing the Category Procurement Manager Category Procurement Manager This course delves into the following modules to provide a well-rounded understanding of the Category Procurement Manager role: Module 1: Supply Chain Basics This module establishes a strong foundation by exploring the core principles of supply chains. You'll learn about the different stages involved, from sourcing raw materials to delivering finished products to the end customer. Module 2: Role of Procurement in an Organisation This module sheds light on the critical role procurement plays within an organization. You'll gain insights into how procurement activities contribute to achieving organizational goals and objectives. Module 3: The Purchasing Cycle Master the various steps involved in the purchasing cycle, ensuring a streamlined and efficient procurement process. This module covers activities like requisition generation, vendor selection, price negotiation, order placement, and receipt management. Module 4: Purchasing Toolkits Equip yourself with the theoretical knowledge of various purchasing tools and techniques. Learn how to leverage these tools to improve decision-making, manage contracts effectively, and optimize procurement processes. Module 5: Managing Competitive Bids This module dives into the world of competitive bidding, a cornerstone of effective Category Procurement Management. You'll understand how to develop and issue bid requests, evaluate proposals, and select the most suitable vendors. Module 6: Quality Management Maintaining quality is paramount in procurement. This module explores quality management principles and techniques to ensure you receive products and services that meet your organization's standards. Module 7: Supplier Relationship Management Building strong and collaborative relationships with suppliers is essential for a successful Category Procurement Manager. This module explores strategies for effective supplier communication, performance management, and risk mitigation. Module 8: Analysing and Reducing Risk in the Supply Chain Supply chains are inherently susceptible to various risks. This module equips you with the theoretical knowledge to identify, analyze, and implement strategies to minimize these risks, ensuring supply chain continuity. Module 9: Improving Efficiency and Accuracy This module focuses on optimizing procurement processes for enhanced efficiency and accuracy. You'll explore various approaches to streamline workflows, minimize errors, and achieve cost savings. Module 10: Category Management Gain a comprehensive understanding of category management, a critical skill for Category Procurement Managers. This module explores how to strategically classify, source, and manage different categories of goods and services to achieve optimal value. Module 11: Inventory Management Effective inventory management is crucial for cost control and maintaining smooth operations. This module explores various inventory management techniques to optimize stock levels and minimize holding costs. Module 12: E-Procurement The world of procurement is increasingly reliant on technology. This module introduces you to the theoretical concepts of e-procurement, exploring how technology can be leveraged to enhance efficiency, transparency, and cost savings. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Category Procurement Manager course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Category Procurement Manager. It is also great for professionals who are already working in Category Procurement Manager and want to get promoted at work. Requirements To enrol in this Category Procurement Manager course, all you need is a basic understanding of the English Language and an internet connection. Career path The Category Procurement Manager course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Category Procurement Manager. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Category Procurement Manager
Delivered Online On Demand5 hours
£12

Agricultural Science Training - QLS Level 5

By Imperial Academy

Level 5 QLS Endorsed Course | CPD Accredited | Audio Visual Training | Free PDF Certificate | Lifetime Access

Agricultural Science Training - QLS Level 5
Delivered Online On Demand
£12

Advanced Excel Models using Formulas, VBA & Power Query

4.3(43)

By John Academy

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Excel Models using Formulas, VBA & Power Query
Delivered Online On Demand6 hours 8 minutes
£18

Algebra for Beginners

4.3(43)

By John Academy

Description: Algebra is an area of mathematics that uses symbols to represent numbers in formulas and equations. Understanding these symbols and how they work together and provide structure to equations allows mathematicians to more efficiently write formulas and solve math problems.  This Algebra for Beginners is an introduction to the basic principles and skills of algebra. Topics include Variables, Grouping Symbols, Equations, Translating Words Into Symbols, and Translating Sentences Into Equations. With this course you will learn to manipulate and solve basic algebraic expressions, solve rational expressions, changing the subject of formulae and using formulae. You will learn to work with integers, decimals and fractions, how to evaluate powers and roots and how to solve single and multi-variable equations and inequalities. Learn how to apply algebra to a wide range of real-world problems and study critical algebraic concepts like functions, domains and ranges. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing 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? Algebra for Beginners 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 Algebra for Beginners 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 Lecture 1 Intro video Algebra Introduction final 00:02:00 Fundamental concepts on Algebraic Expressions Lecture 2 Terminology used in Algebra 00:05:00 Lecture 3 Language of Algebra 00:06:00 Lecture 4 Practice Questions 00:06:00 Lecture 5 Finding numerical value of an algebraic expression 00:14:00 Operations on Algebraic Expressions Lecture 6 Revision of Directed number ( integers 00:06:00 Lecture 7 Addition and subtraction of monomial expressions 00:06:00 Lecture 8 Addition of algebraic expressions with many terms 00:10:00 Lecture 9 Subtraction of algebraic expressions 00:10:00 Indices ( Exponents) Lecture 10 The rules of Indices in algebra 00:11:00 Lecture 11 Fractional indices 00:10:00 Lecture 12 Understanding indices (practice questions) 00:07:00 Lecture 13 Problems from IGCSE Last year papers 00:05:00 Multiplication and Division of Algebraic expressions Lecture 14 Multiplication of monomial algebraic expressions 00:05:00 Lecture 15 Multiplication of monomial with binomials and trinomials 00:11:00 Lecture 16 Division of algebraic expression by a monomial 00:07:00 Lecture 17 Division of algebraic expression by another polynomial 00:09:00 Lecture 18 Division of a polynomial by another polynomial with remainder 00:11:00 Brackets in Algebra Lecture 19 Rules of brackets 00:04:00 Lecture 20 Simplification by removing brackets 00:11:00 Linear equations in one variable Lecture 21 Simplification of algebraic fractions 00:07:00 Lecture 22 Rules to solve linear equations in one variable 00:03:00 Lecture 23 Solving linear equations in one variable 00:07:00 Lecture 24 Solving complex linear equations in one variable 00:10:00 Lecture 25 Word problems on linear equations in one variable 00:13:00 Algebraic Identities Lecture 26 Standard Identities (a + b )² and (a - b )² identities 00:11:00 Lecture 27 Standard Identity ( a - b ) ( a + b) = a ² - b ² 00:08:00 Lecture 28 Standard Identities ( a + b + c ) ² = a ² + b ² + c ² + 2 a b + 2 a c +2 b c 00:07:00 Lecture 29 Standard Identities ( a + b ) ³ and ( a - b ) ³ 00:09:00 Lecture 30 Standard Identities a ³ + b ³ and a ³ - b ³ 00:06:00 Lecture 31 Standard Identities a ³ + b ³ + c ³ - 3 a b c 00:10:00 Formula : Change of subject of formula Lecture 32 -Changing the subject of formula 00:08:00 Linear Inequalities Lecture 33 Linear Inequalities 00:12:00 Resolve into factors Lecture 34 Factorization by taking out common factor 00:10:00 Lecture 35 Factorization by grouping the terms 00:09:00 Lecture 36 Factorize using identity a ² - b ² 00:07:00 Lecture 37 Factorize using identity (a + b )² and (a - b )² 00:08:00 Lecture 38 Factorize using identity ( a + b + c ) ² 00:05:00 Lecture 39 Factorization by middle term split 00:12:00 Algebraic Fractions Lecture 40 Simplification of algebraic fractions 00:06:00 Coordinate axis - points and Line graph Lecture 41 All that you need to know about co ordinate axis 00:04:00 Lecture 42 Some important facts needed to draw line graph 00:03:00 Lecture 43 How to draw a line graph on coordinate plane 00:03:00 Lecture 44 Drawing line graphs 00:06:00 System of simultaneous linear equations in two variables Lecture 45 Simultaneous Linear Equations in two variables- intro 00:03:00 Lecture 46 Graphical method of solving linear equations 00:06:00 Lecture 47 Graphical method - more sums 00:10:00 Lecture 48 Method of Elimination by substitution 00:09:00 Lecture 49 Method of Elimination by Equating coefficients 00:11:00 Lecture 50 Method of Elimination by cross multiplication 00:07:00 Lecture 51 Equations reducible to simultaneous linear equations 00:12:00 Lecture 52 Word Problems on Linear equations 00:18:00 Polynomials Lecture 53 Polynomials and Zeros of polynomials 00:10:00 Lecture 54 Remainder Theorem 00:04:00 Lecture 55 Factor Theorem 00:08:00 Lecture 56 Practice problems on Remainder and Factor Theorem 00:09:00 Lecture 57 Factorization using factor Theorem 00:10:00 Quadratic Polynomials Lecture 58 Zeros of polynomials α, β & γ 00:10:00 Lecture 59 Relation between zeros and coefficients of a polynomials 00:13:00 Lecture 60 Writing polynomials if zeros are given 00:06:00 Lecture 61 Practice problems on zeros of polynomials 00:10:00 Lecture 62 Problems solving with α and β (part 1) 00:11:00 Lecture 63 Problems solving with α and β (part 2) 00:10:00 Quadratic Equations Lecture 64 what are Quadratic equations 00:03:00 Lecture 65 Solutions by factorization method 00:12:00 Lecture 66 Solutions by completing square formula 00:06:00 Lecture 67 Deriving Quadratic formula 00:05:00 Lecture 68 Practice problems by Quadratic formula 00:07:00 Lecture 69 Solving complex quadratic equations by Quadratic Formula 00:11:00 Lecture 70 Solutions of reducible to Quadratic Formula 00:09:00 Lecture 71 Skilled problems on Quadratic Equations 00:07:00 Lecture 72 Exponential problems reducible to Quadratic Equations 00:06:00 Lecture 73 Nature of Roots of Quadratic Equations 00:09:00 Lecture 74 Word problems on quadratic Equations Part 1 00:13:00 Lecture 75 Word problems on quadratic Equations Part 2 00:11:00 lecture 76 word problems on Quadratic 00:12:00 Mock Exam Mock Exam - Algebra for Beginners 00:20:00 Final Exam Final Exam - Algebra for Beginners 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Algebra for Beginners
Delivered Online On Demand11 hours 8 minutes
£18

Puppies - A-Z Guide To Puppy & Dog Training

4.8(9)

By Skill Up

Start on a transformative journey with our comprehensive course, "Puppies - A-Z Guide To Puppy & Dog Training." Unleash the potential in your furry companion today!

Puppies - A-Z Guide To Puppy & Dog Training
Delivered Online On Demand2 hours 57 minutes
£13.99

Emergency First Aid at Work

5.0(5)

By Online Training Academy

Our Emergency First Aid at Work will help you be prepared for anything as emergencies don't wait for the perfect time. They strike without warning, and every second counts. This Emergency First Aid at Work (EFAW) course will help you gain the knowledge of qualified first aiders, as well as risk assessment, you will have a fundamental awareness of how to deliver first aid. An accident or incident can happen anytime that calls for first aid, and this course will provide you with the skills you need to react appropriately and promptly to these potentially life-threatening situations. This Emergency First Aid at Work course covers a wide range of fundamental information needed to help emergency first aiders fulfil their role, including primary and secondary surveys, dealing with breathing problems, administering CPR, and treating Minor injuries. Don't wait for an emergency to realise you're unprepared. Empower yourself and your team with the knowledge and skills to act decisively and confidently when it matters most. Key Features This Emergency First Aid at Work course: CPD Certified Emergency First Aid at Workcourse Level 3 Diploma Developed by Emergency First Aid Specialist Lifetime Access to Emergency First Aid at Work course Why Choose Our Course? By choosing our Emergency First Aid at Workcourse is a smart investment in your professional future. Our Emergency First Aid at Work course is designed by industry professionals to stay ahead of trends, offering the most current and relevant content. This Emergency First Aid at Work course provides you with the tools and knowledge needed to excel in today's competitive landscape. With flexible learning options and a commitment to your success, our Emergency First Aid at Work course is the key to unlocking your potential and advancing your professional journey. Course Curriculum Emergency First Aid at Work course: Module 01: Introduction to Workplace First Aid Module 02: Basic First-Aid Techniques Module 03: Minor Injuries Module 04: Emergency Management at Work Module 05: Workplace First Aid Legislations Module 06: Breathing Problems Module 07: Loss of Responsiveness and CPR Module 08: Dealing With Fractures and Dislocations Module 09: Primary Survey Module 10: Secondary Survey Module 11: Secondary Illnesses and Injuries Learning Outcomes Emergency First Aid at Work course: Identify emergency first aid at work essentials for immediate response. Apply effective incident management techniques in work-related emergencies. Perform primary and secondary surveys with accuracy and confidence. Demonstrate essential emergency first aid at work skills for common scenarios. Recognize chronic medical conditions and provide appropriate initial aid. Execute proper responses to critical and environmental injuries at work. Salaries in the UK The salaries for Emergency First Aid at Work professionals vary depending on their experience and qualifications. However, most professionals in this field can expect to earn a competitive salary. The average salary for a Paramedic in the UK is £45,000 per year. Satisfaction A recent survey found that 80% of Emergency First Aid at Work professionals are satisfied with their jobs. The most common reasons given for job satisfaction were: Variety and challenge in Emergency First Aid at Work Good work-life balance Making a difference as a Emergency First Aid at Work professional Sense of purpose and responsibility Requirements Learners do not require any prior qualifications to enrol on this Emergency First Aid at Work course. You just need to have an interest in Emergency First Aid at Work. CPD 10 CPD hours / points Accredited by The CPD Quality Standards Who is this course for? This Emergency First Aid at Work course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Emergency First Aid at Work. Moreover, this course is ideal for: Employees in diverse work settings seeking emergency first aid at work proficiency. Managers responsible for workplace safety and emergency preparedness. Individuals aiming to enhance their knowledge of immediate medical care. Health and safety officers focusing on employee well-being. Anyone desiring competence in responding to workplace emergencies. Requirements There are no requirements needed to enrol into this Emergency First Aid at Work course. We welcome individuals from all backgrounds and levels of experience to enrol into this Emergency First Aid at Work course. Career path After finishing this Emergency First Aid at Work course you will have multiple job opportunities for you. Some of the following Job sectors of Emergency First Aid at Work are: Health and Safety Officer - £30K to 45K/year Workplace First Aid Trainer - £20K to 30K/year Safety Compliance Inspector - £35K to 50K/year Incident Management Specialist - £20K to 30K/year Paramedic - £25K to 35K/year Certificates Digital certificate - Included Will be downloadable when all lectures have been completed.

Emergency First Aid at Work
Delivered Online On Demand4 hours
£10

Home Workout Level 2

5.0(1)

By Course Gate

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Home Workout Level 2 course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Home Workout Level 2 course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Home Workout Level 2 and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Home Workout Level 2 course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Home Workout Level 2 course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Home Workout Level 2 will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Introduction & First Concepts Introduction 00:01:00 Keeping Fit A Route to Sanity 00:08:00 Doing It For Yourself 00:06:00 Section 02: Science & Benefits of Staying Fit Benefits of Staying Fit 00:07:00 The Science behind Physical Fitness 00:07:00 Section 03: Creating & Maintaining Your Diet & Workout Plan Physical Fitness & Your Sex Life 00:07:00 Tips To Create a Workout Plan 00:07:00 How to Create a Great Diet Plan 00:08:00 How to Maintain Your Plan & Momentum 00:07:00 Section 04: Final Ideas & Tips Conclusion - Final Thoughts & Ideas 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Home Workout Level 2
Delivered Online On Demand1 hour
£11.99