25528 Courses

Transform your approach to nutrition with our comprehensive Diet Complete Course. Master the art of meal planning, delve into the intricacies of nutrition, and explore the realms of both Vegan and Keto lifestyles. Unleash a healthier, more balanced you with expert guidance and a holistic understanding of dietary choices. Join now and embark on a journey to optimize your well-being through informed, sustainable dietary practices.

Getting Started The MSc in Project Management programme is designed for graduates and professionals aiming to pursue or advance their careers in project management. It equips students with the necessary skills and knowledge to effectively plan, develop, manage, and execute complex projects. This comprehensive programme gives students a deep understanding of the project manager role, covering various management processes and practices relevant to project management. Students will gain proficiency in applying their expertise across different sectors. Enrolling in the MSc in Project Management programme enables students to develop the expertise needed to excel in the field and pursue rewarding careers in managing projects effectively. The programme aims to equip students to deliver practical and realistic solutions to strategic business challenges. The programme comprises two phases; the first is the Level 7 Diploma in Project Management, awarded by OTHM and delivered by the School of Business and Technology London. The second phase is the MA in Project Management Advanced Entry, delivered by London Graduate School and awarded by the University of Buckingham. School of Business and Technology London partners with LGS to promote this programme. About Awarding Body Buckingham is unique. It is the only independent University in the UK with a Royal Charter and probably the smallest, with around 2,700 students (approx 1,600 on campus). The University campus is well known for being one of the most attractive locations in the region. The Great Ouse River, home to much wildlife, winds through the heart of campus. Each student mixes with over 100 other different nationalities, so being at Buckingham is just like being in a mini global village. These contacts, acquaintances and friendships carry on long after life at Buckingham is over. Ranked Top 10 for Student Satisfaction Ranked Top 10 for Graduate Prospect Recognised by World Education Services (WES) OTHM Qualifications are approved and regulated by Ofqual (Office of Qualifications and Examinations Regulation) and recognised by Qualifications Wales. OTHM qualifications have achieved a reputation for maintaining significant skills in various job roles and industries like Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. OTHM serves the progression option with several UK universities that acknowledges the ability of learners after studying Level 3-7 qualifications to be considered for advanced entry into corresponding degree year/top-up and Master's/top-up programmes. Regulated by ofqual.gov.uk Recognised by World Education Services (WES) Assessment Assignments and Project No Examinations Entry Requirements A Bachelor's degree or an equivalent or higher qualification. A copy of a valid photo ID. A Statement of Purpose outlines your motivations for joining the course and your career aspirations in project management. An updated Curriculum Vitae (CV) that highlights at least two years of work experience at the graduate level in either a managerial or professional capacity. English Requirements A pass in English at A-level. A Bachelor's degree that was studied and assessed in English. An IELTS overall score of 6.5, with a minimum of 6.0 in each component. A TOEFL score of 72 overall, with a minimum of 18 in reading, 17 in listening, 20 in speaking, and 17 in writing. This includes the TOEFL Home Edition. In addition to the above requirements, all applicants will be scheduled for a live virtual interview with a staff member from the London Graduate School. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure Phase 1 - OTHM Level 7 Diploma in Project Management Programme Structure Planning, Controlling and Leading a Project Unit Reference No: F/618/0223 TQT : 300 Credit : 30 This unit introduces learners to real-world project development and management, emphasizing global business challenges. It encourages critical thinking about project management as complex, culturally dependent systems. Understanding efficient project management is crucial due to the growing prevalence of project activities in firms. Learners delve into team roles, management skills, success factors, and monitoring. Procurement Risk and Contract Management Unit Reference No: R/618/0226 TQT : 300 Credit : 30 This unit aims to equip students with a fundamental understanding of procurement, emphasizing the identification and management of associated risks. It also fosters a critical grasp of relevant legislative frameworks and explores risk assessment in the procurement context. Advanced Project and Logistics Management Unit Reference No: H/618/0229 TQT : 200 Credit : 20 This unit aims to provide learners with an understanding of portfolio management concepts and their features. It will also explore the benefits of having a Project Management Office and the steps involved in establishing an effective one. Additionally, learners will assess the supply chain ecosystem and evaluate IT frameworks suitable for handling logistics and supply chain complexities. Operations and Information Management for Project Managers Unit Reference No: K/618/0233 TQT : 200 Credit : 20 This unit aims to foster a critical understanding of operations and information systems management in the context of projects. Learners will analyze the interconnections between different functional areas and the impact of current factors. Additionally, they will investigate how organizational strategy relates to product planning and assess the significance of inventory management, incorporating information systems and inventory scheduling. Advanced Research Methods Unit Reference No: A/618/0236 TQT : 200 Credit : 20 This unit aims to provide learners with the practical, technical, and methodological skills necessary for independent research in project and management. It acknowledges that effective research requires cultivating specific and broad research skills. This encompasses grasping the research design process, learning diverse techniques for conducting research in business and management studies, and recognizing the ethical and societal implications of conducting valuable research. This unit empowers learners to cultivate a critical awareness of pivotal research skills as researchers and potential practitioners.   Phase 2 - MSc in Project Management Advanced Entry Programme Structure Research Methods Consultancy Project Report Delivery Methods The programme comprises two phases; the first is the Level 7 Diploma in Project Management, awarded by OTHM and delivered by the School of Business and Technology London. The School of Business and Technology London offers flexible learning methods, including online and blended learning, allowing students to choose the mode of study that suits their preferences and schedules. The programme is self-paced and facilitated through an advanced Learning Management System. Students can easily interact with tutors through the SBTL Support Desk Portal System for course material discussions, guidance, assistance, and assessment feedback on assignments. School of Business and Technology London provides exceptional support and infrastructure for online and blended learning. Students benefit from dedicated tutors who guide and support them throughout their learning journey, ensuring a high level of assistance. The second phase is the MSc in Project Management (Advanced Entry), delivered by the London Graduate School and awarded by the University of Buckingham through distance learning. You will receive excellent support from academic team of London Graduate School, including your programme manager and your supervisor who will be with you every step of the way. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Register on the Math Tricks for Teachers today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Math Tricks for Teachers is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Math Tricks for Teachers Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Math Tricks for Teachers, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction Introduction 00:02:00 Geometry Lines and Angles (Basics) 00:07:00 Parallel lines (Basics) 00:06:00 Practice Problems 1 (Lines and Angles) 00:06:00 Triangles (Basics) 00:11:00 Practice Problems 2 (angle sum and exterior angle Property) 00:10:00 Pythagoras Theorem 00:13:00 Inequalities in Triangles 00:06:00 Sine and Cosine Rule 00:12:00 Median, Altitude, Angle bisector 00:06:00 Practice problems 3 00:10:00 Properties of Medians 00:09:00 Practice Problems 4 00:07:00 Properties of Equilateral Triangles 00:04:00 Some special Quadrilaterals 00:08:00 Polygons-interior angles, diagonals etc. 00:08:00 Angle Bisector Theorem 00:07:00 Congruent Triangles 00:06:00 Similar Triangles 00:14:00 Practice Problems 5 00:10:00 Circle 00:10:00 Cyclic Quadrilateral _ Tangent to circle 00:07:00 Areas Areas of Parallelogram & Triangle 1 00:10:00 Areas of Parallelogram _ Triangle 2 00:10:00 Practice Problems based on Areas 1 00:05:00 Practice Problems based on Areas 2 00:12:00 Mensuration of 2 dimensional figures Mensuration Formulae 00:07:00 Practice problems on 2-d figures 00:11:00 Assignment (Video) on 2 - d figure 00:02:00 Areas related to the circle 00:05:00 Practice questions on areas related to circle 00:10:00 Practice Test (Check your knowledge of Geometry) Practice Test (Geometry) 00:02:00 Concept of Unit Digit What is Unit Digit? 01:00:00 How to find unit digit of numbers with exponents 00:10:00 Practice Problems based on Unit Digit 00:08:00 Simplification Problems-1 Simplifications based on Percentages 00:11:00 Simplification based on Exponents 00:12:00 Fastest method of finding square roots 00:12:00 Fastest method of finding cube roots 00:03:00 Simplification based on square and cube roots 00:16:00 Simplification Problems 01:00:00 Crack Simplification Problems-2 Simplification Problems Type 1 00:10:00 Simplification problems Type 1 00:08:00 Simplification problems Type 2 00:08:00 Simplification problems Type 3 00:08:00 Simplification problems Type 4 00:07:00 Finding smallest and greatest from difficult exponents 00:08:00 Simplification using Digital sum What is Digital Sum 00:05:00 What is Digital Sum? 00:20:00 How to Apply Digital Sum Technique in Different Operations 00:14:00 Simplification Problems using Digital Sum 1 00:07:00 Simplification Problems using Digital Sum 2 00:06:00 Time and Work Simplification Problems using Digital Sum -2 00:06:00 Resources Download 1 01:10:00 Problems based on Persons, Days, Work and Hours 00:12:00 Shortcut Formulas for Most Common Problems 00:11:00 Problems based on Two Persons 00:06:00 Problems based on Three Persons 00:10:00 Based on Efficiency 00:13:00 Complex Problems on Efficiency 00:10:00 Fraction of Work 00:07:00 Leaving and Joining 1 00:06:00 Men, Women and Boys 00:05:00 Work and Wages 00:11:00 Pipes and Cisterns Resources Download 1 00:25:00 Basics of Pipes and Cisterns 00:06:00 Pipes and Cisterns - Type 1 00:07:00 Pipes and Cisterns - Type 2 00:04:00 Pipes and Cisterns - Type 3 00:07:00 Pipes and Cisterns - Type 4 00:06:00 Pipes and Cisterns - Type 5 00:05:00 Speed , Distance and Time Speed, Distance and Time Resources Download 00:45:00 Basic Concepts and Simple Problems 00:10:00 Problems Based on Average Speed 00:07:00 Problems of Finding Distance 00:13:00 Practice Problems 1 00:10:00 Practice Problems 2 00:08:00 Practice Problems 3 00:07:00 Boats and Streams Boats and Streams 00:25:00 Basics of Boats and Streams 00:10:00 Finding Speed of Boat or Stream 00:13:00 Problems Based on Finding Distance 00:06:00 Latest Problems on Boat and Cisterns 00:11:00 Percentage Percentage Basics 1 00:10:00 Percentage Basics 2 00:04:00 Fractional Values of Percentages 00:09:00 Simplification using Fractional Values of Percentages -1 00:06:00 Simplification Problems of Percentage 2 00:05:00 Article for Resources 00:25:00 Word Problems Problems Based on Marks in Examination 00:15:00 Problems Based on Price and Quantity 1 00:08:00 Problems Based on Price and Quantity 2 00:08:00 Word Problems Based on Income 00:08:00 Resources for the Section 'Word Problems' 00:25:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Register on the Math Tricks & Shortcuts today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Math Tricks & Shortcuts is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Math Tricks & Shortcuts Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Math Tricks & Shortcuts, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction Introduction 00:02:00 Geometry Lines and Angles (Basics) 00:07:00 Parallel lines (Basics) 00:06:00 Practice Problems 1 (Lines and Angles) 00:06:00 Triangles (Basics) 00:11:00 Practice Problems 2 (angle sum and exterior angle Property) 00:10:00 Pythagoras Theorem 00:13:00 Inequalities in Triangles 00:06:00 Sine and Cosine Rule 00:12:00 Median, Altitude, Angle bisector 00:06:00 Practice problems 3 00:10:00 Properties of Medians 00:09:00 Practice Problems 4 00:07:00 Properties of Equilateral Triangles 00:04:00 Some special Quadrilaterals 00:08:00 Polygons-interior angles, diagonals etc. 00:08:00 Angle Bisector Theorem 00:07:00 Congruent Triangles 00:06:00 Similar Triangles 00:14:00 Practice Problems 5 00:10:00 Circle 00:10:00 Cyclic Quadrilateral _ Tangent to circle 00:07:00 Areas Areas of Parallelogram & Triangle 1 00:10:00 Areas of Parallelogram _ Triangle 2 00:10:00 Practice Problems based on Areas 1 00:05:00 Practice Problems based on Areas 2 00:12:00 Mensuration of 2 dimensional figures Mensuration Formulae 00:07:00 Practice problems on 2-d figures 00:11:00 Assignment (Video) on 2 - d figure 00:02:00 Areas related to the circle 00:05:00 Practice questions on areas related to circle 00:10:00 Practice Test (Check your knowledge of Geometry) Practice Test (Geometry) 00:02:00 Concept of Unit Digit What is Unit Digit? 01:00:00 How to find unit digit of numbers with exponents 00:10:00 Practice Problems based on Unit Digit 00:08:00 Simplification Problems-1 Simplifications based on Percentages 00:11:00 Simplification based on Exponents 00:12:00 Fastest method of finding square roots 00:12:00 Fastest method of finding cube roots 00:03:00 Simplification based on square and cube roots 00:16:00 Simplification Problems 01:00:00 Crack Simplification Problems-2 Simplification Problems Type 1 00:10:00 Simplification problems Type 1 00:08:00 Simplification problems Type 2 00:08:00 Simplification problems Type 3 00:08:00 Simplification problems Type 4 00:07:00 Finding smallest and greatest from difficult exponents 00:08:00 Simplification using Digital sum What is Digital Sum 00:05:00 What is Digital Sum? 00:20:00 How to Apply Digital Sum Technique in Different Operations 00:14:00 Simplification Problems using Digital Sum 1 00:07:00 Simplification Problems using Digital Sum 2 00:06:00 Time and Work Simplification Problems using Digital Sum -2 00:06:00 Resources Download 1 01:10:00 Problems based on Persons, Days, Work and Hours 00:12:00 Shortcut Formulas for Most Common Problems 00:11:00 Problems based on Two Persons 00:06:00 Problems based on Three Persons 00:10:00 Based on Efficiency 00:13:00 Complex Problems on Efficiency 00:10:00 Fraction of Work 00:07:00 Leaving and Joining 1 00:06:00 Men, Women and Boys 00:05:00 Work and Wages 00:11:00 Pipes and Cisterns Resources Download 1 00:25:00 Basics of Pipes and Cisterns 00:06:00 Pipes and Cisterns - Type 1 00:07:00 Pipes and Cisterns - Type 2 00:04:00 Pipes and Cisterns - Type 3 00:07:00 Pipes and Cisterns - Type 4 00:06:00 Pipes and Cisterns - Type 5 00:05:00 Speed , Distance and Time Speed, Distance and Time Resources Download 00:45:00 Basic Concepts and Simple Problems 00:10:00 Problems Based on Average Speed 00:07:00 Problems of Finding Distance 00:13:00 Practice Problems 1 00:10:00 Practice Problems 2 00:08:00 Practice Problems 3 00:07:00 Boats and Streams Boats and Streams 00:25:00 Basics of Boats and Streams 00:10:00 Finding Speed of Boat or Stream 00:13:00 Problems Based on Finding Distance 00:06:00 Latest Problems on Boat and Cisterns 00:11:00 Percentage Percentage Basics 1 00:10:00 Percentage Basics 2 00:04:00 Fractional Values of Percentages 00:09:00 Simplification using Fractional Values of Percentages -1 00:06:00 Simplification Problems of Percentage 2 00:05:00 Article for Resources 00:25:00 Word Problems Problems Based on Marks in Examination 00:15:00 Problems Based on Price and Quantity 1 00:08:00 Problems Based on Price and Quantity 2 00:08:00 Word Problems Based on Income 00:08:00 Resources for the Section 'Word Problems' 00:25:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Register on the The Complete Full-Stack JavaScript Course! today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The The Complete Full-Stack JavaScript Course! is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The The Complete Full-Stack JavaScript Course! Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the The Complete Full-Stack JavaScript Course!, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction and Setup Welcome To The Course 00:11:00 Environment Setup 00:12:00 Anatomy of a React Project 00:13:00 Getting Started with ReactJS Writing a React Component 00:09:00 Purchasing and Procurement Management 01:40:00 The React State 00:15:00 Understanding Component Props and Re-rendering 00:18:00 Importing CSS Into React Components[iframevideo] [/iframevideo] 00:05:00 Building a ReactJS Website Coding a calculator part 1 00:19:00 Coding a Calculator Part 2 00:35:00 React Website Setup 00:06:00 Component Children 00:17:00 React Routing 00:10:00 Route Parameters and HTML Slicing Part 1 00:15:00 Route Parameters and HTML Slicing Part 2 00:17:00 Services and Portfolio Pages Part 2 00:10:00 Working With Forms in React Part 1 00:16:00 Working With Forms in React Part 2 00:22:00 Using Formik 00:23:00 Yup Form Validation Schemas 00:17:00 Rest API with LoopbackJS Setup of REST API Using LoopbackJS 00:15:00 Creating Models 00:13:00 Model Observers 00:16:00 Model Relations 00:16:00 ESLINT 00:09:00 Subclassing Access Tokens 00:06:00 Persisting Data Using MongoDB 00:20:00 Creating Data 00:07:00 Updating Data 00:04:00 Finding Model Instances Part 2 00:03:00 Deleting Model Instances 00:07:00 Creating Post Collection 00:06:00 Roles and Rolemapping 00:14:00 Applying Access Control to Our Post Model 00:13:00 Adding an Editor Role 00:10:00 Creating a Category Model 00:09:00 File Storage and Collection Part 1 00:15:00 File Storage and Collection Part 2 00:10:00 Custom Remote Methods and File Uploads Part 1 00:18:00 Custom Remote Methods and File Uploads Part 2 00:14:00 Creating Login Route 00:18:00 Adding a Login Form 00:12:00 Redux and Material-UI Wrapping Components 00:11:00 Dispatching Actions 00:06:00 Creating Our Store and Reducers 00:24:00 Integrating Remote API Calls 00:22:00 Applying Middle Ware 00:15:00 Material-UI Intro 00:12:00 Drawer and CSS 00:16:00 Drawer Collapsing and Animations 00:14:00 Icons, Lists, Links 00:17:00 Main Content Class 00:14:00 Persisting Reducers Using Local Storage 00:15:00 Basic Tables 00:11:00 Fetching Posts and Users From Our API 00:21:00 Fab Buttons 00:12:00 Setting up Redux, Material-UI and Formik for Our Add Post Page 00:12:00 Material-UI Forms With Formik 00:19:00 Flex Display and Connecting Our Post Form to Our Database via Redux Part 1 00:15:00 Flex Display and Connecting Our Post Form to Our Database via Redux Part 2 00:15:00 Editing Existing Posts 00:28:00 Uploading Post Images Part 1 00:16:00 Uploading Post Images Part 2 00:17:00 Integrating Quill as a Content Editor 00:18:00 Loading Posts on the Front-end Part 1 00:14:00 Loading Posts on The Front-end Part 2 00:17:00 Loading More Posts on Demand 00:12:00 Single Post Page 00:27:00 Registering New Accounts 00:25:00 Posting Comments and Adding Relations and ACLs to Our API Part 1 00:20:00 Posting Comments and Adding Relations and ACLs to Our API Part 2 00:19:00 Deploying React Apps With NGINX 00:26:00 Deploying Our API Using PM2 And NGINIX Part 1 00:18:00 Deploying Our API Using PM2 And NGINIX Part 2 00:14:00 Deploying Our API Using PM2 And NGINIX Part 3 00:17:00 WebSocket Chat Application Creating A Chat App 00:08:00 Creating Our Chat Store 00:11:00 Websocket Connections 00:08:00 Sending Socket Messages 00:13:00 Creating Signup and Login Forms 00:18:00 Writing Account Based Logic Part 1 00:30:00 Writing Account Based Logic Part 2 00:02:00 Using Auth Tokens 00:13:00 Styling The Messenger 00:21:00 Tracking Logged In Users 00:14:00 Search Functionality 00:20:00 Creating New Threads And Sending To Relevant Clients 00:27:00 Connecting On Page Load If Already Logged In 00:24:00 Get Threads on Page Load 00:10:00 Disconnecting Socket Sessions 00:11:00 Adding Messages and Sending to Relevant Clients 00:32:00 Rendering Messages Client-side 00:19:00 Rendering Messages With User Information 00:23:00 Ejecting a React Application 00:09:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

In today's dynamic job market, proficiency in Employee Hiring and Termination is not just desirable but essential. Understanding the intricacies of the recruitment process, from sourcing candidates to conducting virtual interviews, is pivotal in securing the right talent for organizational success. Equally important is comprehending the nuances of Employee Termination, ensuring legal compliance and maintaining a positive employer brand. The course covers a comprehensive curriculum, including Recruitment Methods, Human Resource Management, and Key Skills in Recruitment, providing a holistic understanding of the hiring process. Moreover, mastering Employee On-Boarding and Termination Procedures enhances one's employability, particularly in the UK job market, where such skills are highly sought after. Professionals equipped with this expertise can expect competitive salaries, with average earnings ranging from £25,000 to £35,000 annually. The increasing demand for skilled individuals in this sector is evident, with a steady rise in job opportunities by 7% annually, highlighting the significance and advantages of undertaking this course for career advancement. Key Features: CPD Certified Employee Hiring and Termination Course Free Certificate Developed by Specialist Lifetime Access Course Curriculum: Module 01: Introduction To Recruitment Process Model Module 02: Recruitment Methods Module 03: Human Resource Management Module 04: Key Skills And Issues In Recruitment Function Module 05: Virtual Interviewing Module 06: Employee On-Boarding Module 07: Introduction To Employee Termination Module 08: The Employee Termination Procedure Module 09: Employee Termination Letter And Guide Learning Outcomes: Understand recruitment process models for effective hiring strategies. Implement various recruitment methods to attract suitable candidates. Demonstrate knowledge of human resource management principles in recruitment. Identify key skills and address issues in the recruitment function. Utilize virtual interviewing techniques for remote candidate assessment. Execute employee onboarding processes to integrate new hires efficiently. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Introduction to Employee Hiring and Termination course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Employee Hiring and Termination. Moreover, this course is ideal for: HR professionals seeking comprehensive recruitment and termination knowledge. Managers responsible for hiring and terminating employees in their departments. Small business owners needing to understand recruitment and termination procedures. Individuals aspiring to enter HR roles with foundational knowledge. Employees transitioning into HR-related responsibilities within their organisations. Requirements There are no requirements needed to enrol into this Introduction to Employee Hiring and Termination course. We welcome individuals from all backgrounds and levels of experience to enrol into this Introduction to Employee Hiring and Termination course. Career path After finishing this Employee Hiring and Termination course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Employee Hiring and Termination are: HR Manager - £35K to 60K/year. Recruitment Consultant - £25K to 45K/year. Talent Acquisition Specialist - £30K to 50K/year. HR Coordinator - £20K to 35K/year. Employee Relations Advisor - £25K to 45K/year. Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

The Animal Care & Behaviour: Obedience & Health course is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Animal Care & Behaviour Course consists of several modules that take around 2 hour to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn a e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion PDF Certificate at £9.99. Print copy by post is also available at an additional cost of £15.99 and the same for PDF and printed transcripts. Course Content Module 01: Introduction to the Care and Animal Welfare of All Species Introduction to The Care and Animal Welfare of All Species 00:06:00 Module 02: Basic Animal Health Basic Animal Health 00:06:00 Module 03: First Aid for Animals First Aid for Animals 00:07:00 Module 04: Getting to Know the Dogs & Puppies Getting to Know the Dogs & Puppies 00:09:00 Module 05: Getting to Know the Kittens and Cats Getting to Know the Kittens and Cats 00:10:00 Module 06: Learning about Horses Learning about Horses 00:06:00 Module 07: Learning about Birds Learning about Birds 00:07:00 Module 08: Specific Information on Rabbits & Guinea-Pigs Specific Information on Rabbits & Guinea-Pigs 00:05:00 Module 09 : Specific Information on Ornamental Fish Specific Information on Ornamental Fish 00:08:00 Module 10: Specific Information on Reptiles Specific Information on Reptiles 00:06:00 Mock Exam Mock Exam - Animal Care & Behaviour: Obedience & Health 00:20:00 Final Exam Final Exam - Animal Care & Behaviour: Obedience & Health 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

The Build Your Algebra Fundamentals is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Build Your Algebra Fundamentals consists of several modules that take around 11 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion PDF Certificate at £9.99. Print copy by post is also available at an additional cost of £15.99 and the same for PDF and printed transcripts. Course Content Introduction Lecture 1 Introduction 00:03:00 Fundamental concepts on Algebraic Expressions Lecture 2 What is Algebra 00:02:00 Lecture 3 Simple Equations 00:05:00 Lecture 4 What are Polynomials 00:04:00 Lecture 5 Terms in Polynomials 00:03:00 Lecture 6 Degree of Polynomials 00:05:00 Lecture 7 Writing statements to algebraic form 00:04:00 Operations on Algebraic Expressions Lecture 8 Integers and common mistakes in solving integers 00:13:00 Lecture 9 Arrangement of Terms 00:07:00 Lecture 10 Powers on integers 00:04:00 Lecture11 Simplification using BODMAS 00:08:00 Lecture 12 Distributive Properties in Polynomials 00:04:00 Lecture 13 Simplify Polynomials 00:10:00 Lecture 14 Additions of Polynomials 00:06:00 Lecture 15 Subtractions of Polynomials 00:10:00 Indices ( Exponents) Lecture 16 The rules of Indices in algebra 00:11:00 Lecture 17 Fractional indices 00:10:00 Lecture 18 Understanding indices (practice questions) 00:07:00 Lecture 19 Problems from IGCSE Last year papers 00:09:00 Multiplication and Division of Algebraic expressions Lecture 20 Multiplication of monomial to Polynomial 00:09:00 Lecture 21 Multiplication of Polynomial by Polynomial 00:06:00 Lecture 22 Division of algebraic expression by a monomial 00:08:00 Lecture 23 Division of algebraic expression by another polynomial 00:09:00 Lecture 24 Division of a polynomial by another polynomial with remainder 00:11:00 Brackets in Algebra Lecture 25 Rules of brackets 00:04:00 Lecture 26 Simplification by removing brackets 00:11:00 Linear equations in one variable Lecture 27 Simplification of algebraic fractions 00:07:00 Lecture 28 Rules to solve linear equations in one variable 00:03:00 Lecture 29 Solving linear equations in one variable 00:07:00 Lecture 30 Solving complex linear equations in one variable 00:10:00 Lecture 31 Word problems on linear equations in one variable 00:13:00 Algebraic Identities Lecture 32 What are Identities? 00:05:00 Lecture 33 Identity ( a + b ) ² 00:13:00 Lecture 34 Identity ( a - b ) ² new 00:07:00 Lecture 35 Identity a² - b² = (a-b) (a +b ) new 00:07:00 Lecture 36 -- Standard Identities ( a + b + c ) ² = a ² + b ² + c ² + 2 a b + 2 a c +2 b c old 00:07:00 Lecture 37 Identity (x + a) (x + b) Identity Derivation & Application new 00:08:00 Lecture 38 Pascal's Triangle _ Identity ( a + b ) ³ new 00:07:00 Lecture 39 Identities( a - b ) ³, ( a ³ + b ³) and (a ³ - b ³) new 00:13:00 Lecture 40 - Standard Identities a ³ + b ³ + c ³ - 3 a b c 00:10:00 Formula : Change of subject of formula Lecture 41 -Changing the subject of formula 00:08:00 Linear Inequalities Lecture 42 - Linear Inequalities 00:12:00 Resolve into factors Lecture 43 - Factorization by taking out common factor 00:10:00 Lecture 44 - Factorization by grouping the terms 00:09:00 Lecture 45 - factorize using identity a ² - b ² 00:07:00 Lecture 46 - factorize using identity (a + b )² and (a - b )² (2) 00:08:00 Lecture 47 - factorize using identity ( a + b + c ) ² 00:05:00 Lecture 48 - factorization by middle term split 00:12:00 Algebraic Fractions Lecture 49 -Simplification of algebraic fractions 00:06:00 Coordinate axis - points and Line graph Lecture 50 All that you need to know about co ordinate axis 00:04:00 Lecture 51 Some important facts needed to draw line graph 00:03:00 Lecture 52 - How to draw a line graph on coordinate plane 00:03:00 Lecture 53 Drawing line graphs 00:06:00 System of simultaneous linear equations in two variables Lecture 54 Simultaneous Linear Equations in two variables- intro 00:03:00 Lecture 55 Graphical method of solving linear equations 00:06:00 Lecture 56 Graphical method - more problems 00:10:00 Lecture 57 Method of Elimination by substitution 00:09:00 Lecture 58 Method of Elimination by Equating coefficients 00:11:00 Lecture 59 Method of Elimination by cross multiplication 00:07:00 Lecture 60 Equations reducible to simultaneous linear equations 00:12:00 Lecture 61 Word Problems on Linear equations 00:18:00 Polynomials Lecture 62 Polynomials and Zeros of polynomials 00:10:00 Lecture 63 Remainder Theorem 00:04:00 Lecture 64 Factor Theorem 00:08:00 Lecture 65 Practice problems on Remainder and Factor Theorem 00:09:00 Lecture 66 Factorization using factor Theorem 00:10:00 Quadratic Polynomials Lecture 67 Zeros of polynomials α, β & γ 00:10:00 Lecture 68 Relation between zeros and coefficients of a polynomials 00:13:00 Lecture 69 Finding polynomials if zeros are known 00:06:00 Lecture 70 Practice problems on zeros of polynomials 00:10:00 Lecture 71Problems solving with α and β (part 1) 00:11:00 Lecture 72 Problems solving with α and β (part 2) 00:10:00 Quadratic Equations Lecture73 what are Quadratic equations 00:03:00 Lecture 74 Solutions by factorization method 00:12:00 Lecture 75 Solutions by completing square formula 00:06:00 Lecture 76 Deriving Quadratic formula 00:05:00 Lecture 77 Practice problems by Quadratic formula 00:07:00 Lecture 78 Solving complex quadratic equations by Quadratic Formula 00:11:00 Lecture 79 Solutions of reducible to Quadratic Formula 00:09:00 Lecture 80 Skilled problems on Quadratic Equations 00:07:00 Lecture 81 Exponential problems reducible to Quadratic Equations 00:06:00 Lecture 82 Nature of Roots of Quadratic Equations 00:09:00 Lecture 83 Word problems on quadratic Equations Part 1 00:13:00 Lecture 84 Word problems on quadratic Equations Part 2 00:11:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Register on the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content 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 Thank you 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 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Register on the The Care Certificate Preparation today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The The Care Certificate Preparation is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The The Care Certificate Preparation Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the The Care Certificate Preparation, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Standard 01: Understand your role The Duties and Responsibilities of a Care Worker 00:22:00 Employment Rights and Responsibilities 00:21:00 Aims, objectives and values of the service 00:12:00 Responsibilities to the Individuals 00:22:00 Different Working Relationships in Care Settings 00:09:00 The Importance of Partnership Working 00:15:00 Standard 02: Your personal development Identify Sources of Support for Own Learning and Development 00:16:00 Skills That Healthcare Professionals Need 00:18:00 Standard 03: Duty of Care What Is Duty of Care 00:35:00 Dilemmas That may Arise Between the Duty of Care and an Individual's Rights 00:25:00 Procedures for Responding to Complaints 00:35:00 Recognising Adverse Events, Incidents, Errors and Near Misses 00:20:00 Factors and Difficult Situations That may Cause Confrontation 00:23:00 Standard 04: Equality and Diversity Understanding Diversity 00:12:00 Discrimination that can be Deliberately or Unintentional 00:16:00 legislation and codes of practice relating to equality 00:12:00 Respecting individuals' beliefs, culture, values and preferences 00:09:00 Sources of Information for Diversity, Equality, and Inclusion 00:07:00 Standard 05: Work in A Person-Centred Way Putting Person-Centred Values into Practice 00:12:00 The Importance of Finding out the History, Preferences, Wishes and Needs 00:17:00 Environmental Factors that may cause Discomfort or Distress 00:08:00 Raising concerns directly with the individual concerned 00:10:00 Caregiving is more than just monitoring medicines and driving to doctor 00:16:00 Ensuring the comfort of individuals where they have restricted movement 00:15:00 Promoting person centred values 00:06:00 Recognising the signs of pain or discomfort 00:09:00 Standard 06: Communication Different Ways that People Communicate 00:24:00 Why it is important to observe and be receptive to an individual 00:07:00 Establishing an Individual's Communication and Language Needs, Wishes ans Preferences 00:09:00 Barriers to Effective Communication 00:14:00 How to Check whether the Health Care Support Worker and Adult Social Care 00:05:00 What Is Confidentiality 00:08:00 The Use of Appropriate Verbal and Non-Verbal Communication 00:16:00 Communication Aids 00:07:00 Standard 07: Privacy and Dignity What is meant by privacy and dignity 00:17:00 Maintaining the Privacy of the Individual 00:27:00 Ways of Helping Individuals to Make Informed Choices 00:30:00 How Valuing People Contributes to Active Participation 00:22:00 Supporting the Active Participation of Individuals in Their Care 00:09:00 Standard 08: Fluids and Nutrition The Importance of Food Safety, including Hygiene, in the Preparation and Hand 00:20:00 Ensuring That Drinks Are within Reach of Those That Have Restriction on Their Movement 00:10:00 Ensuring that any Nutritional Products are within Reach of those that have Restriction on Their Movement 00:08:00 Standard 09: Awareness of Mental Health, Dementia and Learning Disabilities How someone may feel if they have mental health conditions 00:20:00 How Conditions Influence a Person's Needs in Relation to Care 00:25:00 How Positive Attitudes towards those with mental health conditions 00:18:00 Adjustments which may be Necessary in Care Delivery 00:29:00 Importance of Early Detection of Mental Health Needs, Dementia or Learning Disability 00:14:00 Requirements of Legislation and Policies 00:28:00 Effect of listed legislation and policies 00:11:00 Capacity 00:20:00 Standard 10: Safeguarding Adults Safeguarding adults 00:10:00 Types of Abuse 00:18:00 Defining 'Harm' 00:11:00 Indicators of Abuse 00:13:00 Factors Which have Featured in Adult Abuse and Neglect 00:17:00 How Care Environments can Promote and Undermine People's Dignity and Rights 00:14:00 Reducing the Likelihood of Abuse with Risk Enablement and Management 00:10:00 Appropriate Actions to take When Abuse is Suspected 00:15:00 Legislation, Local and National Policies and Procedures Related to Safeguarding Adults 00:12:00 The Importance of Sharing Information with the Relevant Agencies 00:13:00 Standard 11: Safeguarding Children Safeguarding Children at Level 1 00:09:00 Actions to Take If a Child, Young Person (Met in Any Circumstances) Is Suspected to Be Abused 00:09:00 Standard 12: Basic Life Support Basic Life Support (BLS) 00:19:00 Standard 13: Health and Safety Legislation Relating to General Health and Safety in a Health or Social Care Work Settings 00:12:00 Health and Safety Policies and Procedures 00:16:00 How to Access Additional Support and Information Relating to Health and Safety 00:12:00 The Importance of Risk Assessment for Health and Safety Standards 00:11:00 Legislation Relating to Moving and Assisting 00:13:00 Procedures to Follow When Accidents or Illness Occur 00:21:00 Protecting Security 00:12:00 Identifying Common Signs of Stress in a Work Setting 00:15:00 Standard 14: Handling Information Agreed Ways of Working regarding the Recording 00:25:00 Importance to Have Secure Systems for Recording, Storing and Sharing Information 00:17:00 How to Keep Records That Are Up to Date, Complete, Accurate and Legible 00:20:00 Standard 15: Infection Prevention and Control The Main Ways an Infection Can Get into the Body 00:11:00 Effective Hand Hygiene 00:11:00 Risk to the individuals 00:10:00 Common types of personal protective clothing, equipment and procedures 00:10:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.