Search: "clean-code"

#excel #cash flow #dashboard

ChatGPT prompt for building a monthly Excel cash flow dashboard from messy exports

I want you to act as an Excel financial analyst. My goal: turn messy bank and e...

👁 22 views

#excel audit #formula debugging #reporting

ChatGPT Prompt for Excel Formula Audit on a Broken Reporting Sheet

Act as an expert Excel analyst. I have a reporting workbook that suddenly shows ...

👁 22 views

hr Intermediate

Employee Handbook Section: Remote Work Policy

Write a comprehensive remote work policy for our employee handbook: - Company t...

#remote work policy #employee handbook #hybrid work

👁 21 views

#excel #data cleaning #TRIM

Clean Messy Data Checklist

Give me a complete Excel data cleaning checklist with formulas for each step: 1)...

👁 20 views

productivity Advanced

Delegation Framework and Task Brief Template

Create a delegation system that helps me hand off work effectively. My role: [y...

#delegation #task management #leadership

👁 20 views

data intermediate

Python Pandas: Data Cleaning and Transformation Workflow

I have a dataset ([CSV/Excel/database] file) with the following issues: [describ...

#Python #pandas #data cleaning

👁 20 views

#excel #inventory #tracker

ChatGPT prompt for creating an Excel inventory tracker with automatic reorder alerts

Act as an Excel inventory management specialist. I need to build an inventory t...

👁 18 views

education Beginner

Study Guide and Practice Questions for Exam Prep

Create a comprehensive study guide and set of practice questions for [subject/ex...

#education #study guide #exam prep

👁 18 views

coding Beginner

ChatGPT prompt for turning bug reports into a developer-ready issue ticket

Act as a product manager preparing issues for engineering. I will give you a me...

#coding #bug report #issue ticket

👁 17 views

excel Advanced

ChatGPT prompt for Excel cash flow forecast from messy exports

You are an Excel analyst helping me build a 13-week cash flow forecast from mess...

#excel cash flow forecast #13 week cash flow #excel formulas

👁 17 views

writing Intermediate

ChatGPT prompt for writing an SOP from a screen recording transcript

You are a process documentation writer. I will paste a rough transcript from a s...

#write SOP from transcript #standard operating procedure #documentation prompt

👁 17 views

Text Manipulation Formulas

Show me essential Excel text formulas with examples: 1) Extract first name from ...

#excel #text #LEFT

#clean CRM export #sales data cleanup #pipeline analysis

data Intermediate

ChatGPT prompt for cleaning CRM export before sales analysis

Act as a sales operations analyst. I have a messy CRM export that I want to clea...

#budget variance report #excel finance analysis #accounting export cleanup

ChatGPT prompt for monthly budget variance report from exported accounting data

I need help turning exported accounting data into a monthly budget variance repo...

#webinar transcript to blog #content repurposing prompt #blog drafting from transcript

writing Intermediate

ChatGPT prompt for turning a rough webinar transcript into a publishable blog post

Act as a senior content editor. I need to turn a rough webinar transcript into a...

#shutdown routine prompt #end of day planning #unfinished tasks reset

productivity Beginner

ChatGPT prompt for end-of-day shutdown routine from open loops and unfinished tasks

Act as an executive assistant for my own workload. I need an end-of-day shutdown...

👁 14 views

data Intermediate

Pandas Cleanup Pipeline for a Messy Real-World CSV

Below is a sample of a messy CSV (10 rows shown). Build a pandas cleaning pipeli...

#data #pandas #csv

👁 14 views

#excel #text-functions #parsing

Convert Messy Text Column Into Clean Structured Fields

I have a single column in Excel containing messy entries like "{{example raw ent...

👁 14 views

excel Beginner

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

#excel #xlookup #index match

productivity Intermediate

ChatGPT prompt for designing SOPs from a process you currently do manually

Act as an operations consultant. I want to turn a messy manual process into a d...

#productivity #sop #operations

#productivity #meeting notes #action items

productivity Beginner

ChatGPT prompt for extracting action items from meeting notes with owners and deadlines

Act as a chief of staff helping me clean up meeting notes. I will paste rough m...

#chatgpt prompt for excel planner #capacity planning #workload tracker

excel Advanced

ChatGPT Prompt for Creating an Excel Capacity Planner for a Small Team

You are an Excel operations consultant. Build a practical team capacity planner ...

#writing #editing #concise

writing Intermediate

Tighten a Draft by Cutting Hedges, Filler Verbs, and Throat-Clearing

Edit the draft below for tightness. Three passes, each shown as a separate diff:...