Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "Excel report"

385 prompts matching "Excel report"

"Excel report" ✕ Clear all ✕
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...

#pivot-table #yoy #analysis
👁 19 views
excel Intermediate

Pivot Table Mastery for Multi-Year Sales Data Analysis

Act as an Excel data analyst. I will paste a sales dataset with columns Date, Re...

#excel #pivot table #sales analysis
👁 19 views
excel Advanced

Excel VBA Macro to Email Each Manager Their Filtered Sheet

Write a VBA macro that splits the Master sheet by [Manager Name], saves each man...

#excel #vba #outlook
👁 19 views
excel Intermediate

Excel Pivot Table Calculated Field for Margin Percentage by Segment

I have a sales table with columns: order_id, date, customer_segment, product, re...

#excel #pivot-table #calculated-field
👁 19 views
excel Intermediate

Build a Loan Amortization Schedule in Excel

Act as a financial analyst. Create a step-by-step Excel guide to build a loan am...

#excel #amortization #financial modeling
👁 19 views
excel Advanced

Excel VBA Macro to Auto-Format Monthly Reports

Write a VBA macro that, when run, formats the active sheet as a monthly report: ...

#excel #vba #macros
👁 19 views
excel Intermediate

Excel Dashboard with Dynamic Slicers

Help me design a single-page Excel dashboard for KPIs (revenue, orders, conversi...

#excel #dashboard #slicers
👁 19 views
excel Intermediate

Build a Sales Pipeline Velocity Tracker in Excel

Act as an Excel expert. I want a single-sheet pipeline velocity tracker. My deal...

#excel #sales #pipeline
👁 19 views
excel Intermediate

Excel Project Gantt Chart from Task List

Generate an Excel Gantt chart from a task list with columns Task, Start Date, Du...

#excel #gantt #project-management
👁 19 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Intermediate

Reconcile two Excel sheets that almost match but disagree on a few rows

You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...

#excel #reconciliation #xlookup
👁 19 views
excel Intermediate

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

#excel #power-query #unpivot
👁 19 views
excel Advanced

Auto-Format New Data VBA

Write a VBA macro that automatically formats any new data pasted into an Excel s...

#excel #VBA #macro
👁 18 views
excel advanced

Excel XLOOKUP Multi-Condition: Advanced Lookup Formulas Guide

I need to look up values in Excel using multiple conditions. My dataset has colu...

#XLOOKUP #INDEX MATCH #multi-criteria lookup
👁 18 views
data intermediate

Data Cleaning Strategy and Python Script Generator

Help me clean and prepare a messy dataset for analysis. Dataset details: Data s...

#data #cleaning #python
👁 18 views
customer-service intermediate

Voice of Customer (VoC) Analysis: Survey Design & Insight Framework

Build a Voice of Customer (VoC) program for my business. Context: Business type...

#voice-of-customer #voc #customer-feedback
👁 18 views
excel Advanced

Excel VBA Macro to Automate Repetitive Report Formatting

Write an Excel VBA macro that automates the formatting of a weekly report I rece...

#VBA #macro #automation
👁 18 views
excel Beginner

ChatGPT Prompt: Excel SUMIFS Formula Builder for Multi-Condition Aggregation

You are an Excel formula expert. I need to build a SUMIFS formula that totals va...

#excel #sumifs #formulas
👁 18 views
excel Intermediate

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...

#excel formulas #dynamic arrays #dashboard
👁 18 views
hr Intermediate

ChatGPT Prompt: Exit Interview Script with Theme Analysis Framework

Create an exit interview process for [COMPANY] that produces actionable insights...

#exit interview #employee relations #hr analytics
👁 18 views
customer-service Advanced

ChatGPT Prompt: VOC Program Setup with NPS, CSAT, and CES Integration

Design a Voice of Customer (VOC) program that aggregates NPS, CSAT, and CES with...

#voc #nps #csat
👁 18 views
excel Intermediate

Excel Loan Amortization Schedule with Extra Payment Scenarios

Create an Excel amortization schedule for a fixed-rate loan with these inputs at...

#excel #loan #amortization
👁 18 views
excel Intermediate

Build a Dynamic Dashboard Using INDEX-MATCH and Slicers

Act as an Excel power user. I have a sales dataset with columns: Date, Region, P...

#excel #dashboard #index-match
👁 18 views
hr Advanced

Difficult Conversation Script for Performance Improvement

Help me prepare a difficult conversation with a direct report whose performance ...

#difficult conversation #performance #management
👁 18 views
excel Advanced

Forecast Sales with Excel FORECAST.ETS

I have monthly sales data in Excel for the last 3 years. Help me build a 12-mont...

#excel #forecast #ets
👁 18 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval