Search: "conditional sum"

#budget analysis #variance #financial template

Excel Budget vs Actual Variance Analysis Template

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

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

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

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

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 #dashboard #slicer

Excel Dashboard with Slicers and Conditional Formatting

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

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

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

#excel #cohort #retention

Build a Cohort Retention Heatmap in Excel

I have customer signup and activity data in Excel. Help me build a monthly cohor...

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

Excel Beginner

Budget Tracker Spreadsheet

Create a budget tracker Excel structure with: income categories, expense categor...

#Excel #budget #finance

#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 #conditional-formatting #kpi

Excel Conditional Formatting Rules for KPI Dashboard Indicators

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

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

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

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

#finance #budget #variance-analysis

finance intermediate

Business Budget Variance Analysis Template Monthly Reporting

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

#pivot-table #yoy #analysis

excel Intermediate

Pivot Table Refactor for Year-over-Year Analysis

Act as a financial analyst. Help me build a pivot table from [DATA RANGE] (colum...

#budget #variance #reporting

Excel Budget Variance Report with Conditional Logic

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