Dashboard Formula Set

I'm building an Excel dashboard. Help me create the summary formulas.

**Data sheet:** "{{data_sheet_name}}" with columns:
{{describe_columns}}

**Dashboard metrics I need:**
1. {{metric_1}} (e.g., "Total revenue this month")
2. {{metric_2}} (e.g., "Top 5 products by units sold")
3. {{metric_3}} (e.g., "Month-over-month growth %")
4. {{metric_4}} (e.g., "Count of orders by status")

For each metric, provide:
- The formula (using SUMIFS, COUNTIFS, LARGE, INDEX-MATCH, etc.)
- Where to place it on the dashboard sheet
- How to make it dynamic (auto-update when new data is added)

Use named ranges or structured table references where appropriate. My data is in an Excel Table named "{{table_name}}".