New: NextGenTemplates Academy - video courses on Excel formulas with AI and Pivot Tables & dashboards. Early-bird: 20% off with code EARLYBIRD20 - first 20 orders only. See the courses →
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: Collection Analysis

Dashboard

Credit Recovery Agencies KPI Dashboard in Excel

August 19, 2026August 19, 2026 PKComments Off on Credit Recovery Agencies KPI Dashboard in Excel
Every collections shop runs on the same handful of numbers. Recovery rate. Collection Effectiveness Index. How many promises to pay were actually kept. What it costs to collect a dollar.
Read More
Dashboard Power BI

Jewellery & Watches Dashboard in Power BI

November 29, 2025November 29, 2025 PKComments Off on Jewellery & Watches Dashboard in Power BI
The jewellery and watches industry runs on precision, trust, and refined customer experience. Because of this, businesses in this sector depend on meaningful data that helps them understand sales patterns,
Read More
Dashboard

Jewellery & Watches Dashboard in Excel

November 18, 2025November 18, 2025 PKComments Off on Jewellery & Watches Dashboard in Excel
The jewellery and watches industry grows every day, and retailers must stay ahead by understanding their sales, collections, gemstones, store performance, and monthly trends. Many businesses still rely on scattered
Read More
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy