Search: "conditional sum"

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 #pivot-table #reporting

Excel Pivot Table Design for Management Reporting

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

#ETL #data warehouse #data pipeline

data Advanced

ETL Pipeline Design: Best Practices for Data Warehouse Architecture

Help me design a production-grade ETL (Extract, Transform, Load) pipeline for a ...

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

#SQL #window functions #analytics

data advanced

SQL Window Functions Advanced Analytics Queries

Teach me SQL window functions with practical business analytics examples. Cover:...

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

#excel #conditional-formatting #kpi

Excel Conditional Formatting Rules for KPI Dashboard Indicators

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

#finance #budget #variance-analysis

finance intermediate

Business Budget Variance Analysis Template Monthly Reporting

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

#excel inventory tracker #reorder point #stock management

excel Intermediate

ChatGPT prompt for Excel inventory reorder tracker with lead times

Act as an Excel operations specialist. I need an inventory reorder tracker for a...

#business #proposal #client

business Intermediate

ChatGPT prompt for writing a business proposal for a potential client

Act as a business development consultant who writes winning proposals. Draft a ...

#finance #investment #memo

finance advanced

Investment Memo for Opportunity Evaluation

Write an investment memo evaluating [investment opportunity — startup, real esta...

#budget analysis #variance #financial template

Excel Budget vs Actual Variance Analysis Template

Create a complete Excel budget vs. actual variance analysis template for [depart...

#excel #dashboard #slicer

Excel Dashboard with Slicers and Conditional Formatting

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

#data #power-bi #dashboard

data intermediate

Power BI Dashboard Design: Sales Performance Metrics

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

#pivot table #grouping #calculated fields

Excel Pivot Table: Advanced Grouping and Summarization Techniques

I have a dataset in Excel with the following columns: [list your columns, e.g., ...

#SQL #GROUP BY #window functions

data intermediate

SQL Advanced Queries: GROUP BY, HAVING, and Window Functions

Help me write advanced SQL queries for [database: PostgreSQL/MySQL/BigQuery/SQL ...

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

#pivot table #sales analysis #excel

excel Intermediate

Build Dynamic Pivot Table from Sales Data

Act as an Excel data analyst. I have a sales dataset with columns: [Date, Region...

#invoice #VBA #automation

Invoice Generator with Auto-Numbering VBA

Create an Excel invoice generator with automatic invoice numbering using VBA. B...

👁 10 views