3605 Model courses in Leeds delivered On Demand

Take your first step toward Natural Language Processing with this beginner-to-pro course. Gain an in-depth understanding of deep learning models for NLP with the help of examples. Learn the essential concepts from the absolute beginning with complete unraveling along with examples in Python.

The primary aim of this course is to equip participants with a comprehensive understanding of the customer decision-making process and how marketing communications can be used to influence consumer behavior. By the end of the course, participants will be able to understand the different types of consumer decision-making, identify the factors that influence consumer behavior, and develop effective marketing communications strategies. After the successful completion of the course, you will be able to learn about the following, Customer Decision-Making. A General Buying Decision-Making Process. Types Of Consumer Decision-Making. Perceived Risk. Involvement Theory. Hedonic Consumption. Organisational Buying Decision Processes. Strategy And Marketing Communications. The Role Of Marketing Communications. Elaboration Likelihood Model. Towards A Model Of Marketing Communications. This course is designed to provide participants with an in-depth understanding of the customer decision-making process and the role of marketing communications in influencing consumer behavior. The course will cover the general buying decision-making process, types of consumer decision-making, perceived risk, involvement theory, and hedonic consumption. Participants will also learn about organizational buying decision processes and the role of marketing communications, including the elaboration likelihood model and developing an effective marketing communications strategy. This course is designed to provide participants with an in-depth understanding of the customer decision-making process and the role of marketing communications in influencing consumer behavior. The course will cover the general buying decision-making process, types of consumer decision-making, perceived risk, involvement theory, and hedonic consumption. Participants will also learn about organizational buying decision processes and the role of marketing communications, including the elaboration likelihood model and developing an effective marketing communications strategy. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Consumer Decision Making & Marketing Communication Self-paced pre-recorded learning content on this topic. Consumer Decision Making and Marketing Communication Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Marketing Professionals & Product Managers Sales Professionals Business Owners Advertising Professionals Brand Managers & Market Researchers Digital Marketers & Communication Specialists Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

This video course is designed to teach you about the latest WidgetKit developments in iOS 16, and how to use them with SwiftUI. You will learn about new features such as live activities and Dynamic Island, and explore how to create dynamic widgets for your iOS applications using SwiftUI. It's a great way to enhance your skills and create high-quality widgets.

Register on the Machine Learning Basics 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 Machine Learning Basics 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 Machine Learning Basics Receive an 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) Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate 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 Machine Learning Basics, 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 Section 01: Introduction Introduction to Supervised Machine Learning 00:06:00 Section 02: Regression Introduction to Regression 00:13:00 Evaluating Regression Models 00:11:00 Conditions for Using Regression Models in ML versus in Classical Statistics 00:21:00 Statistically Significant Predictors 00:09:00 Regression Models Including Categorical Predictors. Additive Effects 00:20:00 Regression Models Including Categorical Predictors. Interaction Effects 00:18:00 Section 03: Predictors Multicollinearity among Predictors and its Consequences 00:21:00 Prediction for New Observation. Confidence Interval and Prediction Interval 00:06:00 Model Building. What if the Regression Equation Contains 'Wrong' Predictors? 00:13:00 Section 04: Minitab Stepwise Regression and its Use for Finding the Optimal Model in Minitab 00:13:00 Regression with Minitab. Example. Auto-mpg: Part 1 00:17:00 Regression with Minitab. Example. Auto-mpg: Part 2 00:18:00 Section 05: Regression Trees The Basic idea of Regression Trees 00:18:00 Regression Trees with Minitab. Example. Bike Sharing: Part1 00:15:00 Regression Trees with Minitab. Example. Bike Sharing: Part 2 00:10:00 Section 06: Binary Logistics Regression Introduction to Binary Logistics Regression 00:23:00 Evaluating Binary Classification Models. Goodness of Fit Metrics. ROC Curve. AUC 00:20:00 Binary Logistic Regression with Minitab. Example. Heart Failure: Part 1 00:16:00 Binary Logistic Regression with Minitab. Example. Heart Failure: Part 2 00:18:00 Section 07: Classification Trees Introduction to Classification Trees 00:12:00 Node Splitting Methods 1. Splitting by Misclassification Rate 00:20:00 Node Splitting Methods 2. Splitting by Gini Impurity or Entropy 00:11:00 Predicted Class for a Node 00:06:00 The Goodness of the Model - 1. Model Misclassification Cost 00:11:00 The Goodness of the Model - 2 ROC. Gain. Lit Binary Classification 00:15:00 The Goodness of the Model - 3. ROC. Gain. Lit. Multinomial Classification 00:08:00 Predefined Prior Probabilities and Input Misclassification Costs 00:11:00 Building the Tree 00:08:00 Classification Trees with Minitab. Example. Maintenance of Machines: Part 1 00:17:00 Classification Trees with Miitab. Example. Maintenance of Machines: Part 2 00:10:00 Section 08: Data Cleaning Data Cleaning: Part 1 00:16:00 Data Cleaning: Part 2 00:17:00 Creating New Features 00:12:00 Section 09: Data Models Polynomial Regression Models for Quantitative Predictor Variables 00:20:00 Interactions Regression Models for Quantitative Predictor Variables 00:15:00 Qualitative and Quantitative Predictors: Interaction Models 00:28:00 Final Models for Duration and Total Charge: Without Validation 00:18:00 Underfitting or Overfitting: The 'Just Right Model' 00:18:00 The 'Just Right' Model for Duration 00:16:00 The 'Just Right' Model for Duration: A More Detailed Error Analysis 00:12:00 The 'Just Right' Model for Total Charge 00:14:00 The 'Just Right' Model for Toral Charge: A More Detailed Error Analysis@@ 00:06:00 Section 10: Learning Success Regression Trees for Duration and TotalCharge 00:18:00 Predicting Learning Success: The Problem Statement 00:07:00 Predicting Learning Success: Binary Logistic Regression Models 00:17:00 Predicting Learning Success: Classification Tree Models 00:09: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.

Overview This comprehensive course on Psychology & Treatment of Addiction will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Psychology & Treatment of Addiction 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 Psychology & Treatment of Addiction. It is available to all students, of all academic backgrounds. Requirements Our Psychology & Treatment of Addiction 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 6 sections • 21 lectures • 01:53:00 total length •Introduction: About instructor & the course: 00:02:00 •The Moral Model: 00:06:00 •The Psychological Model: 00:07:00 •The Medical / Disease Model: 00:09:00 •The Socio-Cultural Model: 00:05:00 •Pharmacotherapy: 00:03:00 •The Minnesota Model: 00:04:00 •Counselling and Therapy: 00:07:00 •Harm Reduction Model: 00:05:00 •Treatments in Practice: 00:05:00 •Drug policies, Legislation and Decriminalisation: 00:09:00 •Community change, Outreach, Harm Reduction or Abstinence: 00:06:00 •Alcohol and Drug education: 00:06:00 •Alcohol- and drug related issues in the workplace: 00:05:00 •Codependency, Children of alcoholic families, parenting styles, family factors: 00:08:00 •Relapse for families, 'letting go', dependent attitudes and dependent behaviours: 00:05:00 •Al-Anon: 00:05:00 •The Intervention Approach: 00:05:00 •Why be a 'helper': 00:03:00 •'Helper' qualities and attitudes: 00:04:00 •Counselling / 'helping' skills: 00:04:00

This course provides a holistic perspective on market planning by examining both external and internal environments. From dissecting industry competitiveness using Porter's Five Forces to strategic analysis with McKinsey's Seven S Model, participants will gain insights into the intricacies of effective marketing strategies. After the successful completion of the course, you will be able to learn about the following, Develop the ability to define and understand the components of the marketing environment. Acquire knowledge and skills related to implementing innovation in marketing strategies. Gain proficiency in conducting PESTLE analysis to assess external factors influencing business environments. Understand and apply the BCG matrix for strategic analysis of a product or business portfolio. Develop a comprehensive understanding of Porter's Five Forces model for analyzing industry competitiveness. Explore the role of marketing in Corporate Social Responsibility (CSR) initiatives. Familiarize yourself with McKinsey's Seven S Model for organizational analysis and strategic planning. Discover the nuances of the marketing environment with a focus on PESTLE analysis and strategic innovation. Dive into tools like the BCG matrix for product portfolio evaluation and explore the role of marketing in Corporate Social Responsibility (CSR). This course ensures a well-rounded understanding of essential frameworks for designing impactful marketing plans. This course empowers participants to navigate the complexities of marketing by examining external and internal dynamics. From mastering PESTLE analysis for environmental assessment to leveraging McKinsey's Seven S Model for strategic planning, participants will acquire the expertise needed for diverse roles, including Marketing Strategist, CSR Manager, and Market Analyst. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding External and Internal Environment for designing a market plan Self-paced pre-recorded learning content on this topic. External and Internal Environment for Designing a Market Plan Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Marketing Strategist Market Analyst Corporate Social Responsibility Manager Strategic Planner Innovation Specialist Product Portfolio Manager Industry Analyst Marketing Environment Analyst Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

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

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want This life coaching course will help you to learn powerful coaching techniques, effective communication skills and transformative strategies to help people thrive in all aspects of life. With this course, you will become a certified life coach, equipped to make a positive impact on the lives of others. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand Life coaching fundamentals such as listening template, questioning, trust checklist, and more Learn various coaching models such as GROW Model, STEPPA Model etc. Understand different coaching steps such as goal setting, reality, options and obstacles, Will and Action Planning Learn how to structure your coaching sessions Discover the relationship between the client and the coach Know advanced coaching strategies such as managing emotional states or personal SWOT analysis Get acquainted with diet and nutrition fundamentals Understand exercise coaching such as cardio or resistance training Why Life Coaching Course right for you? The life coaching course online will give you a basic overview of coaching fundamentals, a listening introduction, three kinds of listening as a coach, and your listening template. You will learn the difference between coaching and standard questions and types of coaching questions. This extensive course will teach you advanced coaching strategies and introduce the concept of trust. You will explore different personality models such as the Big Five personality model, Myers Briggs personality model and steps to identify your personality model. By the end of the course, you will gain life coaching skills and theoretical knowledge on coaching fundamentals, models, personality models, and methods to structure your coaching sessions. Life Coaching Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Introduction What You Will Learn Get To Know Your Instructor Part 1 : Life Coaching Certification What Is Life Coaching The Benefits Of Becoming A Life Coach The Difference Between Coaching, Therapy, Mentoring & Training The Responsibilities Of A Life Coach Coaching Fundamentals Coaching Fundamentals Overview Listening Introduction The 3 Kinds Of Listening As A Coach Your Listening Template Questioning Introduction Questioning & Coaching How Coaching Questions Are Different From Normal Questions The Different Types Of Coaching Questions Questions Summary Building Trust Introduction The Trust Checklist Exercise How To Build Trust As A Coach More Trust Building Strategies Understanding Personalities Understanding Personalities Overview Big Five Personality Model Myers Briggs Personality Model Your Personality Model How To Bring Out Your Strengths With This Model. Coaching Models Explained Coaching Models Introduction GROW Model Explained STEPPPA Model Explained FUEL Model Explained CLEAR Model Explained Why We Will Use The GROW Model Coaching Step 1: Goal Setting Step 1 Introduction Why Defining Your Values Is Important. How To Define Your Personal Values. What Does Your Ideal Life Look Like. The 4 Biggest Goal Setting Mistakes To Avoid Stretch Goals Explained Why You Should Start With Long Term Goals. Setting Your First Long Term Goal Turning Long Term Goals Into Short Term Goals Next Steps Coaching Step 2: Reality Step 2 Introduction Status Quo Explained Wheel Of Life Excercise Explained Big Rocks Exercise Explained Coaching Example Step 2 Coaching Step 3: Option & Obstacles Step 3 Introduction How To Brainstorm With Your Client(s). How To Evaluate Your Brainstorming Ideas. 'Spheres Of Influence' Excerise Explained 'Not To Do List' Exercise Explained Coaching Example Step 3 Coaching Step 4: Will & Action Planning Step 4 Introduction The 80/20 Rule Applied To Coaching How To Design An Action Plan Coaching Example Step 4 GROW Model Recap How To Structure Your Coaching Sessions. Structuring Your Sessions Introduction How To Define Your Coaching Ground Rules. How Much Should You Charge. The Pre Coaching Call Your First Coaching Session Progress Evaluation Sessions My Recommended Coaching Timeline Clint Coach Relationship Client Coach Relationship Intro What Clients Expect From Their Coaches. Why Clients Choose One Coach Over Another. Client Coach Boundaries How To Retain Clients Long Term. Advanced Coaching Strategies Advanced Coaching Strategies Introduction Reframing Explained Managing Emotional States Understanding Representational Systems Personal SWOT Analysis Johari Window - Developing Self Awareness Giving Good Feedback As A Coach Part 2: Holistic Health Coaching Certification Part 2 Introduction What It Means To Be Healthy What Does A Health Coach Do. How Can You Combine Life Coaching & Health Coaching. Diet & Nutrition Fundamentals Diet Introduction Your Health & Diet: How They Are Linked The Consequences Of Following A Bad Diet How To Eat For Longevity What Are Calories? Explained The Relationship Between Bodyweight And Health Calories & Bodyweight In A Healthy Diet The Surprising Results Of The Twinkie Diet The Relationship Between Weight Loss And Health Calculating Your Total Daily Calories Healthy Weight Ranges The Best Foods For A Healthier Life Best Protein Foods Best Carbohydrate Foods Best Dietary Fat Foods How Much Of Each (Protein, Carbs, Fat). Diet & Nutrition Coaching Client Assessment Introduction Client Interview How To Create A Diet Plan For Clients. Calculating BMI Exercise Coaching: Cardio Cardio Introduction The Different Types Of Cardio How To Monitor Your Heart Rate During A Workout. Cardio vs Weigh Training - Which Is Better For Weight Loss Exercise Coaching: Resistance Training Weight Training Introduction Muscle Building Formula The Science Behind Muscle Growth Weight Training vs Bodyweight Training How To Create A Beginner Workout Plan 5 Most Important Aspects Of Lifting Form Progressive Overload Hormone Health Explained Hormones Introduction The 3 Types Of Hormones The Endocrine System Explained Hormones & Heart Disease Anabolic Steroids: Why They Are So Dangerous Most Important Hormones Overview Insulin Glucagon Adrenaline Cortisol Ghrelin Leptin Thyroid Hormones Estrogen Growth Hormone Testosterone Supplements How To Build Your Own Supplement Stack Top 3 Beginner Supplements For Muscle Growth The Best Supplements To Boost Immunity The Best Supplements For Vegans & Vegetarians The Best Supplements For Joint & Bone Health The Best Supplements For Fat Loss Health & Fitness Motivation Health & Fitness Motivation Introduction The Role Of Stress In Motivation The Motivation Problem How To Build Willpower 8 Steps To Building Fitness Discipline How To Get Out Of A Workout Rut. More Tips To Stay Motivated Health & Fitness FAQ Answered What Is Nutrient Density. Is Brown Sugar Better Than White Sugar. What Should You Train On Your First Day At The Gym. Fresh vs Frozen Food: Which Is Healthier Part 3: Wellness Coaching Certification Part 3 Introduction Steers Management The Difference Between Stress & Anxiety Short vs Long Term Stress The Effects Of Stress & Anxiety On Your Body Proven Stress Management Strategies & Techniques The Benefits Of Calm Breathing Breathing Exercise #1 - Three Part Breath Breathing Exercise #2 - Bellows Breath Progressive Muscle Relaxation Complete PMR Routine Sleep Sleeping For A Longer Life Tips To Fall Asleep Faster Supplements For Improved Sleep Emotional Self Care What Is Emotional Self Care How To Accept Yourself. Taming Your Inner Critic Getting A Different Perspective Acknowledging Your Qualities Getting Rid Of Time-Consuming Commitments How To Say 'No' To Others. Who should take this course? This online course is suitable for those who want to pursue a career in life coaching or anyone interested in learning life coaching and various coaching models in general. Entry Requirements There are no academic entry requirements for this Life Coaching course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This life coaching online course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum SAMHI Dual Diagnosis Introduction Video SAMHI Dual Diagnosis Intro Video and Downloadable Worksheet / PowerPoint Slides 00:04:00 Module 1 - Drugs and Effects Module 1 - Drugs and Effects: Video Part 1 (content part 1 - 4) 00:16:00 Module 1 - Drugs and Effects: VIDEO PART 2 (Content Part 5 - 6) 00:20:00 Module 1 - Drugs and Effects: Video Part 3 (Content Part 7 - 8) 00:20:00 Module 1 - Drugs and Effects: Video Part 4 (Content Part 9) 00:15:00 Module 1 - Drugs and Effects: Video Part 5 (Content Part 10) 00:10:00 Module 1 - Drugs and Effects: Video Part 6 (Content 10 - 12) 00:18:00 Module 1 - Drugs and Effects: Video Part 7 (Content Part 13) 00:13:00 Module 1 - Drugs and Effects: Video Part 8 (Content Part 14) 00:20:00 Module 1 - Drugs and Effects: Video Part 9 (Content 14) 00:20:00 Module 1 - Drugs And Effects: Video Part 10 (Content Part 15 - 18) 00:19:00 Module 2 Addictions & Mental Health Module 2 Addictions & Mental Health: Video Part 1 Content Part 1 - 2 00:16:00 Module 2 Addictions & Mental Health: Video Part 2 Content Part 3 - 5 00:19:00 Module 2 Addictions & Mental Health: Video Part 3 Content Part 6 - 7 00:13:00 Module 2 Addictions & Mental Health: Video Part 4 Content Part 00:17:00 Module 2 Addictions & Mental Health: Video Part 5 Content Part 00:18:00 Module 2 Addictions & Mental Health: Video Part 6 Content Part 00:20:00 Module 2 Addictions & Mental Health: Video Part 7 Content Part 00:14:00 Module 2 Addictions & Mental Health: Video Part 8 Content Part 00:12:00 Module 2 Addictions & Mental Health: Video Part 9 Content Part 00:20:00 Module 2 Addictions & Mental Health: Video Part 10 Content Part 00:13:00 Module 3 Harm Minimisation & Optimal Health Module 3 Harm Minimisation & Optimal Health Video Part 1 Content Part 00:23:00 Module 3 Harm Minimisation & Optimal Health Video Part 2 Content Part 00:17:00 Module 3 Harm Minimisation & Optimal Health Video Part 3 Content Part 00:09:00 Module 3 Harm Minimisation & Optimal Health Video Part 4 Content Part 00:18:00 Module 3 Harm Minimisation & Optimal Health Video Part 5 Content Part 00:17:00 Module 3 Harm Minimisation & Optimal Health Video Part 1 Content Part 6 00:11:00 Module 3 Harm Minimisation & Optimal Health Video Part 7 Content Part 7 00:12:00 Module 4 Brain Works - Neurophysiology Module 4 Brain Works - Neurophysiology 00:17:00 Module 4 Brain Works - Neurophysiology Video Part 1 Content Part 00:10:00 Module 4 Brain Works - Neurophysiology Video Part 2 Content Part 00:17:00 Module 4 Brain Works - Neurophysiology Video Part 3 Content Part 00:19:00 Module 4 Brain Works - Neurophysiology Video Part 4 Content Part 00:16:00 Module 4 Brain Works - Neurophysiology Video Part 5 Content Part 00:11:00 Module 5 Trauma Model & Keys to Treatment Module 5 Trauma Model & Keys to Treatment Video Part 1 Content Part 1 - 2a - 2f 00:20:00 Module 5 Trauma Model & Keys to Treatment Video Part 2 Content Part 2g 00:15:00 Module 5 Trauma Model & Keys to Treatment Video Part 3 Content Part 2h - 2i 00:15:00 Module 5 Trauma Model & Keys To Treatment Video Part 4 Content Part 3 00:13:00 Module 5 Trauma Model & Keys to Treatment Video Part 5 Content Part 4 00:12:00 Module 5 Trauma Model & Keys to Treatment Video Part 6 Content Part 5 - 7 00:18:00 Module 5 Trauma Model & Keys to Treatment Video Part 7 Content Part 8 00:17:00 Module 5 Trauma Model & Keys to Treatment Video Part 7 Content Part Video Part 8 00:16:00 Module 5 Trauma Model & Keys to Treatment Video Part 9 Content Part 11 00:16:00 Module 5 Trauma Model & Keys to Treatment Video Part 10 Content Part 12 00:19:00 Module 6 Brief & Early Intervention and Tripod of Support Module 6 Brief & Early Intervention And Tripod Of Support Video 1 Content Part 1 00:18:00 Module 6 Brief & Early Intervention and Tripod of Support Video 2 Content Part 2 00:20:00 Supplementary Resources Supplementary Resources - Addiction & Mental Health (Dual Diagnosis) Integrative 12hrs 00:00:00 Certificate of Achievement Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00