Search: "Excel report"

#excel #forecasting #revenue

Forecast Monthly Revenue With Excel's FORECAST.ETS

I have 36 months of revenue data (column A: month-end dates, column B: revenue)....

#template #data-validation #conditional-formatting

Build a Reusable Excel Template With Input Validation Built In

Help me design a reusable Excel template for [USE CASE: e.g. expense report, pro...

#sensitivity #what-if #modeling

Excel: Two-Way Sensitivity Table Without the Data Table Feature

Excel's built-in Data Table feature recalculates the whole workbook and freezes ...

#excel #sensitivity-analysis #data-table

Build a sensitivity table that stress-tests three assumptions at once

Act as a financial modeling instructor. Walk me through building a two-input dat...

#excel #cash flow #forecast

Build a Rolling 12-Month Cash Flow Forecast in Excel

You are an Excel financial modeling expert. Help me build a rolling 12-month cas...

#data validation #dropdown lists #dependent dropdowns

Excel Data Validation and Dropdown Lists

Teach me how to create advanced data validation and dependent dropdown lists in ...

#CI/CD #GitHub Actions #deployment

coding Advanced

CI/CD Pipeline Configuration with GitHub Actions

Create a complete CI/CD pipeline using GitHub Actions for my project: - Project...

#excel #pivot-table #sales

excel intermediate

Excel Pivot Table Sales Trend Analysis

I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...

#excel #vlookup #index-match

excel beginner

VLOOKUP vs INDEX-MATCH: Smart Data Lookup Formulas

I need to retrieve data from a lookup table in Excel. My main table has [column ...

Excel Macro to Automate Monthly Report

Write a VBA macro for Excel that automates my monthly reporting process. The mac...

#excel #vba #macro

#Power BI #DAX #dashboard

data advanced

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...

#kpi #scorecard #dashboard

excel intermediate

Excel Dashboard KPI Scorecard with Traffic Lights

Design an Excel KPI scorecard dashboard for [department] with: 1) KPI table with...

#meeting agenda #meeting facilitation #team meetings

productivity beginner

Meeting Agenda Design: Effective Structured Meeting Template

Help me design meeting agenda templates for these common meeting types at my com...

#power query #excel #data combine

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

customer-service Intermediate

ChatGPT Prompt: Bug Report Acknowledgment That Builds Trust

You are a customer-facing engineer. Write a reply to a customer who has just rep...

#customer-service #support #bug-report

#pivot tables #excel #data analysis

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

#finance #cash-flow #forecasting

finance Advanced

Build a 13-Week Cash Flow Forecast With Scenario Toggles

Walk me through building a 13-week cash flow forecast for a small business. Outp...

#excel #scenarios #data tables

Create a What-If Scenario Comparison Table With Data Tables

I have a financial model with three driver inputs (cells B2: pricing, B3: churn,...

#hr #compensation #fairness

hr Advanced

Run a Compensation Review That Doesn't Just Reward Negotiation

Help me design a comp review process that fixes the common failure mode — the lo...

#excel #goal-seek #solver

Excel Goal Seek Alternative for Multi-Variable What-Ifs

I have an Excel model where multiple inputs affect one output and Goal Seek only...

#excel #capacity-planning #modeling

Excel: Build a Capacity Model That Doesn't Pretend Everyone Works 40 Hours

I'm modeling team capacity in Excel for the next quarter: [TEAM, ROLES, HOLIDAYS...

#excel #pivot tables #reporting

Turn a messy operational export into a pivot table that someone will actually read

I have an operational export with [N] rows and columns like [DATE, REGION, PRODU...

Write a VBA macro that does one boring task perfectly instead of ten things badly

I want to automate a small, repetitive Excel task with VBA. The task is: [DESCRI...

#excel #vba #macro