Search: "Excel analysis"

SWOT to OKR Translation Workshop

Given a SWOT analysis (Strengths, Weaknesses, Opportunities, Threats), translate...

#business #swot #okr

#hr #exit-interview #employee-experience

hr Intermediate

Exit Interview Question Set with Theme Coding

Generate a 12-question exit interview set covering: reasons for leaving, manager...

#reconciliation #matching #accounting

Excel: Reconcile Two Lists That Should Match But Don't

I have two lists — one from our accounting system, one from the bank — that shou...

#excel #pivot-tables #reporting

excel Beginner

Excel: Build a Pivot Table That Answers the Question Your Boss Actually Asked

I have a dataset and a vague question from leadership. Help me design a pivot ta...

#excel #charts #visualization

excel Beginner

Pick the chart that tells the story instead of the chart that's easy to make

I have a dataset and I'm about to default to a bar chart because that's what Exc...

#data #cleaning #preprocessing

Clean a messy dataset without losing the rows that actually mattered

I have a dataset with [N] rows and [LIST PROBLEMS: missing values, duplicates, m...

#business #growth #funnel-analysis

Audit my growth funnel for the leak that's actually costing the most

My team has a list of 'growth ideas' a mile long, but I suspect we're working on...

#gantt #project-tracker #dashboard

Create a Self-Updating Excel Project Tracker with Gantt View

Act as a project management consultant. Build me a self-updating Excel project t...

Sanity-check a dataset in 30 minutes before you build anything on top of it

I just got handed a dataset I'm going to use for [analysis / model / dashboard]....

#data #sanity-check #eda

#formulas #validation #helper-column

Build a formula that flags rows where two columns disagree

Act as an Excel expert. I have a spreadsheet where two columns should always agr...

#excel #data cleaning #power query

excel intermediate

Clean Messy Excel Data Step by Step

Act as a data cleaning specialist. My Excel sheet has these issues: [list proble...

#business #swot #analysis

business beginner

Conduct a SWOT Analysis

Act as a business strategist. Perform a detailed SWOT analysis for [company or p...

#data #charts #visualization

Decide which chart actually fits my data and question

I'll describe my dataset and the question I'm trying to answer. Recommend the ri...

#excel #formulas #xlookup

Write a nested IF that a coworker can actually read

I need an Excel formula that assigns a grade band based on a score, with at leas...

#excel #sumifs #debugging

Diagnose why my SUMIFS is returning zero

My SUMIFS formula returns 0 even though I can see matching rows. Ask me to paste...

#business #strategy #swot

business Intermediate

Run a Quick SWOT Analysis

You are an expert business strategy consultant. Help me produce a focused SWOT a...

#finance #ratios #analysis

finance Intermediate

Explain Key Financial Ratios for a Business

You are an expert financial analyst. Help me understand and compute the financia...

#excel #debugging #errors

Audit and Fix Broken Excel Formulas

Act as a spreadsheet debugger. I'll paste a formula that returns an error or wro...

#data #analysis #insights

Interpret a Dataset and Surface Insights

You are a data analyst. I'll paste a summary table or describe a dataset: [PASTE...

#business #strategy #swot-analysis

Run a SWOT and Action Plan for My Idea

You are a pragmatic business strategist. I will describe a business, product, or...

#excel #data-validation #dropdown

Build a Dynamic Dropdown Validation Plan

You are an Excel data-validation specialist. I will describe the lists and rules...

#business #pre-mortem #risk

Run a Pre-Mortem on a Project Plan

You are a risk facilitator running a pre-mortem. I will describe a project I'm a...