SETTING UP EXCEL SPREADSHEET #
This is a sample Excel sheet for a campaign budget against online child sexual exploitation. This example will use SUM, equations, and Excel functions to create a budget. Please note that this is a simplified example, and you should customize it to your specific campaign’s needs.
You can follow these steps:
Step 1: Set up your Excel spreadsheet
1. Open Excel and create a new workbook.
2. Rename the first sheet as “Campaign Budget.”
3. Create the following column headers in the first row: “Expense Category,” “Description,” “Amount (Monthly),” “Amount (Annual),” “Funding Source,” “Notes.”
Step 2: List your expense categories
In Column A (“Expense Category”), list all the categories for your campaign expenses. Here’s a sample list:
- Personnel
- Training and Education
- Awareness Campaigns
- Technology and Software
- Legal Support
- Miscellaneous
Step 3: Enter expense details
For each expense category, fill in the “Description,” “Amount (Monthly),” “Amount (Annual),” “Funding Source,” and “Notes” columns with relevant information. For example:
- Personnel: Project Manager Salary, $4,000, $48,000, Grant A, –
- Training and Education: Workshop Costs, $2,500, $30,000, Grant B, –
- Awareness Campaigns: Social Media Ads, $1,000, $12,000, Donations, –
- Technology and Software: Monitoring Tools, $500, $6,000, Grant A, –
- Legal Support: Legal Consultation, $3,600, $43,200, Grant C, –
- Miscellaneous: Travel Expenses, $800, $9,600, Donations, –
Step 4: Calculate annual totals
In Column D (“Amount (Annual)”), you can use a formula to calculate the annual cost based on the monthly cost. In cell D2, for example (Amount (Annual) for Personnel):`=C2*12`
This formula multiplies the monthly cost (in cell C2) by 12 to calculate the annual cost.
Step 5: Calculate the total budget
At the bottom of the “Amount (Monthly)” and “Amount (Annual)” columns, use the SUM function to calculate the total monthly and annual budgets for the entire campaign:
– In cell C8 (Total Monthly Budget): `=SUM(C2:C7)`
– In cell D8 (Total Annual Budget): `=SUM(D2:D7)`
Here’s a simplified sample Excel sheet for your campaign budget:
Sample Campaign Budget Excel Sheet.
Expense Category | Description | Amount (Monthly) | Amount (Annual) | Funding Source | Notes |
Personnel | Project Manager Salary | $4,000 | $48,000 | Grant A | |
Training and Education | Workshop Costs | $2,500 | $30,000 | Grant B | |
Awareness Campaigns | Social Media Ads | $1,000 | $12,000 | Donations | |
Technology and Software | Monitoring Tools | $500 | $6,000 | Grant A | |
Legal Support | Legal Consultation | $3,600 | $43,200 | Grant C | |
Miscellaneous | Travel Expense | $800 | $9,600 | Donations | |
Total | $12,400 | $148,800 |

Step 6: Create a summary table
You can create a summary table to display the total budget, total funding, and the funding gap.
– Total Budget: In cell E2, link to the Total Annual Budget value from D8: `=D8` – Total Funding: In cell E3, sum up the funding sources. If you list funding sources in Column E (F2:F7), use: `=SUM(F2:F7)`
– Funding Gap: In cell E4, calculate the difference between the Total Budget and Total Funding: `=E2-E3`



I’ll provide you with a simplified template for a campaign budget spreadsheet that you can use as a starting point. You can then collaborate with team members by adding comments and making revisions as needed. ` `
Campaign Budget Spreadsheet | |||
Category | Description | Amount(USD) | Comments/Revisions |
Personnal | Campaign Manager | $(Amount) | (Comments) |
Content creator | $(Amount) | (Comments) | |
Social Media Manager | $(Amount) | (Comments) | |
Webinar/Workshop Facilitaor | $(Amount) | (Comments) | |
Promotion | Facebook Ad | $(Amount) | (Comments) |
Print Materials | $(Amount) | (Comments) | |
Promotional Events | $(Amount) | (Comments) | |
Technology | Website Development | $(Amount) | (Comments) |
Social Media Tools | $(Amount) | (Comments) | |
Reporting software | $(Amount) | (Comments) | |
Outreach & Collaboration | Guest speakers | $(Amount) | (Comments) |
Partnership/ Influencers | $(Amount) | (Comments) | |
Miscellaneous | Travel Expense | $(Amount) | (Comments) |
Contigency | $(Amount) | (Comments) |
Please replace “[Amount]” with the actual budget figures and “[Comments]” with any feedback or revisions from your team members. You can share this spreadsheet with your team using a cloud-based platform like Google Sheets or Microsoft Excel Online, which allows multiple users to collaborate in real-time, add comments, and make edits as necessary.
HOME ASSIGNMENT #
Share spreadsheet and use edit and comments to add feedback and revisions between your team