1873 Summary courses

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

Managing Agile and Waterfall Projects: On-Demand The concept of Agile project management refers to an iterative, incremental approach to managing the design and development of a product, service or result. The goal of this approach is to use it to manage the project in a way that is very flexible and interactive with the customer and/or end user, resulting in added value to the business. The concept of Waterfall project management refers to the use of a number of tools and techniques. A Guide to the Project Management Body of Knowledge (PMBOK® Guide) details 5 process groups: Initiating, Planning, Executing, Monitoring and Controlling, and Closing. As per the PMBOK® Guide - Sixth Edition, there are 49 processes entailed in these 5 process groups, which are focused on enabling project teams to deliver products to a pre-determined and agreed requirements/ specification. The selection of the most appropriate project management approach has, historically, been a choice of 'either/or' when it comes to these two approaches. It is now becoming clear that for many projects, the selection of a single project management approach does not satisfy the efficiency of the project team nor does it optimize the return on investment for the sponsoring organization. A different strategy is needed. "Managing Agile and Waterfall Projects" presents an approach to project management which capitalizes on the most appropriate elements of each approach, tailored to the specific project being undertaken. In this course, the Waterfall approach will be based on the PMBOK® Guide (predictive life-cycle). Each approach will be presented to highlight its particular strategy and strengths. The course will also propose project scenarios that require the project team to use a hybrid method which brings together aspects of both approaches. What You Will Learn You'll learn how to: Identify the strengths that the Waterfall approach brings to project work Identify the strengths that the Agile approach brings to project work Exploit the strengths of each method by combining their practices and protocols to maximize the potential for return on investment The Waterfall Approach to Competing Demands Optimization Foundation Concepts Getting Started The Agile Approach to Competing Demands Optimization Key Facets between Waterfall and Agile Examples for Implementing a Hybrid Approach The Challenges for the 'Combination' Project Management Team Practicing the Hybrid Approach Summary and Next Steps

Project Management Overview™: On-Demand This on-demand program provides learners with an interactive self-paced introduction to the world of project management (PM). Participants will gain fluency in the language and core concepts of PM, regardless of their roles in any project environment. They will also gain experience and perspective with basic yet practical problem-solving on a real-world case study. What You Will Learn You'll learn how to: Speak the language of project management Practice basic skills and tools that support effective project management through a structured process, including: Initiating Planning Executing Monitoring & Controlling Monitoring & Controlling Closing Basic Concepts People in Projects Projects in Organizations A Process Approach Process Groups in Action - Initiating Process Groups in Action - Planning Process Groups in Action - Executing Process Groups in Action - Monitoring & Controlling Process Groups in Action - Closing Summary and Next Steps

About Course ASP.NET Core MVC 6: Master the Latest Web Development Framework Become a full-stack web developer with this comprehensive course on ASP.NET Core MVC 6, taught by a lead instructor with 20+ years of experience. This course is designed for beginners with zero or basic programming experience. You will learn everything you need to know to build modern web applications with ASP.NET Core MVC 6, including: HTML5 and CSS3 Bootstrap 4 C# ASP.NET Core MVC 6 Entity Framework Core SQL Server Express You will also learn about important web development concepts such as routing, controllers, views, and models. The course includes HD video tutorials, code challenges, and coding exercises to help you learn and practice the material. You will also build a real-world project to apply your skills. By the end of this course, you will be fluent in ASP.NET Core MVC 6 and ready to build any website you can dream of. Enroll today and start your journey to becoming a full-stack web developer! Benefits of taking this course: Learn from a lead instructor with 20+ years of experience Become a full-stack web developer with just one course Learn the latest tools and technologies used at large companies such as Apple, Facebook, Google, and Netflix Get comprehensive student testing and feedback from students who are working and applying these coding examples Learn by building real-world websites and web apps Get access to HD video tutorials, code challenges, and coding exercises Target audience: Beginners with zero or basic programming experience who want to learn how to build modern web applications with ASP.NET Core MVC 6 What Will You Learn? Learn structure of ASP .NET MVC Core (.NET 6) Project Create websites and webapp for your business needs Get a job as a junior web developer on Microsoft technologies Identify a case study to manage a project development Master front-end development using HTML & CSS back-end development using C# & MS SQL Create fully function dynamic MVC Core web applications using Asp .NET Core Creating Functional Model, View and Controller functionality on Movie Project Learn to Add Entity Framework Packages to Project Using NuGet Package Manager Applying SQL Server Database Connection to your application Running Power Shell Commands for Scaffolding and CRUD function Webforms Identify and applying Database Migrations You will learn fully functional Validations for your project Course Content Getting Started Course Introduction Course Curriculum How to Get Course Requirements Getting Started on Windows, Linux or Mac How to Ask Great Questions FAQ's ASP.NET Basics Section Introduction What You Can Build with ASP.NET Core What is ASP.NET Core How to Get Visual Studio Installing Visual Studio and ASP.NET Creating New Project Summary Prerequisites: HTML, CSS and Bootstrap Section Introduction HTML Overview Paragraph HTML List Items Forms CSS Overview CSS Internal CSS External CSS Forms Bootstrap Overview First Bootstrap Website Bootstrap Grids System Bootstrap Cards Summary ASP.NET MVC: Movie Project Section Introduction Source Code Reference MVC - Model View Controller Create a MVC Project Exploring the MVC Template Creating Controller Add a Controller URL Routing Logic Creating View Add a View Change Views and Layout Pages Passing Data from Controller to View Creating Model Add a Model Add Entity Framework Packages Scaffold Movie Pages-CRUD Database Migrations Initial Migration Generated Database Context Class Dependency Injection Database Connection String Summary Working with Database Section Introduction SQL Server Express Local DB Seed the Database Add the Seed Initializer Summary Add Search to ASP.NET Core MVC App Section Introduction Add Search Method to Controller Add Search to Page Search by Parameter Summary Model Update Section Introduction Add a New Field to Model Add-Migration Update Database Summary Validations Add Validation Rules to Model Required and Minimum Length Regular Expression Range String Length Validation on Error UI Enable JavaScript on Browser Examine the Details and Delete Code Review on Details Method Code Review on Delete Method Course Files and Resources Course Files and Resources A course by Sekhar Metla IT Industry Expert Xpert Learning RequirementsBasic C# programming experience needed(optional). You will learn MVC Core need to knowNo software is required in advance of the course (all software used in the course is free)No pre-knowledge is required on MVC - you will learn from basic Audience Beginner Asp .Net MVC Core C# coding, Microsoft SQL and CSS developers curious about web development Anyone who wants to generate new income streams Anyone who wants to build dynamic web applications Anyone who wants to become financially independent Anyone who wants to start their own business or become freelance Anyone who wants to become a Full stack web developer Anyone who wants to build fully functional asp .net core mvc database applications Audience Beginner Asp .Net MVC Core C# coding, Microsoft SQL and CSS developers curious about web development Anyone who wants to generate new income streams Anyone who wants to build dynamic web applications Anyone who wants to become financially independent Anyone who wants to start their own business or become freelance Anyone who wants to become a Full stack web developer Anyone who wants to build fully functional asp .net core mvc database applications

Duration 3 Days 18 CPD hours This course is intended for Individuals involved in IT development, IT operations or IT service management; Those whose role is touched by DevOps and continuous delivery, such as the following IT roles: DevOps engineers, Product owners Integration specialists, Operations managers, Incident & change managers, System administrators, Network administrators, Business managers, Automation architects, Enterprise architects, Testers Overview Know the emergence of DevOps Know the core concepts and principles of DevOps Know what DevOps means for you as professional and for your organization Know the essence of a DevOps culture Understand the key elements of a DevOps culture Know the important aspects when creating a DevOps culture Know the Operational models of DevOps Understand the need for autonomous teams Understand the impact of DevOps on Architecture with respect to deployment Understand governance within DevOps teams Understand Agile, Scrum and Kanban and how these practices relate to one another Understand how ITSM processes relate to practices in a DevOps culture Understand how lean is used to optimise processes Know how to provide a Value Stream Map for a given process Understand the way to harvest new and innovative ideas Know the impact of automation on Software Delivery processes Understand the benefits and core principles of Continuous Delivery Describe the key cloud principles for DevOps organisations Know the relevance of monitoring and logging DevOps This course is designed to provide the core education necessary to build your DevOps vocabulary and to understand its principles and practices. With the help of key DevOps concepts and terminology, real-life case studies, examples and interactive group discussions and extensive exercises in each module you will acquire a fundamental understanding of DevOps. Introduction Let?s Get to Know Each Other Overview Course Objectives Mapping of the Competence Model with the Course Modules Course Agenda Type of Activities Exam Course Book Technical Glossary Group Activity Module Summary DevOps Introduction Module Objectives Module Topics Emergence of DevOps Core Concepts of DevOps DevOps Agile Skills Association (DASA) Module Summary Module End Questions Culture Module Objectives Module Topics Essence of a DevOps Culture Key Elements of DevOps Implementation of a DevOps Culture Module Summary Module End Questions Organization Module Objectives Module Topics Organizational Model Autonomous Teams Architecting for DevOps Governance Module Summary Module End Questions Processes Module Objectives Module Topics Process Basics DevOps in Relation to ITSM Agile and Scrum 12 Principles of the Agile Manifesto Optimizing Processes Using Lean Business Value Optimization and Business Analysis Using Story Mapping Module Summary Module End Questions Automation Module Objectives 6A Automation Concepts Automation for Delivery of Software Continuous Delivery Core Concepts Continuous Delivery Automation Concepts Continuous Delivery Automation Focus Topics 6B Data Center Automation Emergence of Cloud Technology and Principles Cloud Services Concepts in a DevOps Organization Automated Provisioning Concepts Platform Product Characteristics and Application Maturity Module Summary Module End Questions Measure and Improvement Module Objectives Module Topics Importance of Measurement Choosing the Right Metrics Monitoring and Logging Module Summary Module End Questions

Access Introduction generally navigate through Access Database, get data fast, update data records by entering, update data and delete data. Run available report, use available forms, create simple forms and reports via wizards. This style tuition helps to maximise the value that you get from the day.

This exclusive Language Therapy Course provides learners with a comprehensive overview of the role of a Speech and Language Therapist, equipping you with the essential skills to advance your career. It includes speech science, speech anatomy, and the characteristics of speech in detail. This Language Therapy course will teach you how Speech and Language Therapists help children and adults with speech and language disorders, including swallowing, eating, and drinking issues. It covers the fundamentals of the speech chain model and walks you through the key stages of literacy and language development. This Language Therapy course includes case studies and practical exercises that will teach you how to assess your clients' needs, set long-term goals, and support them every step of the way to recovery using a variety of communication techniques. In addition, you will gain in-demand professional skills that will help you start your career successfully. Learning Objectives After completing this Language Therapy course, the learner will be able to: Understand the fundamentals of Speech & Language Therapy. Understand the study of communication. Explain components of normal speech, language & voice and communication disorders. Understand eating, drinking and swallowing disorders. Understand the speech & language therapy process. Why Choose Language Therapy Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Language Therapy Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. Free PDF certificate as soon as completing the Language Therapy course. 24/7 support via live chat, phone call or email. [ Note: Free PDF certificate as soon as completing the Language Therapy course] Course curriculum Module 1: Language Therapy The Role of the Language Therapist The History of Language Therapy Practice The Scope of Practice The Language Therapy process The Role of Speech therapy Assistant in Current Healthcare Practice Summary Module 2: Study of Communication The Role of Interpersonal Communication The Components of Communication - Physical, Sensory, Cognitive, Perceptual, Interpersonal and Intrapersonal Communication Impairment or Disorder on the Individual How An Individual Interacts with Their Environment? Recognise Enablers and Barriers to Interpersonal Communication Summary Module 3: Components of Normal Speech, Language & Voice and Communication Disorders Key Components of Speech, Language and Voice The Process of Normal Speech and Language Acquisition Effective Conversational Skills The Different Types of Impairments/Disorders of Normal Speech, Language and Voice Acquired Brain Injuries and Cerebral Palsy Summary Module 4: Eating, Drinking and Swallowing Disorders Key Components of Eating, Drinking and Swallowing The Process of Normal Eating, Drinking and Swallowing Acquisition The Different Types of Difficulties of Eating, Drinking and Swallowing What May Eating, Drinking and Swallowing Intervention Involve? Give Examples of Communication profiles associated with disorders of eating, drinking and swallowing Summary Assessment Method After completing each module of the Language Therapy Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Language Therapy course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Language Therapy course is for anyone who wants to: Gain the skills needed to work in the teaching and child care profession. Improve their speech therapy and language therapy skills. Make a career change and explore new career opportunities. Gain a formal, accredited qualification to improve their career opportunities. Requirements Students who intend to enrol in this Language Therapy course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Compete High provides the most expedient path to learning about Language Therapy, as well as the opportunity to practice your skills in a corporate setting. Certificates Certificate of completion Digital certificate - Included

Nutrition Training - Advanced Diet & Meal Planning Overview Confused by all the different diets out there? What if you could ditch the fads and create a personalized eating plan that actually works for you? Nutrition Training - Advanced Diet & Meal Planning is your guide to becoming your own nutrition boss. This course breaks down the science of food into easy-to-understand chunks. You'll learn the basics of healthy eating, from the different types of nutrients your body needs to how food choices affect your health. We'll then delve deeper into advanced dieting strategies, so you can create a plan that fits your goals, whether you want to lose weight or build muscle. The course also covers popular diets, explaining how they work and if they're the right choice for you. Plus, you'll learn how to use food to help prevent illness. By the end, you'll be able to design custom meal plans that give your body exactly what it needs to thrive. Nutrition Training - Advanced Diet & Meal Planning is your key to unlocking a healthier, happier you through the power of food! Learning Outcomes Grasp the core principles of nutrition and healthy eating. Explore advanced dieting theories to craft a personalized plan. Design targeted meal plans for effective fat loss. Develop strategies to support muscle growth through diet. Evaluate popular diets and make informed choices about your nutrition. Why You Should Choose Nutrition Training - Advanced Diet & Meal Planning Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Nutrition Training - Advanced Diet & Meal Planning is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Nutrition Training - Advanced Diet & Meal Planning is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Nutrition Training - Advanced Diet & Meal Planning Section 01: Introduction Course overview 00:04:00 Get to know your instructor 00:02:00 Section 02: The Nutrition Fundamentals Recap intro 00:01:00 Nutrition priorities 00:04:00 Calories Summary 00:04:00 Macronutrient summary 00:20:00 Meal timing summary 00:09:00 Food Quality & Composition summary 00:05:00 Supplements Summary 00:06:00 Meal planning recap 00:09:00 Section 03: Advanced Dieting Theory Advanced Nutrition Theory Introduction 00:02:00 The Factors That Influence Energy Expenditure 00:09:00 Protein 00:03:00 Amino Acids 00:04:00 Protein & Energy (De Novo Glucogenesis) 00:02:00 Carbohydrates 00:03:00 Glucose & Glycogen 00:03:00 Carbs & Energy (Glycolysis) 00:03:00 Fat 00:03:00 Essential Fatty Acids (Omega 3 & Omega 6) 00:07:00 Fat & Energy (Lipolysis) 00:02:00 The 4th Macronutrient: Alcohol 00:05:00 Section 04: Advanced Dieting For Fat Loss Advanced Fat Loss Introduction 00:01:00 Should I build muscle or lose fat first? 00:06:00 The Different Phases Of A Fat Loss Diet 00:08:00 The Settling Point Theory Explained 00:06:00 How To Reverse Diet 00:05:00 The Best Strategies And Supplements To Reduce Hunger 00:08:00 The Different Stages Of Fitness Transformations 00:07:00 PSMF: The Science-Based Crash Diet That Works 00:07:00 Can You Break Your Metabolism? 00:03:00 Section 05: Advanced Dieting For Muscle Grow Advanced Dieting For Muscle Growth Introduction 00:01:00 The Muscle Growth Priorities 00:05:00 The Different Types Of Bulks 00:02:00 Step By Step Dirty Bulk 00:08:00 Step By Step Regular Bulk 00:07:00 Step By Step Lean Bulk 00:03:00 The Difference Between Fitness Diets & Health Diets 00:04:00 Intra Workout Carbs 00:04:00 Section 06: Popular Diets Explained The 'One True Diet' Fallacy 00:03:00 The Naturalistic Fallacy 00:03:00 The Perfect Nutrient Fallacy 00:02:00 Pros & Cons Of High Carb Diets 00:03:00 Pros & Cons Of Low Carb Diets 00:04:00 Pros & Cons Of Moderate Carb, Moderate Fat Diets 00:02:00 The Blood Type Diet 00:04:00 Carb Cycling 00:04:00 Section 07: Dieting & Disease Prevention Dieting & Diseases Introduction 00:01:00 The Right Diet To Avoid Acid Reflux 00:05:00 The Right Diet For Constipation 00:04:00 The Right Diet To Avoid Diabetes 00:08:00 Leaky Gut Syndrome 00:05:00 Section 08: FAQ Diet vs Exercise: Which Is More Important 00:03:00 HCG diet 00:03:00 Is Fructose Bad For You? 00:04:00 Should You Separate Carbs And Protein? 00:04:00

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

Project Communication Skills (On-Demand) In this course, participants will actively explore best communication practices from a variety of perspectives: in-person, virtual, electronic, and via formal project documentation. Communication is the single most critical project success factor. When effective, projects get executed on time, within budget, and with objectives being met. But that isn't all. Strong communication also nurtures healthy team relationships. And in today's highly diverse world, where projects are often fast-paced, complex, and virtual, that is more important than ever. Strong communication skills foster cultural awareness, trust, and empathy. Together, they contribute greatly to project success-and ultimately, to future project success. In this course, participants will actively explore best communication practices from a variety of perspectives: in-person, virtual, electronic, and via formal project documentation. In order to be transformative, however, those perspectives will be filtered further through the lens of their formal, personalized assessment. It is a powerful tool which identifies individuals' internal needs and priorities. It translates those into descriptive profiles and reports, gifting users with valuable information about themselves and others. Paired with the course's real-world activities, it will provide uniquely strategic opportunities for communicating effectively and meaningfully-and with less conflict, both personally and professionally. What You Will Learn At the end of this program, you will be able to: Identify basic elements of communication and explain how they affect teams Explore how your assessment style impacts you and how you communicate with people of other styles Infer how your style impacts the way(s) you send and interpret emails and instant messages Analyze real world email and instant messaging practices to determine how they affect communication and relationships Explore best practices for formal project communications and presentations Analyze how your assessment style and global diversity can contribute to both strong team communication and conflict Identify solutions for virtual team work communication challenges Getting Started Foundation Concepts Communication as a foundation skill Elements of communication Communicating across media Targeting your audience How communication impacts team performance The Assessment Framework Overview of the assessment's approach Exploring assessment report Increasing your effectiveness with other assessment styles Email and Instant Messages Preferred communications and assessment styles The email brands we create Assessment styles and email Emotion and email Email guidelines and best practices Anatomy of an email The seven deadly email sins Instant messages and other interfaces Project Communications and Presentations Communicating across the project lifecycle Project templates Structuring a presentation Delivering a presentation Interpersonal and Team Communication Skills Communication styles and techniques Managing conflict in a project environment Styles and conflict Communication and global team leadership Virtual Communication Leading global virtual teams Virtual processes and technology Virtual team leadership Summary and Next Steps