11762 Marketing courses delivered Online

Overview This comprehensive course on House Cleaning will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This House Cleaning 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? 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 House Cleaning. It is available to all students, of all academic backgrounds. Requirements Our House Cleaning 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 2 sections • 9 lectures • 03:18:00 total length •Module 01: Introduction to House Cleaning: 00:21:00 •Module 02: Cleaning Equipment and Ingredients: 00:28:00 •Module 03: Cleaning the Kitchen: 00:37:00 •Module 04: Cleaning the Bedroom and Livingroom: 00:24:00 •Module 05: Bathroom Cleaning: 00:22:00 •Module 06: Cleaning and Organising a Kid's Room: 00:23:00 •Module 07: Cleaning Home Office: 00:22:00 •Module 08: Cleaning Walls: 00:21:00 •Assignment - House Cleaning: 00:00:00

Develop your dream career as an athlete's agent with the Athlete Management training course. In this detailed training course you learn; how to guide and manage your clients career and commercial decisions, with further knowledge on growing your athlete management agency. The Athlete Management training course covers everything from; management, problem-solving and creative decision making to commercial analysis and strategic client management. Your Learning Goals: Learn about the sports agent industry Understand the duties and responsibilities of a sports agent Understand the social and economic welfare required for sports agents Learn about the different types of sports agents and their services Learn about the sports agency model Learn about the law duties of sports agents Discover the skills required to be an effective sports agent Understand the importance of networking. Who is this Course for? Athlete Management Training is 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 background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Module : 01 Introduction to Sports Agent Industry 00:15:00 Sports Agent 00:30:00 Duties and Responsibilities of a Sports Agent 00:15:00 Functions of a Sports Agency 01:00:00 Characteristics of a Sports Agency 01:00:00 Different Types of Sports Agents and Services 01:00:00 The Social and Economic Weight of Sports Agents 02:00:00 Module : 02 Sports Agency Model 00:30:00 Statutory and Common Law Duties on Sports Agents 00:30:00 Sports Agents' Representative Bodies 00:30:00 Brand Building and Management 00:15:00 Networking and Sponsorship 00:08:00 Skills Required for Sports Agents 00:30:00 How to Become a Sports Agent 00:30:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview This comprehensive course on Performance Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Performance Management 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 Performance Management. It is available to all students, of all academic backgrounds. Requirements Our Performance Management 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 8 sections • 24 lectures • 04:36:00 total length •Introduction & Course Map: 00:06:00 •Performance Management: 00:11:00 •Strategy Execution: 00:09:00 •Performance & Strategy Framework: 00:16:00 •Balanced Scorecard: 00:15:00 •Employee Performance: 00:10:00 •KPIs Introduction: 00:15:00 •KPIs Selection: 00:17:00 •KPIs Quality: 00:24:00 •KPIs Forms & Types: 00:26:00 •KPIs Polarity, Status, & Documentation: 00:19:00 •Target Setting: 00:11:00 •Target Setting Methods & Example: 00:10:00 •Reporting Introduction: 00:09:00 •Reports Design: 00:05:00 •Reporting Process: 00:08:00 •Review Meeting: 00:04:00 •Reporting IT System: 00:14:00 •Kippy.cloud System: 00:21:00 •Cash & Non-Cash Rewards: 00:10:00 •Kaizen Reward Program: 00:09:00 •Terminology: 00:02:00 •Conclusion & Thank you: 00:05:00 •Assignment - Performance Management: 00:00:00

Overview This comprehensive course on Supply Chain Management for Everyone will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Supply Chain Management for Everyone 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? 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 Supply Chain Management for Everyone. It is available to all students, of all academic backgrounds. Requirements Our Supply Chain Management for Everyone 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 14 sections • 83 lectures • 10:29:00 total length •Introduction and Syllabus: 00:05:00 •Manufacturers and retailers supply chain processes: 00:07:00 •Similarities & Diiferences in manufacturing Retail Supply Chain Elements: 00:12:00 •Retail as a subset of Retail Management & Retail Supply Chain Planning Executive: 00:06:00 •Strategic Tactical Operational view of Retail Supply chain: 00:09:00 •Retail Supply Chain maturity Conclusion: 00:04:00 •Introduction to Category Management: 00:04:00 •Category Management Process Category Definition: 00:10:00 •Category Roles Category Assessment Category Performance Measure: 00:10:00 •Category Strategies & tactics: 00:10:00 •Implementation and Review Enabling components of category management: 00:06:00 •Category captain Challenges in Category Management: 00:09:00 •Merchandising benefits and types: 00:06:00 •Merchandise hierarchy Merchandise Forecasting: 00:08:00 •Merchandise Budgeting: 00:07:00 •Open to Buy Control and Conclusion: 00:08:00 •Introduction benefits and framework of Assortment: 00:04:00 •Assortment strategy Objectives and Assortment Selection Process: 00:10:00 •Assortment Planning Role of IT and Data in Assortment Management: 00:09:00 •Store Clustering Benefits and Types: 00:05:00 •Space Management Benefits Integration with Assortment Stages of Space Planni: 00:07:00 •Planogram Process for planogram management: 00:13:00 •Retail Pricing Challenges: 00:10:00 •Price Elasticity Managing Retail Pricing Life Cycle: 00:07:00 •Retail Promotion Objectives Promotional Measures and KPIs: 00:07:00 •Promotion Tools Decision Points for Retailers while planning Promotions: 00:09:00 •Information used for Planning Promotions Promotion Optimization Process: 00:08:00 •Managing Retail Markdowns: 00:07:00 •Product Design Challenges for the Retailer: 00:08:00 •Private Labels Types Advantages Disadvantages: 00:05:00 •Supply chain decisions in private labels: 00:03:00 •Retail Packaging: 00:07:00 •Green Design Packaging: 00:08:00 •Green Design Packaging Continues: 00:07:00 •IT for Retail Product Lifecycle management Conclusion: 00:08:00 •Retail Distribution Models Retail Replenishment: 00:06:00 •Vendor Managed Inventory its process: 00:06:00 •VMICRP Advantages Cautions: 00:08:00 •CPFR Process: 00:07:00 •Direct Store Delivery Route Accounting Handheld Devices Types of DSD: 00:06:00 •IT for Retail Distribution Replenishment and Conclusion: 00:04:00 •Transport Planning Legs in transportation: 00:04:00 •Transportation Planning Drivers Tools: 00:12:00 •Transportation constraints Transportation Execution Process: 00:07:00 •Transportation Cycle IT for transport management: 00:08:00 •Measures of Transport Management Green transport: 00:04:00 •Retail Warehousing Overview and Functions: 00:09:00 •Value added services of a retail warehouse Cross docking introduction: 00:04:00 •Cross docking Types applications advantages working: 00:09:00 •Why inventory cost of inventory inventory pyramid: 00:07:00 •Factors to consider to decide on inventory measures of inventory conclusion: 00:07:00 •Important concepts Supplier Relationship Management Process: 00:08:00 •Merchandise Procurement Decisions Procurement Process: 00:07:00 •Merchandise Procurement Decisions Procurement Process Continue: 00:08:00 •Global Sourcing Pros and Cons: 00:06:00 •Major Processes in Global Sourcing: 00:08:00 •Sourcing Conclusion: 00:11:00 •Introduction Retail Customer Service Customer Service Mix: 00:08:00 •Customer Service Pyramid Customer Service over Retail Life cycle: 00:07:00 •Ways to improve Customer Service for a Retailer: 00:09:00 •Order Management Process Concept of Perfect Order: 00:06:00 •Multi Channel Retailing: 00:09:00 •Retail Returns Reverse Logistics: 00:08:00 •Reverse Logistics process: 00:11:00 •Retail Loyalty Programmes: 00:08:00 •Retail kiosk advanced payment technologies conclusion: 00:09:00 •Types of Retailer Organised B2C Retail Format examples: 00:05:00 •Cash carry Retailing Rural Retailing: 00:06:00 •Cash carry Retailing Rural Retailing Continue: 00:08:00 •Airport Retailing Non Store based Retail Formats Online Shopping: 00:07:00 •Airport Retailing Non Store based Retail Formats Online Shopping Continue: 00:08:00 •Service Retailing Banking Courier and Conclusion: 00:09:00 •Understanding development process supply chain characteristics: 00:13:00 •Pre pack Planning: 00:05:00 •Apparel retail Supply Chain Innovations: 00:11:00 •Footwear retailing Supply Chain Drivers: 00:09:00 •Case study of Khadims Footwear Conclusion: 00:08:00 •Retail Technology maturity Model Need for IT in retail: 00:09:00 •Barcoding RFID: 00:10:00 •Retail ERP: 00:08:00 •Retail Analytics: 00:06:00 •POS Systems Mobile Applications: 00:04:00 •POS Systems Mobile Applications Continued: 00:09:00

Overview Start a career as an estate agent by gaining the skills and qualifications required to work in the real estate sector. This course will teach you everything you need to know to become a professional real estate agent. In this Estate Agent & Personal Development Level 3 course, you will learn sales techniques, communication skills and personal leadership skills. In addition, you will learn professional negotiation techniques, time management strategies and many other skills vital to succeed in the modern real estate sector. 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 Estate Agent & Personal Development Level 3. It is available to all students, of all academic backgrounds. Requirements Our Estate Agent & Personal Development Level 3 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 1 sections • 10 lectures • 03:47:00 total length •Module 01 - Estate Agent: An Introduction: 00:24:00 •Module 02 - Different Types of Estate Agents: 00:18:00 •Module 03 - Getting Started on the Job: 00:19:00 •Module 04 - Listing Property: Finding the Sellers: 00:27:00 •Module 05 - Valuation Process: 00:24:00 •Module 06 - Negotiating as Estate Agent: 00:15:00 •Module 07 - Selling Property: Finding the Buyers: 00:26:00 •Module 08 - Letting Property: 00:34:00 •Module 09 - Technology for Estate Agents: 00:24:00 •Module 10 - Regulation of Estate Agents: 00:16:00

Overview This comprehensive course on Library and Information Science Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Library and Information Science Course 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 Library and Information Science Course It is available to all students, of all academic backgrounds. Requirements Our Library and Information Science Courseis fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path   Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 8 lectures • 02:27:00 total length •Module 01: Organisation Systems: 00:25:00 •Module 02: Ethics and Values in the Library Professions: 00:21:00 •Module 03: Library Networking: 00:17:00 •Module 04: Library as Infrastructure: 00:25:00 •Module 05: Finance and Budgeting: 00:17:00 •Module 06: Digital and Virtual Libraries: 00:19:00 •Module 07: Library Legislation: 00:23:00 •Assignment - Library and Information Science Course: 00:00:00

Overview Discover some great career opportunities with the retail methods and technology. This Retail Management Advanced Diploma course prepares you with all the elementary skills needed to become a successful retail manager. Retail employers look for individuals who can ensure their customers can quickly locate their desired items. After completion of this course, you will have the skills and knowledge to become an asset to any retail company as a brand manager, retail manager, or similar role. You will have the expertise to run a budget, deal with customer queries, recruit and supervise staff, and much more, to meet your target. 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 Retail Management Advanced Diploma. It is available to all students, of all academic backgrounds. Requirements Our Retail Management Advanced Diploma 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 18 sections • 18 lectures • 05:28:00 total length •Introduction to Retail Management: 00:24:00 •Retail Strategy: 00:15:00 •Retail Buying and Merchandising: 00:19:00 •Retail Pricing: 00:34:00 •Supply Chain Management in Retailing: 00:14:00 •The Sales Process and Dealing with Customers at the Checkout: 00:12:00 •Importance of Consumer Behaviour: 00:14:00 •Taking Trends and Targeting Customers Effectively: 00:13:00 •The Importance of Communicating with Customers: 00:20:00 •Choosing a Retail Location: 00:16:00 •Retail Psychology: 00:15:00 •Negotiate the Right Deal with Suppliers: 00:14:00 •Develop Store Security Procedures: 00:18:00 •Management Skills for Leading Your Team: 00:19:00 •Selling in Multiple Channels: 00:23:00 •Retail Brand Management: 00:18:00 •Health & Safety for Retail Stores: 00:23:00 •Consumer Rights Act: 00:17:00

Overview This comprehensive course on SolidWorks Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This SolidWorks Masterclass 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? 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 SolidWorks Masterclass. It is available to all students, of all academic backgrounds. Requirements Our SolidWorks Masterclass is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 18 lectures • 03:22:00 total length •Introduction: 00:09:00 •User interface: 00:28:00 •Solidworks sketch fundamentals: 00:06:00 •part 1: 00:11:00 •Part 2: 00:10:00 •Part 3: 00:06:00 •Assembly Fundamentals: 00:01:00 •Crank slider mechanism: 00:26:00 •Pepsi bottle: 00:07:00 •Pepsi can: 00:10:00 •Part 1: 00:08:00 •Bearing part 2: 00:05:00 •Bearing assembly: 00:05:00 •Jet Engine parts: 00:28:00 •Jet Engine - Assembly: 00:23:00 •Missiles - parts: 00:14:00 •Missiles - Assembly: 00:05:00 •Assignment - SolidWorks Masterclass: 00:00:00

Overview This comprehensive course on Land Management Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Land Management Course 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 Land Management Course. It is available to all students, of all academic backgrounds. Requirements Our Land Management Course 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 Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 3 sections • 12 lectures • 05:33:00 total length •Module 01: Land Management: An Introduction: 00:28:00 •Module 02: Land Use and Land Use Planning: 00:34:00 •Module 03: Soil Management: 00:36:00 •Module 04: Land Degradation and Management: 00:27:00 •Module 05: Weed Management: 00:37:00 •Module 06: Watershed Management: 00:22:00 •Module 07: Irrigation Management: 00:30:00 •Module 08: Land Tenure, Administration and Transection: 00:42:00 •Module 09: Land Registration and Acquisition: 00:37:00 •Module 10: Land Law: 00:40:00 •Assignment - Land Management Course: 00:00:00 •Order Your Certificate: 00:00:00

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