🔢 Formulas & Functions (1–20)
Prompt 1: Write a formula to calculate the compound annual growth rate (CAGR).
Prompt 2: Generate an IF statement that returns ‘Yes’ if value > 100 and ‘No’ otherwise.
Prompt 3: Create a formula to calculate percentage change between two columns.
Prompt 4: Write a nested IF formula for grading A, B, C, D, F based on scores.
Prompt 5: How to use VLOOKUP to pull data from another sheet?
Prompt 6: Write a formula to extract the year from a date.
Prompt 7: Use the AND function to check if two conditions are true.
Prompt 8: Create a formula to calculate overtime pay after 40 hours.
Prompt 9: Write a formula using INDEX and MATCH instead of VLOOKUP.
Prompt 10: How to use the SUMIF function to total only values over 100?
Prompt 11: Create a COUNTIF formula to count all items equal to ‘Completed’.
Prompt 12: Generate a formula to split full names into first and last names.
Prompt 13: Write a formula to remove extra spaces from a text cell.
Prompt 14: Use the IFERROR function to prevent showing errors in lookup results.
Prompt 15: How to calculate age based on birthdate in Excel?
Prompt 16: Create a formula to check if a date is within the last 30 days.
Prompt 17: Write a dynamic formula to calculate the moving average.
Prompt 18: How to highlight duplicates using a formula?
Prompt 19: Use the TODAY function to auto-populate the current date.
Prompt 20: Create a formula that adds 10% GST to a price column.

📈 Data Analysis & Dashboards (21–40)
Prompt 21: Design a sales dashboard using pivot tables and charts.
Prompt 22: How to build a KPI tracker for monthly performance?
Prompt 23: Create a dynamic dashboard to track expenses vs. budget.
Prompt 24: Generate a pivot table to summarize product sales by category.
Prompt 25: Use slicers to filter data visually on a dashboard.
Prompt 26: Create a rolling 12-month trend line chart.
Prompt 27: How to create a heatmap of sales performance using conditional formatting?
Prompt 28: Build a dashboard to analyze employee attendance by department.
Prompt 29: Design a customer retention dashboard with churn rate analysis.
Prompt 30: Create a data validation drop-down list to filter dashboard content.
Prompt 31: Track project status using a traffic light dashboard.
Prompt 32: Generate weekly sales comparisons using Excel charts.
Prompt 33: Visualize profit margin distribution using box plots.
Prompt 34: Create a dashboard to track recruitment funnel metrics.
Prompt 35: How to create a dynamic chart using named ranges?
Prompt 36: Build an inventory management dashboard with stock alerts.
Prompt 37: Write formulas to compare budget vs. actual cost variance.
Prompt 38: Create a dashboard to visualize NPS (Net Promoter Score).
Prompt 39: Use Excel to analyze product-wise profitability.
Prompt 40: Track social media performance metrics using Excel dashboard.

📊 Charts & Visualization (41–60)
Prompt 41: Create a combo chart with columns and lines in Excel.
Prompt 42: How to build a pie chart showing market share?
Prompt 43: Generate a Gantt chart for project management in Excel.
Prompt 44: Design a waterfall chart to visualize profit breakdown.
Prompt 45: Use sparklines to show trends in rows.
Prompt 46: Make a dynamic bar chart that updates with filters.
Prompt 47: Create a doughnut chart to represent revenue allocation.
Prompt 48: Build a histogram to display data frequency.
Prompt 49: Design a thermometer chart to track progress toward a goal.
Prompt 50: Use a scatter plot to analyze correlation between two variables.
Prompt 51: How to add a trendline to a time-series chart?
Prompt 52: Create a KPI dashboard using progress bar visuals.
Prompt 53: Build a population pyramid using horizontal bar charts.
Prompt 54: Generate a stacked bar chart to compare department-wise output.
Prompt 55: Design a chart to show actual vs. target in different regions.
Prompt 56: Use data labels effectively in a clustered column chart.
Prompt 57: Add custom icons to visualize performance levels.
Prompt 58: Make a sales funnel chart in Excel.
Prompt 59: Create an animated chart for a presentation.
Prompt 60: Format chart axes to improve readability in complex reports.

⚙️ Automation & Productivity (61–80)
Prompt 61: Write a VBA macro to highlight rows with overdue tasks.
Prompt 62: Create a macro to copy data from one sheet to another.
Prompt 63: Automate monthly report generation using Excel macros.
Prompt 64: Use Power Query to clean and transform raw data.
Prompt 65: Set up Excel to send email alerts when certain values are reached.
Prompt 66: Write a macro to sort a table by date in descending order.
Prompt 67: Automate import of CSV files into a consolidated dashboard.
Prompt 68: Create a button to clear form fields in Excel.
Prompt 69: Use conditional formatting to alert when stock falls below minimum.
Prompt 70: Write a VBA script to generate PDF reports from a sheet.
Prompt 71: Use Power Automate to create a workflow for Excel updates.
Prompt 72: Set up automatic goal tracking for team KPIs.
Prompt 73: Build a one-click expense calculator using forms and macros.
Prompt 74: Use Excel Solver to optimize delivery routes.
Prompt 75: Write a macro to insert a new row with formulas intact.
Prompt 76: Create a stopwatch or timer tool using Excel VBA.
Prompt 77: Design a batch printing tool for invoices using Excel VBA.
Prompt 78: Use Excel to create an auto-incrementing invoice number system.
Prompt 79: Automate formatting of monthly performance charts.
Prompt 80: Write a VBA macro to filter and email specific rows.

🧾 Templates & Business Use Cases (81–95)
Prompt 81: Create an Excel template for personal budgeting.
Prompt 82: Build a task tracker with priority and due date sorting.
Prompt 83: Design a project timeline template with Gantt view.
Prompt 84: Make a sales pipeline tracker with deal stage indicators.
Prompt 85: Build a leave tracker for HR with auto-calculation.
Prompt 86: Create a petty cash log with automatic balance updates.
Prompt 87: Design an invoice template with tax calculations.
Prompt 88: Create a monthly planner template in Excel.
Prompt 89: Build a customer database with filtering options.
Prompt 90: Generate a content calendar with publish status tracking.
Prompt 91: Make a payroll sheet that auto-calculates taxes and bonuses.
Prompt 92: Design a travel expense claim template.
Prompt 93: Create a client billing tracker with status updates.
Prompt 94: Build an Excel CRM for small business lead tracking.
Prompt 95: Design a break-even analysis model template.

🧠 Learning & Troubleshooting (96–100)
Prompt 96: Explain the difference between absolute and relative cell references.
Prompt 97: List 10 must-know Excel shortcuts for faster work.
Prompt 98: How to fix #N/A, #VALUE!, and #REF! errors in Excel?
Prompt 99: Compare Excel vs. Google Sheets for business reporting.
Prompt 100: Create a practice plan to master Excel formulas in 30 days.