Excel dashboard and data visualization learning prompt
A safe prompt for learning how to create Excel dashboards step by step with KPI cards, charts, filters, summary tables, and clean report design.
Prompt template
A safe prompt for learning how to create Excel dashboards step by step with KPI cards, charts, filters, summary tables, and clean report design.
Use panel
0/6 filled
You are a data literacy instructor who teaches Excel dashboards, charts, and data visualization in a simple, safe, and step-by-step way. Using the general details below, create an Excel dashboard learning draft with anonymous sample data suitable for the user’s level. Excel level: Dashboard goal: Anonymous data context: Metrics to show: Visual style: Learning depth: Rules: - Work with a general, anonymous, and safe Excel learning context. - Create a sample data structure without asking for real company files, customer data, salary lists, financial reports, personal data, or confidential tables. - Do not present dashboard suggestions as final business reports or verified analysis results; prepare them as reviewable learning drafts. - Mark Excel version, menu names, chart types, and feature differences as points to check. - Do not guess missing data structures; state assumptions clearly. - Apply dashboard design principles such as simplicity, readability, one main message, suitable chart choice, and avoiding unnecessary colors. - Present the output as an editable learning plan the user can adapt to their own file. Output format: 1. Short learning goal summary 2. Basic logic of dashboards 3. Anonymous sample data table structure 4. Explanation of metrics to show 5. KPI card suggestions 6. Chart type suggestions 7. Filter and slicer usage idea 8. Page layout and placement plan 9. Color, font, and readability notes 10. Step-by-step dashboard creation plan 11. Common dashboard mistakes 12. Mini exercises 13. 7-day learning plan 14. Final checklist
This section helps you understand when and how to use this prompt more clearly.
This prompt creates a learning draft for users who want to learn Excel dashboard creation step by step, including KPI cards, charts, filters, summary tables, and page layout.
It is useful for users learning Excel reporting, beginners in data visualization, and people who want to practice with anonymous dashboard examples such as task tracking, sales summary, content performance, or learning progress reports.
It can be used when you want to make Excel data more readable, are unsure which metrics to show, struggle with chart selection, or want to plan a clean report page.
A user may want to create an Excel dashboard for weekly task tracking. By entering their level, anonymous data context, metrics to show, and visual style, they can receive KPI cards, chart suggestions, filter ideas, and a 7-day learning plan.
Instead of writing only 'make a dashboard', a clearer goal such as 'plan a simple Excel dashboard for beginner-level weekly task tracking with KPI cards, a status chart, and filters' creates a more useful output.
Does this prompt teach Excel dashboard design?
Yes. It explains core dashboard parts such as KPIs, charts, filters, page layout, and checklists for learning purposes.
Can this prompt be used without real company data?
Yes. It creates a safe learning draft using anonymous sample data structures.
This example shows how the prompt can create KPI cards, chart suggestions, page layout, and a checklist for learning Excel dashboards.
The goal of this session is to learn the logic of a simple and readable Excel dashboard for weekly task tracking. The dashboard will show basic metrics such as total tasks, completed tasks, pending tasks, and completion rate.
task_id: Task number task_name: Task name category: Task category status: Status priority: Priority due_date: Target date owner: Anonymous owner
1. Total tasks 2. Completed tasks 3. Pending tasks 4. Completion rate 5. Open high-priority tasks
A simple column chart can be used for status distribution. A horizontal bar chart can be used for priority distribution. If completion changes over time, a line chart can be considered. Pie charts should only be used if there are few categories and the chart remains readable.
This is an anonymous and safe Excel dashboard learning draft. The user should adapt the steps based on their Excel version, data structure, and report goal.
Writing the dashboard goal clearly helps the report focus on the right topic, such as sales, task tracking, learning progress, or content calendar.
Using an anonymous data context instead of sharing real files creates a safer learning process.
Defining metrics in advance can prevent the dashboard from becoming crowded with unnecessary charts.
Limited colors, clear titles, and one main message can make a dashboard easier to read.
No. It creates a dashboard learning draft using anonymous sample tables without asking for real files, company data, or personal information.
No. It creates a learning-oriented dashboard draft, metric explanations, chart ideas, and checklists. The user should review everything with their own data.
Yes. If beginner level is selected, it can explain topics such as KPIs, charts, filters, and page layout in simple language.
Yes. It can explain chart options such as column charts, line charts, pie charts, or tables based on the purpose of the data.
Prompts are for illustration only. Accuracy isn't guaranteed—please read and adapt them for your situation.
This prompt is for general purposes. For legal, medical or financial decisions please consult a qualified professional.
A practical workflow for writing AI prompts with clear structure, safe language, searchable topics, and consistent output quality.
Read moreLearn how to compare sample outputs from ChatGPT and Gemini by purpose, tone, accuracy, structure, and usability without expecting fixed results.
Read moreA step-by-step guide to turning long reports, articles, or meeting notes into clearer, review-friendly summaries with AI tools.
Read moreKPI cards can be placed at the top. Status and priority charts can be placed in the middle. A filtered task table or short notes area can be added at the bottom. Use limited colors and clear titles.
1. Create the anonymous task table. 2. Write status and priority fields consistently. 3. Calculate total and status-based metrics. 4. Place KPI cards at the top. 5. Add a simple chart for status distribution. 6. Consider filters or slicers. 7. Review readability with the final checklist.
Adding too many charts can make the dashboard confusing. Using too many colors can reduce readability. Inconsistent status names can break metrics. Trying to show every metric can weaken the main message.
Is the main message clear? Are KPI cards easy to read? Do charts create unnecessary clutter? Are status names consistent? Are colors simple? Do filters work with the right fields? Have the data been reviewed by the user?