4758 Model courses delivered Online

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 Introduction to this Course Introduction to Leadership Styles 00:03:00 Exercise 1: What Concerns You Most about Leading Your People? 00:01:00 The Leadership Challenges before You 00:02:00 The Three Types of Leadership Model 00:04:00 Introduction to Situational Leadership The Principle behind Situational Leadership 00:02:00 Exercise 2: Four People 00:01:00 How did You Do? 00:01:00 Exercise 3: How have You been Led in the Past? 00:01:00 The Tannenbaum & Schmidt Leadership Continuum 00:03:00 The Three Factors that Determine Leadership Style 00:02:00 Simplifying your Leadership Model 00:02:00 A Practical Model for Day-to-Day Leadership How you Learned to Drive: The 'Conscious-Competence' Model 00:06:00 Applying Conscious-Competence to Leadership Styles 00:03:00 The First Two Skills You'll Need 00:01:00 Four Leadership Styles for Different Situations 00:06:00 Exercise 4: Put the Model to Work with Four More People 00:01:00 How did You Do? Feedback on Exercise 4 00:06:00 Exercise 5: Briefing 00:01:00 How did You Do? Feedback on Exercise 5 00:06:00 The Skills for Day-to-Day Leadership Styles Three More Skills You'll Need 00:01:00 Task and Goal Setting 00:05:00 Leadership is a Partnership 00:05:00 How to Offer Feedback 00:05:00 Positive Feedback or Negative Feedback 00:03:00 Exercise 6: Skills Audit 00:01:00 Bonus Content Applying Day-to-Day Leadership Skills to a Team 00:04:00 How to Lead a Team through a Transformation 00:02:00 Another Leadership Styles Model 00:09:00 Closing Section Exercise 7: What have You Learned? 00:01:00 Wishing You Well 00:02:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

In this self-paced course, you will learn how to use TensorFlow 2 to build deep neural networks. You will learn the basics of machine learning, classification, and regression. We will also discuss the connection between artificial and biological neural networks and how that inspires our thinking in deep learning.

Managing Successful Programmes (MSP®) 5th Edition Foundation: On-Demand MSP® certification provides guidance for programme managers, business change managers and the next step for project managers to develop their knowledge and skills to be able to positively respond to the challenges for managing programmes and larger, more strategic or multiple projects. MSP 5th edition emphasizes flexibility, adaptability, and responsiveness by adopting an incremental approach to the programme lifecycle and thus enabling organizational agility. AXELOS offers two levels of MSP Examination: MSP Foundation and MSP Practitioner. The MSP Foundation Examination is intended to assess whether the candidate can demonstrate sufficient recall and understanding of the MSP programme management framework. The MSP Foundation qualification is a prerequisite for the MSP Practitioner Examination, which assesses the ability to apply understanding of the MSP programme management framework in context. The MSP® 5th Edition Foundation course is a 3-day training based on the exam specification for MSP Foundation certification and is aligned with the Managing Successful Programmes (5th Edition) guide from AXELOS. What You Will Learn At the end of this course, participants will be able to: Understand key concepts relating to programmes and MSP Understand how the MSP principles underpin the MSP framework Understand the MSP themes and how they are applied throughout the programme Understand the MSP processes and how they are carried out throughout the programme Key Concepts of MSP Programmes Three Lenses of MSP Principles Themes and Governance Organization Organization Theme Organization Structure Individual Roles Stakeholder Management Design Design Theme Benefits Risk Identification and Prioritization Target Operating Model Documents and Key Roles Justification Justification Theme Business Case Financial Planning Documents and Key Roles Structure Structure Theme Delivery Planning Dependencies Benefits Realization Plan Resourcing Documents and Key Roles Knowledge Knowledge Theme Knowledge Management Information Management Document and Key Roles Assurance Assurance Theme Assurance at Multiple Levels Assurance Planning Document and Key Roles Decisions Decisions Theme Issue Resolution Risk Response Data Gathering and Reporting Options and Analysis Document and Key Roles MSP Processes Identify the Programme Design the Outcomes Plan Progressive Delivery Deliver the Capabilities Embed the Outcomes Evaluate New Information Close the Programme

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Actuary Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Actuary Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Actuary Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Actuary Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Actuary ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance 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 Actuary there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Actuary course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Actuary does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Actuary was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Actuary is a great way for you to gain multiple skills from the comfort of your home. Module 1 Introduction to Actuary Introduction to Actuary 00:12:00 Module 2 Actuaries and Their Environment Actuaries and Their Environment 00:14:00 Module 3 The Valuation of Cash Flows The Valuation of Cash Flows 00:12:00 Module 4 The Basic Deterministic Model The Basic Deterministic Model 00:11:00 Module 5 The Life Table The Life Table 00:11:00 Module 6 Life Annuities Life Annuities 00:14:00 Module 7 Life Insurance Life Insurance 00:12:00 Module 8 The Stochastic Life Contingencies Model The Stochastic Life Contingencies Model 00:11:00 Module 9 The Stochastic Approach to Insurance and Annuities The Stochastic Approach to Insurance and Annuities 00:11:00 Module 10 Taxation and Inflation Taxation and Inflation 00:08:00 Module 11 Probabilistic Models, Uncertain Payment and Profit Testing Probabilistic Models, Uncertain Payment and Profit Testing 00:08:00 Model 12 Individual Risk Models Individual Risk Models 00:07:00 Module 13 Principles of Premium Calculation (1)3 Principles of Premium Calculation (1) 00:10:00 Module 14 Multiple Decrement Theory3 Multiple Decrement Theory 00:09:00

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! This Diploma in Online Financial Modelling 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! Are you looking to improve your current abilities or make a career move? If yes, our unique Financial Modelling at QLS Level 5 course might help you get there! It is an expertly designed course which ensures you learn everything about the topic thoroughly. Expand your expertise with high-quality training from the Financial Modelling at QLS Level 5 course. Due to Financial Modelling at QLS Level 5's massive demand in the competitive market, you can use our comprehensive course as a weapon to strengthen your knowledge and boost your career development. Learn Financial Modelling at QLS Level 5 from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career. The Financial Modelling at QLS Level 5 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 Financial Modelling at QLS Level 5 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 Financial Modelling at QLS Level 5 course. This Financial Modelling at QLS Level 5 training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer This Financial Modelling at QLS Level 5 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. 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. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Financial Modelling at QLS Level 5 course: Module 01: Basic Financial Calculations Module 02: Overview of Financial Markets, Financial Assets, and Market Participants Module 03: Financial Statement Modelling Module 04: Types of Financial Models Module 05: Sensitivity Analysis Module 06: Sales and Revenue Model Module 07: Cost of Goods Sold and Inventory Model Module 08: Valuation Methods Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Online Financial Modelling at QLS Level 5 exams. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Financial Modelling at QLS Level 5 course is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements No prior background or expertise is required. Career path The Financial Modelling at QLS Level 5 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Certificates CPDQS Accredited Certificate Digital certificate - Included CPDQS Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location. Diploma in Online Financial Modelling at QLS Level 5 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Online Financial Modelling at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme and also you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost.

The Art of Delegation and High-Impact Feedback (Virtual) Whether you are a project manager, an executive, or simply someone involved in leading or helping others, a critical part of your work must involve delegating and giving feedback. These two skills, however, are not as simple as they seem. How do you know what to delegate? What kinds of feedback should you give? Knowing this and practicing this are two different things. Ultimately, delegating and giving feedback are skills that must be done mindfully, strategically, and meaningfully. They must be done in ways that not only positively impact performance, but also inspire growth, engagement, and motivation. When done poorly, they can create significant problems. But when done well, they can generate value for everyone and benefit future endeavors. In this course, you will learn to think more deeply about the importance of delegating and discover how to give better feedback. You will have opportunities to apply best practices and methodologies that you can use in the real world, ultimately paying off for you and for others. What You Will Learn At the end of this program, you will be able to: Explain why common excuses for NOT delegating are short-sighted Identify what needs delegating by using a proven methodology Utilize best practices in real world scenarios, delegating in a way that benefits you and the individual to whom you delegate Summarize key lessons learned in brain science which enhance the feedback-giving process Recognize the critical connection between feedback and performance Apply a proven model to deliver feedback that inspires growth, engagement, and motivation Delegation What is delegation? What makes delegation hard? What do I delegate and why? How to delegate effectively

Certified Business Relationship Manager (CBRM®): Virtual In-House Training The CBRM® Practitioner Qualification is intended for the intermediate-to-advanced Business Relationship Manager, as it focuses on advancing to the role of Strategic Business Relationship Manager. As such, the primary focus is on strategic business relationship management, leveraged to optimize business value to the enterprise. The purpose of the Practitioner qualification is to confirm whether the candidate has achieved sufficient understanding and competence to perform the role of Strategic Business Relationship Manager. To pursue the CBRM® certification, a candidate must be a certified Business Relationship Management Professional (BRMP®). What You Will Learn The successful candidate will demonstrate deep understanding and ability to perform the Strategic BRM role. Specifically, the candidate will: Effectively communicate the purpose and objectives of the Strategic BRM role and how to optimally position that role for maximum effectiveness within the enterprise Understand how to use their personal power and influence to build business relationships and foster a culture that excels at business value results Apply the Strategic Relationship Management processes and techniques to build and sustain trust relationships spanning Business Partner and Provider networks Be able to assess Business Demand Maturity and Business Relationship Maturity and how these might evolve over time Be able to assess Provider Capability Maturity and BRM Competencies and identify key areas needing improvement Be able to apply cross-organization communication techniques to clearly articulate real Provider / business value delivered to the organization Be able to influence executive leaders in their use of Provider Capabilities and Assets based upon potential business value and convergence with business strategy Promote and catalyze business innovation in the Provider's sphere of influence Be able to use the Business Value Management process, techniques, and metrics to define, realize, and optimize the value of Provider capabilities and assets Apply Business Partner Experience Management so as to foster a positive Business Partner perception of Provider capabilities as an essential element of building and sustaining trust relationships Shape strategic agendas for optimum business value, with due consideration of external compliance requirements and potential risks to the business Understand the implications of Lean / Agile methods for the BRM role and capability Influence the development and deployment of available Provider capabilities based upon business need and potential to enable or create business value. Apply Business Capability Management to determine and acquire enabling capabilities pursuant to strategic outcomes Apply Business Capability Management to determine and acquire enabling capabilities pursuant to strategic outcomes Contribute to Business Transition Management in order to foster organizational understanding, support, adoption, and business value results of investments in new business capabilities Course Introduction Explain the House of BRM, recalling the BRM Core Disciplines, competencies required for the BRM role, and necessary conditions for protecting the integrity of the role Recall the key BRM concepts, processes, and techniques Understand the Business Relationship Maturity Model and the Five Relationship Maturity Levels Understanding Business Relationship Maturity and Value The Strategic BRM Role and Capability BRM Impact on Business Value Introduction to the ACME Leisurewear Case Scenario that is used through the course Assessing BRM Context Clarifying Issues Conducting a Business Demand Maturity Assessment Conducting a Business Relationship Maturity Assessment Conducting a Provider Capability Maturity Assessment Shaping the Business Partner's experience with the Provider The BRM role in Service Management Developing Strategic Relationships How to assess Strategic Relationships and plan for their improvement How to achieve business impact through influence and persuasion How to plan and execute BRM formal communications Organizational considerations for BRM deployment How to determine appropriate BRM performance measurement Optimizing Business Value Formulating and Clarifying Business Strategy Catalyzing Business Innovation Business Capability Management Value Management Planning Portfolio Management Business Transition Planning Business Value Optimization Summary and CBRM Exam Preparation Course Summary CBRM Syllabus Review Format and structure of the CBRM® Practitioner Exam Exam hints and tips Sample Exam

Disciplined Agile Senior Scrum Master (DASSM): Virtual In-House Training Do you want to take Disciplined Agile® to a new level? Are you looking for tools to solve complex problems and enhance your organization's agility? Do you want to learn how to lead your team to excellence? Expand your knowledge and build practical skills around Disciplined Agile®, business agility, leadership, and team development. Disciplined Agile Senior Scrum Master is a nine-lesson, instructor-led course that shows you how to use the Disciplined Agile tool kit to solve a variety of advanced problems, work with allies within your organization, and optimize how teams work. You will gain knowledge in planning, reporting and metrics, and coordinating activities, as well as how to meet challenges in these areas. And you'll develop the skills you need to foster emotional intelligence, resolve conflicts, and lead high-performance teams at any stage of development. Filled with activities, supplemental reading, and more, this course will prepare you to take the Disciplined Agile Senior Scrum Master (DASSM) exam and, equally important, start using Disciplined Agile immediately within your leadership role. What You Will Learn After the completion of this course, you will be able to: Accelerate your ability to lead high-profile initiatives that are critical to enterprise success Take a deep dive into the Disciplined Agile® tool kit to develop a comprehensive understanding of the hundreds of practices and strategies it contains and the trade-offs of applying them Apply the Disciplined Agile tool kit in hands-on exercises to guide your team in choosing and evolving your best way of working (WoW) in real-life situations Use the tool kit to solve complex challenges commonly encountered in development and operational teams, the value stream, and at the enterprise level Learn how to design and implement metrics that measure your improvements in areas where your teams are struggling Understand how to nurture emotional intelligence Feel confident empowering others on your team(s) Learn how to lead your teams in any situation to improve value delivery for your customers Apply the Disciplined Agile tool kit to guide your team in choosing and evolving the best way of working (WoW) in the situation you face Be prepared to take the Disciplined Agile® Senior Scrum Master (DASSM) exam and earn a valuable, credible certification Roles and responsibilities of DASSM Tuckman Team Development Model Emotional intelligence and why it is essential to team performance Business agility Tactical scaling factors in more complex situations Disciplined DevOps layer 'Test-first' method as it relates to the quality of requirements Scope and purpose of the value stream layer Coordinate activities process goal and why it is important Value creation structure of teams DA™ tool kit to optimize the flow of work and solve challenges related to coordinating and collaborating across teams, or within a larger team of teams Thomas-Kilmann Conflict Resolution Planning Five levels of scope Metrics

This course will take you through the fundamental concepts of machine learning (ML) and artificial intelligence (AI). By the end of this course, you will be ready to dive into the advanced concepts of ML.

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum 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 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00