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

Blogs

Power BI

Power BI KPI Cards with SVG + DAX: Let AI Write Them (Free File)

October 26, 2026 PKComments Off on Power BI KPI Cards with SVG + DAX: Let AI Write Them (Free File)
Which coffee shops are behind target? On a plain card and a grey table nobody can tell in two seconds. In this tutorial you build Power BI KPI cards with
Read More
Excel Tips and Tricks

How to Remove Duplicates in Excel Without Losing the Original (Free File)

October 26, 2026 PKComments Off on How to Remove Duplicates in Excel Without Losing the Original (Free File)
Your customer list has duplicates, and you are emailing the same people twice. You can remove duplicates in Excel in about ten seconds with one built-in button. The trick is
Read More
Power BI

Power BI Drill Through: See the Orders Behind Any Bar (Free File)

October 25, 2026October 25, 2026 PKComments Off on Power BI Drill Through: See the Orders Behind Any Bar (Free File)
Your Power BI chart shows the total. Then your boss points at one bar and asks: which orders make up that number? Power BI drill through answers that in one
Read More
Excel Tips and Tricks Templates

Profitability Analysis Pack in Excel

October 24, 2026 PKComments Off on Profitability Analysis Pack in Excel
Sales are up, so why is there so little profit left at the end of the year? The Profitability Analysis Pack in Excel answers that by showing which products, customers
Read More
VBA

Payroll Management System in Excel VBA

October 21, 2026 PKComments Off on Payroll Management System in Excel VBA
The Payroll Management System in Excel is a macro-enabled workbook that runs monthly payroll for a small business from one file: payslips with overtime, bonus and US tax withholding, a
Read More
Excel Tips and Tricks

Loan Amortization Schedule in Excel + EMI Calculator (Free File)

October 21, 2026 PKComments Off on Loan Amortization Schedule in Excel + EMI Calculator (Free File)
The dealer says "low monthly payments", but what does the loan really cost? In this tutorial you build a loan amortization schedule in Excel and a loan EMI calculator with
Read More
Dashboard Power BI Templates

Micro-Insurance Dashboard in Power BI

October 20, 2026 PKComments Off on Micro-Insurance Dashboard in Power BI
The Micro-Insurance Dashboard in Power BI answers the question every low-cost insurance program asks: which products, channels and partners earn their premium, and where do claims eat it? It reports
Read More
Blogs

Restaurant and Cafe Business Bundle: 7 Templates (Save 60%)

October 20, 2026 PKComments Off on Restaurant and Cafe Business Bundle: 7 Templates (Save 60%)
Running a restaurant, a cafe or any food service business means juggling orders, food cost, labor, delivery fees and guest experience every single day. The Restaurant and Cafe Business Bundle
Read More
Blogs

Retail Shop Business Bundle: 8 Retail Templates (Save 65%)

October 20, 2026 PKComments Off on Retail Shop Business Bundle: 8 Retail Templates (Save 65%)
Running a shop means three jobs at once: billing customers at the counter, keeping stock on the shelves and knowing which products and stores actually make money. The Retail Shop
Read More
Power BI

Power BI Page Navigator: Build a Modern Glass Navigation Bar (Free File)

October 19, 2026 PKComments Off on Power BI Page Navigator: Build a Modern Glass Navigation Bar (Free File)
Your Power BI report has four pages, but people only ever see the first one - because the only way to the others is the tiny page tabs at the
Read More

Posts pagination

1 2 … 456 Next
  • 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