CSG’s mini Copilot series #7

Using Copilot in Excel to insert profit margins

Boosting efficiency with Copilot: inserting profit margins in Excel

Efficiency and accuracy are more important than ever, as processes are becoming more automated – customers expect your business to do the same. Microsoft Copilot in Excel is a powerful way that can help your business meet the demands of 2025, including supporting employees complete their tasks quicker, such as calculating profit margins. Here’s a short guide on how to use Copilot in Excel to insert profit margins, along with some tips to maximise its effectiveness.

How to use Copilot to insert profit margins

1. Open your Excel worksheet:

• Launch Microsoft Excel and open the worksheet where you need to calculate profit margins.

1. Activate Copilot:

• Click on the Copilot icon or use the designated shortcut to activate Copilot.

1. Select your data:

• Highlight the cells containing your revenue and cost data.

1. Request profit margin calculation:

• Type a prompt like “calculate profit margins for the selected data” into Copilot.
• Copilot will generate the formula and insert it into the appropriate cells.

1. Review and adjust:

• Check the inserted formulas to ensure they are correctly applied to your data.
• Adjust any cell references if necessary.

Tips for using Copilot effectively

1. Understand the formula:

• Profit Margin = (Revenue – Cost) / Revenue * 100
• This formula calculates the percentage of profit relative to revenue. Knowing this helps you verify Copilot’s calculations.

1. Use conditional formatting:

• Apply conditional formatting to highlight cells with high or low profit margins. This visual aid helps quickly identify areas needing attention.

1. Create charts:

• Visualize your profit margins using charts like bar graphs or pie charts. This makes it easier to analyze trends and performance.

1. Compare across periods:

• Use Excel to compare profit margins across different time periods. This helps track progress and identify seasonal trends.

1. Automate calculations:

• Set up automated calculations using Excel functions and Copilot to save time and reduce errors.

Learn more about how to leverage AI into your organsation through our AI adoption support.