If you want to create a professional Salary Excel Dashboard using an AI tool, you can use the prompt provided below. Simply copy the prompt and paste it into your preferred AI tool. The AI will generate a well-structured and professional Excel dashboard for your salary sheet.
You can further customize the dashboard by editing existing elements or adding new features based on your requirements. Before generating the dashboard, review the prompt carefully and decide how many KPI cards, charts, tables, and other dashboard components you want to include. Defining these requirements in advance will help the AI generate a more accurate, organized, and visually appealing Excel dashboard that meets your specific needs.
You are an Expert Excel Dashboard Designer and Data Analyst.
I have uploaded an Excel salary sheet.
The sheet contains these columns:
Emp ID
Employee Name
Designation
Basic Salary
HRA (40%)
DA (20%)
Conveyance
Gross Salary
PF (12%)
TDS
Other Deductions
Total Deductions
Net Salary
Your task is to create a Professional Interactive Salary Dashboard.
========================
Dashboard Requirements
========================
Create a modern executive dashboard with a clean corporate design.
Use blue, white and light gray color theme.
-----------------------------------
TOP KPI CARDS (3 Cards)
-----------------------------------
Card 1
Title:
Total Salary Expense
Calculation:
SUM(Net Salary)
Display:
₹ with commas
Large Bold Number
----------------
Card 2
Title:
Total Employees
Calculation:
COUNT(Emp ID)
----------------
Card 3
Title:
Average Salary
Calculation:
AVERAGE(Net Salary)
Display currency format.
-----------------------------------
CHART 1
-----------------------------------
Create a Horizontal Bar Chart
Title:
Department / Designation Wise Salary Distribution
Category:
Designation
Value:
SUM(Net Salary)
Sort:
Highest to Lowest
Show:
Data Labels
Gridlines
Professional Colors
-----------------------------------
CHART 2
-----------------------------------
Create a Doughnut (or Pie) Chart
Title:
CTC Breakdown
Values:
Gross Salary
Total Deductions
Net Salary
Show percentage and values.
-----------------------------------
INTERACTIVE FILTERS
-----------------------------------
Create interactive slicers or filter controls for:
Designation
Employee Name
Salary Range
Employee ID
All charts and KPI cards should update automatically whenever filters are changed.
-----------------------------------
ADDITIONAL INSIGHTS
-----------------------------------
Show these metrics in a small section:
Highest Paid Employee
Highest Net Salary
Lowest Paid Employee
Lowest Net Salary
Total PF Deducted
Total TDS
Average Gross Salary
Average Deductions
-----------------------------------
TABLE
-----------------------------------
Create a searchable employee summary table containing:
Emp ID
Employee Name
Designation
Gross Salary
Total Deductions
Net Salary
The table should respond to dashboard filters.
-----------------------------------
FORMATTING
-----------------------------------
Use professional spacing.
Rounded KPI cards.
Proper alignment.
Currency formatting (₹).
Conditional formatting:
Green for High Salary
Yellow for Medium Salary
Red for Low Salary
Use professional fonts.
-----------------------------------
AUTOMATION
-----------------------------------
Whenever new employee rows are added to the Excel sheet:
Dashboard should update automatically.
Charts should resize automatically.
KPIs should refresh automatically.
No manual editing required.
-----------------------------------
FINAL OUTPUT
-----------------------------------
Provide:
1. Dashboard Layout
2. Excel formulas used
3. Pivot Tables required
4. Pivot Charts required
5. Named ranges if needed
6. Dynamic formulas
7. Any Power Query or Excel Table recommendations
8. Best practices to keep the dashboard fully automatic.
Design it like a professional HR Salary Dashboard suitable for management presentations.