3560 Dash courses

Are you looking to enhance your employees' abilities and skills in Coaching & Mentoring? If yes, then you have come to the right place. Our comprehensive Coaching & Mentoring course at Compliance Central is designed to help your team produce the best possible outcomes by mastering the essential Coaching & Mentoring skills. Whether your employees are new to Coaching & Mentoring or already working in the field, this course will provide them with the necessary knowledge and skillsets to excel. Why Employee Training Matters: Boost Productivity: Well-trained employees work more efficiently, driving productivity in all areas. Increase Employee Morale: Invest in your employees' growth, leading to a positive work environment and higher retention rates. Stay Ahead of Competitors: Equip your workforce with the latest skills and knowledge to outshine the competition. Ensure Compliance and Safety: Specialised training keeps your business compliant and your workplace safe. Improve Customer Satisfaction: Well-trained staff deliver exceptional service, building loyal customer relationships. Why Choose Us? Expert-Developed Training: Industry professionals have developed valuable insights and helpful learning. Flexible Learning: Online Coaching & Mentoring course allows employees to learn at their own pace. Ongoing Support: Dedicated Coaching & Mentoring experts are available to guide your employees throughout the training process. Certificates of Achievement: Recognise your employees' commitment with CPD Certified certificates. Employer Dashboard: Easily track employee Coaching & Mentoring progress in our user-friendly dashboard. Empower Your Workforce Today! Invest in your company's future success. Join us to start your employees' Coaching & Mentoring training and watch your business thrive. Compliance Central - Empowering Businesses Through Knowledge Empower Your Business with Comprehensive Employee Training! At Compliance Central, we understand that well-trained employees are the backbone of successful organisations. Elevate your workforce and propel your business forward with our tailored online training programs. Course Curriculum Breakdown: Coaching and Mentoring:- Module 01: Introduction to Coaching and Mentoring Module 02: Coaching and Mentoring: Objectives & Processes Module 03: Ethical Aspects of Coaching and Mentoring Module 04: Coaching and Mentoring Models Module 05: Effective Communication Skills Module 06: Personal Skills Module 07: Management Skills Module 08: Functional Skills Our Coaching & Mentoring course starts with the fundamentals and gradually progresses to cover advanced topics, making each lesson intuitive and easy to understand. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Coaching & Mentoring course is ideal for new professionals looking to thrive in the Coaching & Mentoring field. Requirements Enrolling in this Coaching & Mentoring course only requires a basic understanding of the English language and an internet connection. Career path Completing the Coaching & Mentoring course will enhance your employees' knowledge and confidence. Career Coach: £25,000 to £50,000 per year Mentoring Program Manager: £30,000 to £55,000 per year Corporate Trainer: £28,000 to £45,000 per year Youth Mentor: £20,000 to £35,000 per year Executive Coach: £40,000 to £70,000 per year Learning and Development Specialist: £25,000 to £45,000 per year Certificates CPD Accredited Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: £3.99 each Outside of the UK: £9.99 each CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate

Are you looking to enhance your employees' abilities and skills in Risk Assessment? If yes, then you have come to the right place. Our comprehensive Risk Assessment course at Compliance Central is designed to help your team produce the best possible outcomes by mastering the essential Risk Assessment skills. Whether your employees are new to Risk Assessment or already working in the field, this course will provide them with the necessary knowledge and skillsets to excel. Why Employee Training Matters: Boost Productivity: Well-trained employees work more efficiently, driving productivity in all areas. Increase Employee Morale: Invest in your employees' growth, leading to a positive work environment and higher retention rates. Stay Ahead of Competitors: Equip your workforce with the latest skills and knowledge to outshine the competition. Ensure Compliance and Safety: Specialised training keeps your business compliant and your workplace safe. Improve Customer Satisfaction: Well-trained staff deliver exceptional service, building loyal customer relationships. Why Choose Us? Expert-Developed Training: Industry professionals have developed valuable insights and helpful learning. Flexible Learning: Online Risk Assessment course allows employees to learn at their own pace. Ongoing Support: Dedicated Risk Assessment experts are available to guide your employees throughout the training process. Certificates of Achievement: Recognise your employees' commitment with CPD Certified certificates. Employer Dashboard: Easily track employee Risk Assessment progress in our user-friendly dashboard. Empower Your Workforce Today! Invest in your company's future success. Join us to start your employees' Risk Assessment training and watch your business thrive. Compliance Central - Empowering Businesses Through Knowledge Empower Your Business with Comprehensive Employee Training! At Compliance Central, we understand that well-trained employees are the backbone of successful organisations. Elevate your workforce and propel your business forward with our tailored online training programs. Course Curriculum Breakdown: Course: Risk Assessment Module 01: Introduction to Risk Assessment Module 02: Risk Assessment at Workplace Module 03: Risk Management Process Module 04: Benefits of Risk Management Module 01: Health & Safety Risk Assessment and Common Risks Module 02: Work Equipment Hazards and Risk Control Module 07: Electrical Risk Assessment Module 08: Reducing and Controlling Electrical Risks Module 09: COSHH Risk Assessments Module 10: Control Measures and Monitoring COSHH Risk Module 11: Risk Factors of Asbestos Module 12: Surveys and Risk Assessment of Asbestos Module 13: Manual Handling Risk Assessments Module 14: Controlling and Reducing the Risks of Manual Handling Module 15: Working at Height Risk Assessment and Prevention Our Risk Assessment course starts with the fundamentals and gradually progresses to cover advanced topics, making each lesson intuitive and easy to understand. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Risk Assessment course is ideal for new professionals looking to thrive in the Risk Assessment field. Requirements Enrolling in this Risk Assessment course only requires a basic understanding of the English language and an internet connection. Career path Completing the Risk Assessment course will enhance your employees' knowledge and confidence. Health and Safety Officer: £25,000 to £45,000 per year Environmental Health and Safety (EHS) Specialist: £30,000 to £50,000 per year Risk Assessment Consultant: £35,000 to £60,000 per year Asbestos Surveyor: £25,000 to £40,000 per year Health and Safety Manager: £40,000 to £65,000 per year Certificates CPD Accredited Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: £3.99 each Outside of the UK: £9.99 each CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate

Are you looking to enhance your employees' abilities and skills in First Aid at Work? If yes, then you have come to the right place. Our comprehensive First Aid at Work course at Compliance Central is designed to help your team produce the best possible outcomes by mastering the essential First Aid at Work skills. Whether your employees are new to First Aid at Work or already working in the field, this course will provide them with the necessary knowledge and skillsets to excel. Get 2 CPD Accredited Courses: Course 01: First Aid Course 02: Basic Life Support (BSL) Why Employee Training Matters: Boost Productivity: Well-trained employees work more efficiently, driving productivity in all areas. Increase Employee Morale: Invest in your employees' growth, leading to a positive work environment and higher retention rates. Stay Ahead of Competitors: Equip your workforce with the latest skills and knowledge to outshine the competition. Ensure Compliance and Safety: Specialised training keeps your business compliant and your workplace safe. Improve Customer Satisfaction: Well-trained staff deliver exceptional service, building loyal customer relationships. Why Choose Us? Expert-Developed Training: Industry professionals have developed valuable insights and helpful learning. Flexible Learning: Online First Aid at Work course allows employees to learn at their own pace. Ongoing Support: Dedicated First Aid at Work experts are available to guide your employees throughout the training process. Certificates of Achievement: Recognise your employees' commitment with CPD Certified certificates. Employer Dashboard: Easily track employee First Aid at Work progress in our user-friendly dashboard. Empower Your Workforce Today! Invest in your company's future success. Join us to start your employees' First Aid at Work training and watch your business thrive. Compliance Central - Empowering Businesses Through Knowledge Empower Your Business with Comprehensive Employee Training! At Compliance Central, we understand that well-trained employees are the backbone of successful organisations. Elevate your workforce and propel your business forward with our tailored online training programs. Course Curriculum Breakdown: Course 01:- Basic Life Support (BLS) Certification Module 1. Introduction to Basic Life Support Module 2. Basic Life Support for Adults Module 3. Basic Life Support for Children Module 4. Basic Life Support for Infants Module 5. Cardiopulmonary Resuscitation Objectives Module 6. Airway Management Module 7. Relief of Choking Module 8. Initial Assessment Objectives Course 02:- Health & Safety: First Aid Module 01: Basic First-Aid Techniques Module 02: Dealing with Minor Injuries at the Workplace Module 03: Call for an Emergency Our First Aid at Work course starts with the fundamentals and gradually progresses to cover advanced topics, making each lesson intuitive and easy to understand. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The First Aid at Work course is ideal for new professionals looking to thrive in the First Aid at Work field. Requirements Enrolling in this First Aid at Work course only requires a basic understanding of the English language and an internet connection. Career path Completing the First Aid at Work course will enhance your employees' knowledge and confidence. Health and Safety Officer: £25,000 to £40,000 per year Environmental Health Officer: £30,000 to £45,000 per year Laboratory Technician: £20,000 to £30,000 per year Occupational Health Specialist: £30,000 to £50,000 per year Safety Compliance Manager: £35,000 to £55,000 per year Certificates CPD Accredited Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: £3.99 each Outside of the UK: £9.99 each CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate

Are you looking to enhance your employees' abilities and skills in Security Management? If yes, then you have come to the right place. Our comprehensive Security Management course at Compliance Central is designed to help your team produce the best possible outcomes by mastering the essential Security Management skills. Whether your employees are new to Security Management or already working in the field, this course will provide them with the necessary knowledge and skillsets to excel. Get 3 CPD Accredited Courses: Course 01:- Diploma in Security Management Course 02:- Communication Skills Course 03:- Minute Taking Course Why Employee Training Matters: Boost Productivity: Well-trained employees work more efficiently, driving productivity in all areas. Increase Employee Morale: Invest in your employees' growth, leading to a positive work environment and higher retention rates. Stay Ahead of Competitors: Equip your workforce with the latest skills and knowledge to outshine the competition. Ensure Compliance and Safety: Specialised training keeps your business compliant and your workplace safe. Improve Customer Satisfaction: Well-trained staff deliver exceptional service, building loyal customer relationships. Why Choose Us? Expert-Developed Training: Industry professionals have developed valuable insights and helpful learning. Flexible Learning: Online Security Management course allows employees to learn at their own pace. Ongoing Support: Dedicated Security Management experts are available to guide your employees throughout the training process. Certificates of Achievement: Recognise your employees' commitment with CPD Certified certificates. Employer Dashboard: Easily track employee Security Management progress in our user-friendly dashboard. Empower Your Workforce Today! Invest in your company's future success. Join us to start your employees' Security Management training and watch your business thrive. Compliance Central - Empowering Businesses Through Knowledge Empower Your Business with Comprehensive Employee Training! At Compliance Central, we understand that well-trained employees are the backbone of successful organisations. Elevate your workforce and propel your business forward with our tailored online training programs. Course Curriculum Breakdown: Course 01:- Diploma in Security Management Module 01: Introduction to Security Management Module 02: Organisational Security Management Module 03: Security Risk Analysis and Risk Reduction Module 04: Physical and Information Security Protection Module 05: Business Resilience and Crisis Management Module 06: Cyber Security and Fraud Prevention Module 07: Security Investigations and Threat Awareness Module 08: Laws and Regulations Course 02:- Communication Skills Module 01: Basic Communication Skills Module 02: Advance Communication (I) Module 03: Advance Communication (II) Module 04: Telephone Etiquette Module 05: Body Language and Effective Communication Course 03:- Minute Taking Course Module 01: Introduction to Minute Writing Module 02: Preparation for Minute Taking Module 03: The Meeting Structure Module 04: Minute Meeting, Decision and Action Module 05: Roles and Responsibility of Minute Taker Module 06: Tips for Minute Taking Module 07: Technology in Minute Taking Module 08: Building Confidence Our Security Management course starts with the fundamentals and gradually progresses to cover advanced topics, making each lesson intuitive and easy to understand. CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Security Management course is ideal for new professionals looking to thrive in the Security Management field. Requirements Enrolling in this Security Management course only requires a basic understanding of the English language and an internet connection. Career path Completing the Security Management course will enhance your employees' knowledge and confidence. Security Manager: £35,000 to £70,000 per year Information Security Analyst: £30,000 to £55,000 per year Risk Manager: £40,000 to £75,000 per year Security Consultant: £45,000 to £80,000 per year Cybersecurity Specialist: £35,000 to £65,000 per year Certificates CPD Accredited Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: £3.99 each Outside of the UK: £9.99 each CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate

Feeling Stuck in Your Career? The HR Management: Recruitment & Leadership 20 Courses Bundle is Your Skill-Building Solution. This exceptional collection of 20 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, HR Management: Recruitment & Leadershipbundle provides an engaging learning experience, helping you learn skills across various disciplines. With The HR Management: Recruitment & Leadership 20 Courses Bundle!, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. HR Management: Recruitment & Leadershipbundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of HR Management: Recruitment & Leadership 20 Courses Bundle! on your job life and career growth! This HR Management: Recruitment & Leadership 20 Courses Bundle! Comprises the Following CPD Accredited Courses: Course 01: Introduction to Modern Human Resource Management Course 02: Complete Guide to HR systems Course 03: Learn Advanced Fundamentals of HR Dashboard Course 04: Virtual Interviewing for HR Course 05: Recruitment: IT Basics for IT Recruiters Course 06: Motivating, Performance Managing and Maintaining Team Culture in a Remote Team Course 07: Key Performance Indicators Professional Course 08: HR Technology Implementation: Preparing Your Team for Success Course 09: Become an Expert in Trello Course 10: Influencing and Negotiating Course 11: Anger Management and Conflict Resolution Program Course 12: Fundamentals of Excellent Leadership Course 13: Organizational Behaviour, HR and Leadership Course 14: Enterprise Risk: Identification and Mitigation Course 15: Essential Communication Skills for Professionals Course 16: Legal Office Administration Course 17: 10 Soft Skills for Workplace Course 18: Learn to Level Up Your Leadership Course 19: Ace Your Presentations: Public Speaking Masterclass Course 20: Time Management What will make you stand out? Upon completion of this online HR Management: Recruitment & Leadership 20 Courses Bundle! you will gain the following: CPD QS Accredited Proficiency with this HR Management: Recruitment & Leadership Bundle After successfully completing HR Management: Recruitment & Leadership bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this HR Management: Recruitment & Leadership Bundle The online test with immediate results You can study and complete HR Management: Recruitment & Leadership bundle at your own pace. Study for HR Management: Recruitment & Leadership bundle using any internet-connected device, such as a computer, tablet, or mobile device. The HR Management: Recruitment & Leadership 20 Courses Bundle! is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the HR Management: Recruitment & Leadership bundle, a comprehensive, complete collection of 20 courses. Each course in HR Management: Recruitment & Leadership bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the HR Management: Recruitment & Leadership bundle offers the flexibility and convenience to learn at your own pace. Make the HR Management: Recruitment & Leadership package your trusted partner in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The HR Management : Recruitment & Leadership 20 Courses Bundle! is perfect for: Expand your knowledge and skillset for a fulfilling career with HR Management: Recruitment & Leadership bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with HR Management: Recruitment & Leadership bundle. Discover your passion or explore new career options with the diverse learning opportunities in HR Management: Recruitment & Leadership bundle. Learn on your schedule, in the comfort of your home - HR Management: Recruitment & Leadership bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with HR Management : Recruitment & Leadership bundle. Certificates CPD Certificates Digital certificate - Included

Different companies use different methods to organize their projects and choosing the right tool to suit their needs is best determined by the type of methodology they use. Learn to better manage agile teams using Jira, which is an excellent project management tool. This is an introductory course to Jira, so if you are a beginner, this course can bring you from zero to hero in no time!

This course focuses on building the application and static website with the help of Next.js. Next.js is written on JavaScript, therefore, the individual will learn to develop the full-stack application CRUD, pagination, authentication, and more.

Course Overview Make your critical data easier to follow with dashboards displaying the main insights when you train to use Data Analytics with Google Data Studio. Sometimes analysts find that their collated information on Google Sheets is not viewed subjectively by clients or that they take unexpected conclusions from it. You can learn to eliminate this possibility by utilising the functions of Google Data Studio (GDS), the premier online tool for converting data into customisable informative reports and dashboards for easy perusal. This Data Analytics training provides a total learning curve for GDS and how to get the very best results from it. You will be taught the basic functions of Google Sheets, including queries and calculations. Following this, you will be given a masterclass on GDS itself, from its field calculation abilities to its layout design and accommodating a client's page requirements. With this expert tuition, you will be able to effortlessly format data and underline all of the key findings with a simple click or touch of the screen. Make your data speak volumes with this valuable course. This best selling Data Analytics with Google Data Studio has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Data Analytics with Google Data Studio is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Data Analytics with Google Data Studio is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Data Analytics with Google Data Studio is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Data Analytics with Google Data Studio, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Data Analytics with Google Data Studio will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Data Analytics with Google Data Studio to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Are you looking for a way to boost your productivity and efficiency with Excel? Do you want to learn how to create, analyze and visualize data in powerful and versatile spreadsheets? If so, then our level 2 online Excel course is perfect for you! This course will teach you how to use advanced functions, formulas, charts, tables, pivot tables and macros in Excel. You will learn how to work with large datasets, automate tasks, perform data analysis and create professional reports and dashboards. You will also get tips and tricks to optimize your workflow and save time. The course is suitable for anyone who has some basic knowledge of Excel and wants to take their skills to the next level. You will have access to video lectures, exercises, quizzes and downloadable resources. You will

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