Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel-fix"

244 prompts matching "excel-fix"

"excel-fix" ✕ Clear all ✕
excel Intermediate

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

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

#pivot tables #excel #data analysis
👁 8 views
excel Advanced

Power Query M Code Generator for Repeatable Data Transformation

Act as a Power Query (M language) developer. I will describe a messy raw export ...

#excel #power query #m code
👁 8 views
excel Advanced

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl
👁 8 views
excel Advanced

Excel Inventory Reorder Alert with Lead Time and Safety Stock

Build an Excel reorder-alert sheet for a small warehouse. Inputs (one row per SK...

#excel #inventory #reorder-point
👁 8 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
👁 8 views
finance Intermediate

Personal Cash Flow Forecast for Next 12 Months

Build a 12-month personal cash flow forecast. Inputs: - Monthly net income: [AMO...

#cash flow #personal finance #budgeting
👁 8 views
excel Intermediate

Excel Dashboard with Dynamic Slicers

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

#excel #dashboard #slicers
👁 8 views
excel Intermediate

Build a Dynamic Project Burn-Down Chart in Excel

Act as an Excel expert. I need to build a project burn-down chart that automatic...

#excel #burn-down #project management
👁 8 views
excel Advanced

Excel: Audit a Spreadsheet I Inherited Before I Trust Its Numbers

I just inherited this workbook from someone who left: [DESCRIBE TABS, KEY OUTPUT...

#excel #audit #inherited-work
👁 8 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
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...

#finance #cash-flow #forecasting
👁 7 views
excel Advanced

Excel Dynamic Array Formula to Split Comma-Separated Tags into Columns

I have column A filled with comma-separated tags like 'urgent, vip, refund, bill...

#excel #dynamic-arrays #textsplit
👁 7 views
excel Intermediate

Convert Messy Excel Date Formats to Standardized ISO

I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...

#dates #iso #data cleaning
👁 7 views
excel Advanced

Reconcile Two Bank Statements with Fuzzy Matching in Excel

I have two sheets: 'Bank' with columns Date, Description, Amount and 'Books' wit...

#excel #reconciliation #fuzzy match
👁 7 views
excel Intermediate

Excel Power Query Combine Multiple Sheets Into Master Table

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

#power query #excel #data combine
👁 6 views
excel Intermediate

Create a What-If Scenario Comparison Table With Data Tables

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

#excel #scenarios #data tables
👁 6 views
excel Advanced

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 #goal-seek #solver
👁 6 views
excel Intermediate

Excel: Build a Rolling 12-Month Revenue Trend Without Hardcoded Dates

I want a chart that always shows the last 12 months of revenue — so when I add M...

#rolling #trend #dynamic-range
👁 6 views
excel Advanced

Build a Weekly KPI Dashboard in Excel That Doesn't Break When Someone Renames a Tab

I'm building a weekly KPI dashboard in Excel for a small operations team. The so...

#excel #dashboard #kpi
👁 6 views
excel Advanced

Schedule an Excel file refresh without setting up a server

I have an Excel workbook that pulls data from a CSV in OneDrive via Power Query....

#excel #automation #power-query
👁 6 views
excel Intermediate

ChatGPT Prompt: Excel Pivot Table Calculated Field for Custom Metrics

You are an Excel pivot table expert. Help me add a calculated field to my pivot ...

#excel #pivot-table #calculated-field
👁 5 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
👁 5 views
excel Intermediate

Compare Two Excel Sheets and Highlight Real Differences

I need to compare two Excel sheets that should match but probably don't. Sheet A...

#excel #comparison #vlookup
👁 5 views
excel Intermediate

Excel Sales Commission Tiered Calculator

Create an Excel formula that calculates sales commission using tiered rates: 5% ...

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