RavenPrompts
Home

Find your category

Create and communicate

  • Photography and image
  • Videos
  • Social media
  • Content creation
  • Marketing

Business and organisation

  • Sales
  • Business
  • Finance
  • Productivity

Learn and develop

  • Education
  • Programming

Life and leisure

  • Food
  • Sports
  • Travel
View all categories →
Prompt libraryFavoritesBlogPricingSuggest a prompt
← Back to the prompt library
FinanceFree🔥 Popular

Monthly budget with variances in Excel

Share prompt

Monthly budget with variances in Excel

Choose a network or copy the link to paste it into Instagram, TikTok or any other app.

Compare a budget with actual movements by category and month.

Prepare and copy↓

It indicates version, platform, function language and Excel separators. Check formulas with fictitious data and keep the original file.

General references: Microsoft: support for BUSCARX / XLOOKUPMicrosoft: Separators and formula errors.

Your prompt

Prepare your prompt

1. Fill in your details. 2. Copy the prepared prompt. 3. Paste it into your AI.

Field 1 of 7

State the tool, version and settings you know. Use “I don’t know yet” for missing details. The example shows the format. Use your own details; it is not added to your answer.

State the tool, version and settings you know. Use “I don’t know yet” for missing details. The example shows the format. Use your own details; it is not added to your answer.

State the tool, version and settings you know. Use “I don’t know yet” for missing details. The example shows the format. Use your own details; it is not added to your answer.

Give dates, duration or available time, and whether they are flexible. The example shows the format. Use your own details; it is not added to your answer.

Enter the information requested in this field. You can add details on multiple lines. The example shows the format. Use your own details; it is not added to your answer.

Use fictional or anonymised information. Do not include passwords or customer data. The example shows the format. Use your own details; it is not added to your answer.

Use fictional or anonymised information. Do not include passwords or customer data. The example shows the format. Use your own details; it is not added to your answer.

Complete the fields or use “I don’t know yet”.

0 of 7 fields ready

Complete the fields or use “I don’t know yet”.

Review prepared prompt
Act as an Excel assistant. Design a spreadsheet for the stated task using the supplied data.
TASK: Monthly budget with variances in Excel
REQUIRED DATA
Excel version and platform: [VERSION AND PLATFORM]
Language of functions: [LANGUAGE OF EXCEL FUNCTIONS]
Argument and decimal separators: [SEPARATORS]
Example of the date format used: [DATE FORMAT]
Level of experience: [LEVEL OF EXPERIENCE]
Fictional or anonymized headers and rows: [STRUCTURE AND SAMPLE]
Specific conditions of the task: [TASK DATA]
Required details: Budget by category, anonymized transactions, period and sign convention.
BEFORE ANSWERING
If essential information is missing, ask up to three specific questions. If no file is provided, use the supplied schema or request it; do not pretend to have analyzed a workbook you have not received.
Confirm the version, platform, language and separators before suggesting advanced functions. If they are missing, first provide the table structure and ask; do not assume compatibility.
TASK-SPECIFIC DELIVERABLES
1. Budget and transaction table kept separate from calculations
2. Absolute and percentage difference formulas handling a zero budget
3. Monthly summary distinguishing expenses, income and missing data
HOW TO BUILD AND CHECK IT
Define worksheets, tables, columns and keys. Separate inputs, parameters and calculations. Preserve the original source and identify cells to be filled in.
Provide ready-to-copy formulas only when you know the configuration; state the destination cell or column, references and how to extend them. Distinguish functions by version and offer a compatible alternative when needed.
Use function names for the specified Excel language even if the response is written in another language. Do not translate existing worksheet or column names without adjusting all references.
Do not invent functions, menus, data or execution results. Explain each calculation’s limits and distinguish zero, blank, error and missing data.
Include five fictional rows and test cases with expected results, such as blanks, duplicates and boundaries. Use only cases relevant to the task.
Suggest reversible changes. Do not delete rows, enable macros, send emails or connect external services unless explicitly requested.
If you have a tool that creates .xlsx files, provide a copy with formulas and checks; otherwise provide tables and steps to build it. Do not claim to have created, opened or tested a file unless you have.
Finish with a short checklist for formulas, units, references and totals, and a concrete next step.
View original prompt
Act as an Excel assistant. Design a spreadsheet for the stated task using the supplied data.
TASK: Monthly budget with variances in Excel
REQUIRED DATA
Excel version and platform: [VERSION AND PLATFORM]
Language of functions: [LANGUAGE OF EXCEL FUNCTIONS]
Argument and decimal separators: [SEPARATORS]
Example of the date format used: [DATE FORMAT]
Level of experience: [LEVEL OF EXPERIENCE]
Fictional or anonymized headers and rows: [STRUCTURE AND SAMPLE]
Specific conditions of the task: [TASK DATA]
Required details: Budget by category, anonymized transactions, period and sign convention.
BEFORE ANSWERING
If essential information is missing, ask up to three specific questions. If no file is provided, use the supplied schema or request it; do not pretend to have analyzed a workbook you have not received.
Confirm the version, platform, language and separators before suggesting advanced functions. If they are missing, first provide the table structure and ask; do not assume compatibility.
TASK-SPECIFIC DELIVERABLES
1. Budget and transaction table kept separate from calculations
2. Absolute and percentage difference formulas handling a zero budget
3. Monthly summary distinguishing expenses, income and missing data
HOW TO BUILD AND CHECK IT
Define worksheets, tables, columns and keys. Separate inputs, parameters and calculations. Preserve the original source and identify cells to be filled in.
Provide ready-to-copy formulas only when you know the configuration; state the destination cell or column, references and how to extend them. Distinguish functions by version and offer a compatible alternative when needed.
Use function names for the specified Excel language even if the response is written in another language. Do not translate existing worksheet or column names without adjusting all references.
Do not invent functions, menus, data or execution results. Explain each calculation’s limits and distinguish zero, blank, error and missing data.
Include five fictional rows and test cases with expected results, such as blanks, duplicates and boundaries. Use only cases relevant to the task.
Suggest reversible changes. Do not delete rows, enable macros, send emails or connect external services unless explicitly requested.
If you have a tool that creates .xlsx files, provide a copy with formulas and checks; otherwise provide tables and steps to build it. Do not claim to have created, opened or tested a file unless you have.
Finish with a short checklist for formulas, units, references and totals, and a concrete next step.

Your answers are used only here: they are not saved to your account or sent to an AI. Preparing a prompt does not use Raven AI queries.

What it helps you do

Compare a budget with actual movements by category and month.

Context: Excel

Where to use it

An AI tool for text or analysis. Check calculations and decisions with the appropriate professionals.

Recommended AI tools

For writing, plans or instructions

Gemini↗Claude↗ChatGPT↗

Available features depend on each tool’s plan and account.

What information to provide

  • Excel version, platform and language
  • Separators and date format
  • Columns and fictional or anonymised rows

The full prompt specifies the information and fields you need to fill in.

What to expect

Budget and transaction structure with variances and a monthly summary.

What to check in the result

Confirm Excel version, language and separators before copying formulas.

See an example of guidance

Presupuesto ilustrativo: separar ingresos, gastos fijos y variables; marcar los datos que faltan y comprobar cada suma antes de decidir.

Ejemplo ilustrativo de formato; no es un resultado generado con este prompt. The answer depends on your data and the tool used.

How to use it

  1. Fill in your details in “Prepare your prompt” once you have access.
  2. Copy the prepared prompt or use the original if you prefer to edit it yourself.
  3. Paste it into a compatible tool and review the answer.

Free prompt

Report a problem

Is something unclear or not working? Tell us what happened so we can review it.

Avoid personal data, passwords and full prompt text. Your message is private to the team.

RavenPrompts uses your account data and this message to handle the reported issue. Data controller, data processing and your rights: Privacy Policy.

#Budget#Expense tracking#Finance

RAVENPROMPTS

Find more prompts for better results.

Explore our library of prompts to create, sell, learn and work better with artificial intelligence.

Explore bank of prompts →
RavenPrompts

Prompts to create, learn and work better with artificial intelligence.

Find your next great prompt.

Follow us

  • Instagram
  • X
  • YouTube

Explore

  • Home
  • Prompt library
  • Blog
  • Free prompts
  • New prompts
  • Suggest a prompt
  • All categories
  • My favorites

Categories

  • Marketing
  • Social media
  • Productivity
  • Programming
  • Education
  • Photography and image
  • Travel

RavenPrompts PRO

  • Plans and pricing
  • My account and purchases

Help and contact

  • Frequently asked questions
  • Contact us
  • Purchase terms
  • Legal notice
  • Privacy
  • Cookie policy

© 2026 RavenPrompts. All rights reserved.

Made to take your ideas further.

Your cookies, your choice

We use necessary cookies for access, security and remembering preferences. You can allow speed measurement and visitor analytics separately. We do not use advertising cookies or cross-site tracking. You can also allow Metricool visitor measurement separately. Cookie policy

Cookie settings

Each optional measurement requires your permission. Earlier choices do not authorise the new visitor analytics. You can withdraw either permission at any time. Metricool is off by default. Your earlier Vercel permissions do not enable it.

They allow sign-in, protect forms and save your choices. Your language is remembered when you select it.

Always active

With your permission, Vercel Speed Insights measures loading, responsiveness and visual stability on some public pages. It does not collect prompts you enter or form contents.

Optional · off by default

With your permission, standard Vercel Web Analytics counts visits to public pages and provides aggregate device, browser and country statistics. We do not send searches, forms or prompts.

Optional · off by default

With your permission, Metricool counts visits to public routes and estimates the country from the IP address. We send no searches, forms, prompts or referring pages.

Optional · off by default

We do not use cookies or pixels to personalise ads or track your activity across sites.

Not currently used

We remember this choice for one year in this browser. You can change it at any time using the cookie button or the footer.

Cookie policy
Prompt library
Home
Prompt library
Blog
Free prompts
New prompts
Suggest a prompt
All categories
My favorites
Marketing
Social media
Productivity
Programming
Education
Photography and image
Travel
Plans and pricing
My account and purchases
Frequently asked questions
Contact us
Purchase terms