Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel-fix"

257 prompts matching "excel-fix"

"excel-fix" ✕ Clear all ✕
excel advanced

Excel Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl
👁 21 views
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
👁 21 views
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
👁 21 views
excel advanced

Excel Financial Modeling: Scenario Manager and Goal Seek Analysis

I'm building a financial model in Excel for [project/business type]. Help me set...

#scenario manager #goal seek #sensitivity analysis
👁 21 views
finance intermediate

Break-Even Analysis: Startup Product Calculation Template

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

#break-even analysis #financial modeling #startup finance
👁 21 views
data intermediate

Power BI Dashboard Design: Best Practices for Business Intelligence

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

#power-bi #dashboard #dax
👁 21 views
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
👁 21 views
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...

#excel #data-validation #dropdown
👁 21 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
👁 21 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Advanced

Excel Budget Variance Report with Conditional Logic

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

#budget #variance #reporting
👁 21 views
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
👁 21 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
👁 21 views
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...

#excel #working-capital #finance-model
👁 21 views
excel Advanced

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#power query #CSV import #data transformation
👁 20 views
excel Intermediate

Automated Invoice Tracker with XLOOKUP and Running Balance

Act as an Excel specialist. Build me an invoice tracking spreadsheet with these ...

#excel #invoice tracking #XLOOKUP
👁 20 views
Excel Beginner

Budget Tracker Spreadsheet

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

#Excel #budget #finance
👁 20 views
excel intermediate

Excel XLOOKUP Advanced Techniques Guide

You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....

#excel #xlookup #lookup
👁 20 views
excel Intermediate

Excel Dynamic Arrays: FILTER, SORT, and UNIQUE Functions Mastery

Help me master Excel dynamic array functions to replace my manual filtering and ...

#dynamic arrays #FILTER #SORT
👁 20 views
excel advanced

Excel Power Pivot Data Model for Cross-Table Business Analysis

Build a complete Excel Power Pivot data model for multi-table business analysis....

#excel #power-pivot #dax
👁 20 views
excel advanced

Excel LAMBDA Function Custom Formula Library Creation Guide

Design a library of reusable custom Excel functions using the LAMBDA function fo...

#excel #lambda #custom-functions
👁 20 views
excel beginner

Excel Formula Troubleshooter and Optimizer

I have an Excel formula that is not working correctly or returning unexpected re...

#excel #formula #debug
👁 20 views
excel Intermediate

Excel Pivot Table Report for Monthly Sales Analysis

Design a step-by-step guide for creating an Excel pivot table report to analyze ...

#pivot table #sales analysis #monthly report
👁 20 views
excel Intermediate

Excel XLOOKUP Formula Builder for Multi-Criteria Match

Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...

#xlookup #formulas #excel
👁 20 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
👁 20 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval