Search: "Excel analysis"

#excel #formulas #commission

Build a Nested IF Formula for Tiered Commission

You are an expert Excel formula engineer. Help me write and explain a single Exc...

#excel #lambda #automation

excel Advanced

Write a Reusable LAMBDA Function

You are an expert Excel 365 power user. Help me turn a repetitive calculation in...

#business #strategy #swot

business Intermediate

Run a Quick SWOT Analysis

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

#coding #algorithms #optimization

coding Advanced

Explain and Optimize an Algorithm

You are an expert algorithms tutor. Help me understand my algorithm's complexity...

marketing Intermediate

Plan SEO Content Around a Keyword

You are an expert SEO content strategist. Help me plan content that can actually...

#marketing #seo #content

#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 #dashboard #pivottable

Build a Dynamic Excel Dashboard Summary

Act as an Excel analyst. I will paste a table of raw data with these columns: [L...

#excel #pivot-table #reporting

Design a Pivot Table Reporting Plan

You are an Excel reporting consultant. Based on the dataset I describe, design t...

#business #strategy #swot-analysis

business Advanced

Run a SWOT and Action Plan for My Idea

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

#excel #performance #optimization

excel Advanced

Diagnose a Slow Excel Workbook

You are an Excel performance consultant. I will describe my workbook's symptoms ...

#excel #reconciliation #vlookup

excel Beginner

Reconcile Two Excel Lists for Differences

You are an Excel reconciliation helper. I have two lists (for example, a system ...

#business #pre-mortem #risk

business Advanced

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...

#data #data-cleaning #quality

data Intermediate

Write a Data Cleaning Checklist

You are a data-quality analyst. Based on the dataset I describe, produce a thoro...

#finance #financial-statements #analysis

finance Advanced

Explain a Financial Statement

You are a financial analyst. I will share figures from a financial statement and...

#pivot-table #debugging #totals

Diagnose Why a Pivot Table Is Showing the Wrong Totals

Help me diagnose why my Excel pivot table is showing wrong totals. Source data r...

#reconciliation #budget #fuzzy-match

Reconcile two versions of a budget when the row labels don't match

You are an Excel modeler. I'll paste two budget extracts from different teams. T...

#scenarios #modeling #choose

excel Advanced

Build a flexible scenario model without nesting IF statements ten layers deep

Act as a financial modeler reviewing my workbook. I have a model that runs base/...

#debugging #audit #trace-precedents

Find which formula in a 12-tab workbook is wrong without checking every cell

You're an Excel auditor. A summary total on my Dashboard tab is off by $4,200 fr...

#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...

#power-query #data-cleaning #pivot

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

#xlookup #index-match #robust

Write a lookup that survives someone reordering the columns

Act as an Excel expert. My VLOOKUPs keep breaking because colleagues insert and ...

#excel #formulas #automation

excel beginner

Write Excel Formulas from Plain English

Act as an Excel formula assistant. I will describe what I want to calculate in p...

#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...