LANGKAH 2: Suruh ChatGPT audit table

Act as an Excel data analyst and audit the uploaded workbook to determine whether the data tables are properly structured for dashboard creation. Check specifically for: - merged cells - multiple header rows - blank row…

Act as an Excel data analyst and audit the uploaded workbook to determine whether the data tables are properly structured for dashboard creation.
Check specifically for:
- merged cells
- multiple header rows
- blank rows or columns inside the dataset
- subtotals or totals mixed with raw records
- inconsistent column names
- duplicate records
- inconsistent date formats
- numbers stored as text
- currency symbols embedded in values
- missing values
- inconsistent categories
- unnecessary formatting
- multiple variables combined inside one column
- columns that should be split
- data that should be converted into an Excel Table
- structural issues that may affect PivotTables, charts, formulas, slicers, or dashboard filtering
Do not automatically assume the table needs fixing.
If the existing data structure is already clean and dashboard-ready, clearly state:
'The table structure is suitable for dashboard creation. No restructuring is required.'
Then briefly explain why.
If improvements are required, list exactly what should be corrected before building the dashboard.

Exact prompt text captured from the public post/author comments on facebook.com/kelasmultimediaofficial. · Attribution: Kelas Multimedia

More Careers prompts