Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel-fix"

244 prompts matching "excel-fix"

"excel-fix" ✕ 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
👁 10 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
👁 10 views
finance Advanced

Three-Statement Financial Model for a Bootstrap SaaS Startup

Build a 36-month, monthly three-statement financial model (P&L, cash flow, balan...

#finance #financial-model #saas
👁 10 views
excel Advanced

Forecast Monthly Revenue with Seasonality Using FORECAST.ETS

Act as a financial analyst. I have 36 months of revenue history. Show me how to ...

#excel #forecasting #ets
👁 10 views
excel Intermediate

Excel Formula to Detect Duplicate Records Across Columns

I need an Excel formula to detect duplicate records based on a combination of mu...

#duplicates #data cleaning #excel
👁 10 views
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
👁 10 views
excel Advanced

Build a Cohort Retention Heatmap in Excel

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

#excel #cohort #retention
👁 10 views
excel Intermediate

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

#template #data-validation #conditional-formatting
👁 10 views
excel Intermediate

ChatGPT Prompt for Building an Excel Cash Collection Tracker from Invoices

Act as an expert Excel analyst for accounts receivable. Help me build a cash col...

#chatgpt prompt for excel tracker #invoice aging #accounts receivable
👁 9 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
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
👁 9 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
👁 9 views
finance Beginner

Personal Net Worth Statement Template

Act as a personal finance planner. Build me a structured net worth statement tem...

#net-worth #personal-finance #balance-sheet
👁 9 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
👁 9 views
excel Advanced

ChatGPT Prompt: Excel Power Query M Code for Web Data Scraping

Write Power Query M code to scrape and transform data from [URL OR DESCRIBE WEBP...

#power query #excel #web scraping
👁 9 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
👁 9 views
excel Intermediate

Build a Dynamic Commission Calculator With Tiered Rates in Excel

I need an Excel commission calculator that supports tiered rates (e.g. 5% on the...

#excel #formulas #commission
👁 9 views
excel Beginner

Excel Conditional Formatting Rule to Highlight Aging Invoices

Help me build a conditional formatting rule for an invoices sheet so each row hi...

#excel #conditional-formatting #accounts-receivable
👁 9 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
👁 9 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
👁 9 views
finance Advanced

Investment Decision Analysis Using NPV and IRR

Analyze this investment opportunity using NPV and IRR: - Initial investment: [AM...

#npv #irr #investment analysis
👁 9 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
👁 9 views
excel Intermediate

Convert Messy Sales Data into a Pivot Table Report

You are an Excel expert. I will paste a messy sales dataset with columns for dat...

#excel #pivot tables #data cleaning
👁 9 views
excel Intermediate

Reconcile Bank Statements with Ledger in Excel

I have two Excel sheets: my bank statement transactions and my internal accounti...

#excel #reconciliation #bank
👁 9 views
excel Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

Help me build a comprehensive personal budget tracker in Excel from scratch. I n...

#budget tracker #personal finance #Excel template
👁 8 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval