These 5 Excel dashboard tricks would have saved me hours as a beginner
www.makeuseof.com/excel-dashboard-tricks-for-beginner/
Pivot Tables – Summarize thousands of rows in seconds without formulas
Pivot Charts – Visualize your Pivot Table data with one click
Helper Sheets – Keep raw data and complex calculations off the main dashboard view
Bring in extra reference data – Two tables on a single Excel worksheet.
Slicers and Filters – Quickly focus on relevant records
Conditional Formatting – Highlight data with visual alerts