Zinq IT Logo

Master Excel with Copilot

Discover how Copilot helps you understand data, build formulas, analyse trends, and create insights without needing advanced Excel skills. Whether you’re working with simple lists or complex spreadsheets, Copilot makes data easier to work with.

Video Library – Copilot in Excel

Excel Prompt Library – Everyday Prompts You Can Reuse

Explore our Prompt Library to see real‑world examples of how to use Copilot effectively. These ready‑to‑use prompts are designed to help you get better results faster, using the GCSE method to keep requests clear, focused, and practical.

Understanding Data:

Summarise this spreadsheet so I can quickly understand the main points. I’m reviewing this data for general awareness, so use the entire sheet and present the summary in clear, plain language.

Explain this data in simple terms so someone unfamiliar with it could understand it. Use the information in the spreadsheet and keep the explanation short and easy to follow.

Identify the key trends or patterns in this spreadsheet. I want to understand what stands out, using all available data, and present the findings as bullet points. 

Working With Formulas:

Create a formula that calculates the value I need based on the data in this sheet. I’m trying to automate a calculation, so provide a working Excel formula and explain it briefly.

Explain what this existing formula does and how it works. I didn’t create the spreadsheet, so use the formula already in the file and describe it in simple terms.

Suggest a simpler or more efficient formula to achieve the same result. Use the current data and calculations and explain why your suggestion is better.

Fix this formula so it returns the correct result. Use the values in this spreadsheet and provide the corrected formula with a short explanation.

Analysing & Comparing Data:

Compare the data in this spreadsheet and explain the key differences. I’m looking for insights, so use the full dataset and summarise the findings clearly.

Analyse how the data has changed over time using the values in this sheet. Present the results as a short written summary I can easily share.

Identify the highest and lowest values in this spreadsheet and explain what they relate to. Use the existing data and keep the explanation clear and concise. 

Cleaning & Reviewing Data:

Review this spreadsheet for possible errors or inconsistencies. I want to improve accuracy, so use the full dataset and clearly list any issues you find.

Help clean up this data so it’s more consistent and reliable. Use the current spreadsheet and suggest specific improvements that improve the document.

Identify any missing or incomplete data in this sheet. Use the existing values and clearly explain what is missing and where to find it is located.

Review the structure of this spreadsheet and suggest improvements. I want it to be easier to work with, so focus on layout, clarity, and organisation. 

Making Data Easier to Use:

Turn this spreadsheet into a simple written summary I can include in a report. Use the data provided and keep the explanation clear and non‑technical. 

Help prepare this spreadsheet so it’s ready to be shared with others. Use the existing data and suggest any final checks or improvements. 

Explain what someone new would need to know to understand this spreadsheet. Use the full file and present the explanation in a clear, step‑by‑step way.

Simplify this spreadsheet so it’s easier to read and work with. Use the data you currently have and focus on improving clarity rather than detail.

Insights & Decision Support:

Summarise the key takeaways from this spreadsheet so I can quickly understand what matters most. Use the data provided and keep it brief. 

Based on this data, explain what areas I should focus on. Use the spreadsheet as your source and clearly justify your reasoning for each area.

Highlight the most important numbers in this spreadsheet and explain why they matter. Use the data as‑is and keep the explanation concise.

Answer a specific question using the data in this spreadsheet. Use only the information available and clearly explain how you reached the answer.

Create a short explanation of this spreadsheet that I could share with a colleague. Use the existing data and keep the tone clear and professional.