50+ Copilot Prompts, Formula Examples Automation Workflows

50+ Copilot Prompts, Formula Examples Automation Workflows

50+ Copilot Prompts, Formula Examples & Automation Workflows

The Secret to Getting Better Results from Copilot

Many users try Copilot once and assume it is not powerful because they use vague prompts.

For example:

❌ Bad Prompt

Analyze this data.

Copilot may provide only a basic summary.

Instead, use:

✅ Better Prompt

Analyze this sales data, identify the top-performing products, compare monthly growth rates, and summarize key opportunities for increasing revenue.

The more context you provide, the better Copilot performs.

A simple formula for creating effective prompts is:

Action + Data + Goal + Output Format

Example:

Analyze this customer dataset and identify the top 10 customers by revenue. Present the results in a table and include recommendations for customer retention.

50 Best Copilot Prompts for Excel

These prompts can save hours of manual work.

Financial Analysis Prompts

1.

Analyze monthly revenue and identify growth trends.

2.

Calculate gross profit margin for each product.

3.

Forecast revenue for the next quarter.

4.

Identify the highest expense categories.

5.

Create a monthly budget summary.

6.

Compare actual expenses against budget targets.

7.

Identify unusual financial transactions.

8.

Calculate year-over-year growth rates.

9.

Build a financial dashboard.

10.

Generate a cash flow report.

Sales Analysis Prompts

11.

Identify the top-selling products.

12.

Compare sales performance by region.

13.

Calculate average order value.

14.

Forecast future sales performance.

15.

Highlight declining sales trends.

16.

Create a sales KPI dashboard.

17.

Analyze customer purchasing behavior.

18.

Identify the most profitable products.

19.

Calculate sales growth by month.

20.

Generate a quarterly sales report.

Marketing Analysis Prompts

21.

Calculate campaign ROI.

22.

Compare conversion rates by channel.

23.

Analyze website traffic trends.

24.

Identify top-performing marketing campaigns.

25.

Build a marketing performance dashboard.

26.

Analyze lead generation metrics.

27.

Identify customer acquisition trends.

28.

Summarize advertising performance.

29.

Forecast future lead generation.

30.

Calculate cost per acquisition.

Human Resources Prompts

31.

Calculate employee turnover rate.

32.

Analyze attendance trends.

33.

Identify departments with the highest productivity.

34.

Create a hiring performance report.

35.

Track employee retention trends.

36.

Analyze overtime expenses.

37.

Compare departmental staffing levels.

38.

Forecast future hiring needs.

39.

Generate workforce KPI reports.

40.

Analyze employee training completion rates.

Inventory & Operations Prompts

41.

Identify products at risk of stock shortages.

42.

Calculate inventory turnover.

43.

Forecast future inventory demand.

44.

Identify slow-moving inventory.

45.

Create a warehouse performance dashboard.

46.

Compare supplier performance.

47.

Calculate reorder points.

48.

Analyze operational bottlenecks.

49.

Track production efficiency.

50.

Summarize inventory performance.

Formula Generation Examples

One of Copilot's strongest features is formula creation.

Instead of searching Google for formulas, simply describe your objective.

IF Formula Example

Prompt:

Create an IF formula that marks sales above $10,000 as High Performance and all other sales as Standard.

Copilot generates the formula automatically.

XLOOKUP Example

Prompt:

Create an XLOOKUP formula to find customer names based on customer IDs.

This eliminates the need to manually build lookup functions.

SUMIFS Example

Prompt:

Create a SUMIFS formula that calculates revenue for each region.

Copilot builds the formula and explains how it works.

Percentage Growth Formula

Prompt:

Calculate month-over-month growth percentage.

Perfect for financial reporting and sales tracking.

Commission Formula

Prompt:

Create a commission formula that pays 5% on sales above $5,000.

Useful for sales compensation plans.

Dashboard Creation with Copilot

Dashboard creation traditionally requires advanced Excel skills.

Copilot dramatically simplifies the process.

Sales Dashboard Example

Prompt:

Create a dashboard showing monthly revenue, sales growth, top products, and regional performance.

Copilot can organize the information into a visual reporting format.

Marketing Dashboard Example

Prompt:

Build a marketing dashboard showing leads, conversions, ROI, and campaign performance.

Executive Dashboard Example

Prompt:

Create an executive KPI dashboard displaying revenue, profit, customer growth, and operational metrics.

Financial Reporting Automation

Finance teams spend significant time preparing reports.

Copilot can automate much of this work.

Monthly Financial Report

Prompt:

Generate a monthly financial summary including revenue, expenses, profit, and growth trends.

Budget Variance Report

Prompt:

Compare actual spending against budget and highlight significant variances.

Forecast Report

Prompt:

Forecast next quarter revenue based on historical trends.

Sales Team Automation

Sales managers can automate many repetitive reporting tasks.

Territory Analysis

Prompt:

Compare territory performance and identify top-performing regions.

Product Analysis

Prompt:

Identify the highest-margin products and summarize key findings.

Sales Forecasting

Prompt:

Forecast future sales using historical data.

Marketing Automation Workflows

Marketing teams can use Copilot to analyze campaign performance.

Campaign Performance Review

Prompt:

Compare all marketing campaigns and identify the highest ROI activities.

Lead Generation Analysis

Prompt:

Analyze lead generation performance and identify growth opportunities.

Customer Acquisition Dashboard

Prompt:

Create a dashboard showing customer acquisition trends over the past 12 months.

Small Business Use Cases

Small business owners often lack dedicated analysts.

Copilot acts as a virtual business intelligence assistant.

Use it to:

  • Monitor sales

  • Analyze customer trends

  • Track expenses

  • Forecast growth

  • Manage inventory

  • Build dashboards

Real-World Example: E-commerce Store

Imagine a Shopify store selling Microsoft software licenses.

Instead of manually reviewing monthly sales reports, you could ask:

Analyze sales performance for all Microsoft Office products and identify the top-selling licenses.

Or:

Compare sales performance between Microsoft Office 2024 Home and Microsoft Office Home & Business 2024.

Or:

Forecast next month's software license sales based on the previous 12 months.

These insights help store owners make better business decisions.

Recommended Office Products for Excel Users

If you're using Excel regularly, having a genuine Microsoft Office license ensures the best experience.

Microsoft Office 2024 Home Download License

https://softwarekeep.digital/products/microsoft-office-2024-home-download-1-pc-license

Best for home users.

Microsoft Office 2024 Home and Business License

https://softwarekeep.digital/products/microsoft-office-2024-home-and-business-license

Perfect for professionals and remote workers.

Microsoft Office Home & Business 2024

https://softwarekeep.digital/products/microsoft-office-home-business-2024

Ideal for entrepreneurs and small business owners.

 

Back to blog