1535 Summary courses in Cardiff delivered Online

Critical Thinking and Creative Problem Solving (Virtual) Two critical skillsets for the future of work are critical thinking and creative problem solving. These modes of working and thinking intersect and overlap; both are necessary and both can be taught. Having the ability to exercise creativity while at the same time applying structure and discipline to the thinking process is a key competency in the twenty-first century workplace. This course explores the interplay between critical and creative thinking, and the necessity of each to effective problem solving and decision making. Participants will learn a variety of techniques to apply critical thinking to real-life scenarios. They will experiment with different problem-solving approaches and will learn about cognitive influences on our decisions and choices. The course delves into the business value of creativity and involves participants in actively integrating criticality, creativity, and problem solving. What you will Learn At the end of this program, you will be able to: Explain basic concepts of problem solving Infer types of cognitive biases that impact decision making Utilize types of root cause analysis Differentiate among obstacles to sound decision making Apply a variety of problem-solving approaches / processes to existing challenges Evaluate alternative solution methods using various techniques Analyze real world problem scenarios to determine the lateral thinking type needed to address them Getting Started Foundation Concepts Definitions Thinking modes and cognitive bias Basic problem-solving framework Problem Definition and Solution Generation Root cause analysis Basic problem-solving obstacles Generating alternative solutions Evaluating Alternatives Critical thinking guidelines Obstacles to sound decision making Tools for evaluating alternatives Exploring Lateral Thinking Problem-solving challenge Workplace application Summary and Next Steps

Assuring Quality Through Acceptance Testing: Virtual In-House Training It is also the business analyst's responsibility to confirm that the resulting solution developed by IT does, in fact, solve the defined problem. This is done first through testing, especially acceptance testing, and then through monitoring of the installed solution in the user community. It is the business analyst's job to define the business problem to be solved by IT. It is also the business analyst's responsibility to confirm that the resulting solution developed by IT does, in fact, solve the defined problem. This is done first through testing, especially acceptance testing, and then through monitoring of the installed solution in the user community. The business analyst is not only concerned with the testing itself, but also with the management and monitoring of the users doing the acceptance testing, and recording, analyzing, and evaluating the results. What you will Learn Upon completion, participants will be able to: Create a set of acceptance test cases Manage and monitor an acceptance test stage where users perform the testing Work with the development team in the systems testing stage Assess the solution once it is in the business environment Foundation Concepts The role of the business analyst An introduction to the BABOK® Guide BA roles and relationships through the project life cycle Introduction to assuring software quality through acceptance testing The Scope of IT Testing Overview of testing stages The testing process Testing documentation Pre-Acceptance Testing The BA's role in testing Early development testing stages (unit and integration) Late development testing stage (system) The Acceptance Test Stage - Part I (Planning, Design, and Development) Overview of user acceptance testing Acceptance test planning Designing user acceptance tests Developing individual user acceptance test cases Building effective user acceptance test scenarios The Acceptance Test Stage - Part II (Execution and Reporting) Operating guidelines Execution Reporting Post-Acceptance Testing Overview Project implementation Project transition (project closure) Production through retirement Testing Commercial Off-the-Shelf (COTS) Software Overview Selecting the software Implementing the software Summary What did we learn and how can we implement this in our work environments?

Conflict Resolution Skills: In-House Training Many organizations have assumed that workplace conflict is always destructive. So, they have often believed that conflict is best dealt with by managers or even via policies and procedures. After all, conflict creates workplace stress and leads to many performance problems, generating very real organizational costs! However, savvy organizations have embraced the fact that when conflict is understood and harnessed, it can be leveraged to add value to teams and even enhance performance. With the right knowledge, skills, training, and practice, conflict can be productive and make organizations better! In this highly interactive course, learners will discover the connection between individual conflict response and team-empowering conflict resolution skills. Participants will explore conflict's visceral dynamics and the nuanced behaviors we individually engage in to communicate and respond to conflict. Learners will apply techniques for transforming unproductive conflict responses into productive ones. Additionally, learners will use a systematic method that prepares them to objectively dissect real-world conflict, while practicing many strategies for resolving it. They will also develop proactive conflict approach plans, which they can transfer back to their own workplaces. What you will Learn At the end of this program, you will be able to: Recognize the organizational costs of conflict Explain our physical and mental responses to conflict Communicate proactively and effectively with different types of people during conflict Replace unproductive conflict responses with productive ones Use the Conflict Resolution Diagram (CRD) process and conflict resolution approaches Relate team stages of development to shifts in conflict Develop a proactive conflict approach for your organization Create a conflict resolution plan for a real-world scenario Getting Started Introductions and social agreements Course goal and objectives Opening activities Conflict Facilitation Readiness Conflict responses and perceptions Conflict basics Conflict and organizations Dynamics of conflict Conflict Styles and Communication A look at the color energies model Conflict through the color energies and DiSC® lens Communication with opposite color energies Individual Response to Conflict The anatomy of conflict Recognizing unproductive conflict responses 4 steps to productive conflict Choosing productive conflict responses Team Performance and Conflict High-performing team relationships Conflict and project team performance Conflict Resolution Diagram (CRD) and process Conflict Facilitation - Preparation Recognizing context and stakeholder needs Using team conflict resolution approaches Preparing for Crucial Conversations® Conflict Facilitation - Clarity Exposing assumptions and biases Defining the conflict and using the CRD Conflict Facilitation - Action Proactive conflict management Conflict facilitation practice Summary and Next Steps Review Personal action plans

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Venture into the realm of IT service excellence with the ITIL Practitioner course, where the chronicles of Information Technology Infrastructure Library (ITIL) come to life. This immersive educational experience is tailored to enlighten enthusiasts on the intricate tapestry of IT Service Management (ITSM) and the Continuous Service Improvement (CSI) model that stands at the heart of ITIL practices. From the foundational bricks of principles and themes, the course ascends to the strategic nuances of Organizational Change Management (OCM), ensuring participants grasp the transformative nature of IT services. The curriculum delves into the mechanisms that fortify communication as a catalyst for service enhancement. Learners are equipped with the proficiency to employ metrics and measurement as a compass for ITSM efficacy. As the narrative progresses, the course unravels the synthesis of CSI within the broader ITIL framework, beckoning participants to not just witness but also weave the future of IT services and their governance. Learning Outcomes Understand the core principles of ITIL and ITSM, including the CSI model. Develop insights into effective Organizational Change Management. Learn to foster impactful communication strategies within IT service management. Acquire the ability to measure and utilize metrics for IT service enhancement. Integrate CSI strategies effectively within ITIL and organizational practices. Why choose this ITIL Practitioner 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 ITIL Practitioner course for? IT professionals seeking to expand their ITIL knowledge. Managers overseeing IT service management teams. Change agents responsible for implementing IT service improvements. Individuals aspiring to integrate ITIL practices within their organizations. Analysts focused on service management metrics and performance. Career path ITIL Practitioner: £35,000 - £60,000 IT Service Manager: £40,000 - £70,000 Change Manager: £45,000 - £65,000 ITIL Consultant: £50,000 - £75,000 Quality Assurance Manager: £40,000 - £60,000 Performance Analyst: £30,000 - £50,000 Prerequisites This ITIL Practitioner does not require you to have any prior qualifications or experience. You can just enrol and start learning.This ITIL Practitioner 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 to ITIL Practitioner Course Introduction 00:14:00 ITSM & Continual Improvement Learning Objectives 00:06:00 Selecting a Management System 00:11:00 Systems Thinking 00:13:00 The 4Ps 00:13:00 Communication & Management Systems 00:14:00 Organizational Capabilities 00:10:00 Adopt, Adapt & Realize 00:15:00 Outside-in vs Inside-out Thinking 00:11:00 Defining a Service 00:05:00 Metrics & Measurement 00:06:00 Improvement, the Practitioner & CSI 00:10:00 Driving IT Service Management Summary 00:15:00 Checkpoint 00:16:00 Principles & Themes Learning Objectives 00:04:00 Principles 00:24:00 Themes 00:09:00 Principles & Themes in Practice 00:08:00 Principles & Themes Summary 00:03:00 Checkpoint 00:07:00 Organizational Change Management (OCM) Learning Objectives 00:02:00 Role & Impact of OCM on Improvement 00:07:00 OCM Activities 00:16:00 OCM & Systems Thinking 00:06:00 OCM Summary 00:06:00 Checkpoint 00:10:00 Effective Communication to enable CSI Learning Objectives 00:01:00 Value, Importance & Benefit of Good Communication 00:05:00 Principles of Communication 00:11:00 Role of Influence 00:07:00 Communication Summary 00:05:00 Checkpoint 00:09:00 Use Metrics & Measurement Learning Objectives 00:02:00 CSFs, KPIs & Improvement 00:18:00 Analyze CSFs & KPIs in Context 00:09:00 Assessments 00:04:00 Use Metrics & Measurement Summary 00:05:00 Design a Report 00:07:00 Checkpoint 00:07:00 CSI Approach Learning Objectives 00:02:00 It Depends 00:09:00 Approach Deconstructed 00:25:00 Goal Question Metric (GQM) Approach Introduction 00:08:00 CSI Approach Summary 00:05:00 Checkpoint 00:06:00 Integrating CSI with ITIL & Beyond Learning Objectives 00:01:00 CSI Approach for the ITIL Practitioner 00:07:00 CSI Approach in ITIL 00:25:00 CSI Approach, PRINCE2 & RESILIA 00:06:00 Integrating CSI with ITIL & Beyond Summary 00:03:00 Checkpoint 00:06:00 Workbooks Workbooks - ITIL Practitioner - Video Training Course 00:00:00 Assignment Assignment - ITIL Practitioner 00:00:00

Overview This comprehensive course on Scrum Master Level 2 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Scrum Master Level 2 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 Scrum Master Level 2. It is available to all students, of all academic backgrounds. Requirements Our Scrum Master Level 2 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 9 sections • 30 lectures • 01:55:00 total length •Introduction: 00:01:00 •Overview of Workflows and Approaches: 00:02:00 •Traditional (Waterfall a like): 00:06:00 •Agile.: 00:06:00 •Traditional vs Agile: 00:07:00 •Summary on Workflows and Approaches: 00:03:00 •Agile Manifesto: 00:02:00 •It's Scrum time: 00:01:00 •Scrum Overview: 00:05:00 •Methodology vs Framework: 00:04:00 •Scrum Roles Overview: 00:01:00 •Scrum Master (SM): 00:06:00 •Product Owner (PO): 00:06:00 •Development Team (Dev Team): 00:07:00 •Summary on Scrum Roles: 00:01:00 •Scrum Events Overview: 00:01:00 •Daily Scrum (Standup): 00:04:00 •Sprint Planning: 00:07:00 •Sprint Review: 00:07:00 •Sprint Retrospective: 00:07:00 •Other Non-Prescribed Events: 00:02:00 •Summary on Scrum Events: 00:03:00 •Scrum Artifacts Overview: 00:01:00 •Product Backlog: 00:10:00 •Sprint Backlog: 00:09:00 •Product Increment: 00:03:00 •Other Non-Prescribed Artifacts: 00:01:00 •Summary on Scrum Artifacts: 00:01:00 •Thank you!: 00:01:00 •Assignment - Scrum Master Level 2: 00:00:00

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! According to 7 in 10 autistic children and young adults said education would be easier for them if the teachers had a better understanding of autism. It shows how important it is for us to learn about autism and PDA in order to create an inclusive society. The Pathological Demand Avoidance course is developed to help you expand your knowledge in this area. The course will provide an overall understanding of PDA through easily digestible modules. This Diploma in Pathological Demand Avoidance course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! In this comprehensive course, you will get to explore the vital areas of Pathological Demand Avoidance. The course will educate you on the definition, signs and symptoms of autism. From the informative modules, you will be able to enhance your knowledge and understanding of sensory processing disorders. In this step-by-step learning process of the history of PDA. Furthermore, the course will deliver detailed lessons on learning disabilities. Along with enriching your knowledge, the course will also help you elevate your resume. At the end of the course, you will receive a QLS- endorsed certificate of achievement. This certificate will add significant value to your resume. Join now! This course will allow you to Enrich your knowledge and understanding of Pathological Demand Avoidance Learn about the signs and symptoms of autism Get an in-depth understanding of the definition and categories of sensory processing disorders Enhance your knowledge of learning disabilities Why Prefer This Pathological Demand Avoidance Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS after completing the Pathological Demand Avoidance course Get a free student ID card! (£10 postal charges will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. *** Course Curriculum *** >> Certificate in Pathological Demand Avoidance at QLS Level 3 << Module 01: Introduction to Pathological Demand Avoidance Introduction to the Module Understanding Pathological Demand Avoidance Characteristics of PDACauses of PDADiagnosis Oppositional Defiant Disorder Causes of ODDSymptoms of ODD Summary Module 02: Understanding Autism Introduction to the Module What is Autism? Autistic Spectrum Disorder Signs and SymptomsCauses of ASD Interventions for Challenging Behaviour Summary Module 03: PDA in Schools and Parent Information Introduction to the Module The Role of the Key Worker Teaching Style Relationships Home-School Liaison Summary Module 04: Sensory Processing Disorder Introduction to the Module What is Sensory Processing? The Sensory Systems Sensory Processing Disorder Categories Tactile DysfunctionVestibular DysfunctionProprioceptive DysfunctionAuditory DysfunctionOral DysfunctionOlfactory DysfunctionVisual Dysfunction The Continuum Summary Module 05: The History of PDA Introduction to the Module A Brief History of PDA A Typical Parental Experience Summary Module 06: Learning Disability and Autism Introduction to the Module What is Learning Disability? Different Terminology Identifying Learning Disability or Autism Support Needs People with a Learning DisabilityPeople with Autism Summary Assessment Process We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. 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 exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Certificate in Pathological Demand Avoidance at QLS Level 3 The Pathological Demand Avoidance course is designed to help people learn about pathological demand avoidance. Anyone with an interest in enriching their knowledge in this subject can take this course. It will come in handy for the current and future professionals of the relevant sector. Requirements The Pathological Demand Avoidance Diploma program does not require any prior knowledge; everyone may participate! This Pathological Demand Avoidance Diploma is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This Pathological Demand Avoidance Diploma allows you to study at your own speed and grow a quality skillset. Career path The Pathological Demand Avoidance course will enrich your understanding of autism. It will allow you to explore career options in the following fields SEN Teacher (Average annual salary £36K) Childcare Worker (Average annual salary £25K) Social Worker (Average annual salary £39k) Health Care Worker (Average annual salary £23k) Learning Support Assistant (Average annual salary £22K) Certificates CPD Accredited Certificate Digital certificate - £10 Certificate in Pathological Demand Avoidance at QLS Level 3 Hard copy certificate - £89 After successfully completing the Certificate in Pathological Demand Avoidance at QLS Level 3, 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 - 89 GBP inside the UK 99 GBP (including postal fees) for international delivery CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

Agile for Non-IT Practitioners - How Agile Project Management is Different and How It Can be Used for Non-IT Projects: On-Demand This course will provide guidance on how Agile can be used beyond software development projects, including how it differs from traditional project management. The course also will provide an overview of the Agile Scrum framework, which is one of the most popular Agile methodologies used.This course provides practical skills, concepts, and principles you can take back to the job and use to implement Agile practices in projects, as applicable. The goal of this course is to acquaint participants with the concepts of agile development methods and the specifics of the Scrum management framework. What You Will Learn You'll learn how to: Describe the Agile project management process and its benefits Use project management vocabulary and terminology Identify the characteristics of a successful project Create an initial project plan Identify and perform the major aspects of project initiation, project control, and close-out Identify and describe organizational change issues in implementing project management Getting Started Course goal and objectives Introducing Agile Scrum Framework Requirements and Product Definition Planning Agile Agile Practices Running a Sprint Summary

IASSC lean six sigma black belt course. Online, 24/7 access to content and exam. Fee includes learning content, live webinars, tutor support, and official IASSC exam.

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