Blogs Archives - Page 14 of 454 - PK: An Excel Expert

Templates VBA

Paint Shop Stock Data Entry System in Excel

September 14, 2026September 14, 2026 PKComments Off

Paint Shop Stock Data Entry System in Excel gives paint shops, decorating-supply retailers, stock assistants, and small-store managers a structured way to add, update, delete, and review paint stock records

Templates VBA

Toy Shop Inventory Data Entry System in Excel

September 14, 2026September 14, 2026 PKComments Off

Toy Shop Inventory Data Entry System in Excel gives toy shops, toy retailers, stock assistants, and small-store managers a structured way to add, update, delete, and review toy inventory records

Power BI Templates

Kitchen Remodeling KPI Dashboard in Power BI

September 14, 2026September 14, 2026 PKComments Off

The Kitchen Remodeling KPI Dashboard in Power BI scores 14 KPIs across 7 KPI groups on four report pages, backed by two hidden tooltip pages and five slicers. Every KPI

Power BI Templates

Home Renovation Contractor KPI Dashboard in Power BI

September 14, 2026September 14, 2026 PKComments Off

The Home Renovation Contractor KPI Dashboard in Power BI tracks 14 remodelling KPIs grouped into 8 categories, across 4 report pages plus 2 hidden tooltip pages, driven by 104 DAX

Dashboard Power BI

Emotion AI Startups Dashboard in Power BI

September 14, 2026September 14, 2026 PKComments Off

The Emotion AI Startups Dashboard in Power BI is a five-page Power BI report built over a 500-row, 18-column sample table spanning one calendar year, January to December 2025. Its

Power BI Templates

Electric Vehicle Charging Dashboard in Power BI

September 14, 2026September 14, 2026 PKComments Off

Electric Vehicle Charging Dashboard in Power BI turns entered charging-session, energy, revenue, hub, tariff, customer, and payment data into five connected analytical pages. The package contains a PBIX report, Data.xlsx

Dashboard Templates

ESG Reporting Dashboard in Excel

September 14, 2026September 14, 2026 PKComments Off

The ESG Reporting Dashboard in Excel is a seven-sheet workbook that turns 500 sample disclosure records into 5 interactive pages, 5 KPI cards and 16 linked charts, all filtered by

Dashboard Templates

ERP Systems Dashboard in Excel

September 14, 2026September 14, 2026 PKComments Off

The ERP Systems Dashboard in Excel is a five-page reporting workbook that turns 500 sample implementation records into five headline KPI cards and 20 charts, filtered by four slicer groups.

Power Query

Merge Queries in Power Query in Excel: Combine Two Tables Without VLOOKUP

September 13, 2026September 13, 2026 PKComments Off

Merge queries in Power Query in Excel to combine two tables in a few clicks instead of writing VLOOKUP formulas. In this tutorial we merge a 350-row Sales Data table

Dashboard Templates

Elevator Maintenance KPI Scorecard in Excel

September 13, 2026September 13, 2026 PKComments Off

The Elevator Maintenance KPI Scorecard in Excel brings 10 monthly service indicators into one formula-driven workbook. Its scorecard combines red/amber/green traffic lights, MTD and YTD modes, target and prior-year comparisons,