4470 Courses delivered Online

Overview Learn the secrets to successful leadership with this complete professional development training course for managers and supervisors. The Diploma in Executive & Business Process Management course is designed to take your management skills to the next level, taking you through business fundamental best practices, etiquettes and skills. It will teach you the qualities of a leader to boost your confidence leading teams and individuals, introducing different management style theories. This course will help you to strengthen your own management style and become a more competent professional when managing projects, teams and stakeholders. Enrol today and take your career to the next level!  Why buy this Diploma in Executive & Business Process Management? 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 Diploma in Executive & Business Process Management you 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 Diploma in Executive & Business Process Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Diploma in Executive & Business Process Management 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 Diploma in Executive & Business Process Management is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 1: Understanding Management and Leadership Understanding Management and Leadership 00:42:00 Module 2: Leadership Theories Leadership Theories 00:27:00 Module 3: Improving Management and Leadership Performance Improving Management and Leadership Performance 00:17:00 Module 4: High Performance Teams High Performance Teams 00:34:00 Module 5: Motivating Employees Motivating Employees 00:28:00 Module 6: Organisational Skills Organisational Skills 00:28:00 Module 7: Talent Management Talent Management 00:39:00 Module 8: Succession Planning Succession Planning 00:26:00 Module 9: Business Process Management Business Process Management 00:30:00 Module 10: Communication Skills Communication Skills 00:29:00 Module 11: Negotiation Techniques Negotiation Techniques 00:17:00 Module 12: Managing Meetings and Giving Feedback Managing Meetings and Giving Feedback 00:24:00 Module 13: Managing Change Managing Change 00:24:00 Module 14: Time Management Time Management 00:39:00 Module 15: Stress Management Stress Management 00:17:00 Module 16: Emotional Intelligence in Leadership Emotional Intelligence in Leadership 00:34:00 Module 17: Managing Conflict Managing Conflict 00:24:00 Module 18: Dealing with Office Politics Dealing with Office Politics 00:36:00 Module 19: Risk Management Risk Management 00:37:00 Module 20: Corporate Responsibility and Ethics Corporate Responsibility and Ethics 00:16:00 Module 21:Microsoft Word, Excel, PowerPoint Microsoft Word 08:06:00 Microsoft Excel 03:59:00 Microsoft PowerPoint 08:24:00 Assignment Assignment - Diploma in Executive Management 00:00:00

Master Business Analysis skills by enrolling the Business Analysis Advanced Course course. The course covers the essential management and leadership aspects of the analysis role, the analysis of budget and finance, market evaluation, analysing competition and selecting marketing strategies. In spite of these, the course lets you design a business plan and helps you to choose the right staffs for you. 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 Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Course Content Business Analysis Business Planning Basics 01:00:00 Market Evaluation 01:00:00 Analyze Competition 01:00:00 Determine A Marketing Strategy 01:00:00 Decide What Extras You May Need Like Staff etc 00:30:00 The Dangers In Not Making A Business Plan 00:15:00 Wrapping Up 00:15:00 Finance & Budgeting Financing Basics 00:45:00 Record Your Income 01:00:00 Make a List of Expenses First and Put Them in Categories 01:00:00 Countdown & Adjust 01:00:00 Review Regularly 01:00:00 Reference Book Business Analysis 00:00:00 Mock Exam Mock Exam- Advanced Business Analysis Course 00:30:00 Final Exam Final Exam- Advanced Business Analysis Course 00:30:00 Assignment Assignment - Business Analysis Advanced Course 3 weeks, 3 days Order Your Certificate Order your Certificate QLS 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.

Looking to enhance your skills and boost your career prospects in the business industry? Look no further than the Level 2 Certificate in Business Improvement Techniques course! This course is designed to provide you with the fundamental skills needed to improve business performance and productivity. You will learn how to identify problems, analyse data, and implement solutions to optimise business processes and drive growth. The curriculum of this course covers a range of topics including Lean principles, Six Sigma methodologies, and process mapping techniques. You will also gain knowledge on quality control, project management, and continuous improvement. The Level 2 Certificate in Business Improvement Techniques is ideal for those looking to start or progress their career in the business sector. Whether you are new to the industry or looking to enhance your existing skills, this course will equip you with the knowledge and confidence to excel in your role. Learning outcomes: Develop an understanding of business development and succession planning strategies to support organizational growth and stability. Apply process management techniques to improve efficiency and productivity in the workplace. Analyze supply chain management processes and identify opportunities for improvement. Plan and forecast operations using appropriate tools and methods to ensure effective resource allocation. Develop skills in communication, negotiation, and conflict management to facilitate effective team leadership and collaboration. Upon completion of this course, you will have gained a valuable qualificate that will enhance your employability and demonstrate your commitment to continuous learning and development. You will also be able to apply the skills and knowledge learned in this course to real-world business scenarios, making you a valuable asset to any organisation. Invest in your future and enrol in the Level 2 Certificate in Business Improvement Techniques course today. This Level 2 Certificate in Business Improvement Techniques course covers a comprehensive range of modules aimed at equipping individuals with the necessary skills to improve business performance. The course covers various topics such as business development, process management, supply chain management, procurement, project management, and quality management, among others. Additionally, the course provides training in essential management skills such as leadership, conflict resolution, and talent management. Learners will also gain proficiency in negotiation techniques, communication skills, and business etiquette, among others. This course is ideal for individuals seeking to improve their business performance and advance their careers in management or business administration. Curriculum Module 01: Business Development and Succession Planning Module 02: Process Management Module 03: Supply Chain Management Module 04: Planning & Forecasting Operations Module 05: Procurement & Purchasing Management Module 06: Project Management Module 07: Retail Pricing Module 08: Business Analysis Planning and Monitoring Module 09: Strategic Analysis and Product Scope Module 10: Quality Management Module 11: Management Skills for Leading Your Team Module 12: Selling in Multiple Channels Module 13: Representing Your Boss and Company Module 14: Preparing for Brainstorming Module 15: Generating Solutions (I) Module 16: Generating Solutions (II) Module 17: Analyzing Solutions Module 18: Selecting a Solution Module 19: Negotiation Techniques Module 20: Communication Skills Module 21: Skills of an Effective Administrator Module 22: What is Marketing? Module 23: Common Marketing Types (I) Module 24: Common Marketing Types (II) Module 25: Conflict Management Module 26: Talent Management Module 28: Managing Risk and Recovery Module 27: Time Management Module 29: Business Etiquette Certificate After completing this course, you will get a Free PDF certificate, which is CPD Quality Standards Certified. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Level 2 Certificate in Business Improvement Techniques is suitable for individuals who are interested in developing their skills and knowledge in business improvement techniques. It is also appropriate for those who are currently working in a business environment and wish to enhance their understanding of processes and productivity. Please Note: This is not a regulated course. To get professional qualification, you can choose any of the following: Level 2 Certificate in Lean Organisation Management Techniques (RQF) Level 2 Certificate in Business Improvement Techniques (RQF) Level 2 NVQ Diploma in Business Improvement Techniques (RQF) Level 2 Certificate in Team Leading (RQF) Level 2 Certificate in Business Administration (RQF) Level 2 Certificate in Customer Service (RQF) Level 2 Certificate in Sales and Marketing (RQF) Level 2 Certificate in Digital Marketing (RQF) Level 2 Certificate in Project Management (RQF) Level 2 Certificate in Data Protection and Compliance (RQF) Level 2 Certificate in Information Technology (RQF) Level 2 Certificate in Retail Operations (RQF) Career path Production: £21,000 - £44,000 per year Quality Control: £18,000 - £40,000 per year Project Management: £26,000 - £67,000 per year Supply Chain Management: £24,000 - £61,000 per year Purchasing: £21,000 - £50,000 per year Administration: £15,000 - £31,000 per year Marketing: £20,000 - £48,000 per year Business Analysis: £26,000 - £60,000 per year Certificates Certificate of completion Digital certificate - Included

Are you looking to improve your current abilities or make a career move? Our unique operations management course might help you get there! Expand your expertise with high-quality training - study the operations management course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the operations management online training course. This Diploma in Operations Management at QLS Level 5 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 150 CPD points) to make your skill development & career progression more accessible than ever! Why Prefer This Diploma in Operations Management Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS after completing the Diploma in Operations Management course Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. The operations management course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the operations management course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this operations management course. This operations management training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join this diploma in operations management program today and gear up for excellence. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the operations management course: Cleaning Supervisor 01: Introduction to Operations Management Cleaning Supervisor 02: Project Management Cleaning Supervisor 03: Business Development and Succession Planning Cleaning Supervisor 04: Process Management Cleaning Supervisor 05: Supply Chain Management Cleaning Supervisor 06: Planning & Forecasting Operations Cleaning Supervisor 07: Procurement & Purchasing Management Cleaning Supervisor 08: Manufacturing & Delivery Operations Cleaning Supervisor 09: Quality Management Cleaning Supervisor 10: Managing Risk and Recovery Cleaning Supervisor 11: Performance Management Cleaning Supervisor 12: Talent Management Cleaning Supervisor 13: Communication Skills Cleaning Supervisor 14: Negotiation Techniques Cleaning Supervisor 15: Conflict Management Cleaning Supervisor 16: Stress Management Cleaning Supervisor 17: Time Management Assessment Process After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Diploma in Operations Management at QLS Level 5 exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this operations management course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path Enrolling on this Diploma in Operations Management training can lead you to the following career opportunities: Operations Manager Business Operations Analyst Program Manager Business Process Manager Production Manager Project Manager Supervisor General Manager Production Executive Certificates Certificate of completion Digital certificate - £10 Diploma in Operations Management at QLS Level 5 Hard copy certificate - £119 Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Operations Management at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 119 GBP inside the UK 129 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)

*** A Better Pathway for Rapid Growth! Limited Time Opportunity; Hurry Up! *** Ignite your dynamic career and strengthen your deep insight knowledge by signing up for Strategic Risk and Crisis Management. This Strategic Risk and Crisis Management is the ideal approach for you to obtain a thorough understanding and knowledge of the subject. We are concerned about the progression of your career. Therefore, after conducting extensive studies and consulting with experienced personnel, we formulated this outstanding Strategic Risk and Crisis Management course to improve your pertinent skills. In this easy-to-digest course, you will get exclusive training, which will enable you to stand out in this competitive market. However, the Strategic Risk and Crisis Management course covers all of the recent materials in order to keep you up to date with the job market and make you a good fit for your career. This top-notch course curriculum comprises basic to advanced levels of modules that will increase your skillsets. After completing this Programme, you will attain the productivity to succeed in your organisation. So, if you are eager to see yourself in a gratifying Strategic Risk and Crisis Management career, then enrol in our course today! What will make you stand out? On completion of this online course, you will gain: After successfully completing the Strategic Risk and Crisis Management Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of Strategic Risk and Crisis Management learning materials. Online test with immediate results Enroling in the Course has no additional costs. You can study and complete the course at your own pace. Study for the Strategic Risk and Crisis Management course using any internet-connected device, such as a computer, tablet, or mobile device. The substantial Strategic Risk and Crisis Management is designed to help you demonstrate the preliminary to in-depth level of learning regarding this topic. Moreover, you will be provided with the most knowledgeable and informative modules for your lifetime by enroling in this Strategic Risk and Crisis Management just once. Furthermore, as you proceed through the modules of this course, you will discover the fundamentals of Strategic Risk and Crisis Management and explore the key topics such as: Strategic Risk and Crisis Management Module 01: Introduction to Risks and Risk Analysis Module 02: Process of Risk Analysis and Management Module 03: Corporate of Risk Management Module 04: Managing Financial Risks Module 05: Introduction to Crisis and Crisis Management Module 06: Crisis Response and Communication Module 07: Incidents Management and Emergency Response Plan Module 08: Crisis Management Team Module 09: Post Crisis Phase Therefore, reinforce your knowledge and furnish your skills by enroling in our Strategic Risk and Crisis Management course. Take one step closer to achieving your goal. Show off your new skills with a certificate of completion When you have finished all of the course lectures, a digital certificate will be available for download. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Strategic Risk and Crisis Management Course the Right Option for You? This course is recommended for anyone who is interested in learning more about this topic. You'll learn the fundamental ideas and gain a comprehensive understanding of the topic by taking this course. This course is open to everybody. You can access the course materials from any location in the world and there are no requirements for enrolment. You should enrol in this course if you: Aspire to understand Strategic Risk and Crisis Management better. Already working on Strategic Risk and Crisis Management and eager to learn more. Is a student pursuing a relevant field of study? Trying to get a job in Strategic Risk and Crisis Management-related fields. Requirements Without any formal requirements, you can delightfully enrol in this Strategic Risk and Crisis Management course. Just get a device with internet connectivity and you are ready to start your learning journey. Thus, complete this course at your own pace. Career path The aim of this exclusive Strategic Risk and Crisis Management course is to help you toward your dream career. So, complete this course and enhance your skills to explore opportunities in relevant areas.

Ignite your dynamic career and strengthen your deep insight knowledge by signing up for Mushroom Farming Techniques. This Mushroom Farming Techniques is the ideal approach for you to obtain a thorough understanding and knowledge of the subject. We are concerned about the progression of your career. Therefore, after conducting extensive studies and consulting with experienced personnel, we formulated this outstanding course to improve your pertinent skills. In this easy-to-digest Mushroom Farming Techniques course, you will get exclusive training, which will enable you to stand out in this competitive market. However, the Mushroom Farming Techniques course covers all of the recent materials in order to keep you up to date with the job market and make you a good fit for your career. This top-notch course curriculum comprises basic to advanced levels of modules that will increase your skillsets. After completing this Programme, you will attain the productivity to succeed in your organisation. So, if you are eager to see yourself in a gratifying career, then enrol in our course today! What will make you stand out? On completion of this online course, you will gain: CPD QS Accredited After successfully completing the Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. The online test with immediate results You can study and complete the course at your own pace. Study for the course using any internet-connected device, such as a computer, tablet, or mobile device. The substantial Mushroom Farming Techniques is designed to help you demonstrate the preliminary to in-depth level of learning regarding this topic. Moreover, you will be provided with the most knowledgeable and informative modules for your lifetime by enrolling in this course just once. Furthermore, as you proceed through the modules of this course, you will discover the fundamentals of Mushroom Farming Techniques and explore the key topics such as: Mushroom Farming Techniques Module-01: Introduction to Mushroom Cultivation Module-02: Identifying Edible Mushrooms Module-03: Mushroom Culture Part One Module-04: Mushroom Culture Part Two Module-05: Mushroom Spawning Module-06: Mushroom Compost Part One Module-07: Mushroom Compost Part Two Module-08: Making and Casing Mushroom Beds Module-09: Mushrooms Growing Conditions Module-10: Growing Mushrooms Outside Module-11: Harvesting and Storing Mushrooms Module-12: Mushroom Business Therefore, reinforce your knowledge and furnish your skills by enrolling in our course. Take one step closer to achieving your goal. Show off your new skills with a certificate of completion Once you complete the Mushroom Farming Techniques course, you will be eligible to request a digital certificate for free. For Printed Transcript & Hardcopy Certificate - 4.99 GBP (Inside the UK Postal Fee) 8.99 GBP (International Delivery Fee) CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Mushroom Farming Techniques Course the Right Option for You? This course is recommended for anyone who is interested in learning more about this topic. You'll learn the fundamental ideas and gain a comprehensive understanding of the topic by taking this Mushroom Farming Techniques course. Requirements Without any formal requirements, you can delightfully enrol in this course. Career path The aim of this exclusive Mushroom Farming Techniques course is to help you toward your dream career. So, complete this course and enhance your skills to explore opportunities in relevant areas.

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •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 •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 •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 •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 •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 •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 •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 •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: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00

Overview This comprehensive course on Understand Piping & Instrumentation Diagrams P&IDs will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Understand Piping & Instrumentation Diagrams P&IDs comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Understand Piping & Instrumentation Diagrams P&IDs. It is available to all students, of all academic backgrounds. Requirements Our Understand Piping & Instrumentation Diagrams P&IDs is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 14 sections • 119 lectures • 08:26:00 total length •Introduction: 00:04:00 •What's a P&ID ?: 00:03:00 •Why is a P&ID so important ?: 00:02:00 •Who uses P&ID's ?: 00:06:00 •How do P&ID's look like ?: 00:08:00 •Introduction- PID READING: 00:02:00 •Anatomy of a P&ID: 00:01:00 •The title block: 00:03:00 •The drawing scale: 00:03:00 •The grid system: 00:02:00 •The revision block: 00:03:00 •Changes: 00:02:00 •Notes and legends: 00:03:00 •Valve symbols: 00:14:00 •Valve actuator symbols: 00:09:00 •Control valve designations: 00:02:00 •Standards and conventions for valve status: 00:07:00 •Process equipment symbols: 00:12:00 •Piping symbols: 00:03:00 •Pipe fitting symbols: 00:03:00 •Isolating, venting & draining symbols for ease of maintenance: 00:05:00 •Instrumentation: 00:03:00 •Sensing devices and detectors: 00:04:00 •Location symbols: 00:04:00 •Modifiers and transmitters: 00:05:00 •Indicators and recorders: 00:03:00 •Controllers: 00:03:00 •Example #1 : Identifying process equipment and flow paths: 00:05:00 •Example #2 : Identifying valve position and failure mode: 00:03:00 •Example #3 : Identifying the symbols: 00:02:00 •Piping designation code: 00:06:00 •Equipment designation code: 00:03:00 •Instrument designation code: 00:02:00 •Miscellaneous designation codes: 00:02:00 •The process: 00:01:00 •Process control: 00:06:00 •The control loop: 00:02:00 •Process control terms: 00:10:00 •Control loops : Feedback control: 00:02:00 •Pressure control loops: 00:01:00 •Flow control loops: 00:01:00 •Level control loops: 00:01:00 •Temperature control loops: 00:01:00 •Multi-variable loops: 00:02:00 •Feedforward control: 00:02:00 •Feedforward + Feedback: 00:01:00 •Cascade control: 00:08:00 •Split range control: 00:03:00 •Operations on control signals: 00:02:00 •Ratio control: 00:02:00 •Batch control: 00:01:00 •Selective control: 00:01:00 •Do we need to control at all ?: 00:01:00 •Principles of equipment-wise control: 00:10:00 •Pipe control system: 00:02:00 •Control of a single pipe: 00:02:00 •Control of pressure in a pipe: 00:03:00 •Control of flow in a pipe: 00:04:00 •Flow merging: 00:08:00 •Flow splitting: 00:05:00 •Centrifugal pump control: 00:04:00 •Control valve vs Variable Frequency Drive (VFD) for centrifugal pumps: 00:03:00 •Minimum flow control for centrifugal pumps: 00:09:00 •Positive displacement pump control: 00:02:00 •Control by a recirculation pipe for PD pumps: 00:03:00 •Variable Speed Drive (VSD) control for PD pumps: 00:01:00 •Control by stroke adjustment for PD pumps: 00:01:00 •Compressor control system: 00:02:00 •Compressor capacity control: 00:12:00 •Compressor anti-surge control: 00:03:00 •Heat transfer equipment control: 00:02:00 •Heat exchanger direct control system: 00:04:00 •Heat exchanger bypass control system: 00:04:00 •Reactor temperature control: 00:06:00 •Air cooler control: 00:02:00 •Heat exchanger for heat recovery: 00:01:00 •Heat exchanger back pressure control: 00:02:00 •Basic fired heater control: 00:08:00 •Complex fired heater control: 00:05:00 •Container and vessel control: 00:07:00 •Container blanket gas control: 00:02:00 •Safety strategies: 00:01:00 •Concept of Safety Instrumented Systems (SIS): 00:01:00 •SIS actions and types: 00:14:00 •SIS extent: 00:02:00 •SIS requirement: 00:03:00 •Anatomy of a SIS: 00:02:00 •SIS element symbols: 00:01:00 •SIS primary elements : Sensors: 00:03:00 •SIS final elements: 00:04:00 •Switching valve actuator arrangements: 00:02:00 •Valve position validation: 00:02:00 •Merging a switching valve and a control valve: 00:03:00 •SIS logics: 00:01:00 •Showing safety instrumented functions on P&ID's: 00:07:00 •Discrete control: 00:05:00 •Alarm system: 00:02:00 •Anatomy of alarm systems: 00:02:00 •Alarm requirements: 00:06:00 •Alarm system symbology in P&ID's: 00:06:00 •Concept of common alarms: 00:01:00 •Fire and Gas Detection Systems (FGS): 00:03:00 •Electric motor control: 00:07:00 •P&ID representation of commands and responses: 00:05:00 •P&ID representation of inspection and repair: 00:05:00 •P&ID example of electro-motor control: 00:04:00 •P&ID example #1 : Legend and specifications: 00:05:00 •P&ID example #2 : Hydrogen delivery station: 00:16:00 •P&ID example #3 : Acid system: 00:13:00 •P&ID example #4 : Centrifugal pump: 00:09:00 •P&ID example #5 : Utility station: 00:04:00 •P&ID example #6 : Waste water filter: 00:08:00 •P&ID example #7 : Steam separator: 00:15:00 •P&ID example #8 : Flare knock-out drum: 00:14:00 •P&ID example #9 : Centrifugal compressor: 00:05:00 •P&ID example #10 : Hydrogen production from shale gas: 00:11:00 •P&ID example #11 : Fired heater: 00:07:00 •Resources - Understand Piping & Instrumentation Diagrams P&IDs: 00:00:00 •Assignment - Understand Piping & Instrumentation Diagrams P&IDs: 00:00:00

Flash Sale Now On | Gifts: PDF Certificate

Overview This comprehensive course on R Programming for Data Science will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This R Programming for Data Science comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this R Programming for Data Science. It is available to all students, of all academic backgrounds. Requirements Our R Programming for Data Science is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 23 sections • 129 lectures • 06:25:00 total length •Introduction to Data Science: 00:01:00 •Data Science: Career of the Future: 00:04:00 •What is Data Science?: 00:02:00 •Data Science as a Process: 00:02:00 •Data Science Toolbox: 00:03:00 •Data Science Process Explained: 00:05:00 •What's Next?: 00:01:00 •Engine and coding environment: 00:03:00 •Installing R and RStudio: 00:04:00 •RStudio: A quick tour: 00:04:00 •Arithmetic with R: 00:03:00 •Variable assignment: 00:04:00 •Basic data types in R: 00:03:00 •Creating a vector: 00:05:00 •Naming a vector: 00:04:00 •Vector selection: 00:06:00 •Selection by comparison: 00:04:00 •What's a Matrix?: 00:02:00 •Analyzing Matrices: 00:03:00 •Naming a Matrix: 00:05:00 •Adding columns and rows to a matrix: 00:06:00 •Selection of matrix elements: 00:03:00 •Arithmetic with matrices: 00:07:00 •Additional Materials: 00:00:00 •What's a Factor?: 00:02:00 •Categorical Variables and Factor Levels: 00:04:00 •Summarizing a Factor: 00:01:00 •Ordered Factors: 00:05:00 •What's a Data Frame?: 00:03:00 •Creating Data Frames: 00:20:00 •Selection of Data Frame elements: 00:03:00 •Conditional selection: 00:03:00 •Sorting a Data Frame: 00:03:00 •Additional Materials: 00:00:00 •Why would you need lists?: 00:01:00 •Creating a List: 00:06:00 •Selecting elements from a list: 00:03:00 •Adding more data to the list: 00:02:00 •Additional Materials: 00:00:00 •Equality: 00:03:00 •Greater and Less Than: 00:03:00 •Compare Vectors: 00:03:00 •Compare Matrices: 00:02:00 •Additional Materials: 00:00:00 •AND, OR, NOT Operators: 00:04:00 •Logical operators with vectors and matrices: 00:04:00 •Reverse the result: (!): 00:01:00 •Relational and Logical Operators together: 00:06:00 •Additional Materials: 00:00:00 •The IF statement: 00:04:00 •IFELSE: 00:03:00 •The ELSEIF statement: 00:05:00 •Full Exercise: 00:03:00 •Additional Materials: 00:00:00 •Write a While loop: 00:04:00 •Looping with more conditions: 00:04:00 •Break: stop the While Loop: 00:04:00 •What's a For loop?: 00:02:00 •Loop over a vector: 00:02:00 •Loop over a list: 00:03:00 •Loop over a matrix: 00:04:00 •For loop with conditionals: 00:01:00 •Using Next and Break with For loop: 00:03:00 •Additional Materials: 00:00:00 •What is a Function?: 00:02:00 •Arguments matching: 00:03:00 •Required and Optional Arguments: 00:03:00 •Nested functions: 00:02:00 •Writing own functions: 00:03:00 •Functions with no arguments: 00:02:00 •Defining default arguments in functions: 00:04:00 •Function scoping: 00:02:00 •Control flow in functions: 00:03:00 •Additional Materials: 00:00:00 •Installing R Packages: 00:01:00 •Loading R Packages: 00:04:00 •Different ways to load a package: 00:02:00 •Additional Materials: 00:00:00 •What is lapply and when is used?: 00:04:00 •Use lapply with user-defined functions: 00:03:00 •lapply and anonymous functions: 00:01:00 •Use lapply with additional arguments: 00:04:00 •Additional Materials: 00:00:00 •What is sapply?: 00:02:00 •How to use sapply: 00:02:00 •sapply with your own function: 00:02:00 •sapply with a function returning a vector: 00:02:00 •When can't sapply simplify?: 00:02:00 •What is vapply and why is it used?: 00:04:00 •Additional Materials: 00:00:00 •Mathematical functions: 00:05:00 •Data Utilities: 00:08:00 •Additional Materials: 00:00:00 •grepl & grep: 00:04:00 •Metacharacters: 00:05:00 •sub & gsub: 00:02:00 •More metacharacters: 00:04:00 •Additional Materials: 00:00:00 •Today and Now: 00:02:00 •Create and format dates: 00:06:00 •Create and format times: 00:03:00 •Calculations with Dates: 00:03:00 •Calculations with Times: 00:07:00 •Additional Materials: 00:00:00 •Get and set current directory: 00:04:00 •Get data from the web: 00:04:00 •Loading flat files: 00:03:00 •Loading Excel files: 00:05:00 •Additional Materials: 00:00:00 •Base plotting system: 00:03:00 •Base plots: Histograms: 00:03:00 •Base plots: Scatterplots: 00:05:00 •Base plots: Regression Line: 00:03:00 •Base plots: Boxplot: 00:03:00 •Introduction to dplyr package: 00:04:00 •Using the pipe operator (%>%): 00:02:00 •Columns component: select(): 00:05:00 •Columns component: rename() and rename_with(): 00:02:00 •Columns component: mutate(): 00:02:00 •Columns component: relocate(): 00:02:00 •Rows component: filter(): 00:01:00 •Rows component: slice(): 00:04:00 •Rows component: arrange(): 00:01:00 •Rows component: rowwise(): 00:02:00 •Grouping of rows: summarise(): 00:03:00 •Grouping of rows: across(): 00:02:00 •COVID-19 Analysis Task: 00:08:00 •Additional Materials: 00:00:00 •Assignment - R Programming for Data Science: 00:00:00