Act as a Microsoft Excel expert.Create a formula that solves the following problem:[Describe your requirement]Explain the formula step-by-step and provide an Excel 365 version if available.

Act as an Excel trainer.Explain the following Excel formula in simple English:[Paste Formula]Break down every function step-by-step, explain what each argument does, and provide a practical example using sample data.

Act as a senior Excel troubleshooting expert.Review this formula:[Paste Formula]Identify all errors, explain why they occur, and provide a corrected version with best practices.

Convert the following VLOOKUP formula into XLOOKUP.Explain the advantages of XLOOKUP, performance improvements, and when it should be used instead of VLOOKUP.Formula:[Paste Formula]

Act as a Business Intelligence consultant.Design a professional Excel dashboard for monthly sales reporting.Include KPIs, charts, slicers, filters, and an executive summary section.Recommend the ideal layout and explain why.

Create conditional formatting rules that:• Highlight overdue tasks in red• Highlight upcoming deadlines in orange• Highlight completed tasks in greenProvide step-by-step instructions.

I have customer data with duplicates, inconsistent capitalization, extra spaces, and missing values.Show the fastest way to clean it in Excel using formulas, Power Query, or Excel 365 tools.

Explain how to create a Pivot Table that summarizes sales by region, product category, and month.Include recommended settings and best practices.

Act as a VBA developer.Write VBA code that automatically formats the active worksheet, adjusts column widths, freezes the top row, and highlights headers.Explain how to install and run the macro.

Act as an Excel performance optimization expert.My workbook contains [Number] rows and multiple formulas.Analyze the possible reasons it is running slowly and provide step-by-step recommendations to improve performance, reduce file size, and speed up calculations.

Act as a financial planning expert.Create a professional monthly budget template in Excel that includes income tracking, expenses, savings goals, debt payments, and visual charts.Explain how each section should work.

Act as an HR reporting specialist.Create an Excel attendance tracker that records employee attendance, absences, leave days, holidays, and monthly summaries.Include useful formulas and dashboard suggestions.

Act as a project management consultant.Design a project tracking workbook with task names, owners, deadlines, completion percentages, status indicators, and automated progress reporting.Provide best practices for project visibility.

Act as a senior sales analyst.Review the following sales dataset:[Paste Data]Identify trends, top-performing products, weak areas, growth opportunities, seasonal patterns, and actionable recommendations.

Act as a business performance consultant.Design a KPI dashboard that tracks revenue, profit, customer growth, conversion rates, and business performance metrics.Recommend charts and dashboard layout.

Generate 1,000 rows of realistic sample sales data including order dates, customer names, products, quantities, sales values, and regions.Format the output so it can be copied directly into Excel.

Act as a forecasting and business planning expert.Using the historical sales data below:[Paste Data]Recommend the best forecasting method, create a forecast model, identify future trends, and explain the assumptions behind the prediction.

Act as a Microsoft Power Query expert.Explain how to use Power Query to clean, transform, and automate the following dataset:[Describe Your Dataset]Provide step-by-step instructions and best practices suitable for Excel 365 users.

Act as an Excel dashboard specialist.Show me how to create dynamic charts that automatically update when new data is added.Include formulas, named ranges, Excel Tables, and best practices.

Act as a project management consultant.Provide step-by-step instructions for creating a professional Gantt Chart in Excel.Include task tracking, milestones, dependencies, and progress indicators.

Act as a financial modeling expert.Create a financial model for a small business including revenue projections, expenses, cash flow, profit margins, and break-even analysis.Explain every assumption used.

Act as an Excel automation specialist.Review my workflow:[Describe Workflow]Suggest ways to automate repetitive tasks using formulas, VBA, Power Query, Office Scripts, and Excel 365 features.

Act as an Excel data quality expert.Create data validation rules for the following spreadsheet:[Describe Spreadsheet]Include dropdown lists, date restrictions, number limits, and custom validation formulas.

Act as a data-cleaning specialist.My Excel sheet contains dates stored as text and inconsistent formatting.Show me the best formulas and methods to convert everything into proper Excel date formats.

Act as a senior Excel consultant.Review my workbook structure and identify opportunities to improve:• Performance• Readability• Automation• Reporting• Data Quality• Dashboard DesignProvide a prioritized action plan.