6 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.
You’ll split time between meetings, desk work and community contact. Mornings often start with checking Microsoft Outlook for council emails and scheduling, then reviewing spreadsheets in Microsoft Excel for budget or project updates.
Afternoons can be public meetings or site visits with residents and community groups, plus time entering notes into a CRM system and updating policy drafts in Microsoft Word. Expect interruptions—urgent contract queries or a sudden budget reallocation can change the plan fast.
The main tools are Microsoft Outlook for email/calendar and Microsoft Word for policy drafts and reports. Microsoft Excel is used daily for budgets, data tables and simple analysis.
You’ll also use financial management software to run budgets and payments, plus a CRM system to log resident contacts and casework. Knowing those five systems covers most of the technical work you’ll do.
Roughly half is paperwork and numbers: preparing budgets, running Excel models, checking entries in financial management software and producing reports for meetings. Accurate numbers matter because councils publish budgets and audits.
The other half is meetings—community groups, contractors and internal teams—where you explain decisions, gather views and follow up in the CRM system. The balance shifts during budget season or a big local project.
Yes, but be careful. Use AI to draft or summarize text, then check everything against local law and council policy. Never paste personal data from residents into an external AI without permission—use your CRM and internal systems instead.
Treat AI as a first draft tool. Final documents must be edited in Microsoft Word, verified for accuracy, and approved by a manager before sharing. Keep records of changes in your document history.
Relevant courses: public administration, local government studies, or qualifications in public finance (CIPFA in the UK or equivalent). Short certificates in contract management or project management (PRINCE2 Foundation) are useful.
Also learn Excel well (pivot tables, VLOOKUP/XLOOKUP) and CRM basics. Practical experience—volunteering with local groups or internship in a council office—matters as much as certificates.
Practical Excel skills (pivot tables, basic formulas), clear writing in Microsoft Word, and confident use of your council’s CRM and financial management software are essential—these tools run the job.
You also need plain-speaking communication for residents and contractors, and the ability to switch from detail (budget figures) to big-picture strategy quickly. Project coordination and basic contract knowledge matter more than advanced technical degrees.