Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel formulas"

303 prompts matching "excel formulas"

"excel formulas" ✕ Clear all ✕
excel advanced

Excel VBA Macro Automation for Repetitive Reports

Write a VBA macro for Excel that automates the following repetitive reporting ta...

#vba #macro #automation
👁 14 views
excel advanced

Excel Financial Model Three-Statement Integration

Build a three-statement financial model in Excel for [company type, e.g., a SaaS...

#financial-model #three-statement #excel
👁 14 views
excel advanced

Excel Scenario Manager and What-If Analysis Business Planning

You are a financial modeling expert using Excel. I need to build a what-if analy...

#excel #scenario-manager #what-if
👁 14 views
excel advanced

Excel Power Pivot Data Model for Cross-Table Business Analysis

Build a complete Excel Power Pivot data model for multi-table business analysis....

#excel #power-pivot #dax
👁 14 views
excel intermediate

Excel Conditional Formatting Rules for KPI Dashboard Indicators

Create a complete system of Excel conditional formatting rules to build a profes...

#excel #conditional-formatting #kpi
👁 14 views
excel beginner

Excel Formula Troubleshooter and Optimizer

I have an Excel formula that is not working correctly or returning unexpected re...

#excel #formula #debug
👁 14 views
excel intermediate

Excel Audit Trail & Change Tracking for Collaborative Workbooks

I need to set up audit trails and change tracking in Excel for a shared workbook...

#audit-trail #change-tracking #version-history
👁 14 views
data Intermediate

Data Dashboard Design Blueprint for Business KPI Reporting

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

#dashboard design #KPI #data visualization
👁 14 views
excel Intermediate

Excel Conditional Formatting Heatmap Project Status Dashboard

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

#excel #conditional formatting #dashboard
👁 14 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
data Advanced

A/B Test Power Analysis Pre-Launch Check

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

#ab-test #power-analysis #experimentation
👁 14 views
excel Intermediate

Convert Messy Text Column Into Clean Structured Fields

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

#excel #text-functions #parsing
👁 14 views
excel Advanced

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

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

#excel #shift schedule #data validation
👁 13 views
data Intermediate

Google Sheets Dashboard with Automated Data Import

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

#data #Google Sheets #dashboard
👁 13 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
👁 13 views
excel Intermediate

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

#excel list reconciliation #duplicate matching #near match cleanup
👁 13 views
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 ...

#chatgpt prompt for excel planner #capacity planning #workload tracker
👁 13 views
excel Intermediate

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

#excel #cash flow #forecast
👁 13 views
excel Advanced

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

#scenario model #financial modeling #excel planning
👁 13 views
Excel Intermediate

Excel Formula Generator

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

#Excel #formulas #automation
👁 13 views
excel intermediate

Excel Dynamic Array FILTER SORT UNIQUE Formula Guide

Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...

#dynamic array #FILTER #SORT
👁 13 views
excel intermediate

Excel Pivot Table Design for Management Reporting

You are an Excel reporting expert. I need to build a professional pivot table re...

#excel #pivot-table #reporting
👁 13 views
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...

#data #looker-studio #dashboard
👁 13 views
data intermediate

Power BI Dashboard Design: Sales Performance Metrics

Act as a Power BI specialist and data visualization expert. Help me design a sal...

#data #power-bi #dashboard
👁 13 views
excel Intermediate

Excel Gantt Chart: Project Timeline and Milestone Tracker

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

#Gantt chart #project management #Excel timeline
👁 13 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval