AI Prompt & Content Creation

I have a two-part assignment that calls for a creative technologist who is equally comfortable crafting world-class AI prompts and turning the resulting output into polished, ready-to-publish content.

1) AI Prompt Engineering
I will share the goal, target audience, and tone for each piece. Your job is to design, iterate, and document reusable prompts that reliably deliver on those requirements in tools such as ChatGPT or Claude. I want to see the rationale behind each prompt and a brief note on how you refined it.

2) AI Content Creation
Using the approved prompts, produce the actual content—blog articles, social captions, short reports, or email sequences—tailored to the brief. Clarity, originality, and correct formatting are essential.

Microsoft Excel link
Although the core of the work is AI-driven, I occasionally need to pull the generated data into Excel, run quick analyses, and assemble summary tables or visualisations. If you can automate that hand-off (for example with Power Query, Office Scripts, or a simple VBA macro that cleans and structures the AI output), please highlight it—this will be a plus.

Deliverables
• Prompt library with version notes
• Final content files (DOCX or Google Docs)
• Optional Excel automation script, if offered

Acceptance criteria will be prompt reliability (same inputs produce consistent quality), content meeting the brief in tone and length, and error-free formatting.

If this sounds like your skill set, tell me about one recent project where you combined prompt engineering with content production, and mention any Excel automation you implemented.