Search: "excel-tables"

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

#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 #scheduling #shift planning

excel Beginner

ChatGPT Prompt for Excel Shift Schedule Conflict Checker

Help me build an Excel shift scheduling sheet that automatically flags staffing ...

#excel #dashboard #slicer

excel intermediate

Excel Dashboard with Slicers and Conditional Formatting

Act as an Excel dashboard designer. I want to build an interactive dashboard wit...

#excel #data-validation #dropdown

excel beginner

Excel Data Validation: Drop-down Lists and Input Controls

Act as an Excel data integrity specialist. I need to set up data validation with...

#data #quality #assessment

data intermediate

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

#Gantt chart #project management #Excel timeline

excel Intermediate

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

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

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

#npv #irr #investment analysis

finance Advanced

Investment Decision Analysis Using NPV and IRR

Analyze this investment opportunity using NPV and IRR: - Initial investment: [AM...

#fp&a #financial-modeling #drivers

finance Advanced

Build a Driver-Based Financial Model from Scratch

Act as a senior FP&A modeler. Walk me through building a driver-based financial ...

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

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

ChatGPT prompt for creating Excel macros to automate repetitive report formatting

Act as an Excel VBA developer who writes clean, maintainable macros. Create VBA...

#excel #vba #macros

excel advanced

Excel VBA Macro: Automate Repetitive Report Generation

Act as an Excel VBA expert. I need to automate a repetitive report generation ta...

#excel #vba #macro

excel intermediate

Excel SUMIF & COUNTIF: Advanced Multi-Criteria Formula Guide

Act as an Excel formula expert. I want to master SUMIF, SUMIFS, COUNTIF, and COU...

#excel #sumif #countif

#break-even analysis #financial modeling #startup finance

finance intermediate

Break-Even Analysis: Startup Product Calculation Template

Help me calculate and model the break-even analysis for [product/business type]....

#power-bi #dashboard #dax

data intermediate

Power BI Dashboard Design: Best Practices for Business Intelligence

Help me design an effective Power BI dashboard. My situation: Data source: [EXC...

#excel #data-validation #dropdown

excel Intermediate

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

#budget #variance #reporting

Excel Budget Variance Report with Conditional Logic

Build me a complete Excel budget vs actual variance report. I have monthly budge...

#cash flow #personal finance #budgeting

finance Intermediate

Personal Cash Flow Forecast for Next 12 Months

Build a 12-month personal cash flow forecast. Inputs: - Monthly net income: [AMO...

#excel #working-capital #finance-model

excel advanced

Build a working capital model from a P&L extract without manual joins

Act as a finance analyst. I will paste a monthly P&L extract plus a trial-balanc...