Search: "Excel formulas"

#email marketing #A/B testing #subject lines

marketing Intermediate

Email Marketing A/B Testing: Subject Line Optimization Guide

Help me design and run effective A/B tests for my email marketing campaigns. I n...

#writing #linkedin #thought-leadership

writing intermediate

LinkedIn Thought Leadership Post Writing Framework and Templates

Create a complete LinkedIn thought leadership content system for executives and ...

#charts #data-visualization #visual-storytelling

excel beginner

Excel Chart Types Selection & Visual Storytelling Guide

Help me choose the right Excel chart type and tell a compelling data story. I ha...

#pivot table #sales analysis #monthly report

Excel Pivot Table Report for Monthly Sales Analysis

Design a step-by-step guide for creating an Excel pivot table report to analyze ...

#data cleaning #CSV #pandas

data Intermediate

Data Cleaning Checklist for Messy CSV and Excel Datasets

Create a systematic data cleaning checklist and workflow for a messy dataset in ...

#SaaS metrics #financial model #unit economics

finance Advanced

Financial Model Template for SaaS Business Unit Economics

Build a financial model framework for a SaaS business covering unit economics an...

#xlookup #excel formulas #index match

Excel XLOOKUP Multi-Criteria Lookup Replacing INDEX-MATCH

Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...

#excel #conditional formatting #dashboard

Excel Conditional Formatting Heatmap Project Status Dashboard

You are an Excel dashboard designer. Build a conditional-formatting heatmap for ...

#net-worth #personal-finance #balance-sheet

finance Beginner

Personal Net Worth Statement Template

Act as a personal finance planner. Build me a structured net worth statement tem...

#concept-map #study #visualization

education Beginner

Concept Map Builder for Difficult Topic

Act as a learning coach. Help me build a concept map for [TOPIC]. Produce: (1) t...

#ab-test #power-analysis #experimentation

data Advanced

A/B Test Power Analysis Pre-Launch Check

Act as an experimentation statistician. Before launching an A/B test on [METRIC]...

ChatGPT Prompt: Excel Macro VBA Generator for Repetitive Data Cleanup Tasks

You are a VBA developer. I want a macro that automates a repetitive cleanup task...

#excel #vba #macro

#excel #data-validation #dropdown

ChatGPT Prompt: Excel Data Validation Drop-Down with Dependent Lists

You are an Excel expert. Build me a cascading drop-down where the second list de...

#pivot tables #excel #data analysis

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

#excel #power query #m code

Power Query M Code Generator for Repeatable Data Transformation

Act as a Power Query (M language) developer. I will describe a messy raw export ...

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl

#excel #conditional-formatting #accounts-receivable

excel Beginner

Excel Conditional Formatting Rule to Highlight Aging Invoices

Help me build a conditional formatting rule for an invoices sheet so each row hi...

#finance #financial-model #saas

finance Advanced

Three-Statement Financial Model for a Bootstrap SaaS Startup

Build a 36-month, monthly three-statement financial model (P&L, cash flow, balan...

Build Dynamic Dashboard With Slicers and Pivot Charts

Act as an Excel dashboard designer. I have a dataset of {{describe data: e.g., m...

#excel #dashboard #pivot

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

#finance #modeling #three-statement

finance Advanced

Build a Three-Statement Model Skeleton From Scratch

Act as an FP&A senior. Sketch the structure of a three-statement model (Income S...

#excel #dashboard #charts

Professional Dashboard with Charts

Create instructions for building a professional Excel dashboard with these chart...

👁 6 views