Search: "formulas"

#dashboard design #KPI #data visualization

data Intermediate

Data Dashboard Design Blueprint for Business KPI Reporting

Design a KPI dashboard blueprint for [department: sales / operations / marketing...

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

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

#excel #shift schedule #data validation

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

Act as an Excel expert. Create a weekly employee shift schedule spreadsheet for ...

#data #Google Sheets #dashboard

data Intermediate

Google Sheets Dashboard with Automated Data Import

Act as a Google Sheets expert. Create a complete marketing dashboard in Google S...

#excel #xlookup #index match

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 list reconciliation #duplicate matching #near match cleanup

ChatGPT prompt for reconciling two Excel lists with duplicates and near matches

I need to reconcile two Excel lists that should overlap, but the data is messy. ...

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

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

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

#excel #cash flow #forecast

ChatGPT Prompt for Excel Monthly Cash Flow Forecast with Collections Delay

I need a monthly cash flow forecast in Excel for a business with uneven customer...

#scenario model #financial modeling #excel planning

ChatGPT Prompt for Excel Scenario Model Comparing Best Base and Worst Cases

Help me build an Excel scenario model that compares best case, base case, and wo...

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

Create Excel formulas for: [DESCRIBE TASK]. Include: the formula, explanation of...

excel intermediate

Excel XLOOKUP Advanced Techniques Guide

You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....

#excel #xlookup #lookup

#data #looker-studio #dashboard

data intermediate

Google Looker Studio Dashboard Design for Business Intelligence

You are a BI analyst and data visualization expert. I need to build a profession...

#Gantt chart #project management #Excel timeline

Excel Gantt Chart: Project Timeline and Milestone Tracker

I want to build a professional Gantt chart in Excel for project management witho...

#excel #data-validation #dropdown

excel intermediate

Excel Data Validation Dropdown Lists for Error-Free Data Entry

Create a comprehensive guide for implementing Excel data validation with dropdow...

#education #online-course #script-writing

education intermediate

Online Course Content Script Writing Template Engagement Framework

Write a complete guide for scripting engaging online course video lessons. Inclu...

#finance #budget #variance-analysis

finance intermediate

Business Budget Variance Analysis Template Monthly Reporting

Build a complete budget variance analysis system for business financial manageme...

#tiktok #content-strategy #viral-content

marketing intermediate

TikTok Content Strategy: Viral Hooks, Trends & Growth Playbook

Build a TikTok content strategy for my brand. Context: Brand/Business: [DESCRIB...

#excel #audit #performance

Audit a Workbook for Broken or Slow Formulas

You are an Excel auditing specialist. Walk me through a systematic audit of a wo...